作者Snylsh (Snylsh<(￣﹌￣)/)
看板PHP
标题[请益] CSV档上传网页制作
时间Thu Dec 22 15:08:53 2005
各位板上的先进们好 小弟想写出藉由上传页面让CSV档传到我的电脑
并且写入我的MYSQL资料库 大概试着写了一下 不过还是不行
希望板上先进可以指教一下
资料库名称为class 资料表也是class 栏位有class name
PHP版本为4.3.1 程式如下:
<?
// 组态设定与连结 DataBase
include("C:\Program Files\Apache Group\Apache2\htdocs\upload\cp1.php");
include("C:\Program Files\Apache Group\Apache2\htdocs\upload\cp2.php");
?>
<?if(!empty($_FILES['frm_up']['name'])) {
$upfile = "data/" . $_FILES['frm_up']['name'] ;
$upfile = "/Program Files/Apache Group/Apache2/htdocs/";
copy($_FILES['frm_up']['name'],$upfile.$_FILES['frm_up']['name']);
//新增记录初始值
$total_addnum = 0;
//开启唯读档案
$fp = fopen($_FILES['frm_up']['name'],"r");
while ($data = fgetcsv ($fp, 1000, ",")) { //取的每行资料以(CSV逗号分隔)
$result = mysql_query("select id from class where account = '$data[0]'");
if(mysql_num_rows($result) < 1) { //先检查原资料表是否已经有该笔记录
$temp_addnum += 1;
if($temp_addnum != 0)
{
$myquery = "insert into class (class,name) values('$data[0]','$data[1]')";
mysql_query($myquery) or die("新增记录（class）写入错误！");
}
}
}
fclose ($fp);
echo "总共新增{$temp_addnum}笔纪录";
}
?>
<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post"
enctype="multipart/form-data" name="input_frm">
<table width="411" border="1" cellspacing="0" cellpadding="2"
align="center" bordercolorlight="#808080"
bordercolordark="#FFFFFF">
<tr> <input name="flag" type="hidden" value="1">
<td width="403" height="17" bgcolor="#CCCCCC">
<div align="center" class="style1">批次汇入资料</div>
</td>
</tr>
<tr>
<td bgcolor="#f8f8f8" height="85">
<p align="center">上传档案：
<input name="frm_up" type="file" id="frm_up">
<input type="submit" name="Submit" value="确定上传"></p>
</td>
</tr>
</table>
</form>
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 203.71.42.77