//mssql.php
$host="localhost";
$user="sa";
$password="";
$db="kao";error_reporting(7);
if(!$sql) $sql="select @@version";
echo "
$conn = new com("adodb.connection") or die("cannot start ado");
$conn->open("provider=sqloledb; data source=$host;
initial catalog=$db; user id=$user; password=$password");$rs = $conn->execute($sql);
$num_columns = $rs->fields->count();
echo $num_columns . "\n";
for ($i=0; $i {
$fld[$i] = $rs->fields($i);
}$rowcount = 0;
while (!$rs->eof)
{
for ($i=0; $i {
echo $fld[$i]->value . "\t";
}
echo "\n";
$rowcount++;
$rs->movenext();
}$rs->close();
$conn->close();$rs->release();
$conn->release();$rs = null;
$conn = null;
?>
立即学习“PHP免费学习笔记（深入）”；
立即学习“PHP免费学习笔记（深入）”；
立即学习“PHP免费学习笔记（深入）”；
立即学习“PHP免费学习笔记（深入）”；
php与Access数据库连接的代码
$dbc=new com("adodb.connection");
$dbc.open("driver=microsoft access driver (*.mdb);dbq=c:\member.mdb");
$rs=$dbc->execute("select * from tablename");
$i=0;
while (!$rs->eof){
$i+=1
$fld0=$rs->field(0);
$fld1=$rs->field(1);
....
echo "$fld0->value $fld1->value ....";
$rs->movenext();
}
$rs->close();
?>
