WHERE 子句用于过滤记录。
WHERE 子句用于提取满足指定标准的的记录。
SELECT column_name(s) |
FROM table_name |
WHERE column_name operator value |
为了让 PHP 执行上面的语句,我们必须使用 mysqli_query() 函数。该函数用于向 MySQL 连接发送查询或命令。
下面的实例将从 "Persons" 表中选取所有 FirstName='Peter' 的行:
<?php |
$con=mysqli_connect("localhost","username","password","database"); |
// 检测连接 |
if (mysqli_connect_errno()) |
{ |
echo "连接失败: " . mysqli_connect_error(); |
} |
$result = mysqli_query($con,"SELECT * FROM Persons |
WHERE FirstName='Peter'"); |
while($row = mysqli_fetch_array($result)) |
{ |
echo $row['FirstName'] . " " . $row['LastName']; |
echo "<br>"; |
} |
?> |
Peter Griffin