Complete example of PHP database operation Helper class, phphelper

Complete example of PHP database operation Helper class, phphelper_PHP tutorial

WBOY

Release： 2016-07-12 08:52:47

Original

1666 people have browsed it

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

Copy after login

2. Select database

$db_select=mysql_select_db($db_database);

Copy after login

3. Perform CRUD operations

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

Copy after login

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

4. Query

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

Copy after login

5. Close the connection

mysql_close($connection);

Copy after login

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

Copy after login

dbtext.php configuration file:

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

Copy after login

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.