This article mainly introduces PHP implementation based on object-oriented Mysqli expansion library, adding and deleting the Operation tool class, combined with the case analysis of the mysqli additions and deletions to the Operation class packaging and use skills, the need for friends can refer to, hope to help everyone.
The Mysqli extension Library is an improved version of the MySQL extension library, which improves stability and efficiency on the basis of the MySQL extension library, and the Mysqli extension Library has two sets of things, one set is the process-oriented mysqli and the other is the object-oriented mysqli. The operation is roughly the same as the MySQL extension library, this time to extract an operation of the MySQL tool class, and the calling class.
1. mysqli Extension Library Operations Database tool class
<?php//Database operation class dbutil{ private $host = "localhost"; Private $username = "root"; Private $password = "123456"; Private $dbname = "student"; private $conn; Public Function Dbutil () { $this->conn=new mysqli ($this->host, $this->username, $this->password,$ This->dbname) or Die ($this->conn->connect_error); } Query public function query ($sql) { $all = $this->conn->query ($sql); return $all; } Insert, modify, delete public function Otheroperate ($sql) { if ($this->conn->query ($sql)) { if ($this- conn->affected_rows>0) { return "OK"; } else{ return "Erroor";}} } Public function Close () { $this->conn->close (); }}? >
2. The following is the code that invokes the tool class
<?php require_once "mysqlutil.php"; /* $sql = "SELECT * from M_student"; $util =new dbutil (); $result = $util->query ($sql); while ($row = $result->fetch_assoc ()) { echo "$row [Stuname]". </br> "; } $result->free (); $util->close (); */ $sql = "Update m_student set stuname= ' Yang mi ' where id=3"; $util =new dbutil (); $result = $util->otheroperate ($sql); echo $result; $util->close ();? >
If you want to use other methods, you can consult the PHP development documentation.