Example analysis of mysql database operation class in php

The code demonstrated in this article belongs to a relatively simple database encapsulation class, which is more suitable for beginners. Friends who need it can refer to

and then talk about the overall idea. The encapsulation of the entire class includes a private property $conn for connecting to the database and several operating functions. When $conn is instantiated, the constructor processes the incoming parameters and returns a resource-type connection handle. Then you can add, delete, check, and modify the database by calling the corresponding method of the instantiated object.

talk less and show code：

<?php
/** 
*以下代码用于数据库操作类的封装
* 
* @author rex<rex.sp.li@aliyun.com> 
* @version 1.0
* @since 2015
*/
class Mysql{
//数据库连接返回值
private $conn;
/**
* [构造函数，返回值给$conn]
* @param [string] $hostname [主机名]
* @param [string] $username[用户名]
* @param [string] $password[密码]
* @param [string] $dbname[数据库名]
* @param [string] $charset[字符集]
* @return [null]
*/
function __construct($hostname,$username,$password,$dbname,$charset=&#39;utf8&#39;){
　　$conn = @mysql_connect($hostname,$username,$password);
　　if(!$conn){
　　　　echo &#39;连接失败，请联系管理员&#39;;
　　　　exit;
　　}
　　$this->conn = $conn;
　　$res = mysql_select_db($dbname);
　　if(!$res){
　　echo &#39;连接失败，请联系管理员&#39;;
　　exit;
　　}
　　mysql_set_charset($charset);
}
function __destruct(){
　　mysql_close();
}
/**
* [getAll 获取所有信息]
* @param [string] $sql [sql语句]
* @return [array] [返回二维数组]
*/
function getAll($sql){
　　$result = mysql_query($sql,$this->conn);
　　$data = array();
　　if($result && mysql_num_rows($result)>0){
　　　　while($row = mysql_fetch_assoc($result)){
　　　　$data[] = $row;
　　　　}
　　}
　　return $data;
}
/**
* [getOne 获取单条数据]
* @param [string] $sql [sql语句]
* @return [array] [返回一维数组]
*/
function getOne($sql){
　　$result = mysql_query($sql,$this->conn);
　　$data = array();
　　if($result && mysql_num_rows($result)>0){
　　　　$data = mysql_fetch_assoc($result);
　　}
　　return $data;
}

/**
* [getOne 获取单条数据]
* @param [string] $table [表名]
* @param [string] $data [由字段名当键，属性当键值的一维数组]
* @return [type] [返回false或者插入数据的id]
*/

function insert($table,$data){
　　$str = &#39;&#39;;
　　$str .="INSERT INTO `$table` ";
　　$str .="(`".implode("`,`",array_keys($data))."`) "; 
　　$str .=" VALUES ";
　　$str .= "(&#39;".implode("&#39;,&#39;",$data)."&#39;)";
　　$res = mysql_query($str,$this->conn);
　　if($res && mysql_affected_rows()>0){
　　　　　　return mysql_insert_id();
　　}else{
　　　　return false;
　　}
}
/**
* [update 更新数据库]
* @param [string] $table [表名]
* @param [array] $data [更新的数据，由字段名当键，属性当键值的一维数组]
* @param [string] $where [条件，‘字段名&#39;=‘字段属性&#39;]
* @return [type] [更新成功返回影响的行数，更新失败返回false]
*/
function update($table,$data,$where){
　　$sql = &#39;UPDATE &#39;.$table.&#39; SET &#39;;
　　foreach($data as $key => $value){
　　$sql .= "`{$key}`=&#39;{$value}&#39;,";
　　}
　　$sql = rtrim($sql,&#39;,&#39;);
　　$sql .= " WHERE $where";
　　$res = mysql_query($sql,$this->conn);
　　if($res && mysql_affected_rows()){
　　　　return mysql_affected_rows();
　　}else{
　　return false;
　　}
}

/**
* [delete 删除数据]
* @param [string] $table [表名]
* @param [string] $where [条件，‘字段名&#39;=‘字段属性&#39;]
* @return [type] [成功返回影响的行数，失败返回false]
*/
function del($table,$where){
　　$sql = "DELETE FROM `{$table}` WHERE {$where}";
　　$res = mysql_query($sql,$this->conn);
　　if($res && mysql_affected_rows()){
　　　　return mysql_affected_rows();
　　}else{
　　return false;
　　}
}
}

Instantiated class:

<?php

//包含数据库操作类文件
include &#39;mysql.class.php&#39;;

//设置传入参数
$hostname=&#39;localhost&#39;;
$username=&#39;root&#39;;
$password=&#39;123456&#39;;
$dbname=&#39;aisi&#39;;
$charset = &#39;utf8&#39;;

//实例化对象

$db = new Mysql($hostname,$username,$password,$dbname);

//获取一条数据

$sql = "SELECT count(as_article_id) as count FROM as_article where as_article_type_id=1";
$count = $db->getOne($sql);

//获取多条数据

$sql = "SELECT * FROM as_article where as_article_type_id=1 order by as_article_addtime desc limit $start,$limit";
$service = $db->getAll($sql);

//插入数据

$arr = array(
&#39;as_article_title&#39;=>&#39;数据库操作类&#39;,
&#39;as_article_author&#39;=>&#39;rex&#39;,
);
$res = $db->insert(&#39;as_article&#39;,$arr);

//更新数据

$arr = array(
&#39;as_article_title&#39;=>&#39;实例化对象&#39;,
&#39;as_article_author&#39;=>&#39;Lee&#39;,
);
$where = "as_article_id=1";
$res = $db->update(&#39;as_article&#39;,$arr,$where);

//删除数据

$where = "as_article_id=1";
$res = $db->del(&#39;as_article&#39;,$where);

?>

Demonstration completed Code, maybe say a few words.

The getOne method passes in the sql statement of $sql to query a single piece of data and returns a one-dimensional array; the getAll method also passes in the sql statement to query multiple pieces of data and returns a two-dimensional array; the insert method passes Enter the table name and associative array, and return a boolen type or the index corresponding to the inserted data; the update method passes in the table name, an associative array, and conditions, and returns a boolen or the number of affected rows; the del method passes in the table name and conditions, and returns a boolen type.

That's all, but not the all. Friends who are interested can optimize it by passing getOne and getAll directly into the sql statement as parameters.

The above is the detailed content of Example analysis of mysql database operation class in php. For more information, please follow other related articles on the PHP Chinese website!