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.
How do I ma
Hello Irin,
Not sure where you problem is but here is what I would check first.
After you open the page that has the drop down list, view the source and
See if the OPTION VALUE= has any value assigned to it. If you are using
IE, on the menu bar click on View - Source.
Second, if that is fine,
> 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
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
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
15 matches
Mail list logo
