Php + mysqli Database Connection Methods

This article mainly introduces two ways to connect to the php + mysqli database. The example analyzes the Two Connection Methods of object-oriented and process-oriented, which are very useful. For more information, see

This article mainly introduces two ways to connect to the php + mysqli database. The example analyzes the Two Connection Methods of object-oriented and process-oriented, which are very useful. For more information, see

This article describes two methods for connecting to the php + mysqli database. Share it with you for your reference. The details are as follows:

The following describes the two methods of mysqli database connection: Object-oriented and process-oriented. The Code is as follows:

Method 1: Establish a database connection in an object-oriented manner

The Code is as follows:

$ Mysqli = new MySQLi ("localhost", "root", "1233456"); // default MySQL class. For its attributes and methods, see the manual.
If ($ mysqli-> connect_error) {// connect_error is the attribute and an error is returned.
Die ("Database Connection Failed:". $ mysqli-> connect_errno. "--". $ mysqli-> connect_error); // connect_errno: Error No.
}
$ Mysqli-> select_db ("liuyan"); // select a database
$ Mysqli-> query ("set names 'gbk '");

Method 2: process-oriented database connection. This is similar to the mysql extension library.

The Code is as follows:

$ Conn = @ mysqli_connect ("localhost", "root", "123456") or die (mysqli_connect_error ());
Mysqli_select_db ($ conn, "liuyan") or die (mysqli_connect_error (); // different from the mysql extension library, the database name is written below and $ conn is required
Mysqli_query ($ conn, "set names 'gbk'"); // same as above
?>

I hope this article will help you with php programming.