Two ways of php+mysqli database connection, mysqli database connection
The examples in this article describe two methods of php+mysqli database connection. Share it with everyone for your reference. The details are as follows:
Here is a comparison of two methods of mysqli database connection, namely object-oriented and process-oriented. The code is as follows:
The first way: establish database connection in object-oriented way
Copy code The code is as follows:
$mysqli = new MySQLi("localhost","root","1233456");//Default MySQL class, its properties and methods can be found in the manual
if($mysqli->connect_error){//connect_error is an attribute and an error is reported
die("Database connection failed: ".$mysqli->connect_errno."--".$mysqli->connect_error); // connect_errno: error number
}
$mysqli->select_db("liuyan");//Select database
$mysqli->query("set names 'GBK'");
Second way: Establish a database connection in a process-oriented way, this is similar to the mysql extension library
Copy code 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());//Unlike the mysql extension library, the database name is written at the end, and $conn is required
mysqli_query($conn,"set names 'GBK'");//Same as above
?>
I hope this article will be helpful to everyone’s PHP programming design.
http://www.bkjia.com/PHPjc/949456.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/949456.htmlTechArticleTwo ways of php+mysqli database connection, mysqli database connection This article describes the two ways of php+mysqli database connection way. Share it with everyone for your reference. The details are as follows: Here...
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
