索引数组来自mysql调用，所以我可以多次调用

Question

Ok, so I think I should be storing my mysql query as an array since I want to call upon the data multiple times. So instead of querying the database over and over, I can just do it once and then use the array over and over.

However, I am a bit lost in how to regenerate the table I was able to with mysql+php with the new array...

Here is my array call:

$userid = 3;
$results = mysqli_query($con,"SELECT user,product,etd FROM wp_summary WHERE user=$userid");

$history = array();
while( $row = mysqli_fetch_array($results) ){
    $history[]= [
                  $row['product'],
                  $row['etd']
                  ];
} 
echo print_r($history); //debugging so  I can see I actually called it right

But what I would like to do is now dynamically generate a table with a while loop on the rows. with a MySQL query, it was like this:

while($row = mysqli_fetch_array($result))
{
    echo "<tr style='font-size: 0.8em'>";
    echo "<td>" . $row['product'] . "</td>";
    echo "<td>" . $row['etd'] . "</td>";
    echo "</tr>";
}

But I can I convert this for the array now instead of the mysql query?

Answer 1

Solved my own riddle after the hint from @DimitrisFilippou ;

for ($i = 0; $i < count($history); $i++) {
    echo '<br>';
    echo $history[$i]['product'];
    echo $history[$i]['etd'];
    }