Practical mysql database connection class _ PHP Tutorial

Practical mysql database connection class. This is the mysql database connection file code in php. if you are looking for such a function code, you can come in and check it out, very complete file this is a mysql tutorial data in the php Tutorial this is a mysql database connection file code in php, if you are looking for such a function code, you can come in to see, very complete file

This is the connection file code of the mysql tutorial database tutorial in the php Tutorial. if you are looking for code for such a function, you can come in and check out the complete file. */

Class mysql {
Private $ db_host; // host address
Private $ db_user; // User name
Private $ db_pass; // connection password
Private $ db_name; // name
Private $ db_charset; // encoding

Private $ conn;
Private $ query_id; // used to determine whether the SQL statement is successfully executed
Private $ result; // result set
Private $ num_rows; // number of rows in the result set, which is only valid for select
Private $ insert_id; // id generated by the previous insert operation

// Constructor/destructor
Function _ construct ($ db_host, $ db_user, $ db_pass, $ db_name, $ db_charset, $ conn ){
$ This-> db_host = $ db_host;
$ This-> db_user = $ db_user;
$ This-> db_pass = $ db_pass;
$ This-> db_name = $ db_name;
$ This-> db_charset = $ db_charset;
$ This-> conn = $ conn;
$ This-> connect ();
}

Function _ destruct (){
@ Mysql_close ($ this-> conn );
}

// Connect to/select a database
Public function connect (){
If ($ this-> conn = 'pconn '){
@ $ This-> conn = mysql_pconnect ($ this-> db_host, $ this-> db_user, $ this-> db_pass );
} Else {
@ $ This-> conn = mysql_connect ($ this-> db_host, $ this-> db_user, $ this-> db_pass );
}
If (! $ This-> conn ){
$ This-> show_error ('database-connection failed: username or password error! ');
}
If (! @ Mysql_select_db ($ this-> db_name, $ this-> conn )){
$ This-> show_error ("database-selection failed: Database $ this-> db_name unavailable ");
}
Mysql_query ("set names $ this-> db_charset ");
Return $ this-> conn;
}

// Query method
Public function query ($ SQL ){
If ($ this-> query_id) $ this-> free_result ();
$ This-> query_id = @ mysql_query ($ SQL, $ this-> conn );
If (! $ This-> query_id) $ this-> show_error ("SQL statement"$ SQL"Execution error ");
Return $ this-> query_id;
}

// Query all
Public function findall ($ table_name ){
$ This-> query ("select * from $ table_name ");
}

// Mysql_fetch_array
Public function fetch_array (){
If ($ this-> query_id ){
$ This-> result = mysql_fetch_array ($ this-> query_id );
Return $ this-> result;
}
}

//......

Public function fetch_assoc (){
If ($ this-> query_id ){
$ This-> result = mysql_fetch_assoc ($ this-> query_id );
Return $ this-> result;
}
}

Public function fetch_row (){
If ($ this-> query_id ){
$ This-> result = mysql_fetch_row ($ this-> query_id );
Return $ this-> result;
}
}

Public function fetch_object (){
If ($ this-> query_id ){
$ This-> result = mysql_fetch_object ($ this-> query_id );
Return $ this-> result;
}
}

// Obtain num_rows
Public function num_rows (){
If ($ this-> query_id ){
$ This-> num_rows = mysql_num_rows ($ this-> query_id );
Return $ this-> num_rows;
}
}

// Obtain insert_id
Public function insert_id (){
Return $ this-> insert_id = mysql_insert_id ();
}

// Display the total number of tables
Public function show_tables (){
$ This-> query ("show tables ");
If ($ this-> query_id ){
Echo "database $ this-> db_name total". $ this-> num_rows ($ this-> query_id). "table
";
$ I = 1;
While ($ row = $ this-> fetch_array ($ this-> query_id )){
Echo "$ I -- $ row [0]
";
$ I ++;
}
}
}

// Display the total number of databases
Public function show_dbs (){
$ This-> query ("show databases ");
If ($ this-> query_id ){
Echo "total databases". $ this-> num_rows ($ this-> query_id )."
";
$ I = 1;
While ($ this-> row = $ this-> fetch_array ($ this-> query_id )){
Echo "$ I --". $ this-> row [database]."
";
$ I ++;
}
}
}

// Delete database: return the deletion result
Public function drop_db ($ db_name = ''){
If ($ db_name = ''){
$ Db_name = $ this-> db_name; // the current database is deleted by default.
$ This-> query ("drop database $ db_name ");
} Else {
$ This-> query ("drop database $ db_name ");
}
If ($ this-> query_id ){
Return "database $ db_name deleted ";
} Else {
$ This-> show_error ("database $ db_name deletion failed ");
}
}

// Delete a data table: return the deletion result.
Public function drop_table ($ table_name ){
$ This-> query ("drop table $ table_name ");
If ($ this-> query_id ){
Return "the data table $ table_name is successfully deleted ";
} Else {
$ This-> show_error ("An error occurred while deleting the data table $ table_name ");
}

}

// Create a database
Public function create_db ($ db_name ){
$ This-> query ("create database $ db_name ");
If ($ this-> query_id ){
Return "database $ db_name created successfully ";
} Else {
$ This-> show_error ("database $ db_name creation failed ");
}
}

// Obtain the database version
Public function get_info (){
Echo mysql_get_server_info ();
}

// Display the error message
Public function show_error ($ msg ){
$ Errinfo = mysql_error ();
Echo "Error: $ msg
Return: $ errinfo

";
}

// Release the memory
Public function free_result (){
If (@ mysql_free_result ($ this-> query_id ))
Unset ($ this-> result );
$ This-> query_id = 0;
}

} // End class

This is the mysql tutorial data in the php Tutorial...