mysql.class.php link database class_PHP tutorial-PHP Tutorial-php.cn

mysql.class.php link database class_PHP tutorial

WBOY

Release： 2016-07-13 17:45:37

Original

1110 people have browsed it

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);
}

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