PHP Connection MySQL database operation class _php tutorial

Source: Internet
Author: User
Tags mysql tutorial
PHP Connection MySQL database operation class This is a relatively full MySQL operation class Oh, yesterday wrote a simple connection MySQL database code, relative to this, that is the simplest, this is a data query, update, delete, and other operations.

PHP Tutorial Connect MySQL Tutorial Database tutorial Operation class
This is a relatively full MySQL operation class Oh, yesterday wrote a simple connection MySQL database code, relative to this, that is the simplest, this is a data query, update, delete, and other operations.
*/

Class mysql{

Private $db _host; Database Host
Private $db _user; Database user Name
Private $db _pwd; Database Password
Private $db _database; Database name
Private $conn; database connection identification;
Private $sql; Statements executed by SQL
Private $result; Resource identifier for query
Private $coding; Database encoding, gbk,utf8,gb2312
Private $show _error = true; Local debug use, print error

/**
* Constructor function
*
* @access Public
* @parameter string $db _host database Host
* @parameter string $db _user database user name
* @parameter string $db _pwd database Password
* @parameter string $db _database database name
* @parameter String $coding encoding
* @return void
*/
Public function __construct ($db _host, $db _user, $db _pwd, $db _database, $coding) {
$this->db_host = $db _host;
$this->db_user = $db _user;
$this->db_pwd = $db _pwd;
$this->db_database = $db _database;
$this->coding = $coding;
$this->connect ();
}

/**
* Link Database
*
* @access Private
* @return void
*/
Private Function Connect () {

$this->conn = @mysql_connect ($this->db_host, $this->db_user, $this->db_pwd);
if (! $this->conn) {
Print error when the Show_error is turned on
if ($this->show_error) {
$this->show_error (' ERROR hint: Link database failed! ');
}
}

if (! @mysql_select_db ($this->db_database, $this->conn)) {
Failed to open database
if ($this->show_error) {
$this->show_error (' ERROR hint: Open database failed! ');
}
}

if (! @mysql_query ("Set names $this->coding")) {
Failed to set encoding
if ($this->show_error) {
$this->show_error (' ERROR warning: setting encoding failed! ');
}
}
}

/**
* Executable query Add modify delete and so on any SQL statement
*
* @access Public
* @parameter string $sql SQL statement
* @return Resource Resource Identifier
*/
Public Function Query ($sql) {
$this->sql = $sql;
$result = mysql_query ($this->sql, $this->conn);
if (! $result) {
Query execution failed with print error
$this->show_error ("Wrong SQL statement:", $this->sql);
}else{
Returns the resource identifier
return $this->result = $result;
}
}

/**
* Query all databases in MySQL server
*
* @access Public
* @return void
*/
Public Function show_databases () {
$this->query ("Show Databases");
Total number of print databases
echo "Existing database:". Mysql_num_rows ($this->result);
echo "
";
$i = 1;
Loop out the name of each database
while ($row =mysql_fetch_array ($this->result)) {
echo "$i $row [Database]". "
";
$i + +;
}
}

/**
* Query the database for all table names
*
* @access Public
* @return void
*/
Public Function Show_tables () {
$this->query ("Show Tables");
Total number of printed tables
echo "Database {$this->db_database} is common." Mysql_num_rows ($this->result). "Zhang table:";
echo "
";
Constructs an array subscript, loops out all the table names of the database
$column _name = "Tables_in_". $this->db_database;
$i = 1;
Loop out the name of each table
while ($row =mysql_fetch_array ($this->result)) {
echo "$i $row [$column _name]". "
";
$i + +;
}
}

/**
* Take a Recordset, get an array-index and association
*
* @access Public
* @return void
*/
Public Function Fetch_array () {
Return mysql_fetch_array ($this->result);
}

/**
* Simplified SELECT query statement
*
* @access Public
* @parameter string $table table name
* @parameter string $field field name
* @return Resource
*/
Public function FindAll ($table, $field = ' * ') {
return $this->query ("Select $field from $table");
}

/**
* Simplified Delete query statement
*
* @access Public
* @parameter string $table table name
* @parameter string $condition The condition of the query
* @return Resource
*/
Public Function Delete ($table, $condition) {
return $this->query ("Delete from $table where $condition");
}

/**
* Simplified Insert INSERT statement
*
* @access Public
* @parameter string $table table name
* @parameter string $field field name
* @parameter string $value Insert Value
* @return Resource
*/
Public Function Insert ($table, $field, $value) {
return $this->query ("INSERT into $table ($field) VALUES (' $value ')");
}

/**
* Simplified UPDATE INSERT statement
*
* @access Public
* @parameter string $table table name
* @parameter the contents of string $update _content update
* @parameter string $condition condition
* @return Resource
*/
Public Function Update ($table, $update _content, $condition) {
return $this->query ("Update $table set $update _content where $condition");
}

/**
* Get the ID generated by the insert operation in the previous step
*
* @access Public
* @return Integer
*/
Public Function insert_id () {
return mysql_insert_id ();
}

/**
* Number of result set bars calculated
*
* @access Public
* @return Integer
*/
Public Function num_rows () {
Return mysql_num_rows ($this->result);
}

/**
* Query field number and field information
*
* @access Public
* @parameter string $table table name
* @return void
*/
Public Function Num_fields ($table) {
$this->query ("SELECT * from $table");
echo "
";
Number of print fields
echo "Number of fields:". $total = Mysql_num_fields ($this->result);
echo "

";
The Mysql_fetch_field () function obtains column information from the result set and returns it as an object.
for ($i = 0; $i < $total; $i + +) {
Print_r (Mysql_fetch_field ($this->result, $i));
}
echo "
";
echo "
";
}

/**
* Output SQL statement error message
*
* @access Public
* @parameter string $message tip information
* @return void
*/
Public Function show_error ($message = ', $sql = ') {
echo "

";
echo " error message Tip:
";
echo "";
Print Error Reason
echo "Error Reason:". Mysql_error (). "

";
Print error message
The Mysql_error () function returns the text error message generated by the previous MySQL operation.
echo "";
echo "". $message. "";
echo "";
Print Error SQL statement
echo "
" . $sql. "
";
echo "";
echo " ";
}
}

How to use

$mysql = new MySQL ($dbhost, $dbuser, $dbpwd, $dbname, $coding);
?>

http://www.bkjia.com/PHPjc/630818.html www.bkjia.com true http://www.bkjia.com/PHPjc/630818.html techarticle PHP Connection MySQL database operation class This is a relatively full MySQL operation class Oh, yesterday wrote a simple connection MySQL database code, relative to this, that is the simplest, ...

  • Related Article

    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.