如何循环PHP代码和MySQL？

Question

How do I use the PHP loop through the query instead of putting all the result into an array then looping through the array

The way I use array and loop is like this:

<?php $userInfos = $qry->querySelect( SQL CODE HERE );

  foreach($userInfos as $uInfo)
        {
        $fName = $uInfo['fName'];
        $lName = $uInfo['lName'];
        $gender = $uInfo['gender'];
?>

First name is: <? echo $fName; ?> and Last name is <? echo $lName; ?>.

<?php } ?>

I wanted to know better insight on how PHP loop through the query is better than array. Please redirect me to some example or possibly with MySQL code included.

How can I convert the above php code to be more efficient if I am pulling millions of record?

Thanks so much!.

Answer 1

You can do a simple loop with mysqli_fetch_row()

http://php.net/manual/en/mysqli-result.fetch-row.php