<?
/* title:数据库名字
** localhost主机名 root 数据库连接用户名 我这里密码为空
** title.csv csv文件名,从excel里另存成.csv结尾的
** newsmag 表名
*/
$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");//打开用excel导出的csv文件
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 newsmag (newstitle,newscontent,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);
?>
不懂。没办法用phpmyadmin实现吗? |