一个简洁的php操作access类,PHP操作Access类

PHP操作Access类(PHP+ODBC+Access)，Access数据库操作类。<?php //--------------------------------------------------------------------

//   使用范例：

//$databasepath="database.mdb";

//$dbusername="";

//$dbpassword="";

//include_once("class.php");

//$access=new Access($databasepath,$dbusername,$dbpassword);

//--------------------------------------------------------------------classAccess

{var$databasepath,$constr,$dbusername,$dbpassword,$link;functionAccess($databasepath,$dbusername,$dbpassword)

{$this->databasepath=$databasepath;$this->username=$dbusername;$this->password=$dbpassword;$this->connect();

}functionconnect()

{$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 "恭喜你,数据库连接成功!";

//else echo "数据库连接失败!";}functionquery($sql)

{return@odbc_exec($this->link,$sql);

}functionfirst_array($sql)

{returnodbc_fetch_array($this->query($sql));

}functionfetch_row($query)

{returnodbc_fetch_row($query);

}functiontotal_num($sql)//取得记录总数{returnodbc_num_rows($this->query($sql));

}functionclose()//关闭数据库连接函数{odbc_close($this->link);

}functioninsert($table,$field)//插入记录函数{$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);

}functiongetinfo($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;

}functiongetlist($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;

}functiongetfieldlist($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;

}functionupdateinfo($table,$field,$id,$set)//更新记录{$sql="UPDATE".$table."SET".$set."WHERE".$field."=".$id;$this->query($sql);

}functiondeleteinfo($table,$field,$id)//删除记录{$sql="DELETE FROM".$table."WHERE".$field."=".$id;$this->query($sql);

}functiondeleterecord($table,$condition)//删除指定条件的记录{$sql="DELETE FROM".$table."WHERE".$condition;$this->query($sql);

}functiongetcondrecord($table,$condition="")//取得指定条件的记录数{$sql="SELECT COUNT(*) AS num FROM".$table."".$condition;$query=$this->query($sql);$this->fetch_row($query);$num=odbc_result($query,1);return$num;

}

}?>