How to implement PHP to connect to mysql and query data: first use the mysqli_connect function to establish a connection with the database; then use the mysqli_query function combined with the select statement to query the database data.

Uncomment extension=php.mysqli_dll in php.ini.

(Recommended video:java video tutorial)

Code example:

数据库连接失败'); } //基于刚创建的连接对象进行一次查询操作 $query= mysqli_query($connection,'select * from users'); if(!$query){ exit('
查询失败
'); } //遍历结果集 while ($row=mysqli_fetch_assoc($query)){ //打印结果集 var_dump($row); } //释放结果集 mysqli_free_result($query); //断开与数据库连接 mysqli_close($connection); ?>

Table data queried by Navicat in the database

Related recommendations:php training

The above is the detailed content of How to connect php to mysql and query data. For more information, please follow other related articles on the PHP Chinese website!