0) {
//get the csv file
$csvFile = $_FILES[csv][tmp_name];
}
*/
// Set path to CSV file
$csvFile = '/var/www/html/xadesweb/protected/contacts.csv';
//calling the function
$csv = readCSV($csvFile);
if(!empty($csv)){
foreach($csv as $file){
//inserting into database
$query_insert = "insert into tb_login set
username = '".$file[0]."',
company = '".$file[1]."',
companyname = '".$file[2]."',
active = '".$file[3]."',
status = '".$file[4]."',
firstname = '".$file[5]."',
lastname = '".$file[6]."',
email = '".$file[7]."',
password = '".$file[8]."";
echo $query_insert;
$insert = mysql_query($query_insert);
}
}else{
echo 'Csv is empty';
}
include('connect-db.php');
//connect to the database
//$connect = mysql_connect("localhost","username","password");
//mysql_select_db("mydatabase",$connect); //select the table
//
// get results from database
$result = mysql_query("SELECT * FROM tb_login")
or die(mysql_error());
//redirect
header('Location: import.php?success=1'); die;
}
?>
Import a CSV File with PHP & MySQL
Your file has been imported.
"; } //generic success notice ?>