PHP MySQL Select
SELECT 语句用于从数据库中选取数据。
从数据库表中选取数据
SELECT 语句用于从数据库中选取数据。
语法
SELECT column_name(s)
FROM table_name
FROM table_name
如需学习更多关于 SQL 的知识，请访问我们的 SQL 教程。
为了让 PHP 执行上面的语句，我们必须使用 mysqli_query() 函数。该函数用于向 MySQL 连接发送查询或命令。
实例
下面的实例选取存储在 "Persons" 表中的所有数据（* 字符选取表中所有数据）：
<?php
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM Persons");
while($row = mysqli_fetch_array($result))
{
echo $row['FirstName'] . " " . $row['LastName'];
echo "<br>";
}
mysqli_close($con);
?>
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM Persons");
while($row = mysqli_fetch_array($result))
{
echo $row['FirstName'] . " " . $row['LastName'];
echo "<br>";
}
mysqli_close($con);
?>
上面这个实例在 $result 变量中存储由 mysqli_query() 函数返回的数据。
接下来，我们使用 mysqli_fetch_array() 函数以数组的形式从记录集返回第一行。每个随后对 mysqli_fetch_array() 函数的调用都会返回记录集中的下一行。 while 循环会遍历记录集中的所有记录。为了输出每行的值，我们使用了 PHP 的 $row 变量（$row['FirstName'] 和 $row['LastName']）。
以上代码将输出：
Peter Griffin
Glenn Quagmire
Glenn Quagmire
在 HTML 表格中显示结果
下面的实例选取了和上面的实例相同的数据，但是本例将把数据显示在一个 HTML 表格中：
<?php
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM Persons");
echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['FirstName'] . "</td>";
echo "<td>" . $row['LastName'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM Persons");
echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['FirstName'] . "</td>";
echo "<td>" . $row['LastName'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>
以上代码将输出：
| Firstname | Lastname |
|---|---|
| Glenn | Quagmire |
| Peter | Griffin |
