推荐你用ADODB类库支持,差不多全部的数据库
Windows下支持Access<?php
include('adodb/tohtml.inc.php'); // load code common to ADODB
include('adodb/adodb.inc.php'); // load code common to ADODB
$db= &ADONewConnection("ado_access"); $access=realpath('test1.mdb');
$myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'.'DATA SOURCE='.$access.';'.'USER ID=;PASSWORD=;';
if (@$db->PConnect($myDSN,"","","")) {
print "ADO version=".$db->_connectionID->version."<br>";
$sql= 'select * from artC order by cat_id asc';
$rs=$db->Execute($sql);
rs2html($rs,'border=2 cellpadding=3',array('Customer Name','Customer ID')); } else print "ERROR: Access test requires a Access database $access".'<BR>'.$db->ErrorMsg();
?>
Windows下支持Access<?php
include('adodb/tohtml.inc.php'); // load code common to ADODB
include('adodb/adodb.inc.php'); // load code common to ADODB
$db= &ADONewConnection("ado_access"); $access=realpath('test1.mdb');
$myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'.'DATA SOURCE='.$access.';'.'USER ID=;PASSWORD=;';
if (@$db->PConnect($myDSN,"","","")) {
print "ADO version=".$db->_connectionID->version."<br>";
$sql= 'select * from artC order by cat_id asc';
$rs=$db->Execute($sql);
rs2html($rs,'border=2 cellpadding=3',array('Customer Name','Customer ID')); } else print "ERROR: Access test requires a Access database $access".'<BR>'.$db->ErrorMsg();
?>
这个是
include('adodb/tohtml.inc.php');
里的一个函数,不用也可以
这个文件不包含也可以
$sql= 'select * from artC order by cat_id asc';
$rs=$db->Execute($sql);
rs2html($rs,'border=2 cellpadding=3',array('Customer Name','Customer ID')); 换成$sql= 'select * from artC order by cat_id asc';
$rs=$db->Execute($sql);
while(!$rs->EOF) {
echo $rs->fields["artId"].$rs->fields["title"];
$rs->MoveNext();
}官方:
http://adodb.sourceforge.net/