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 识别电脑还是手机访问网站
精彩图集
精彩文章