php连接数据库类封装用php连接数据库( 二 ) _数据库

?php
//包含数据库操作类文件
include 'mysql.class.php';
//设置传入参数
$hostname='localhost';
$username='root';
$password='123456';
$dbname='aisi';
$charset = 'utf8';
//实例化对象
$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(
'as_article_title'='数据库操作类',
'as_article_author'='rex',
);
$res = $db-insert('as_article',$arr);
//更新数据
$arr = array(
'as_article_title'='实例化对象',
'as_article_author'='Lee',
);
$where = "as_article_id=1";
$res = $db-update('as_article',$arr,$where);
//删除数据
$where = "as_article_id=1";
$res = $db-del('as_article',$where);
?
php封装一个class类实现mysql数据库的增删该查?php
class db{
private $db;
const MYSQL_OPT_READ_TIMEOUT = 11;
const MYSQL_OPT_WRITE_TIMEOUT = 12;
private $tbl_name;
private $where;
private $sort;
private $fields;
private $limit;
public static $_instance = null;
function __construct(){
$cfg = loadConfig('db');
$db = mysqli_init();
$db-options(self::MYSQL_OPT_READ_TIMEOUT, 3);
$db-options(self::MYSQL_OPT_WRITE_TIMEOUT, 1);
@$db-real_connect($cfg['host'],$cfg['user'],$cfg['pwd'],$cfg['db']);
if ($db-connect_error) {
$this-crash($db-errno,$db-error);
}
$db-set_charset("utf8");
$this-db = $db;
//echo $this-db-stat;
}
public static function getInstance(){
if(!(self::$_instance instanceof self)){
self::$_instance = new self();
}
return self::$_instance;
}
private function __clone() {}//覆盖__clone()方法php连接数据库类封装，禁止克隆
public function find($conditions = null){
if($conditions) $this-where($conditions);
return $this-getArray($this-buildSql(),1);
}
public function findAll($conditions = null){
if($conditions) $this-where($conditions);
return $this-getArray($this-buildSql());
}
//表
public function t($table){ $this-tbl_name = $table; return $this;}
//条件
public function where($conditions){
$where = '';
if(is_array($conditions)){
$join = array();
foreach( $conditions as $key = $condition ){
$condition = $this-db-real_escape_string($condition);
$join[] = "`{$key}` = '{$condition}'";
}
$where = "WHERE ".join(" AND ",$join);
}else{
if(null != $conditions) $where = "WHERE ".$conditions;
}
$this-where = $where;
return $this;
}
//排序
public function sort($sort){
if(null != $sort) $sort = "ORDER BY {$sort}";
$this-sort = $sort;
return $this;
}
//字段
public function fields($fields){$this-fields = $fields; return $this; }
public function limit($limit){$this-limit = $limit; return $this;}
private function buildSql(){
$this-fields = empty($this-fields) ? "*" : $this-fields;
$sql = "SELECT {$this-fields} FROM {$this-tbl_name} {$this-where} {$this-sort}";
accessLog('db_access',$sql);
if(null != $this-limit)$sql .= " limit {$this-limit}";
return $sql;
}
/**
* 返回查询数据
* @param$sql
* @param bool $hasOne
* @return array|bool|mixed
*/
private function getArray($sql,$hasOne = false){
if($this-db-real_query($sql) ){
if ($result = $this-db-use_result()) {

php连接数据库类封装用php连接数据库( 二 )

推荐阅读

学习和教育

4个妙招熬绿豆汤最解暑

中国最美的十座长江大桥，你去过其中的几座呢？世界上有哪些非常唯美漂亮的桥梁？

天涯明月刀手游食谱茶叶蛋怎么样茶叶蛋菜谱介绍

百岁老人怎么养生的百岁老人讲诉自己的如何养生

健身如何减肥呢健身怎样减肥

鸽子汤怎么炖最补肾

梦见和婆家人争吵梦见自己和婆家发生争吵

豆豆日志兑换码大全,豆豆日志app兑换码在哪用

数组转对象

洗澡热水器怎样省电视费,通过这种办法来

redislock注解 redislock

web前端|HTML5 Canvas可拖动的弹性大树摇摆动画

检测技术综合题分析题,中级会计实务计算分析题和综合题

蝴蝶梅什么时候开花蝴蝶梅什么时候开花结果

孕前不能吃哪些食物？

长江商学院实力怎么样？入学条件是什么？

解决大金空调启动问题大金空调绿灯亮不启动怎么办 ,有以下几个原因

贫血|变革与希望：HIF与CKD贫血“相遇之道”

女生超伤感个性网名女生超伤感个性网名推荐

php连接数据库类封装 用php连接数据库( 二 )

推荐阅读

php连接数据库类封装用php连接数据库( 二 )