php access数据导入mysql
php access数据导入mysql [代码片段(24行)]
<?PHP
ini_set('max_execution_time',300);
$conn = @new COM("ADODB.Connection") or die ("ADO Connection faild.");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("*.mdb");
$conn->Open($connstr);
$rs = @new COM("ADODB.RecordSet");
$rs->Open("select * from TABLE_NAME",$conn,1,3);
while(!$rs->eof){
$ftitle[]=iconv('GB2312','UTF-8',$rs->Fields["c_title"]->Value);
$fcontent[]=iconv('GB2312','UTF-8',$rs->Fields["c_content"]->Value);
$fcdate[]=strtotime($rs->Fields["c_date"]->Value);
$rs->Movenext(); //
}
$rs->close();
for ($i=0;$i<sizeof($ftitle);$i++){
$data=array(
"b_title"=>$ftitle[$i],
"b_content"=>$fcontent[$i],
"b_date"=>$fcdate[$i]
);
/**/
}
?>
//该片段来自于http://outofmemory.cn
- 上一篇:php 抽奖函数升级版
- 下一篇:php 识别电脑还是手机访问网站
精彩图集
精彩文章






