Two while cannot be applied to the same query?

encountered a problem today 

$sql = $mysqli->query(
              "SELECT .... "
            );

I have a query that I want to apply to two while, but only the first one has a response 

<? while ($row = mysqli_fetch_array($sql)){ ?>

<? }?>

<? while ($row = mysqli_fetch_array($sql)){ ?>

<? }?>

is there any way to implement the same query that can be applied to two while? In the same place.

Mysqli mysql php7 php
Apr.07,2021

you can save the results of fetch to an array and then cycle through the array. 

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

foreach($rows as $row) {
A
}

foreach($rows as $row) {
B
}

or simply use mysqli_fetch_all , which is said to have some performance advantages: 

$rows=mysqli_fetch_all($result, MYSQLI_BOTH);

Note mysqli_fetch_all defaults to MYSQLI_NUM , which is different from mysqli_fetch_array , so add a second parameter.

add a sentence mysql_data_seek ($sql, 0)
before the second while. Excuse me if there is anything wrong with the grammar of php,. 

<? while ($row = mysqli_fetch_array($sql)){ ?>

<? }?>

<? mysql_data_seek( $sql, 0 ); ?>

<? while ($row = mysqli_fetch_array($sql)){ ?>

<? }?>

Previous: Ask an IdentityServer4 question, close and reopen the browser will automatically log in?

Next: Php script execution, process creation

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
© 2021 CodesHelper
Advertising Contact us About us
Menu