php链接MDB数据库代码示例
- 例一:
- <?php
- //php链接MDB数据库代码示例
- $connstr = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("C:\Program Files\Att2008\att2000.mdb");
- $conn = odbc_connect($connstr, "", "", SQL_CUR_USE_ODBC);
- $issuetime = date("Y-m-d H:i:s");
- $sql = "select * from CHECKINOUT where USERID=2";
- $query = odbc_exec($conn, $sql);
- while ($row = odbc_fetch_array($query)) {
- $dt = $row["USERID"];
- $checktime = $row["CHECKTIME"];
- if($checktime < "2011-5-18 13:35:02") {
- echo $checktime;
- }
- }
- ?>
- 例二:
- <?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\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>";
例五:
-
<?
-
$conn = new com("ADODB.Connection");
-
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("data/db.mdb");
-
$conn->Open($connstr);
-
$rs = new com("ADODB.RecordSet");
-
$rs->Open("select * from szd_t",$conn,1,1);
-
while(! $rs->eof) {
-
$f = $rs->Fields(1);
-
echo $f->value;
-
$rs->MoveNext();
-
}
?>
例六:
提供已知的几种连接方式: 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>';
}