CSV to MySql Upload Infinite Loop

[rkellermeyer]

Hey everyone ... This should be a pretty easy question for someone who is used to using fgetcsv:

 

I have a script that needs to import a csv file into a mysql table ... I keep getting stuck in a loop that only ends when the script hits the 30 second timeout I have set on the server ... It never actually inserts a record, and it never spits out a message indicating and error ... Can someone help figure out why I get caught in this loop?

 

Here's the code:

function import_csv()
{
if(isset($_POST['submit_csv']))
   {
	 $filename=$_POST['filename'];
	 $handle = fopen("$filename", "r");
	 while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
	 {
	   $import="INSERT INTO `{mydatabase}`.`{my table}` (`name`, `qrl`, `begin`) VALUES ('$data[0]','$data[1]','$data[2]')";
	   mysql_query($import) or die(mysql_error());
	 }
	 fclose($handle);
	 print "Import done";
    }
   else
   {
	  print "<form action='results.php' method='post'><input type='file' name='filename'><br /><input type='submit' value='submit' name='submit_csv' /></form>";
   }
}

[dcro2]

This code is not doing what you think it's doing. I'm pretty sure $_POST['filename'] will be blank.

Instead, what you want is to use $_FILES[]

	if(isset($_POST['submit_csv']) && $_FILES['filename']['error'] == UPLOAD_ERR_OK)
{
	$filename = $_FILES['filename']['tmp_name'];

[rkellermeyer]

Still getting the loop ... rtfm now ... again. 

[dcro2]

Facepalm. You need to add enctype='multipart/form-data' to the form.

		  print "<form action='results.php' enctype='multipart/form-data' method='post'><input type='file' name='filename'><br /><input type='submit' value='submit' name='submit_csv' /></form>";

[rkellermeyer]

Yeah, just slapped myself ... Thanks for the help!