An example of application of php mysqli extension library

Example of php mysqli extension library:

 #Connect to database
 $link=mysqli_connect("localhost","root","root");
 #Select database
 $link-> ;select_db("rorely") or die("could not find database");
 #Query the database
 $result=$link->query("select * from test");
 #Output the contents of each record in the database table
 while($row=mysqli_fetch_object($result)){
 echo $row->id." ".$row->name." ".$row->age." ".$row-> sex." ".$row->address."";
 }
 #Close the database
 mysqli_close($link);
?>

Result: 1 Jane 26 female wenming cun 123# 3 Tome 21 male wenming cun 32# 4 Lily 25 female wenming cun 2# 5 Lucy 25 female wenming cun 2# 6 Jim 22 male wenmin cun 45# 7 Jim 22 male wenmin cun 45#

Articles you may be interested in: How to add extension library to php under Linux Two methods to add CURL extension library to PHP Two examples of preprocessing operations in the php mysqli extension library Example of php mysqli extension library operating mysql