php access修改,Access的PHP操作类[修改]

//FileName:Access.class.php

//Summary: Access数据库操作类

//Author: forest

//CreateTime: 2006-8-10

//LastModifed:

//copyright (c)2006

//http://freeweb.nyist.net/~chairy

//[email]chaizuxue@163.com[/email]

// 使用范例：

//$databasepath="database.mdb";

//$dbusername="";

//$dbpassword="";

//include_once("Access.class.php");

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

// 2008.12.23 Aboc Edit /9986584

// 在判断字段是否为空时,用 is null / is not null

// 2011.4.30 Aboc Edit

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 );

if (!$this->link)die('数据库连接失败');

return $this->link;

}

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 );

}

/**

* 取得记录总数

*

* @param unknown_type $sql

* @return unknown

*/

function total_num($sql) {

return odbc_num_rows ( $this->query ( $sql ) );

}

/**

* 关闭连接

*

*/

function close() {

odbc_close ( $this->link );

}

/**

* 插入

*

* @param unknown_type $table

* @param unknown_type $array

*/

function insert($table, $array) {

if (empty($array))return false;

$k = array();

$v = array();

foreach ($array as $key=>$value){

if (!is_numeric($value)){

$value = trim($value);

$value = str_replace("'", "\'", $value);

}

$k[] = "`$key`";

$v[] = "'$value'";

}

$sql = "INSERT INTO " . $table . " (" . join(',', $k) . ") VALUES (" . join(',', $v) . ")";

return $this->query ( $sql );

}

/**

* 获取详情

* Enter description here ...

* @param unknown_type $table

* @param unknown_type $field

* @param unknown_type $id

* @param unknown_type $colnum

*/

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 < $colnum; $i ++) {

$info [$i] = odbc_result ( $query, $i );

}

}

return $info;

}

/**

* 取得记录列表

*

* @param unknown_type $table

* @param unknown_type $field

* @param unknown_type $colnum

* @param unknown_type $condition

* @param unknown_type $sort

* @return unknown

*/

function getlist($table, $field, $colnum, $condition, $sort = "ORDER BY id DESC") {

$sql = "SELECT * FROM " . $table . " " . $condition . " " . $sort;

//echo $sql;

$query = $this->query ( $sql );

$i = 0;

while ( $this->fetch_row ( $query ) ) {

$recordlist [$i] = $this->getinfo ( $table, $field, odbc_result ( $query, 1 ), $colnum );

$i ++;

}

return $recordlist;

}

/**

* 取得记录列表

*

* @param unknown_type $table

* @param unknown_type $field

* @param unknown_type $fieldnum

* @param unknown_type $condition

* @param unknown_type $sort

* @return unknown

*/

function getfieldlist($table, $field, $fieldnum, $condition = "", $sort = "") {

$sql = "SELECT " . $field . " FROM " . $table . " " . $condition . " " . $sort;

$query = $this->query ( $sql );

$i = 0;

$rdlist = array();

while ( $this->fetch_row ( $query ) ) {

$info = array();

for($j = 0; $j < $fieldnum; $j ++) {

$info [$j] = odbc_result ( $query, $j + 1 );

}

$rdlist [$i] = $info;

$i ++;

}

return $rdlist;

}

/**

* 获取所有数据

* Enter description here ...

* @param unknown_type $table

* @param unknown_type $field

* @param unknown_type $where

* @param unknown_type $limit

* @param unknown_type $order

*/

function fetchAll($table,$field=array(),$where,$limit='',$order=''){

$where = !empty($where)?"where $where":'';

$limit = $limit!=''?"top $limit":'';

$order = $order != ''?" order by $order":'';

$sql = "select $limit ".join(',', $limit)." from $table $where $order";

$query = $this->query ( $sql );

$i = 0;

$fieldnum = count($field);

$rdlist = array();

while ( $this->fetch_row ( $query ) ) {

$info = array();

for($j = 0; $j < $fieldnum; $j ++) {

$info [$field[$j]] = odbc_result ( $query, $j + 1 );

}

$rdlist [$i] = $info;

$i ++;

}

return $rdlist;

}

/**

* 更新

*

* @param unknown_type $table

* @param unknown_type $field

* @param unknown_type $id

* @param unknown_type $set

*/

function updateinfo($table, $field, $id, $set) {

$where = ! empty ( $field ) ? " WHERE " . $field . "=" . $id : "";

$sql = "UPDATE " . $table . " SET " . $set . $where;

return $this->query ( $sql );

}

/**

* 更新2

* Enter description here ...

* @param unknown_type $table

* @param unknown_type $array

* @param unknown_type $where

*/

function update($table,$array,$where){

$where = !empty($where)?"where $where":'';

if (empty($array))return false;

$set = '';

foreach ($array as $key=>$value){

if (!is_numeric($value)){

$value = trim($value);

$value = str_replace("'", "\'", $value);

}

$set .= !empty($set)?",`$key`='$value'":"`$key`='$value'";

}

return $this->query ("update $table set $set $where ");

}

/**

* 删除

*

* @param unknown_type $table

* @param unknown_type $field

* @param unknown_type $id

*/

function deleteinfo($table, $field, $id) {

$where = ! empty ( $field ) ? " WHERE " . $field . "=" . $id : "";

$sql = "DELETE FROM " . $table . $where;

//echo $sql;exit;

return $this->query ( $sql );

}

/**

* 删除2

* Enter description here ...

* @param unknown_type $table

* @param unknown_type $where

*/

function delete($table,$where){

$where = !empty($where)?"where $where":'';

return $this->query ("DELETE FROM " . $table . $where);

}

/**

* 依条件删除/带where

*

* @param unknown_type $table

* @param unknown_type $condition

*/

function deleterecord($table, $condition) {

$sql = "DELETE FROM " . $table . " WHERE " . $condition;

$this->query ( $sql );

}

/**

* 取得指定条件的记录数/不带where

*

* @param unknown_type $table

* @param unknown_type $condition

* @return unknown

*/

function getcondrecord($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;

}

}

?>