PHP封裝數(shù)據(jù)庫操作類
而PHP在訪問數(shù)據(jù)庫的時候又經(jīng)常會出現(xiàn)各種問題，如字符編碼問題、SQL語法錯誤問題、PHP處理數(shù)據(jù)記錄對象和返回對象的問題等。下面內(nèi)容由小編為大家介紹PHP封裝數(shù)據(jù)庫操作類方法，供大家參考!
優(yōu)點:
方便快捷, 數(shù)據(jù)庫操作只需調(diào)用接口;
統(tǒng)一編碼(utf8),不易導(dǎo)致亂碼
結(jié)構(gòu)清晰. 如處理前端請求的后臺程序(test.php) + 表封裝類(user.class.php) + 數(shù)據(jù)庫封裝類(db.class.php) + 配置信息(configuration.php)
以下例子有四個文件: configuration.php + db.class.php + user.class.php + test.php，放在同一個目錄下。
首先是一個數(shù)據(jù)庫配置的文件類configuration.php
/**
* 數(shù)據(jù)庫配置信息
*/
define('DB_HOST','localhost'); /pic/p>
define('DB_USER','root'); /pic/p>
define('DB_PASSWORD',''); /pic/p>
define('DB_NAME','test0'); /pic/p>
define('DB_CHARSET','utf8'); /pic/p>
define('TIMEZONE',"PRC"); /pic/p>
?>
接下來就是數(shù)據(jù)庫操作類db.class.php
require_once("./configuration.php"); /pic/p>
date_default_timezone_set(TIMEZONE);
/**
* 類名：DB
* 說明：數(shù)據(jù)庫操作類
*/
class
DB
{
public
$host; /pic/p>
public
$username; /pic/p>
public
$password; /pic/p>
public
$dbname; /pic/p>
public
$conn; /pic/p>
/**
* DB類構(gòu)造函數(shù)
*/
public
function DB($host=DB_HOST ,$username=DB_USER,$password=DB_PASSWORD,$dbname=DB_NAME)
{
$this->host = $host;
$this->username = $username;
$this->password = $password;
$this->dbname = $dbname;
}
/**
* 打開數(shù)據(jù)庫連接
*/
public
function open()
{
$this->conn = mysql_connect($this->host,$this->username,$this->password);
mysql_select_db($this->dbname);
mysql_query("SET CHARACTER SET utf8");
}
/**
* 關(guān)閉數(shù)據(jù)連接
*/
public
function close()
{
mysql_close($this->conn);
}
/**
* 通過sql語句獲取數(shù)據(jù)
* @return: array()
*/
public
function getObjListBySql($sql)
{
$this->open();
$rs
= mysql_query($sql,$this->conn);
$objList
= array();
while($obj
= mysql_fetch_object($rs))
{
if($obj)
{
$objList[] = $obj;
}
}
$this->close();
return
$objList;
}
/**
* 向數(shù)據(jù)庫表中插入數(shù)據(jù)
* @param：$table,表名
* @param：$columns,包含表中所有字段名的數(shù)組。默認(rèn)空數(shù)組，則是全部有序字段名
* @param：$values,包含對應(yīng)所有字段的屬性值的數(shù)組
*/
public
function Data($table,$columns=array(),$values=array())
{
$sql
= ' into '.$table
.'( ';
for($i
= 0; $i
< sizeof($columns);$i
++)
{
$sql
.= $columns[$i];
if($i
< sizeof($columns) - 1)
{
$sql
.= ',';
}
}
$sql
.= ') values ( ';
for($i
= 0; $i
< sizeof($values);$i
++)
{
$sql
.= "'".$values[$i]."'";
if($i
< sizeof($values) - 1)
{
$sql
.= ',';
}
}
$sql
.= ' )';
$this->open();
mysql_query($sql,$this->conn);
$id
= mysql__id($this->conn);
$this->close();
return
$id;
}
/**
* 通過表中的某一屬性獲取數(shù)據(jù)
*/
public
function getDataByAtr($tableName,$atrName,$atrValue){
@$data
= $this->getObjListBySql("SELECT * FROM ".$tableName." WHERE $atrName = '$atrValue'");
if(count($data)!=0)return
$data;
return
NULL;
}
/**
* 通過表中的"id"，刪除記錄
*/
public
function ($tableName,$atrName,$atrValue){
$this->open();
$Result
= false;
if(mysql_query("DELETE FROM ".$tableName." WHERE $atrName = '$atrValue'")) $Result
= true;
$this->close();
if($Result) return
true;
else
return false;
}
/**
* 更新表中的屬性值
*/
public
function updateParamById($tableName,$atrName,$atrValue,$key,$value){
$db
= new
DB();
$db->open();
if(mysql_query("UPDATE ".$tableName." SET $key = '$value' WHERE $atrName = '$atrValue' ")){ /pic/p>
$db->close();
return
true;
}
else{
$db->close();
return
false;
}
}
/*
* @description: 取得一個table的所有屬性名
* @param: $tbName 表名
* @return：字符串?dāng)?shù)組
*/
public
function fieldName($tbName){
$resultName=array();
$i=0;
$this->open();
$result
= mysql_query("SELECT * FROM $tbName");
while
($property
= mysql_fetch_field($result)){
$resultName[$i++]=$property->name;
}
$this->close();
return
$resultName;
}
}
?>
接下來是測試了。我在phpmyadmin中建了一個test0數(shù)據(jù)庫，里面建一張表user。然后用php寫一個user類對應(yīng)數(shù)據(jù)庫中的user表。
user.class.php
require_once("./db.class.php");
class
User{
public
$name = NULL;
public
$password = NULL;
/**
* 構(gòu)造函數(shù)
*/
public
function __construct($name,$password){
$this->name = $name;
$this->password = $password;
}
public
function (){
$db
= new
DB();
$resultid
= $db->Data("user",array(),array('',$this->name,$this->password));
return
$resultid;
}
public
static function getUserById($uid){
$db
= new
DB();
return
$db->getDataByAtr("user",'uid',$uid);
}
public
static function getUserByName($name){
$db
= new
DB();
@$data
= $db->getObjListBySql("SELECT * FROM user WHERE name = '$name'");
if(count($data)!=0)return
$data;
else
return null;
}
public
static function getAllUser(){
$db
= new
DB();
@$data
= $db->getObjListBySql("SELECT * FROM user");
if(count($data)!=0) return
$data;
else
return null;
}
public
static function ByUid($uid){
$admin
= Admin::getAdminById($uid);
$db
= new
DB();
if($db->("user","uid",$uid)) return
true;
else
return false;
}
}
?>
測試程序: test.php
header("Content-Type:text/html; charset=utf8");
require_once("./user.class.php");
$user
= new
User("HelloWorld","123456");
$user->();
$users
= User::getAllUser();
foreach
($users
as $u) {
echo
"
".$u->name."
".$u->password."
";
}
?>
運行結(jié)果:
【PHP封裝數(shù)據(jù)庫操作類】相關(guān)文章：
PHP操作MySQL數(shù)據(jù)庫的基本類03-22
PHP對數(shù)據(jù)庫MySQL的連接操作12-02
PHP中FTP操作類代碼03-03
關(guān)于php操作mysql執(zhí)行數(shù)據(jù)庫查詢09-18
PHP中如何定義類及其成員屬性與操作03-06
PHP訪問數(shù)據(jù)庫11-12
PHP中的Reload操作12-19