Complete example of PHP database operation Helper class, phphelper_PHP tutorial

A complete example of the PHP database operation Helper class, phphelper

The example in this article describes the PHP database operation Helper class. Share it with everyone for your reference, the details are as follows:

PHP database operation is divided into several steps (here, MYSQL is taken as an example):

1. Establish connection

$connection=mysql_connect($db_host,$db_username,$db_password);

2. Select database

$db_select=mysql_select_db($db_database);

3. Perform CRUD operations

mysql_query("set names 'utf8'");//编码
$result=mysql_query($sqlstring);

(mysql_affected_rows()The number of record rows affected by the previous mysql operation)

4. Query

mysql_fetch_array($result);
mysql_fetch_row($result);

5. Close the connection

mysql_close($connection);

DBHelper.php class file:

<&#63;php
class DBHelper
{
  //建立连接
  function GetConnection($db_host,$db_username,$db_password)
  {
    $connection=mysql_connect($db_host,$db_username,$db_password);
    if($connection==false)
      die("数据库连接失败：".mysql_error());//输入具体错误信息
    return $connection;
  }
  //选择对应数据库
  function DBSelect($db_database)
  {
    $db_select=mysql_select_db($db_database);
    if($db_select==false)
      die("数据库选择失败：".mysql_error());
    return $db_select;
  }
  //执行CRUD操作
  function Excute($sqlstring)
  {
    $result=mysql_query($sqlstring);
    return $result;
  }
  //释放资源
  function CloseConnection($connection)
  {
    if($connection!=null)
    mysql_close($connection);
  }
}
&#63;>

dbtext.php configuration file:

<&#63;php
$db_host="localhost";
$db_database="mymessage";
$db_username="root";
$db_password="123456";
&#63;>

Readers who are interested in more PHP-related content can check out the special topics of this site: "Summary of PHP database operation skills based on pdo", "PHP MongoDB database operation skills collection", "php object-oriented programming introductory tutorial", "php Summary of String Usage", "Introduction Tutorial on PHP MySQL Database Operation" and "Summary of PHP Common Database Operation Skills"

I hope this article will be helpful to everyone in PHP programming.

http://www.bkjia.com/PHPjc/1125874.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1125874.htmlTechArticleA complete example of the PHP database operation Helper class, phphelper This example describes the PHP database operation Helper class. Share it with everyone for your reference, the details are as follows: PHP operation database is divided into several...