来自 mysql 的 php 数组

Question

我正在使用 PHP 从 MySQL 获取值。我的表有这样的形式:

COL1 = MAIL mail@mail.com
COL2 = NAME myname

我正在从数据库中获取用户的行。

$query = mysqli_query($conn, "select * from user where mail = 'telmo@mail.com'");
$row = mysqli_fetch_array($query);

print_r($row);

但是我的输出很奇怪，它给了我一个像这样的二维数组:

Array ( [0] => mail@mail.com [MAIL] => mail@mail.com [1] => myname [NAME] => myname )

我正在学习 PHP，我想知道这是否应该是这样的。因为我想要更多类似的东西:

MAIL => mail@mail.com
NAME => myname

也许我不太了解这种语法，但这就是我寻求帮助的原因。提前致谢

提前谢谢您

Answer 1

来自the manual

mysqli_fetch_array() is an extended version of the mysqli_fetch_row() function. In addition to storing the data in the numeric indices of the result array, the mysqli_fetch_array() function can also store the data in associative indices, using the field names of the result set as keys.

您真正要找的是 mysqli_fetch_assoc()

Returns an associative array that corresponds to the fetched row or NULL if there are no more rows.