I Created a file called import.php for PHP that I used to import a csv file. but its not working fine.i have 3 field in database.name id email email got alwyas numeric value 0 and name null.
Here is part of the script.
Any ideas why it would be being read as a long line?
<?php
$connect = mysql_connect('localhost','root','');
if (!$connect) {
die('Could not <span class="IL_AD" id="IL_AD3">connect to</span> <span class="IL_AD" id="IL_AD12">MySQL</span>: ' . mysql_error());
}
$cid =mysql_select_db('test',$connect);
// supply your database name
define('CSV_PATH','D:/xampp/htdocs/import/');
// path where your CSV file is located
$csv_file = CSV_PATH . "aa.csv"; // Name of your CSV file
$csvfile = fopen($csv_file, 'r');
$theData = fgets($csvfile);
$i = 0; while (!feof($csvfile)) {
$csv_data[] = fgets($csvfile, 1024);
$csv_array = explode(",", $csv_data[$i]);
$insert_csv = array();
$insert_csv['ID'] = $csv_array[0];
$insert_csv['name'] = $csv_array[1];
$insert_csv['email'] = $csv_array[2];
$query = "INSERT INTO csv(ID,name,email)
VALUES('','".$insert_csv['name']."','".$insert_csv['email']."')";
$n=mysql_query($query, $connect );
$i++;
}
fclose($csvfile);
echo "File data successfully imported to database!!";
mysql_close($connect);
?>
and this is my input file from where i upload csv file....i got Warning msg and my data base fiel id is created and email value i got 0 and name id null.
<html>
<body>
<form action="impt.php" method="post"
enctype="multipart/form-data">
<label for="file">Filename:</label>
<input type="file" name="file" id="file"><br>
<input type="submit" name="submit" value="Submit">
</form>
</body>
</html>
This is your code using fgetcsv
<?php
$connect = mysql_connect('localhost','root','');
if (!$connect) {
die('Could not <span class="IL_AD" id="IL_AD3">connect to</span> <span class="IL_AD" id="IL_AD12">MySQL</span>: ' . mysql_error());
}
$cid = mysql_select_db('test', $connect);
// supply your database name
define('CSV_PATH','D:/xampp/htdocs/import/');
// path where your CSV file is located
$csv_file = CSV_PATH . "aa.csv"; // Name of your CSV file
$csvfile = fopen($csv_file, 'r');
$i = 0;
while (($data = fgetcsv($csvfile, 1000)) !== FALSE) {
if ($data != null) { // skip empty lines
$insert_csv = array();
$insert_csv['ID'] = $data[0];
$insert_csv['name'] = $data[1];
$insert_csv['email'] = $data[2];
$query = "INSERT INTO csv(ID,name,email)
VALUES('','".$insert_csv['name']."','".$insert_csv['email']."')";
$n=mysql_query($query, $connect );
}
$i++;
}
fclose($csvfile);
echo "File data successfully imported to database!!";
mysql_close($connect);
?>