wormbaby
(wormbaby)
中级会员
 
中级会员
UID 21863
精华
0
积分 396
帖子 395
金钱 396 喜悦币
威望 0
人脉 0
阅读权限 30
注册 2003-7-21
来自 北京
状态 离线
|
[推荐阅读] 页面输入数据不成功~~~~~
多谢蓝色提醒!!哈哈，已经可以了。比那咱方法好多了。
<?
$connect=mysql_connect("localhost","root","") or die("could not connect to database");
mysql_select_db("title",$connect) or die (mysql_error());
$row = 1;
$handle = fopen ("title.csv","r");
while ($data = fgetcsv ($handle, 1000, ",")) {
$num = count ($data);
print "<p> $num fields in line $row: <br>\n";
//print_r ($data);
$st2=addslashes($data[1]);
$q="insert into title (title,text,byname) values ('$data[0]','$st2','$data[2]')";
echo "$q<br>";
mysql_query($q) or die (mysql_error());
if (!mysql_error());
{
echo "ok";
}
$row++;
// for ($c=0; $c < $num; $c++) {
// print $data[$c] . "<br>\n";
//}
}
fclose ($handle);
?>
|
|
