- <?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://www.codesnippet.cn/detail/070120148445.html
来源: http://www.codesnippet.cn/detail/070120148445.html