PHP csv imprter

I have no idea why this code is not working. it doesn’t enter data into my database even though everything seems to be correct. I get a blank screen after submitting and that’s about it. No errors, nothing.

[php]

<?php $connect = mysql_connect("localhost","erlendanderson","ugumuq"); mysql_select_db("nooruse",$connect) or die ('Viga andmebaasi valimisel'); //select the table // if ($_FILES[csv][size] > 0) { $file = $_FILES[csv][tmp_name]; $handle = fopen($file,"r"); do { if ($data[0]) { mysql_query("INSERT INTO norse5_proov (osakond, soetusaasta, it_number, tooteruhm, mudeli_nimetus, sn, riigivara_nr, inventaari_nr, maja, ruum, vastutaja, markus, kasutajanimi) VALUES ( '".addslashes($data[0])."', '".addslashes($data[1])."', '".addslashes($data[2])."', '".addslashes($data[3])."', '".addslashes($data[4])."', '".addslashes($data[5])."', '".addslashes($data[6])."', '".addslashes($data[7])."', '".addslashes($data[8])."', '".addslashes($data[9])."', '".addslashes($data[10])."', '".addslashes($data[11])."', '".addslashes($data[12])."', ) "); } } while ($data = fgetcsv($handle,1000,",","'")); header('Location: import.php?success=1'); die; } ?> Andmete importimine
<body> 

	<?php if (!empty($_GET['success'])) { echo "<b>Andmed sisestatud.</b><br><br>"; } ?> 

	<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1"> 
		Vali fail: <br /> 
		  <input name="csv" type="file" id="csv" /> 
		  <input type="submit" name="Submit" value="Esita" /> 
	</form> 

</body> 

[/php]

csv:

,12,A001,ARVUTI,Dell Optiplex 390 -kahe väljundiga,#4WN395J,,#12032101,5,018,Auditoorium, ,12,M001,MONITOR,Dell P2212HB,#CN0V0VCM742611CL08WM,,#12032101,5,018,Auditoorium, ,12,Pole vajalik,TAHVEL,,,,,5,018,Auditoorium,seinale paigaldamata ,10,A216,ARVUTI,Microlink,207258,,#6099990131,5,jõusaal,Auditoorium, ,10,M203,MONITOR,Samsung SyncMaster 943N,#MY19HMAQA30094A,,puudub,5,jõusaal,Auditoorium, ,10,PR002,PRINTER,HP Laserjet 1320,#CNM1H01706,,puudub,5,jõusaal,Auditoorium, ,12,A002,ARVUTI,Dell Optiplex 390 -kahe väljundiga,#JCN395J,,#12032102,5,013,Auditoorium, ,12,M002,MONITOR,DELL ,#CN0V0VCM742611CL09PM,,#12032102,5,013,Auditoorium, ,12,Pole vajalik,TAHVEL,,,,,5,013,Auditoorium, ,12,A003,ARVUTI,Dell Optiplex 390 -kahe väljundiga,#BTN395J,,#12032103,5,028,Auditoorium, ,12,M003,MONITOR,Dell 2212HB,#CN0V0VCM742611CP273U,,#12032103,5,028,Auditoorium, ,10,ET087,ESITLUSTEHNIKA,Sanyo PLC-XW65,68X04266,,#6099990228,5,028,Auditoorium, ,10,M204,MONITOR,Samsung SyncMaster 943,#MY19HMBQ504444B,,puudub,5,rõivistu,Puudub, ,10,M161,MONITOR,Samsung SyncMaster 943,#MY19HMAQA40485H,,puudub,5,rõivistu,Puudub, ,10,A247,ARVUTI,Microlink,238337,,puudub,5,rõivistu,Puudub, ,12,T01,TELEFON,Cisco SPA 504G,#CBT141100SR,,puudub,5,rõivistu,Puudub, ,12,A004,ARVUTI,Dell Optiplex 390 -kahe väljundiga,#HBN395J,,#12032104,5,020,Auditoorium, ,12,M004,MONITOR,Dell 2212HB,#CN0V0VCM742611CM4CMM,,#12032104,5,020,Auditoorium, ,12,ET208,ESITLUSTEHNIKA,Wireless Receiver TXS-626,Y09/001089-01,,puudub,5,020,Auditoorium, ,12,ET209,ESITLUSTEHNIKA,Võimendi-mikser PRE26 AUDAC,10020086320033,,puudub,5,020,Auditoorium,

Are you certain there is no mysql error? Add a reporting function to your query e.g.

[php]mysql_query("…")or die(mysql_error());[/php]

Thank you! This time it worked but it didn’t display me the success screen.
I can see the imported data when I log into phpmyadmin.

Got it working for some odd reasons. No idea why.

Sponsor our Newsletter | Privacy Policy | Terms of Service