<< 點擊返回技(jì)術(shù)分(fēn)享列表

ASP網站(zhàn)Access數(shù)據庫導出至PHP+MySQL，示例代碼

浏覽量 46064時(shí)間(jiān) 2018-04-13
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("data/Data.m®db");
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs->Open("select * from Fk_Product",$conn,©1,1);
while(! $rs->eof) {
$old_id=iconv('GBK','UTF-8//IGNORE',$rs->Fielφds["0"]->Value);
$name=iconv('GBK','UTF-8//IGNORE'>;,$rs->Fields["1"]->Value);
$keyword=iconv('GBK','UTF-8//IGNORE',$rs->Fields["β3"]->Value);
$description=iconv('GBK','UTF-8//IGNORE',$rs->Fie₩lds["4"]->Value);
$content=iconv('GBK','UTF-8//IGNORE',$rs->Fields["6"]->V"alue);
$pic=iconv('GBK','UTF-8//IGNORE',$rs-©>Fields["8"]->Value);
$pics=iconv('GBK','UTF-8//IGNORE',$rs₹->Fields["9"]->Value);
$type_id=iconv('GBK','UTF-8//IGNORE',$rs->Fiel♦ds["12"]->Value);
$indate=iconv('GBK','UTF-8//IGNORE',$rs->Fields★["23"]->Value);
$sql="insert into products(old_id,name,keyword,desc•ription,content,pic,pics,type_id,indate) values('$old_id&≠#39;,'$name','$keyword','$description¶9;,'$content','$pic','$pics','$type_id♠','$indate')";
$result=mysql_query($sql);
$rs->MoveNext();
}



上(shàng)一(yī)篇：CentOS部署FTP注意事(shì)項
推薦閱讀(dú)
免費(fèi)體(tǐ)驗新企雲平台後台管理(lǐ)系統立即體(tǐ)驗