mysql_class.php

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php
// +----------------------------------------------------------------------
// |MySQL操作类
// +----------------------------------------------------------------------
// | Author: justmepzy(justmepzy@gmail.com)
// +----------------------------------------------------------------------
class MySQL{
	
	private $db_mysql_hostname;
	private $db_mysql_username;
	private $db_mysql_password;
	private $db_mysql_database;
	private $db_mysql_port;
	private $db_mysql_charset;
	
	private $query_list = array();
	
	//查询次数
	public $query_count = 0;
	//查询开始时间
	public $query_start_time;
	
	//当前查询ID
	protected $queryID;
	//当前连接
	protected $conn;
	// 事务指令数
	protected $transTimes = 0;
	// 返回或者影响记录数
    protected $numRows    = 0;
    // 错误信息
    protected $error      = '';
	
	public function __construct($hostname_or_conf,$username,$password,$database,$port = '3306',$char = 'utf8'){
		if(is_array($hostname_or_conf)){
			$this->db_mysql_hostname = $hostname_or_conf['hostname'];
			$this->db_mysql_username = $hostname_or_conf['username'];
			$this->db_mysql_password = $hostname_or_conf['password'];
			$this->db_mysql_database = $hostname_or_conf['database'];
			$this->db_mysql_port = isset($hostname_or_conf['port'])?$hostname_or_conf['port']:'3306';
			$this->db_mysql_charset = isset($hostname_or_conf['charset'])?$hostname_or_conf['charset']:'utf8';
			
		}elseif(!empty($hostname_or_conf)||!empty($username)||!empty($password)||!empty($database))
		{
			 $this->db_mysql_hostname = $hostname_or_conf;
	  		 $this->db_mysql_username = $username;
	  		 $this->db_mysql_password = $password;
	 		 $this->db_mysql_database = $database;
			 $this->db_mysql_port = $port;
			 $this->db_mysql_charset = $char;
			 
		}else{
			die('configuration error.');
		}
      	$this->connect();
    }

	private function connect(){
		$server = $this->db_mysql_hostname.':'.$this->db_mysql_port;
		$this->conn = mysql_connect($server,$this->db_mysql_username,$this->db_mysql_password,true) or die('');