主页 / 问题 / 1112249
Accepted
Positron NN
Asked:2020-04-18 23:45:40 +0000 UTC2020-04-18 23:45:40 +0000 UTC

使用 PHP 从 MySQL/MariaDB 表中获取多行

  • 772

我有一张这样的桌子：

+----------+----------+------------+
| one      | two      | three      |
+----------+----------+------------+
| red      | blue     | data       |
| red      | blue     | data_two   |
+----------+----------+------------+

我需要得到dataand data_two，为此我编写了以下代码：

$dbs = mysqli_connect('localhost', 'user', 'pass', 'database');
$sql = "SELECT three FROM table WHERE one = 'red' AND two = 'blue';";
$res = mysqli_query($dbs, $sql);
$row = mysqli_fetch_array($res);

之后数组$row如下所示：

Array ( [0] => data [three] => data )

也就是说，我得到了 only data，但是如果我在控制台中执行相同的 SQL 查询，我得到了dataand data_two：

MariaDB [database]> SELECT three FROM table WHERE one = 'red' AND two = 'blue';
+------------+
| three      |
+------------+
| data       |
| data_two   |
+------------+
2 rows in set (0.001 sec)

告诉我，我怎样才能在 PHP 中同时获得两个dat？提前致谢！

php

1 个回答

  1. Best Answer

    添加此构造：

    $rows = [];
while($row = mysqli_fetch_array($res)) {
    $rows[] = $row;
}
    • 1

相关问题