<? $link=mysql_connect("localhost","",""); mysql_select_db("wsjd"); //$query="LOAD DATA INFILE 'D:/t_wsjd.txt' REPLACE INTO TABLE `t_wsjd` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'"; //$query="LOAD DATA INFILE 'd:/t_wsjd.txt' INTO TABLE t_wsjd FIELDS TERMINATED BY ','"; //$query="LOAD DATA INFILE 'd:\t_wsjd.txt' REPLACE INTO TABLE `t_wsjd` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'"; $sql = 'LOAD DATA LOCAL INFILE \'d:/t_wsjd.txt\' REPLACE INTO TABLE `t_wsjd` '; $sql .= 'FIELDS TERMINATED BY \',\''; $sql .= 'ENCLOSED BY \'"\''; $sql .= 'ESCAPED BY \'\\\\\''; $sql .= 'LINES TERMINATED BY \'\\r\\n\''; $query=mysql_query($sql,$link); //echo "$sql"; if ($query) { echo "<br> succ!"; } else { echo "<br> bad"; } ?>不行啊!!有没有办法啊?高手!!
是12个字段,每个字段用英文的逗号隔开,以回车结束一行!
$link=mysql_connect("localhost","","");
mysql_select_db("wsjd");
//$query="LOAD DATA INFILE 'D:/t_wsjd.txt' REPLACE INTO TABLE `t_wsjd` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'";
//$query="LOAD DATA INFILE 'd:/t_wsjd.txt' INTO TABLE t_wsjd FIELDS TERMINATED BY ','";
//$query="LOAD DATA INFILE 'd:\t_wsjd.txt' REPLACE INTO TABLE `t_wsjd` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'";
$sql = 'LOAD DATA LOCAL INFILE \'d:/t_wsjd.txt\' REPLACE INTO TABLE `t_wsjd` ';
$sql .= 'FIELDS TERMINATED BY \',\'';
$sql .= 'ENCLOSED BY \'"\'';
$sql .= 'ESCAPED BY \'\\\\\'';
$sql .= 'LINES TERMINATED BY \'\\r\\n\'';
$query=mysql_query($sql,$link);
//echo "$sql";
if ($query)
{
echo "<br> succ!";
}
else
{
echo "<br> bad";
}
?>不行啊!!有没有办法啊?高手!!
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body>
<form name="form1" method="post" action="test.php" enctype="multipart/form-data">
<p>
<input type="file" name="test">
</p>
<p>
<input type="submit" name="Submit" value="提交">
</p>
</form>
</body>
</html>test.php文件内容<?php
$fc = file($_FILES['test']['tmp_name']);
$a = count($fc);
$sql = "INSERT INTO t_wsjd VALUES";
for($ii=0; $ii<$a; $ii++) {
$sql .= "(".$fc[$ii]."),";
}
$sql = substr($sql, 0, -1);
//输出SQL语句检查是否正确
echo($sql);$link=mysql_connect("localhost","","");
mysql_select_db("wsjd");
$query=mysql_query($sql,$link);
//echo "$sql";
if ($query)
{
echo "<br> succ!";
}
else
{
echo "<br> bad";
}
?>在test.htm中把文件提交而后在test.php中处理.你把这两个文件放在一个目录下调试一下吧.
不知道你的数据库结构.所以..............你自己再调调吧!
//参数设置:修改以下几项设置
$host = "localhost"; //改为MYSQL数据库主机名
$dbuser = "root"; //数据库登录用户名
$dbpass = "su12yu12"; //数据库登录用户密码
$db = "test"; //欲操作数据表所在的数据库
$tbl = "mybase"; //欲操作的数据表//程序正文
if(file_exists($_FILES['test']['tmp_name']) && isset($_POST['Submit'])){
$data = file($_FILES['test']['tmp_name']); $conn = mysql_pconnect($host,$dbuser,$dbpass);
mysql_select_db($db);
for ($i = 0; $i < count($data); $i++) {
echo $data[$i]."<hr>";
$data[$i] = ereg_replace(",","','",$data[$i]);
$data[$i] = ereg_replace("\r\n","",$data[$i]);
$sql = "INSERT INTO $tbl VALUES('".$data[$i]."');";
mysql_query($sql);
}
echo "<font color=green>数据成功写入表</font><br><br>";
} else echo "<font color=red>没有上传文件</font><br><br>";?>
<form name="form1" method="post" action="<? echo $_SERVER['PHP_SELF'];?>" enctype="multipart/form-data">
<p>
选择数据文件:<input type="file" name="test">
</p>
<p>
<input type="submit" name="Submit" value="提交">
</p>
</form>
我的数据表如下:
CREATE TABLE `t_wsjd` (
`TYPE` varchar(200) default NULL,
`fzdw` varchar(225) default NULL,
`xkzh` varchar(255) default NULL,
`dwmc` varchar(255) default NULL,
`dwdz` varchar(255) default NULL,
`fddbr` varchar(255) default NULL,
`xkxm` varchar(255) default NULL,
`cpmc` varchar(255) default NULL,
`fzrq` varchar(255) default NULL,
`dh` varchar(255) default NULL,
`yb` varchar(255) default NULL,
`email` varchar(255) default NULL,
) TYPE=MyISAM;我想要:在要导入的文件中,xkzh这个字段和已存在数据表里面的xkzh这个享段一样的时候,就覆盖旧的记录,请问如何解决?我会另外给你分的!!
//参数设置:修改以下几项设置
$host = "localhost"; //改为MYSQL数据库主机名
$dbuser = "root"; //数据库登录用户名
$dbpass = "xxxxxx"; //数据库登录用户密码
$db = "test"; //欲操作数据表所在的数据库
$tbl = "t_wsjd"; //欲操作的数据表//程序正文
echo "<font size=-1>";
if(file_exists($_FILES['test']['tmp_name']) && isset($_POST['Submit'])){
$data = file($_FILES['test']['tmp_name']); $conn = mysql_pconnect($host,$dbuser,$dbpass);
mysql_select_db($db);
for ($i = 0; $i < count($data); $i++) {
$data[$i] = ereg_replace(",","','",$data[$i]);
$data[$i] = ereg_replace("\r\n","",$data[$i]);
$data[$i] = "'".$data[$i]."'";
$update_data = explode(",",$data[$i]);
$result = mysql_query("select * from $tbl where xkzh=".$update_data[2].";");
$res = @mysql_fetch_array($result);
if ($res) {
$sql = "UPDATE $tbl SET `TYPE`=".$update_data[0].", `fzdw`=".$update_data[1].", `dwmc`=".$update_data[3].", `dwdz`=".$update_data[4].", `fddbr`=".$update_data[5].", `xkxm`=".$update_data[6].", `cpmc`=".$update_data[7].", `fzrq`=".$update_data[8].", `dh`=".$update_data[9].", `yb`=".$update_data[10].", `email`=".$update_data[11]." where xkzh=".$update_data[2].";";
} else {
$sql = "INSERT INTO $tbl VALUES(".$data[$i].");";
}
echo $sql."<br>";
if(mysql_query($sql)) echo "OK!<br>";
else echo "false<br>";
echo "<hr>";
}
echo "<font color=green>数据成功写入/更新表</font><br><br>";
} else echo "<font color=red>没有上传文件</font><br><br>";?>
<form name="form1" method="post" action="<? echo $_SERVER['PHP_SELF'];?>" enctype="multipart/form-data">
<p>
选择数据文件:<input type="file" name="test">
</p>
<p>
<input type="submit" name="Submit" value="提交">
</p>
</form>
</font>