How does PHP read MySQL data?

In PHP, you can use the MySQLi or PDO extension to fetch MySQL data.

The following is an example of code using MySQLi extension to fetch data from MySQL.

<?php

// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "dbname";

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询数据
$sql = "SELECT id, name, email FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["name"]. " - Email: " . $row["email"]. "<br>";
    }
} else {
    echo "没有查询到数据";
}

// 关闭连接
$conn->close();

?>

Please note that this is just a simple example code. In a real project, you may need more error handling and security checks to ensure data safety.