0) {
//get the csv file
$file = $_FILES[csv][tmp_name];
$handle = fopen($file,"r");
//loop through the csv file and insert into database
do {
if ($data[0]) {
mysqli_query("INSERT INTO c_productprice (mrp_price, barcode_number) VALUES
(
'".addslashes($data[0])."',
'".addslashes($data[1])."'
)
");
}
} while ($data = fgetcsv($handle,1000,",","'"));
//
//redirect
header('Location: import.php?success=1'); die;
}
?>
Your file has been imported.
"; } //generic success notice ?>
0) {
//get the csv file
$file = $_FILES['csv']['tmp_name'];
$handle = fopen($file,"r");
$name = $_FILES['csv']['name'];
//loop through the csv file and insert into database
do {
if ($data[0]) {
$exist = mysql_num_rows(mysql_query("SELECT contact_number FROM contacts WHERE contact_number = '".addslashes(trim($data[1],'"'))."'"));
if($exist == 0 ) {
mysql_query("INSERT INTO contacts (contact_name, contact_number,contact_file) VALUES
(
'".addslashes(trim($data[0],'"'))."',
'".addslashes(trim($data[1],'"'))."',
'".$name."'
)
");
}
}
} while ($data = fgetcsv($handle,1000,",","'")); //
//redirect
echo '';
die;
}
?>
Your file has been imported.
"; } //generic success notice ?>
" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "";
echo "Displaying contents:
";
readfile($_FILES['filename']['tmp_name']);
}
//Import uploaded file to Database
$handle = fopen($_FILES['filename']['tmp_name'], "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$import="INSERT into tablename(item1,item2,item3,item4,item5) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')";
mysql_query($import) or die(mysql_error());
}
fclose($handle);
print "Import done";
//view upload form
}else {
print "Upload new csv by browsing to file and clicking on Upload
\n";
print "";
}
*/
?>