<?
$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 " <br/> " ;
$rs -> movenext();
}
echo " 共 $i 条记录 " ;
$rs -> Close();
$rs -> Release();
$rs = null ;
$conn -> Close();
$conn -> Release();
$conn = null ;
?>
$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 " <br/> " ;
$rs -> movenext();
}
echo " 共 $i 条记录 " ;
$rs -> Close();
$rs -> Release();
$rs = null ;
$conn -> Close();
$conn -> Release();
$conn = null ;
?>
以上代码在winXP SP2 IIS5.1 PHP5下测试通过