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 is of great practical value, for more information about how to connect to the php + mysqli database, see the following example. 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, which is similar to 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.