PHP连接Access数据库无错版

总是需要一些温暖。哪怕是一点点自以为是的纪念。注册 | 登陆

Submitted by 海东青 on 2008, December 12, 8:13 PM. 电脑技术

$conn=@new COM("adodb.connection") or die("connection is error!");
$connStr="Provider = Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("easy.mdb");
$conn->Open($connStr);

$sqlStr="select * from Userdata";
$rs = @new COM("ADODB.RecordSet");
$rs->Open($sqlStr,$conn,1,3);
//$rs=$conn->execute(sqlStr);
$i=0;
while (!$rs->eof)
{
  $i+=1;
  $U_money=$rs->Fields["U_money"]->Value;
  $U_name=$rs->Fields["U_name"]->Value;
//   $U_money=$rs["U_money"];
//   $U_name=$rs["U_name"];
  echo "$U_money ";
  echo "$U_name ";
  echo "
";
  $rs->movenext();
}
echo "共 $i 条记录";
$rs->Close();
$rs->Release();
$rs=null;
$conn->Close();
$conn->Release();
$conn=null;
?>