How to import csv file with ; separator in mysql via php, i can import csv with coma but not with semicilon.

Question

How to import csv file with ; separator in mysql via php, i can import csv with coma but not with semicilon.

///////////////////////////////////////////////////// Code /////////////////////////////////////////////////////
include_once("db_connect.php");
if(isset($_POST['import_data'])){
// validate to check uploaded file is a valid csv file
$file_mimes = array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'application/x-csv', 'text/x-csv', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel', 'text/plain');
if(!empty($_FILES['file']['name']) && in_array($_FILES['file']['type'],$file_mimes)){
if(is_uploaded_file($_FILES['file']['tmp_name'])){
$csv_file = fopen($_FILES['file']['tmp_name'], 'r');
//fgetcsv($csv_file);
// get data records from csv file
while(($emp_record = fgetcsv($csv_file)) !== FALSE){
// Check if employee already exists with same email
$sql_query = "SELECT login, pass FROM user WHERE login = '".$emp_record[0]."'";
$resultset = mysqli_query($conn, $sql_query) or die("database error:". mysqli_error($conn));
// if employee already exist then update details otherwise insert new record
if(mysqli_num_rows($resultset)) {
$sql_update = "UPDATE user set login='".$emp_record[0]."', pass='".$emp_record[1]."' WHERE login = '".$emp_record[0]."'";
mysqli_query($conn, $sql_update) or die("database error:". mysqli_error($conn));
} else{
$mysql_insert = "INSERT INTO user (login, pass )VALUES('".$emp_record[0]."', '".$emp_record[1]."')";
mysqli_query($conn, $mysql_insert) or die("database error:". mysqli_error($conn));
}
}
fclose($csv_file);
$import_status = '?import_status=success';
} else {
$import_status = '?import_status=error';
}
} else {
$import_status = '?import_status=invalid_file';
}
}
header("Location: index.php".$import_status);
////////////////////////////////////////////////////////////////////////////////////////

csv files :
NAME;PASSWORD

Answer 1

Hi I find the solution

while(($emp_record = fgetcsv($csv_file,10000, ";"))

Thank you all.

Answer 2

thank You daniel, i will see the link.

Answer 3

Maybe you can check these url

http://www.damnsemicolon.com/php/php-upload-csv-mysql#.WexO_Fv9RO0

https://stackoverflow.com/questions/29487302/php-processing-csv-file-separated-by-semicolon

Answer 4

Hi @Daniel Fernández Hidalgo
Teh first link it's for the coma separator.
The second link the solution not work.
Thank you.