Hi John,
I want to read a csv-file and import the datas into a mysql-db.
How do I make this. A little scriptexaple in php would be helpfull.
Why not just LOAD DATA INFILE from MySQL? No need to involve PHP at all,
really...
I think the command you also can write in the mysql_db_query-Command.
T
Ruprecht Helms wrote:
I want to read a csv-file and import the datas into a mysql-db.
How do I make this. A little scriptexaple in php would be helpfull.
Why not just LOAD DATA INFILE from MySQL? No need to involve PHP at all,
really...
--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/regis
rtfm
http://ca3.php.net/manual/en/function.fgetcsv.php
bastien
From: Ruprecht Helms <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] insert into mysql-db from csv-file
Date: Mon, 17 Jan 2005 17:26:56 +0100
Hi,
I want to read a csv-file and import the datas into a mysql-db.
Ho
Hi,
I want to read a csv-file and import the datas into a mysql-db.
How do I make this. A little scriptexaple in php would be helpfull.
Regards,
Ruprecht
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Aleks
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 1:37 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [PHP-DB] INSERT into mysql from dynamic drop down
Hi all,
Right now i would like to INSERT the values from a d
Hi all,
Right now i would like to INSERT the values from a dynamic drop down
menu into mysql database but encountered some problem here. Values in the drop
down menu are retrieved from DB as follows:
" .$row["tutor_name"]. "";
}
$result = $db->query($sql);
?>
-
> I'd like to have some kind of a GUI on the internet
Could you not use phpMyAdmin??
Download it for free from http://www.phpwizard.net/projects/phpMyAdmin/
Cheers.
Russ
On Thu, 3 May 2001 15:43:11 +0200 Nils Wetterich <[EMAIL PROTECTED]> wrote:
> Hi NG
>
> Now that I finally realy work with
Hi NG
Now that I finally realy work with the combination mySQL & PHP on a
Windows-machine I began to just love it. There's only one problem I still
have:
How can I INSERT data from a HTML-form to the database on the server? I'd
like to have some kind of a GUI on the internet so I could administer
I found the problem. I didn't give myself write access to the database :}
- Original Message -
From: "Darryl Friesen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 8:32 AM
Subject: Re: [PHP-DB] insert into mysql
> > &g
> > > > $sql = "INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')";
> >
> > Another thought: Are ID and part character data of some sort? If not
(i.e.
> > if ID is an int) then remove the single quotes.
> >
> A trivial point this, but if you insert values in ' into a mysql int
> column then MyS
On Thu, 25 Jan 2001, Darryl Friesen wrote:
>
>
> > It still didn't work.
> > just says unable to add part
>
> > > $sql = "INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')";
>
> Another thought: Are ID and part character data of some sort? If not (i.e.
> if ID is an int) then remove the
Man, do I feel dumb. My wwwuser didn't have the right privledges to add or remove
from the database.
Works fine now. Thanks for all the suggestions.
Warning: Supplied argument is not a valid MySQL-Link resource in
c:\inetpub\wwwroot\rfq.php on line 16
Unable to add part
//--- Add part --
if($act=="ADD"){
$sql="INSERT INTO ecomm (ID,part) VALUES $sql.="('$sid','$spp')";
if(! mysql_db_que
en" <[EMAIL PROTECTED]>
To: "Robert" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 2:26 PM
Subject: Re: [PHP-DB] insert into mysql
>
>
> > It still didn't work.
> > just says unable to add part
>
> > > $sql
> It still didn't work.
> just says unable to add part
> > $sql = "INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')";
Another thought: Are ID and part character data of some sort? If not (i.e.
if ID is an int) then remove the single quotes.
- Darryl
> It still didn't work.
> just says unable to add part
Remove the @ from @mysql_db_query and it will spit out the SQL error
explaining why the query fails. That should help for debugging.
- Darryl
--
Darryl Friesen, B.Sc
you didn't specify $dbname
-Original Message-
From: Robert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 3:07 PM
To: Darryl Friesen; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] insert into mysql
It still didn't work.
just says unable to add part
$db = mysql_conne
It still didn't work.
just says unable to add part
$db = mysql_connect("tech2000", "wwwguest", "guest");
- Original Message -
From: "Darryl Friesen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January
> You're INSERT query is wrong. Take the ',$db' off the end.
^^
Oops. That's "Your". Long day.
- Darryl
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators,
> //--- Add part --
> if($act=="ADD"){
> $sql="INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp'),$db";
> if(! @mysql_db_query("$sql")){
>echo("Unable to add part."); mysql_close($db);exit();} }
>
> Why does this not work?
>
You're IN
//--- Add part --
if($act=="ADD"){
$sql="INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp'),$db";
if(! @mysql_db_query("$sql")){echo("Unable to add part.");mysql_close($db);exit();}
}
Why does this not work?
21 matches
Mail list logo
