PhpMYSQL data operation class _ PHP Tutorial

Source: Internet
Author: User
Tags pconnect sql error
PhpMYSQL data operation class. For mysql database operations, [php]? Php *** db. class. phpcreatedatabseobject *** @ authorDick417@668x.net * @ copyrightblog. csdn. nethaibrother *** classD mysql database operation class, share with you


[Php]

/**
* Db. class. php create databse object
*
* @ Author Dick 417@668x.net
* @ Copyright http://blog.csdn.net/haibrother
*
**/

Class Dick_Db {
Public $ db_host = ''; // host address
Public $ db_username = ''; // database account
Public $ db_password = ''; // database password
Public $ db_name = ''; // database name
Public $ link = ''; // database connection object
Public $ debug = 1; // whether to enable debug. debug is enabled by default.
Public $ pconnect = 0; // whether to enable persistent connections. by default, persistent connections are disabled.
Public $ log_file = 'Log/'; // log file directory

/**
* Initialization information
* @ Param object
**/
Public function _ construct ($ config = ''){
If (! Is_object ($ config )){
$ This-> halt ('database config is not wrong, please check it! ');
}
If (! Empty ($ config )){
$ This-> db_host = $ config-> host;
$ This-> db_username = $ config-> username;
$ This-> db_password = $ config-> password;
$ This-> db_name = $ config-> dbname;
}
$ This-> connect ();
}

/**
* Get link
**/
Public function connect (){
$ Connect = $ this-> pconnect === 1? 'MySQL _ pconnect ': 'MySQL _ connect ';
If (! $ This-> link = @ $ connect ($ this-> db_host, $ this-> db_username, $ this-> db_password )){
$ This-> halt ('database cant not connect! ');
}
Mysql_set_charset ('utf8', $ this-> link );
Mysql_select_db ($ this-> db_name, $ this-> link );
}


/**
* Query
* @ Param string $ SQL
* Return boolean
**/
Public function query ($ SQL ){
If (! $ Query = mysql_query ($ SQL, $ this-> link )){
$ Message = date ('Y-m-d H: I: s'). '. $ SQL;
$ This-> write_log ($ message );
$ This-> halt ('SQL error, please check it! ', $ SQL );
}
Return $ query;
}

/**
*
* @ Param string $ SQL
* @ Param string $ type
* Mysql_fetch_assoc mysql_fetch_array mysql_fetch_row mysql_affected_rows
* @ Return array
*/
Public function fetch ($ SQL, $ type = 'assoc '){
$ Fetch_type = 'MySQL _ fetch _ '. $ type;
$ Query = $ this-> query ($ SQL );
$ Result = $ fetch_type ($ query );
$ This-> free_result ($ query );
$ This-> close ();
Return $ result;
}

/**
* @ Param string $ SQL
* @ Return array
**/
Public function dickFetch ($ SQL, $ type = 'assoc '){
$ Fetch_type = 'MySQL _ fetch _ '. $ type;
$ Query = $ this-> query ($ SQL );
$ Rows = array ();
While ($ row = $ fetch_type ($ query )){
$ Rows [] = $ row;
}
$ This-> free_result ($ query );
$ This-> close ();
Return $ rows;
}

/**
* Get the last insert ID
* @ Param string $ SQL
**/
Public function insert_id (){
Return mysql_insert_id ($ this-> link );
}

/**
* Release Database object resources
**/
Public function free_result ($ query ){
Return mysql_free_result ($ query );
}


/**
* Close database connection
**/
Public function close (){
If ($ this-> pconnect === 0) return mysql_close ($ this-> link );
}



/**
* For integer security processing, only an integer greater than or equal to 0 is returned.
* @ Param int
* @ Return int
**/
Public function numeric (& $ variint ){
If (! Isset ($ variint ))
Return 0;
If (! Is_numeric ($ variint ))
Return 0;

// Starts with 0
$ Str_len = strlen ($ variint );
For ($ I = 0; $ I <$ str_len; $ I ++ ){
If ($ variint [$ I]! = '0 ')
Break;
}
If ($ I> 0 & $ variint> 0 ){
$ Variint = substr ($ variint, $ I, $ str_len );
$ Str_len = strlen ($ variint );
}

// Digital security processing
If ($ str_len> 0 ){
If (! Preg_match ("/^ [0-9] + $/", $ variint )){
Return 0;
} Else {
$ Variint = substr ($ variint, 0, 10 );
// Compatible with MYSQL's INT unsigned maximum value of 4294967295
$ Variint = ($ variint> 4294967295 )? 4294967295: $ variint;
Return $ variint;
}
} Else {
Return 0;
}
}

/**
* Mysql error is returned.
**/
Public function error (){
Return ($ this-> link )? Mysql_error ($ this-> link): mysql_error ());
}


