在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
<?php
//create link
$conn = @new com('ADODB.Connection') or die('ADO Connection failed.');
$connstr = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source='.$_SERVER['DOCUMENT_ROOT'].'\FILENAME.mdb';
$conn->Open($connstr);
echo 'linked successful';
//create search
$rs = @new com("ADODB.RecordSet");
$rs->Open("select * from TABLENAME",$conn);
//read data
while(!$rs->eof)
{
echo $rs->Fields['LISTNAME']->Value.'<br>';
$rs->Movenext();
}
$rs->close();
?>
例四:
try{ $path2="D:/myenv/Apache24/htdocs/www/xiongmaoxueyuan/xiongmaoxueyuan.accdb"; $db = new PDO("odbc:driver={microsoft access driver ( *.accdb)};dbq=".$path2); echo "Connected success\n"; } catch (Exception $e) { echo "Failed:".iconv('GB2312', 'UTF-8', $e->getMessage()); } $rs = $db->query('select * from test'); print "<pre>"; print_r($rs->fetchAll()); print "</pre>"; 例五:
?>
例六:
提供已知的几种连接方式: 1. $conn = new com("ADODB.Connection"); $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("test.mdb"); $conn->Open($connstr); 2. $conn=new com("ADODB.connection"); $connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("test.mdb"); $conn->open($connstr); 3. $connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password); 在ThinkPhp的controller中由于存在命名空间,所以要使用“$conn = new \com("ADODB.Connection");”
http://zhidao.baidu.com/question/383674258.html?qbl=relate_question_1&word=php%20mdb $rs=new com('adodb.recordset');$rs->Open('SELECT * FROM 数据表名',$conn,1,1); $rs->PageSize=50; $page=1; if(!empty($_GET['page'])){ $page=$_GET['page']; if($page<1)$page=1; if($page>$rs->PageCount)$page=$rs->PageCount; } $rs->AbsolutePage=$page; echo '<table width="100%"><tr>'; foreach( $rs->Fields as $name){ echo '<td>'.$name->Name.'</td>'; } echo '</tr>'; for(;!$rs->EOF;$rs->MoveNext()){ echo '<tr>'; foreach( $rs->Fields as $name){ echo '<td>'.$name.'</td>'; } echo '</tr>'; if($rs->AbsolutePosition>=$rs->AbsolutePage*$rs->PageSize)break; } echo '</tale>'; for($i=0;$i<$rs->PageCount;$i++){ echo '<a href="index.php?page='.($i+1).'"> '.($i+1).' </a>'; } |
2022-08-15
2022-08-17
2022-11-06
2022-08-18
2022-07-18
请发表评论