|
|
Posted by mantrid on 06/21/07 00:17
"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:op.tt8oweggqnv3q9@metallium...
On Wed, 20 Jun 2007 22:07:07 +0200, mantrid <ian.dandav@virgin.net> wrote:
>
> "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.
>
> 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);
Well, the power of fgetscv() is in the fact that your should not need this
explode.
Try the list() directly on the $data array. If that doesn't work,
print_r($data) to check wether everything is OK.
--
Rik Wasmus
That did it. thanks.
Just one problem with the field datetime (type datetime). values are not
saving, get 0000-00-00 00:00:00 added instead of the actual date and time.
All other fields update ok
Any clues.
Ian
Navigation:
[Reply to this message]
|