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;
}
}?>