Import CSV file into MySQL database using PHP

Dear reader,

I'm trying to import 2 CSV files into temptables in my MySQL database.
In my local development environment it works fine, but when I upload the file to the server I get an error saying the query cannot be executed. It concerns the query below.

$import = "INSERT INTO temp_grau1 (CODI,CONCEPTA,TAMANY,PVP,PREU_ESPECIAL,ANYADA,STOCK) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')";

I've also attached the code snipped.

Any help is very much appriciated!

Kind regards.

Geerd

if(isset($_POST['submit'])){

			//leegmaken tabellen

			$result = mysql_query("DELETE FROM temp_grau1",$db);
			$result = mysql_query("DELETE FROM temp_grau2",$db);

     			$filename=$_POST['filename1'];

   			$handle = fopen("$filename", "r");

    			while (($data = fgetcsv($handle, 10000, ";")) !== FALSE){

			        $import = "INSERT INTO temp_grau1 (CODI,CONCEPTA,TAMANY,PVP,PREU_ESPECIAL,ANYADA,STOCK) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')";

  				mysql_query($import) or die ("Kan de query1 niet uitvoeren.");

    			}

     			fclose($handle);

     			print "Import LIJST 1 done";

     			$filename=$_POST['filename2'];

   			$handle = fopen("$filename", "r");

    			while (($data = fgetcsv($handle, 10000, ";")) !== FALSE){

			        $import = "INSERT INTO temp_grau2 (CODI,CONCEPTA,TAMANY,PVP,PREU_ESPECIAL,ANYADA,STOCK) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')";

  				mysql_query($import) or die ("Kan de query2 niet uitvoeren.");

    			}

     			fclose($handle);

     			print "Import LIJST 1 done";

			?><META HTTP-EQUIV="refresh" CONTENT="0; url=../Menu_Prijslijst.php"><?php



		}else{

			print "<br><br><center>Please enter the URL of the files you want to use for the price comparison.";

			print "<form action='Inladen.php' method='post'>";

      			print "Pricelist file 1 (previous file):<br>";

      			print "<input type='file' name='filename1' size='20'><br>";

      			print "Pricelist file 2 (current file):<br>";

      			print "<input type='file' name='filename2' size='20'><br><br>";

     			print "<input type='submit' name='submit' value='COMPARE LISTS'></form><center>";

   		} 

		?>

Select allOpen in new window