mysql database operation class_PHP tutorial-PHP Tutorial-php.cn

mysql database operation class_PHP tutorial

WBOY

Release： 2016-07-13 17:05:12

Original

819 people have browsed it

mysql database operation class This section uses the php mysql database operation function. It can delete, modify, add, backup and other operations on the database. It also supports two database connection methods, and the settings of the previous database encoding, etc.

mysql tutorial database tutorial operation class
This article uses the MySQL database operation function of the PHP tutorial. It can delete, modify, add, backup and other operations on the database. It also supports two database connection methods, and the settings of the previous database encoding, etc.
*/

class dbstuff {
var $querynum = 0;
var $link;
var $sqlid;
var $record;
var $dbcharset='utf-8';
var $charset='utf-8';
function connect($dbhost, $dbuser, $dbpw, $dbname = '', $pconnect = 0, $halt = true) {
if($pconnect) {
If(!$this->link = @mysql_pconnect($dbhost, $dbuser, $dbpw)) {
$halt && $this->halt('can not connect to mysql server');
}
} else {
If(!$this->link = @mysql_connect($dbhost, $dbuser, $dbpw, 1)) {
$halt && $this->halt('can not connect to mysql server');
}
}

if($this->version() > '4.1') {
Global $charset, $dbcharset;
If(!$dbcharset && in_array(strtolower($charset), array('gbk', 'big5', 'utf-8'))) {
$dbcharset = str_replace('-', '', $charset);
}

if($dbcharset) {
@mysql_query("set character_set_connection=$dbcharset, character_set_results=$dbcharset, character_set_client=binary", $this->link);
}

if($this->version() > '5.0.1') {
@mysql_query("set sql_mode=''", $this->link);
}
}

if($dbname) {
@mysql_select_db($dbname, $this->link);
}

}

function select_db($dbname) {
Return mysql_select_db($dbname, $this->link);
}

function fetch_array($query, $result_type = mysql_assoc) {
Return mysql_fetch_array($query, $result_type);
}

function query($sql, $type = '') {
global $debug, $discuz_starttime, $sqldebug, $sqlspenttimes;

$func = $type == 'unbuffered' && @function_exists('mysql_unbuffered_query') ?
'mysql_unbuffered_query' : 'mysql_query';
if(!($query = $func($sql, $this->link))) {
If(in_array($this->errno(), array(2006, 2013)) && substr($type, 0, 5) != 'retry') {
$this->close();
$this->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
$this->query($sql, 'retry'.$type);
} elseif($type != 'silent' && substr($type, 5) != 'silent') {
$this->halt('mysql query error', $sql);
}
}

$this->querynum++;
           $this->sqlid=$query;
return $query;
}

function affected_rows() {
Return mysql_affected_rows($this->link);
}

function error() {
return (($this->link) ? mysql_error($this->link) : mysql_error());
}

function errno() {
Return intval(($this->link) ? mysql_errno($this->link) : mysql_errno());
}

function result($query, $row) {
$query = @mysql_result($query, $row);
return $query;
}

function result_first($sql) {
Return $this->result($this->query($sql), 0);
}

function num_rows($query) {
$query = mysql_num_rows($query);
return $query;
}

function num_fields($query) {
Return mysql_num_fields($query);
}

function free_result($query) {
Return mysql_free_result($query);
}

function insert_id() {
  return ($id = mysql_insert_id($this->link)) >= 0 ? $id : $this->result($this->query("select last_insert_id()"), 0);
}

function fetch_row($query) {
  $query = mysql_fetch_row($query);
  return $query;
}

function fetch_fields($query) {
  return mysql_fetch_field($query);
}

function version() {
  return mysql_get_server_info($this->link);
}

function close() {
  return mysql_close($this->link);
}

    function nr($sql_id="") {
        if(!$sql_id) $sql_id=$this->sqlid;
     return mysql_num_rows($sql_id);
    }

    function nf($sql_id="") {
        if(!$sql_id) $sql_id=$this->sqlid;
        return mysql_num_fields($sql_id);
    }

    function nextrecord($sql_id="") {
        if(!$sql_id) $sql_id=$this->sqlid;
        if($this->record=mysql_fetch_array($sql_id)) return $this->record;
        else return false;
    }

    function f($name) {
        if($this->record[$name]) return $this->record[$name];
        else return false;
    }

    function lock($tblname,$op="write") {
        if(mysql_query("lock tables ".$tblname." ".$op)) return true;
        else return false;
    }

    function unlock()
        {if(mysql_query("unlock tables")) return true; else return false;}

    function ar() {
        return @mysql_affected_rows($this->link);
    }

    function i_id() {
            return mysql_insert_id();
    }

function halt($message = '', $sql = '') {
  define('cache_forbidden', true);
  include('db_mysql_error.inc.php');
}
}

?>