mysql.class.php link database class_PHP tutorial

File name mysql.class.php

//###################### Start Introduce ####################### ###############
// mysql connection class
// author: bluemaple , emaile: bluemaple@x263.net
// You can execute general mysql commands, such as insert, delete, select, update
// How to use: Add
in front of the required files // require("./mysql.class.php");
// $DB=new DB_MYSQL; // Loading class
// $DB->dbServer="localhost"; // Connection database address
// $DB->dbUser="root"; // Username
// $DB->dbPwd=""; // Password
// $DB->dbDatabase="we"; // Database name
// $DB->connect(); // Connect to database
//You can change the database during use
// Description of functions that can be used
// query($sql,$dbbase);                                                                                                // can be executed directly
// query_first($sql,$dbbase); // The query returns only one record, $sql is the sql statement, and $dbbase selects the database for you (optional)
// fetch_array($sql,$dbbase); // The query returns a set of records, and you can use num_rows to get the returned number
// insert, update, delete are all execution commands, in which $affected_rows; can be used to get the returned number
// When inserting, you can use insert_id to get the returned id number of the insertion result
// count_records($table,$index,$where,$dbbase)//To get the number of records in a table, $table is the table name, $index is the key, $where is the condition, $dbbase is the database, the last two You don’t need to select
//###################### End Introduce ####################### #################

class DB_MYSQL // Database mysql query class
{
var $dbServer; // Database connection service address
var $dbDatabase; //Selected database, initial state
var $dbbase=""; // This can be changed later
var $dbUser; // Login username
var $dbPwd; // Login user password
var $dbLink; // Database connection pointer
var $query_id; // Pointer to execute query command
var $num_rows; // Number of entries returned
var $insert_id; // Return the ID of the last INSERT command used
var $affected_rows; // Return the number of columns affected by the query command
// The number of columns (ROW) affected by Insert, Update or Delete.
// delete without where, then returns 0
       
function connect($dbbase="") // Database connection function, including database connection
           {
​​​​​ global $usepconnect; // Whether to use a permanent connection, $userpconnect is set externally.
             if ($usepconnect==1){
                     $this->dbLink=@mysql_pconnect($this->dbServer,$this->dbUser,$this->dbPwd);
                                                                                                                                                                                                                                      $this->dbLink=@mysql_connect($this->dbServer,$this->dbUser,$this->dbPwd);
                }
If(!$this->dbLink) $this->halt("Connection error, unable to connect!!!");
               if ($dbbase=="") {
                 $dbbase=$this->dbDatabase;
                                                                                                        If(!mysql_select_db($dbbase, $this->dbLink)) // Connect to database
{ $this->halt("This database cannot be used, please check whether the database is correct!!!");}
          }

function change_db($dbbase=""){ // Change database
$this->connect($dbbase);
}

  function query_first($sql,$dbbase=""){ // 返回一个值的sql命令
      $query_id=$this->query($sql,$dbbase);
        $returnarray=mysql_fetch_array($query_id);
        $this->num_rows=mysql_num_rows($query_id);
      $this->free_result($query_id);      
      return $returnarray;
      }
 
  function fetch_array($sql,$dbbase="",$type=0){ // 返回一个值的sql命令
                           // type为传递值是name=>value,还是4=>value
      $query_id=$this->query($sql,$dbbase);
      $this->num_rows=mysql_num_rows($query_id);
      for($i=0;$inum_rows;$i++){
          if($type==0)
              $array[$i]=mysql_fetch_array($query_id);
          else
              $array[$i]=mysql_fetch_row($query_id);
          }
      $this->free_result($query_id);
      return $array;
      }
 
  function delete($sql,$dbbase=""){ // 删除命令
      $query_id=$this->query($sql,$dbbase);
      $this->affected_rows=mysql_affected_rows($this->dbLink);
      $this->free_result($query_id);
        }
 
  function insert($sql,$dbbase=""){ // 插入命令
      $query_id=$this->query($sql,$dbbase);
      $this->insert_id=mysql_insert_id($this->dbLink);
      $this->affected_rows=mysql_affected_rows($this->dbLink);
      $this->free_result($query_id);
        }
 
  function update($sql,$dbbase=""){  //  更新命令
      $query_id=$this->query($sql,$dbbase);
      $this->affected_rows=mysql_affected_rows($this->dbLink);      
      $this->free_result($query_id);
      }
 
  function count_records($table,$index="id",$where="",$dbbase=""){ // 记录总共表的数目
                                                   // where为条件
                                                   // dbbase为数据库
                                                   // index为所选key，默认为id
        if($dbbase!="") $this->change_db($dbbase);
        $result=@mysql_query("select count(".$index.") as 'num' from $table ".$where,$this->dbLink);
        if(!$result) $this->halt("错误的SQL语句: ".$sql);
        @$num = mysql_result($result,0,"num");    
        return $num;
      }
 
function query($sql,$dbbase=""){ // Execute queyr command
If($dbbase!="") $this->change_db($dbbase);
$this->query_id=@mysql_query($sql,$this->dbLink);
echo "d";
If(!$this->query_id) $this->halt("Wrong SQL statement: ".$sql);
Return $this->query_id;
}
 
function halt($errmsg) // Database error, unable to connect successfully
           {
                  $msg="

Database error!

";
                $msg.=$errmsg;
                  echo $msg;
             die();
}

function free_result($query_id) // Release query selector
           {
           @mysql_free_result($query_id);
}

function close() //Close the database connection
           {
mysql_close($this->dbLink);
}
}
?>

Here’s how to use it

text.php

require("./mysql.class.php");
$DB=new DB_MYSQL;
$DB->dbServer="localhost";
$DB->dbUser="root";
$DB->dbPwd="";
$DB->dbDatabase="we";
$DB->connect(); // Connect to database
?>

from Fantasy Spring Continent

http://www.bkjia.com/PHPjc/478652.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/478652.htmlTechArticleFile name mysql.class.php ? //############## ######## Start Introduce ###################################### / / mysql connection class // author: bluemaple , emaile: bluemaple@x263.net // Can...