mysqli_fetch_array() を使用して MySQL クエリ結果を効果的に管理するにはどうすればよいですか?

<code class="php">while($row = mysqli_fetch_array($result)) {
    $posts[] = $row['post_id'].$row['post_title'].$row['content'];
}</code>

<code class="php">$posts = array(); // Initialize an empty array
while($row = mysqli_fetch_array($result)) {
    $posts[] = $row; // Store each row as an array
}</code>

<code class="php"><?php
foreach ($posts as $row) {
    foreach ($row as $element) {
        echo $element. "<br>"; // Echo each element from each row
    }
}
?></code>

<code class="php">echo $posts[0]['post_id']; // Access the 'post_id' value for the first row
echo $posts[0]['content']; // Access the 'content' value for the first row</code>