while($row=mysqli_fetch_array())中如何将结果调用出{}

Question

例如
<?php
$mysqli=new MySQLi("localhost","a","a","a");
$pay_historysql="select * from ecm_user_pay_for_system where user_id='test' and trade_status='TRADE_FINISHED'";
$recult=$mysqli->query($pay_historysql);
$tjjg=array();
while($row=mysqli_fetch_array($recult,MYSQLI_ASSOC))
{
echo = $row['id'];//这里可以输出结果
}

?>我想让 $row['id']在while之外能调用，请问该怎么办呢？

Answer 1

<?php
 $mysqli=new MySQLi("localhost","a","a","a");
 $pay_historysql="select * from ecm_user_pay_for_system where user_id='test'".
                " and  trade_status='TRADE_FINISHED'";
 $recult=$mysqli->query($pay_historysql);
 $tjjg=array();
 $array=array();
 while($row=mysqli_fetch_array($recult,MYSQLI_ASSOC))
 {
       echo = $row['id'];//这里可以输出结果
       array_push($array,$row);
       array_shift(0);
        // $array 此时是一个包含所有记录的二维数组;
 }     
  
 print_r($array[0]['id']) ;?>

Answer 2

        $mysqli=new MySQLi("localhost","a","a","a");
        $pay_historysql="select * from ecm_user_pay_for_system where user_id='test' and trade_status='TRADE_FINISHED'";
        $recult=$mysqli->query($pay_historysql);
        $tjjg=array();
        while($row=mysqli_fetch_assoc($recult))
        {
            $array[]= $row;//这里可以输出结果
        }
print_r($array);
        

Answer 3

 $mysqli=new MySQLi("localhost","a","a","a");
        $pay_historysql="select * from ecm_user_pay_for_system where user_id='test' and trade_status='TRADE_FINISHED'";
        $recult=$mysqli->query($pay_historysql);
        $tjjg=array();
        while($row=mysqli_fetch_assoc($recult))
        {
            $array[]= $row;//这里可以输出结果
        }
print_r($array);这个比较直白

Answer 4

$rowarr=array();
while($row=mysqli_fetch_array($recult,MYSQLI_ASSOC))
 {
        $rowarr[] = $row;
 }
 foreach($rowarr as $key=>$value)
 {$statusarr = $value['...'];
echo $statusarr;
}