1.PHP访问Access数据库
程序代码
<?php
$conn = new com("ADODB.Connection");
$rs = new com("ADODB.RecordSet");
$connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("db1.mdb");
$conn->Open($connstr);
$rs->Open("select * from movie",$conn,1,1);
while(! $rs->eof) {
echo $rs->Fields(1)."<br/>";
$rs->MoveNext();
}
$rs->close;
$rs=null;
$conn->close;
$conn=null;
?>
2.PHP访问Sql Server2000数据库
程序代码
<?php
$conn = new com("ADODB.Connection");
$rs = new com("ADODB.RecordSet");
$connstr="provider=sqloledb;data source=(local);uid=sa;pwd=sa;database=db1";
$conn->Open($connstr);
$rs->Open("select * from movie",$conn,1,1);
while(! $rs->eof) {
echo $rs->Fields(1)."<br/>";
$rs->MoveNext();
}
$rs->close;
$rs=null;
$conn->close;
$conn=null;
?>
程序代码$conn = new com("ADODB.Connection");
$rs = new com("ADODB.RecordSet");
$connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("db1.mdb");
$conn->Open($connstr);
$rs->Open("select * from movie",$conn,1,1);
while(! $rs->eof) {
echo $rs->Fields(1)."<br/>";
$rs->MoveNext();
}
$rs->close;
$rs=null;
$conn->close;
$conn=null;
?>
2.PHP访问Sql Server2000数据库
程序代码<?php
$conn = new com("ADODB.Connection");
$rs = new com("ADODB.RecordSet");
$connstr="provider=sqloledb;data source=(local);uid=sa;pwd=sa;database=db1";
$conn->Open($connstr);
$rs->Open("select * from movie",$conn,1,1);
while(! $rs->eof) {
echo $rs->Fields(1)."<br/>";
$rs->MoveNext();
}
$rs->close;
$rs=null;
$conn->close;
$conn=null;
?>