php pdo mysql类源码_实用PDO MYSQL数库操作类

配制

/*配制*/

return array (

'DB_Default'=>'Default',//默认连接

/* 主数据 */

'Default' =>

array (

'DB_HOST' => '127.0.0.1', // 服务器地址

'DB_NAME' => '8now_invoicing', // 数据库名

'DB_USER' => 'root', // 用户名

'DB_PWD' => '', // 密码

'DB_PREFIX' => '8now_', // 数据库表前缀

'DB_CHARSET' => 'utf8' ), // 数据库编码默认采用utf8

);<?php

/**

* 数据库操作类

* @author 角度 QQ:1286522207

*

*/

class db {

public $data_Default;

private $DB_HOST;

private $DB_NAME;

private $DB_USER;

private $DB_PWD;

private $DB_PREFIX;

private $DB_CHARSET;

public $Limit = " LIMIT 1";

public $OrderBy;

public $and;

public $dbname;

protected $sign = array ('=', '<>', '>', '=', '<=' );

function __construct($db) {

$dbmysql = include ROOT_CONFIG . 'db.php';

$dbconfig = $dbmysql [$db];

$this->DB_HOST = $dbconfig ['DB_HOST'];

$this->DB_NAME = $dbconfig ['DB_NAME'];

$this->DB_USER = $dbconfig ['DB_USER'];

$this->DB_PWD = $dbconfig ['DB_PWD'];

$this->DB_PREFIX = $dbconfig ['DB_PREFIX'];

$this->DB_CHARSET = $dbconfig ['DB_CHARSET'];

}

private function pdo_db() {

try {

return new PDO ( "mysql:host=$this->DB_HOST;dbname=$this->DB_NAME", $this->DB_USER,

$this->DB_PWD, array (PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES '$this->DB_CHARSET'",

PDO::ATTR_PERSISTENT => true ) );

} catch ( Exception $e ) {

echo '数据库连接失败,详情: ' . $e->getMessage () . ' 请在/config/db.php中配制正确的数据库连接信息';

exit ();

}

}

public function M($name) {

$this->dbname = $this->DB_PREFIX . $name;

}

/**

* 处理条件

*/

public function where($where) {

if (! $this->and)

$this->and = ' and';

if (is_array ( $where )) {

foreach ( $where as $key => $row ) {

$w [] = " `$key`='$row'";

}

$sql = " WHERE (" . trim ( implode ( $this->and, $w ) ) . ") ";

} elseif (! $where) {

return false;

} else {

$sql = " WHERE " . $where;

}

return $sql;

}

/**

* 处理数据

*/

private function date($date) {

if (is_array ( $date )) {

foreach ( $date as $key => $row ) {

$d [] = "`" . $key . "`='" . $row . "'";

}

return implode ( ',', $d );

} else {

return $date;

}

}

/**

* 处理插入数据

*/

public function Upvalues($date) {

if (is_array ( $date )) {

foreach ( $date as $key => $row ) {

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

$r [] = "'" . $row . "'";

}

$k = "(" . implode ( ',', $k ) . ")";

$r = "(" . implode ( ',', $r ) . ")";

return $k . ' VALUES ' . $r;

} else {

return false;

}

}

/**

* 排序

* @param 列 $Row

* @param ASC or DESC$ORDER

*/

public function OrderBy($Row = '', $ORDER = 'DESC') {

$this->OrderBy = "ORDER BY `$Row` $ORDER";

}

/**

* 执行查询语句 SELECT

*/

public function query($sql) {

return empty ( $sql ) ? exit ( '必须指定SQL语句' ) : $this->pdo_db ()->query ( $sql );

}

/**

* 执行 INSERT、UPDATE、DELETE

*/

public function exec($sql) {

return empty ( $sql ) ? exit ( '必须指定SQL语句' ) : $this->pdo_db ()->exec ( $sql );

}

/**

* 查询个数

*/

public function Limit($a = NULL, $b = NULL) {

$this->Limit = Filter::IntegerFilter ( $a ) && Filter::IntegerFilter ( $b ) ? " LIMIT $a,$b" : '';

}

/**

* 处理多个查询条件

*

*/

public function LIKEMultipleQueries($LIKE, $W) {

$LIKE = array_filter ( explode ( ' ', trim ( $LIKE ) ) );

if (is_array ( $LIKE )) {

foreach ( $LIKE as $row ) {

$l [] = "`$W` LIKE '%" . trim ( $row ) . "%'";

}

return '(' . implode ( ' OR ', $l ) . ')';

}

}

/**

* 点亮关键字

*/

public $SearchLightKey = array ();

public function SearchLightKey($array, $q) {

foreach ( $array as $s ) {

foreach ( $q as $key => $row ) {

$row = array_filter ( explode ( ' ', trim ( $row ) ) );

if ($s [$key]) {

foreach ( $row as $r ) {

$s [$key] = preg_replace ( "/(" . trim ( $r ) . ")/i",

"\\1", $s [$key] );

}

}

}

$this->SearchLightKey [] = $s;

}

}

/**快捷操作开始**/

/**

* 查询一条数据

*/

public function find($where, $Row = '*') {

$sql = "SELECT $Row FROM `$this->dbname` " . $this->where ( $where ) . $this->OrderBy . $this->Limit;

return $this->pdo_db ()->query ( $sql )->fetch ();

}

/**

* 查询多条数据

*/

public function findAll($where, $Row = '*') {

$sql = "SELECT $Row FROM `$this->dbname` " . $this->where ( $where ) . $this->OrderBy . $this->Limit;

return $this->pdo_db ()->query ( $sql )->fetchAll ();

}

/**

* 查询总数

*/

public function findsum($where, $Row) {

$sql = "SELECT SUM($Row) as $Row FROM `$this->dbname` " . $this->where ( $where ) . " LIMIT 1";

return $this->pdo_db ()->query ( $sql )->fetch ();

}

/**

* 查询个数

*/

public function findcount($where, $Row) {

$sql = "SELECT COUNT($Row) as $Row FROM `$this->dbname` " . $this->where ( $where ) . " LIMIT 1 ";

return $this->pdo_db ()->query ( $sql )->fetch ();

}

/**

* 更新数据

*/

public function update($date, $where) {

$sql = "UPDATE `$this->dbname` SET " . $this->date ( $date ) . $this->where ( $where ) . ";";

return $this->pdo_db ()->exec ( $sql );

}

/**

* 插入数据

*/

public function insert($date) {

$sql = "INSERT INTO `$this->dbname` " . $this->Upvalues ( $date ) . ";";

$pdo = $this->pdo_db ();

return $pdo->exec ( $sql ) ? $pdo->lastInsertId () : false;

}

/**

* 删除数据

*/

public function delete($where) {

$sql = "DELETE FROM `$this->dbname` " . $this->where ( $where ) . $this->Limit . ";";

return $this->pdo_db ()->exec ( $sql );

}

}

以上就是实用PDO MYSQL数库操作类的内容，更多相关内容请关注PHP中文网(www.php.cn)！

本文原创发布php中文网，转载请注明出处，感谢您的尊重！