|
|
Posted by mantrid on 06/20/07 20:07
"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:op.tt6t46t6qnv3q9@metallium...
> On Tue, 19 Jun 2007 23:30:42 +0200, Rik <luiheidsgoeroe@hotmail.com>
wrote:
>
> > On Tue, 19 Jun 2007 23:03:45 +0200, mantrid <ian.dandav@virgin.net>
> > wrote:
> >
> >> Hello
> >> Can anyone point me in the right direction for the way to read a text
> >> file a
> >> line at a time and separate the fields on that line and use them as
> >> data in
> >> an INSERT to add a record to a mysql table. Then read the second line
in
> >> text file and repeat.
> >>
> >
> > Worst case: fgets() & explode()/split(), but depending on the format
> > fscanf() or even the great fgetcsv() can be your friends.
>
> Oh, and if it's possible: do not underestimate the power of LOAD DATA
> INFILE syntax of mysql itself. No need to fuss around in PHP if MySQL can
> do it practically on it's own.
> --
> Rik Wasmus
Hi
Decided to use the fgetcsv(). couldnt get LOAD DTA INFILE to work. Im
getting close with the following script, but error message says query failed
as array doesnt contain data. Am I missing something obvious
**********************************
$YourFile = $uploadfile ;
$handle = fopen($YourFile, "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
list($userid, $companyid, $aimlisted, $amount, $price, $stamp, $comm,
$datetime) = explode(",", $data);
//echo
$userid."<br>".$companyid."<br>".$aimlisted."<br>".$amount."<br>".$price."<b
r>".$stamp."<br>".$comm."<br>".$datetime;
$q = "INSERT INTO transactions
(transactionid,userid,companyid,aimlisted,amount,price,stamp,comm,datetime)
VALUES ('',$userid, $companyid, $aimlisted, $amount, $price, $stamp, $comm,
'$datetime')";
$add_buy = mysql_query($q) or die('<span class=RedWarning>Query failed: '
.. mysql_error().'</span>');
}
fclose($handle);
**************************************
I echoed the variables from the list (commented out in script) and they to
show they contain no data.
can anyone see where Ive gone wrong?
Ian
Navigation:
[Reply to this message]
|