/**
* Mysql errno is returned.
**/
Public function errno (){
Return intval ($ this-> link )? Mysql_errno ($ this-> link): mysql_errno ());
}

/**
* Write SQL error logs
* @ Param string
* @ Param string type
**/
Public function write_log ($ message = '', $ type = 'Date '){
If (empty ($ message) return false;
If (! In_array ($ type, array ('date', 'month') return false;
If (! Is_dir ($ this-> log_file )){
Mkdir ($ this-> log_file );
}
Switch ($ type ){
Case 'month ':
$ File = $ this-> log_file.date ('Y-M'). '. log ';
Break;

Default:
$ File = $ this-> log_file.date ('Y-m-D'). '. log ';
Break;
}
If (! File_exists ($ file )){
File_put_contents ($ file ,'');
}
If (! Is_readable ($ file )){
$ This-> halt ($ file. '-the system has no read permission! ');
}
If (! Is_writable ($ file )){
$ This-> halt ($ file. '-the system has no write permission! ');
}
$ Contents = file_get_contents ($ file );
$ Add_message = '-Error:'. $ this-> error (). '-Errno:'. $ this-> errno ();
File_put_contents ($ file, $ contents. $ message. $ add_message. "\ n ");

}


/**
* Terminate the program
* @ Param str $ message
* @ Return print
**/
Public function halt ($ message = '', $ SQL = ''){
If ($ this-> debug = 1 ){
$ Error_get_last = error_get_last ();
If ($ message ){
$ Errmsg ="System info: $ Message \ n ";
}
$ Errmsg. ="Time: ". Date ('Y-m-d H: I: s')." \ n ";
$ Errmsg. ="Script: ". $ Error_get_last ['file']." \ n ";
If ($ SQL ){
$ Errmsg. ="SQL: ". Htmlspecialchars ($ SQL)." \ n ";
}
$ Errmsg. ="Error: ". $ This-> error ()." \ n ";
$ Errmsg. ="Errno.: ". $ This-> errno ();

Echo"\ N ";
Echo"

";
Echo nl2br ($ errmsg );
Exit ();
}

}

/**
* Program test printing
* @ Param string
* @ Return print
**/
Public function prf ($ param ){
Echo'

'; 
print_r($param);
echo '
';
Exit;
}


}
######################################## #########
#### Test program
####
######################################## ##########
Error_reporting (E_ALL );
Header ('content-type: text/html; charset = utf-8 ');
Date_default_timezone_set ('Asia/Shanghai ');
$ Config = array (
'Host' => '2017. 168.2.1 ',
'Username' => 'root ',
'Password' => '',
'Dbname' => 'test ',
);
$ Db = new Dick_Db (object) $ config );
$ Db-> pconnect = 1;
$ SQL = 'select * FROM T1 ';
$ Db-> prf ($ db-> dickFetch ($ SQL ));

?>

Http://www.bkjia.com/PHPjc/477537.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/477537.htmlTechArticlemysql database operation class, share with you [php]? Php/*** db. class. php create databse object *** @ author Dick 417@668x.net * @ copyright http://blog.csdn.net/haibrother ***/class D...

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.