PHP 执行 MySQL 查询

首先新建 mysqli 对象，并连接数据库。

$servername = "localhost";
$username = "root";
$password = "toor";
$dbname = "service";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Failed connecting to SQL server: " . $conn->connect_error);
}

随后便可使用 query 方法执行 SQL 语句，SQL 返回值保存在 $result 中。

$sql = "SELECT * FROM `staffs` WHERE name = '$userName'";
$result = $conn->query($sql);