php - mysqli_fetch_array while 循环列

Question

这个问题已经有答案了:

get array of rows with mysqli result (2 个回答)

已关闭 7 个月前。

应该是非常基本的，但我无法让它工作。我有这个代码来迭代 mysqli 查询:

while($row = mysqli_fetch_array($result)) {
    $posts[] = $row['post_id'].$row['post_title'].$row['content'];
}

它可以工作并返回:

Variable #1: (Array, 3 elements) ↵ 0 (String): "4testtest" (9 characters) 1 (String): "1Hello world!Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!" (99 characters) 2 (String): "2Sample PageThis is an example page. It's different from a blog post because it will stay in one place and will show up in your site navigation (in most themes)." (161 characters)

问题是它将所有三列放入一列中，因此我无法单独访问它们。

例如:

0 (String): "4testtest" (9 characters)

应该分为4，测试，测试

当我这样做时:

while($row = mysqli_fetch_array($result)) {             
    $posts['post_id'] = $row['post_id'];
    $posts['post_title'] = $row['post_title'];
    $posts['type'] = $row['type'];
    $posts['author'] = $row['author'];  
}   

它只输出 1 行，而不是全部三行……

非常感谢任何帮助!

Answer 1

从 MySQL 获取所有值:

    $post = array();
    while($row = mysqli_fetch_array($result))
    {
        $posts[] = $row;
    }

然后，获取每个值:

<?php 
     foreach ($posts as $row) 
        { 
            foreach ($row as $element)
            {
                echo $element."<br>";
            }
        }
?>

回显值。或者从 $post 变量中获取每个元素