Home >Backend Development >PHP Problem >How to implement additions, deletions and modifications in PHP object-oriented database connection

How to implement additions, deletions and modifications in PHP object-oriented database connection

藏色散人
藏色散人Original
2020-08-27 09:16:433754browse

php object-oriented method of connecting to the database to implement additions, deletions and modifications: first create the Mysql class and define variables; then initialize the class through the constructor; then connect to the database and customize the method of inserting data; finally use the update and delete methods to modify Or just delete the data.

How to implement additions, deletions and modifications in PHP object-oriented database connection

Recommended: "PHP Video Tutorial"

PHP (object-oriented) connects to the database to achieve basic additions, deletions and modifications Check

1. Create the mysql_class.php file and then create the Mysql class in the file and define the variable

<?php
    class
 Mysql{
        private
 $host;//服务器地址
        private
 $root;//用户名
        private
 $password;//密码
        private
 $database;//数据库名
         
        //后面所提到的各个方法都放在这个类里
        //...
    }
?>

2. Initialize the class through the constructor

function
 __construct($host,$root,$password,$database){
    $this->host
 = $host;
    $this->root
 = $root;
    $this->password
 = $password;
    $this->database
 = $database;
    $this->connect();
}

For connect( ) method, let’s talk about it in the next step

3. Methods to create a connection database and close the database

function
 connect(){
    $this->conn
 = mysql_connect($this->host,$this->root,$this->password) or die("DB
 Connnection Error !".mysql_error());
    mysql_select_db($this->database,$this->conn);
    mysql_query("set
 names utf8");
}
         
function
 dbClose(){
    mysql_close($this->conn);
}

4. Encapsulate the mysql_query(), mysql_fetch_array(), mysql_num_rows() functions

function
 query($sql){
    return
 mysql_query($sql);
}
        
function
 myArray($result){
    return
 mysql_fetch_array($result);
}
        
function
 rows($result){
    return
 mysql_num_rows($result);
}

5. Customized query data method

function
 select($tableName,$condition){
    return
 $this->query("SELECT
 * FROM $tableName $condition");
}

6. Customized data insertion method

function
 insert($tableName,$fields,$value){
    $this->query("INSERT
 INTO $tableName $fields VALUES$value");
}

7. Customized data modification method

function
 update($tableName,$change,$condition){
    $this->query("UPDATE
 $tableName SET $change $condition");
}

8. Customized deletion of data Method

function
 delete($tableName,$condition){
    $this->query("DELETE
 FROM $tableName $condition");
}

Now that the database operation class has been encapsulated, let’s take a look at how to use it.

We still use PHP to connect to the database to implement the most basic addition, deletion, modification and query (process-oriented) of the database and tables involved in the article (the data in the table is added by yourself):

9 , then we first instantiate the database operation class

$db
 = new Mysql("localhost","root","admin","beyondweb_test");

Instantiation can be performed outside the Mysql class in the mysql_class.php file.

Then we create a test.php file, first introduce the mysql_class.php file

<?php
    require("mysql_class.php");
?>

Then let’s start the operation

10. Insert data into the table

<?php
    $insert
 = $db->insert("user","(nikename,email)","(#beyondweb#,#beyondwebcn@xx.com#)");//请把#号替换为单引号
    $db->dbClose();
?>

11. Modify the data in the table

<?php
    $update
 = $db->update("user","nikename
 = #beyondwebcn#","where
 id = #2#");//请把#号替换为单引号
    $db->dbClose();
?>

12. Query the data in the table and output it

<?php
    $select
 = $db->select("user");
    $row
 = $db->rows($select);
    if($row>=1){
?>
<table
 border="1px">
    <tr>
        <th>id</th>
        <th>nikename</th>
        <th>email</th>
    </tr>
<?php
    while($array
 = $db->myArray($select)){
        echo
"<tr>";
        echo
"<td>".$array[#id#]."</td>";//请把#号替换为单引号
        echo
"<td>".$array[#nikename#]."</td>";//请把#号替换为单引号
        echo
"<td>".$array[#email#]."</td>";//请把#号替换为单引号
        echo
"</tr>";
    }
?>
</table>
<?php
    }else{
        echo
"查不到任何数据!";
    }
      
    $db->dbClose();
?>

13. Delete the data in the table

<?php
    $delete
 = $db->delete("user","where
 nikename = #beyondweb#");//请把#号替换为单引号
    $db->dbClose();
?>

The above is the detailed content of How to implement additions, deletions and modifications in PHP object-oriented database connection. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn