在将excel/csv文件导入mysql时遇到问题 [英] Having the problem in importing excel/csv file into mysql
本文介绍了在将excel/csv文件导入mysql时遇到问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
导入.csv文件时遇到问题.实际上已成功导入,但是所有字段都只出现在一列中.
这是代码:
在index.php
I am getting problem in importing the .csv file.actually it is successfully imported but all field are come in only one column.
Here is the code:
On index.php
<html>
<form action="load.php" method="post" enctype="multipart/form-data">
<input type="file" name="file" id="file" />
<input type="submit" value="Load" name="load"/>
</body>
</form>
</html>
在load.php
On load.php
function connect_db()
{
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("new_import", $con);
}
if (isset($_POST['load']))
{
echo "button on is pressed <br />";
if ($_FILES["file"]["error"] > 0)
{
echo "Error: " . $_FILES["file"]["error"] .
"You have not selected a file or some other error <br />";
}
else
{
$file_name=$_FILES["file"]["name"];
echo $file_name."<br />";
$file_type=$_FILES["file"]["type"];
echo $file_type."<br />";
// if($file_type!='text/csv')
//{
// echo "Please the input file should be a .csv file";
//}
// else
//{
echo "its correct";
$location="C:\\xampp\\mysql\\data\\import\\";
move_uploaded_file($_FILES["file"]["tmp_name"],$location . $_FILES["file"]["name"]);
//}
connect_db();
/* $q= "LOAD DATA LOCAL INFILE '$file_name' INTO TABLE import1
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(@name, mobno)
SET name = @name,mobno=mobno";*/
$q="LOAD DATA INFILE '$file_name' INTO TABLE import1
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
(@name,mobno)
SET name=@name,mobno=@mobno";
mysql_query($q) or die(mysql_error());
}
}
?>
并且问题如下在mysql数据库中
名称| mob.no
neha | 9561061902
名称| mob.no
neha | 9561061902
and problem is as follows in mysql database
name|mob.no
neha|9561061902
name|mob.no
neha|9561061902
推荐答案
con = mysql_connect(" ," , "); 如果(!
con = mysql_connect("localhost","root",""); if (!
con) { die(' 无法连接:'.mysql_error()); } mysql_select_db(" ,
con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("new_import",
con); } 如果(isset(
con); } if (isset(
这篇关于在将excel/csv文件导入mysql时遇到问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文