Re: Parsing CSV files into a MySQL Table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



If what you have below is the exact SQL you have an error:

mysql_query ("INSERT INTO 'footable' (foo1, foo2, foo3, foo4, foo5, foo6,
foo7) VALUES '$foo1', '$foo2', '$foo3', '$foo4', '$foo5', '$foo6',
'$foo7')");

should be

mysql_query ("INSERT INTO 'footable' (foo1, foo2, foo3, foo4, foo5, foo6,
foo7) VALUES ('$foo1', '$foo2', '$foo3', '$foo4', '$foo5', '$foo6',
'$foo7')");

You are missing an opening paren after the VALUES keyword.  Using
mysql_error will help you catch these kinds of things.

E

"Mark Benson" <markbenson@xxxxxxx> wrote in message
news:10968661.1099403196030.JavaMail.markbenson@xxxxxxxxxx
> Hi, newbie here, go easy on me I'm learning this as I go ;)
>
> Got a bit of teaser here.
>
> //<?php
>
> mysql_connect (localhost, foouser, foologin);
>
> mysql_select_db (footest1);
>
> $csvfile = file("http://foo.com/foolist.csv";);
>
> foreach($csvfile as $line_no => $datastring) {
> $data = explode (",", $datastring);
> $foo1 = $data[0];
> $foo2 = $data[1];
> $foo3 = $data[2];
> $foo4 = $data[3];
> $foo5 = $data[4];
> $foo6 = $data[5];
> $foo7 = $data[6];
>
> mysql_query ("INSERT INTO 'footable' (foo1, foo2, foo3, foo4, foo5, foo6,
foo7)
> VALUES '$foo1', '$foo2', '$foo3', '$foo4', '$foo5', '$foo6', '$foo7')");
> }
>
> //?>
>
> The result of the above is I get nothing INSERT-ed in 'footable'. No lines
of data at all. I looked in the table using phpMyAdmin and zilch.
>
> I have however dumped the contents of each variable in the 'foreach' loop
to the screen in a table and it all maps out correctly as i was in the CSV
file, so the CSV file is being parsed correctly. The fault seems to be in
the MySQL query I think.
> Privilages have no influence - I've tried both the database's 'regular'
users and also the 'root' user and it makes no odds.
> I've also tried dumping the list of single variables and using '($data[0],
$data[1] etc...) and that has no effect.
>
> It's probably something glaringly obvious to an expert but as I say I'm
learning as I go so any help would be great :)
>
> Thx.
>
> -- 
> Mark Benson
>
> http://homepage.mac.com/markbenson

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux