復制代碼 代碼如下:

--------------------------------------------------------------------
//FileName:class.php
//Summary:?Access數(shù)據(jù)庫操作類
//Author:??forest
//CreateTime:?2006-8-10?????
//LastModifed:
//copyright?(c)2006?freeweb.nyist.net/~chairy??[email]chaizuxue@163.com[/email]
//???使用范例：
//$databasepath="database.mdb";
//$dbusername="";
//$dbpassword="";
//include_once("class.php");
//$access=new?Access($databasepath,$dbusername,$dbpassword);

--------------------------------------------------------------------
????class?Access
????{
?????????var?$databasepath,$constr,$dbusername,$dbpassword,$link;
?????????function?Access($databasepath,$dbusername,$dbpassword)
?????????{
???????????????$this->databasepath=$databasepath;
????????$this->username=$dbusername;
????????$this->password=$dbpassword;
????????$this->connect();
??????????}

????function?connect()
????{
????????$this->constr="DRIVER={Microsoft?Access?Driver?(*.mdb)};?DBQ="?.?realpath($this->databasepath);?
????????$this->link=odbc_connect($this->constr,$this->username,$this->password,SQL_CUR_USE_ODBC);
????????return?$this->link;
????????//if($this->link)?echo?"恭喜你,數(shù)據(jù)庫連接成功!";
????????//else?echo?"數(shù)據(jù)庫連接失敗!";
????}

????function?query($sql)
????{
????????return?@odbc_exec($this->link,$sql);
????}

????function?first_array($sql)
????{
????????return?odbc_fetch_array($this->query($sql));
????}

????function?fetch_row($query)
????{
????????return?odbc_fetch_row($query);
????}

????function?total_num($sql)//取得記錄總數(shù)
????{
????????return?odbc_num_rows($this->query($sql));
????}

????function?close()//關(guān)閉數(shù)據(jù)庫連接函數(shù)
????{????
????????odbc_close($this->link);
????}

????function?insert($table,$field)//插入記錄函數(shù)
????{
????????$temp=explode(',',$field);
????????$ins='';
????????for?($i=0;$i????????{
????????????$ins.="'".$_POST[$temp[$i]]."',";
????????}
????????$ins=substr($ins,0,-1);
????????$sql="INSERT?INTO?".$table."?(".$field.")?VALUES?(".$ins.")";
????????$this->query($sql);
????}

????function?getinfo($table,$field,$id,$colnum)//取得當條記錄詳細信息
????{
????????$sql="SELECT?*?FROM?".$table."?WHERE?".$field."=".$id."";
????????$query=$this->query($sql);
????????if($this->fetch_row($query))
????????{
????????????for?($i=1;$i????????????{
??????????$info[$i]=odbc_result($query,$i);
?????????????}
?????????}
?????????return?$info;
????}

????function?getlist($table,$field,$colnum,$condition,$sort="ORDER?BY?id?DESC")//取得記錄列表????
????{
?????????$sql="SELECT?*?FROM?".$table."?".$condition."?".$sort;
?????????$query=$this->query($sql);
?????????$i=0;
?????????while?($this->fetch_row($query))?
?????????{
????????$recordlist[$i]=getinfo($table,$field,odbc_result($query,1),$colnum);
????????$i++;
??????????}
??????????return?$recordlist;
????}

????function?getfieldlist($table,$field,$fieldnum,$condition="",$sort="")//取得記錄列表
????{
?????????$sql="SELECT?".$field."?FROM?".$table."?".$condition."?".$sort;
?????????$query=$this->query($sql);
?????????$i=0;
?????????while?($this->fetch_row($query))?
?????????{
?????????for?($j=0;$j????????{
???????????????????$info[$j]=odbc_result($query,$j+1);
????????}????
????????$rdlist[$i]=$info;
????????$i++;
?????????}
?????????return?$rdlist;
????}

????function?updateinfo($table,$field,$id,$set)//更新記錄
????{
????????$sql="UPDATE?".$table."?SET?".$set."?WHERE?".$field."=".$id;
????????$this->query($sql);
????}

????function?deleteinfo($table,$field,$id)//刪除記錄
????{
?????????$sql="DELETE?FROM?".$table."?WHERE?".$field."=".$id;
?????????$this->query($sql);
????}

????function?deleterecord($table,$condition)//刪除指定條件的記錄
????{
?????????$sql="DELETE?FROM?".$table."?WHERE?".$condition;
?????????$this->query($sql);
????}

????function?getcondrecord($table,$condition="")//?取得指定條件的記錄數(shù)
????{
?????????$sql="SELECT?COUNT(*)?AS?num?FROM?".$table."?".$condition;
?????????$query=$this->query($sql);
?????????$this->fetch_row($query);
?????????$num=odbc_result($query,1);
?????????return?$num;????????????
????}
?????}
?>??

?