php - 从不同的值创建单个数组

Question

我有一个非常基本的列表查询，我希望在单个数组中显示所有列表

$sql = "SELECT * FROM vendor";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) 
    {
        while($row = mysqli_fetch_assoc($result)) 
            {
                echo"<pre>";
                    print_r($row);
                echo "</pre>";
            }
    } 

我得到的结果是

Array
(
    [id] => 1
    [email] => 
    [password] => 
    [status] => 
)

Array
(
    [id] => 2
    [email] => 
    [password] => 
    [status] => 
)

Array
(
    [id] => 3
    [email] => 
    [password] => 
    [status] => 
)

但是我希望得到看起来像这样的结果。

Array
(
   [0] => Array
    (
        [id] => 1
        [email] => 
        [password] => 
        [status] => 
    )
   [1] => Array
    (
        [id] => 1
        [email] => 
        [password] => 
        [status] => 
    )
)

谁能告诉我如何获得这个结果

Answer 1

首先，您需要将所有行存储到 attaylist 中，然后打印

$sql = "SELECT * FROM vendor";
$result = mysqli_query($conn, $sql);
$resulyArray = array();
if (mysqli_num_rows($result) > 0) 
    {
        while($row = mysqli_fetch_assoc($result)) 
            {
    array_push($resulyArray , $row);


            }
    } 


echo"<pre>";
  print_r($resulyArray);
echo "</pre>";