php - index array results from mysql call so I can call multiple times

234

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?

901

Answer

Solution:

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'];
    }

People are also looking for solutions to the problem: php - Query to add into multiple tables not working

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.