PHP数据库操作类 -tutorial php-php.cn

PHP数据库操作类

WBOY

Lepaskan： 2016-07-25 09:12:27

asal

885 orang telah melayarinya

/*==================================================================*/
/* 文件名:BaseLogic.class.php */
/* 概要: 数据处理公共类. */
class BaseLogic extends MyDB {
protected $tabName; //表的名称
protected $fieldList; //字段集合
protected $messList;
//==========================================
// 函数: add($postList)
// 功能: 添加
// 参数: $postList 提交的变量列表
// 返回: 刚插入的自增ID
//==========================================
function add($postList) {
$fieldList='';
$value='';
foreach ($postList as $k=>$v) {
if(in_array($k, $this->fieldList)){
$fieldList.=$k.",";
if (!get_magic_quotes_gpc())
$value .= "'".addslashes($v)."',";
else
$value .= "'".$v."',";
}
}
$fieldList=rtrim($fieldList, ",");
$value=rtrim($value, ",");
$sql = "INSERT INTO {$this->tabName} (".$fieldList.") VALUES(".$value.")";
echo $sql;
$result=$this->mysqli->query($sql);
if($result && $this->mysqli->affected_rows >0 )
return $this->mysqli->insert_id;
else
return false;
}
//==========================================
// 函数: mod($postList)
// 功能: 修改表数据
// 参数: $postList 提交的变量列表
//==========================================
function mod($postList) {
$id=$postList["id"];
unset($postList["id"]);
$value='';
foreach ($postList as $k=>$v) {
if(in_array($k, $this->fieldList)){
if (!get_magic_quotes_gpc())
$value .= $k." = '".addslashes($v)."',";
else
$value .= $k." = '".$v."',";
}
}
$value=rtrim($value, ",");
$sql = "UPDATE {$this->tabName} SET {$value} WHERE id={$id}";
return $this->mysqli->query($sql);
}
//==========================================
// 函数: del($id)
// 功能: 删除
// 参数: $id 编号或ID列表数组
// 返回: 0 失败成功为删除的记录数
//==========================================
function del($id) {
if(is_array($id))
$tmp = "IN (" . join(",", $id) . ")";
else
$tmp = "= $id";
$sql = "DELETE FROM {$this->tabName} WHERE id " . $tmp ;
return $this->mysqli->query($sql);
}
function get($id) {
$sql = "SELECT * FROM {$this->tabName} WHERE id ={$id}";
$result=$this->mysqli->query($sql);
if($result && $result->num_rows ==1){
return $result->fetch_assoc();
}else{
return false;
}
}
function getMessList(){
$message="";
if(!empty($this->messList)){
foreach($this->messList as $value){
$message.=$value."
";
}
}
return $message;
}
}
?>

复制代码