It is not recommended to use mysql_connect, mysql_query and other functions in PHP5.3 and above versions. Instead, use the mysqli series (improved). This is an example of connecting to a database and querying data.
<?php
require 'conn.php'; //$link=mysqli_connect($host,$user,$pass,$database);
$query="select * from user_info";
if($result=mysqli_query($link,$query)){
echo "query was successfully executed.".'<br>';
while($row=mysqli_fetch_assoc($result)){
echo $row["name"]." ".$row["surname"].'<br>';
}
mysqli_free_result($result);
}
else{
echo "the query is not executed.".'<br>';
}
mysqli_close($link);
?>The above introduces PHP 5619 to connect to the database, including the content of connecting to the database. I hope it will be helpful to friends who are interested in PHP tutorials.
How Oracle creates a database
What is the difference between dubbo and zookeeper
The difference between anchoring and aiming
The role of vga interface
vlookup matches two columns of data
What are the problems with using php
What caching mechanisms does php have?
A complete list of alter commands in Mysql
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
