php把excel導(dǎo)入mysql 如何用php實現(xiàn)將excel導(dǎo)入到數(shù)據(jù)庫中?
如何用php實現(xiàn)將excel導(dǎo)入到數(shù)據(jù)庫中?我用的代碼是: //連接數(shù)據(jù)庫文件 $connect=mysql_connect("localhost","admin","admin") or die("
如何用php實現(xiàn)將excel導(dǎo)入到數(shù)據(jù)庫中?
我用的代碼是:
//連接數(shù)據(jù)庫文件
$connect=mysql_connect("localhost","admin","admin") or die("鏈接數(shù)據(jù)庫失敗!")
//連接數(shù)據(jù)庫(test)
mysql_select_db("testcg",$connect) or die (mysql_error())
$temp=file("test.csv")//連接EXCEL文件,格式為了.csv
for ($i=0$i