// php 操作 access 函数
function db_open(){
//连接数据库
$GLOBALS["db"]="D:\DataBase\mydb.mdb";
$GLOBALS["conn"] = new com("ADODB.Connection");
$connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".realpath($GLOBALS["db"]);
//$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".realpath($GLOBALS["db"]);
$GLOBALS["conn"]->open($connstr);
$GLOBALS["rs"] = new com("ADODB.RecordSet");
}
function db_close(){
//关闭数据库
$GLOBALS["conn"]->close();
}
function conn_execute($sql){
//执行sql
$GLOBALS["conn"]->execute(iconv("gb2312","UTF-8",$sql));
}
function rs_open($sql,$cursorType,$lockType){
//RecordSet的open方法
$GLOBALS["rs"]->Open($sql,$GLOBALS["conn"],$cursorType,$lockType);
}
function rs_close(){
//关闭RecordSet
$GLOBALS["rs"]->close();
}
function rs_recordcount(){
//RecordSet的recordcount方法
return $GLOBALS["rs"] -> recordcount();
}
function rs_eof(){
//RecordSet eof或bof
return $GLOBALS["rs"] -> eof||$GLOBALS["rs"] -> bof?true:false;
}
function rs_move($n){
//移动指针
$GLOBALS["rs"]->Move($n);
}
function rs_movenext(){
//移动指针+1
$GLOBALS["rs"]->MoveNext();
}
function rs($fieldName){
//移动指获取指定字段值
return iconv("gb2312","UTF-8",$GLOBALS["rs"]->Fields[$fieldName]->Value);
}
?>