将数组中的mySQL结果加载到数组中 - Load mySQL results in arrays into a array

Load mySQL results in arrays into a array

本文关键字：数组加载结果 mySQL | 更新日期: 2023-09-27

我不知道如何将mySQL结果（地址、名称）加载为以下格式：

$to=array(
    array("address"=>"johndoe@domain.ext","name"=>"John Doe"),
    array("address"=>"jofrost@domain.ext","name"=>"Jo Frost"),
    array("address"=>"someone@domain.ext","name"=>"Some One"),
    etc...
);

请遵循旧的学习方式。Thx。

类似

$query = 'SELECT address, name FROM table';
$mysqli = new mysqli('host', 'user', 'password', 'database');
if ($mysqli->connect_errno) {
    echo 'Connect failed:' . $mysqli->connect_error;
    exit();
}
if($res = $mysqli->query($query)) {
    $ret = [];
    while($row = $res->fetch_assoc()) {
       $ret[] = $row;
    }
    print_r($ret);
 } else {
      echo $mysqli->error;
 }

查看更多：

http://php.net/manual/en/book.mysqli.php

http://php.net/manual/en/mysqli.query.php

http://php.net/manual/en/mysqli-result.fetch-assoc.php