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,