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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
