Re: Re: Csv issue

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

 




admin@xxxxxxxxxxxxxxxxxxx wrote:
> OKay now i am really stumped.
> Notice: Undefined index: filename
> When clearly I have it being set in the form with the file.
> Any suggestions?
>
>
>
> admin@xxxxxxxxxxxxxxxxxxx wrote:
>   
>> I am using a form to select a csv file and then import it into mysql and 
>>     
> maybe im just drawling a blank here. But why is it blowing up.
>   
>> This thing loads like 14 million records into the database and I am clue less 
>>     
> how it can do that with a 2 record csv file.
>   
>> <form enctype='multipart/form-data' action=? method=post>
>> Upload:<input type=file name=filename>
>> <input type=submit value='Upload'></form>
>>
>>
>> $row = 1;
>> $filename = $_POST['filename'];
>> $handle = fopen("$filename", "r");
>> while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
>> {
>> $num = count($data);
>> echo "<p> $num fields in line $row: <br /></p>\n";
>> $row++;
>> }
>> fclose($handle);
>> print "Import done";
>>
>> This will produce millions of lines until i go in and stop the process on the 
>>     
> server. I know its stupid but im drawling a blank as to why its doing this. The 
> csv file has 2 lines in period. 
>   
>> <p> 0 fields in line 1: <br /></p>
>> <p> 0 fields in line 2: <br /></p>
>> ect for millions of records.
>>     
> Try:
>
> print_r(file($_POST['filename']));
>
> And see if you get what you expect.  You might also want to have
> error_reporting at its highest and display_errors also.
>
> -Shawn
>
>   

Please reply to the list.  I missed it the first time around, but you
need to use the $_FILES array: 
http://php.net/manual/features.file-upload.php

-Shawn

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux