php链接MDB数据库代码示例

1. 例一：
2. <?php
3.     //php链接MDB数据库代码示例
4. $connstr = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("C:Program FilesAtt2008att2000.mdb");
5. $conn = odbc_connect($connstr, "", "", SQL_CUR_USE_ODBC);
6. $issuetime = date("Y-m-d H:i:s");
7. $sql = "select * from CHECKINOUT where USERID=2";
8. $query = odbc_exec($conn, $sql);
9. while ($row = odbc_fetch_array($query)) {
10.     $dt = $row["USERID"];
11.     $checktime = $row["CHECKTIME"];
12.     if($checktime < "2011-5-18 13:35:02") {
13.         echo $checktime;
14.     }
15. }
16. ?>

 

1. 例二：

• <?php
• /***
•   This file is just for an example of Php+Access.
•   You can find these functions from http://www.php100.com/cover/php/1681.html
• */
• /* ODBC string */
• $odbc = "Driver={Microsoft Access Driver (*.mdb)};Dbq=".realpath("our.mdb");
• $conn = odbc_connect($odbc, '', '', SQL_CUR_USE_ODBC);
• $sql ="select * from test";
• $query = odbc_exec($conn, $sql);
• print $query."</br>";
• $num = odbc_num_fields($query);
• if ($num != 0)
•     for($i=1; $i<$num; $i++)
•     {
•         $row = odbc_fetch_row($query);
•         echo "->".odbc_result($query,"Addr")."</br>";
•         //echo "->".odbc_result($query,3)."</br>"; /* the same as Line 24*/
•     }
• else
•     print "No data";
• ?>

• 例三：

<?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 ";
 
        } 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. <?
2. 　　$conn = new com("ADODB.Connection");
3. 　　$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("data/db.mdb");
4. 　　$conn->Open($connstr);
5. 　　$rs = new com("ADODB.RecordSet");
6. 　　$rs->Open("select * from szd_t",$conn,1,1);
7. while(! $rs->eof) {
8. 　　$f = $rs->Fields(1);
9. echo $f->value;
10. 　　$rs->MoveNext();
11. 　　}

?>

 

 

 

 

例六：

 

提供已知的几种连接方式：

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>';
}