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