超急！上传一个文本文件到mysql数据表中？

应该是12个字段，在phpmyadmin中好像有这个程序吧

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

LOAD DATA INFILE 'd:/inetpub/test.txt' INTO TABLE users
xuzuning(唠叨，能详细点吗？如果成功给你三百分，分三分给！
是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";
}
?>不行啊！！有没有办法啊？高手！！
test.htm文件内容
<!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中处理.你把这两个文件放在一个目录下调试一下吧.
不知道你的数据库结构.所以..............你自己再调调吧!
<?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>
netvt(唯她 v1.1.1),谢谢您的帮忙，我试了一下可以！
我的数据表如下：
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这个享段一样的时候，就覆盖旧的记录,请问如何解决？我会另外给你分的！！
<?php
//参数设置：修改以下几项设置
$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>