首先新建 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);