如何从mysql查询结果按日期分组在php中给出符号(如更改颜色或fa-up/fa-down

Question

​

​

预期:如果osl高于之前的日期，则回显'fa-up‘。

<?php $sql_nongadai_kol_kw2= mysqli_query($kon,"SELECT * FROM vw_nongadai_kanwil ORDER BY TGL_UPDATE DESC LIMIT 31"); ?> 
<?php foreach( $sql_nongadai_kol_kw2 as $print ){;
    $tanda ='tes';
    $osl_tes =$print['osl_total'];
    if ($osl_tes > $osl_tes) {$tanda = '<i class="fa fa-long-arrow-up"></i>';}
    elseif ($osl_tes < $osl_tes) {$tanda = '<i class="fa fa-long-arrow-down"></i>';}
    elseif ($osl_tes = $osl_tes) {$tanda = '<i class="fa fa-long-arrow-v"></i>';}
    else {$tanda = 'error';}
?>
    <tr>
      <th scope="row"><?php echo $print['tgl_update'];?></th>
      <td align="right"><?php echo $tanda;?> - <?php echo number_format($print['osl_total']); ?></td>                            
    </tr>                                
<?php } ;?>

Answer 1

你应该在foreach循环之前启动$osl_tes，在循环内将$osl_tes与$print['osl_total']进行比较，并将新值绑定到$osl_tes：

<?php 
    $sql_nongadai_kol_kw2= mysqli_query($kon,"SELECT * FROM vw_nongadai_kanwil ORDER BY TGL_UPDATE DESC LIMIT 31"); 
    $osl_tes = 0; // or some other initial value
?> 
<?php foreach( $sql_nongadai_kol_kw2 as $print ){;
    $tanda ='tes';
    
    if ($print['osl_total'] > $osl_tes) {$tanda = '<i class="fa fa-long-arrow-up"></i>';}
    elseif ($print['osl_total'] < $osl_tes) {$tanda = '<i class="fa fa-long-arrow-down"></i>';}
    elseif ($print['osl_total'] = $osl_tes) {$tanda = '<i class="fa fa-long-arrow-v"></i>';}
    else {$tanda = 'error';}

    $osl_tes = $print['osl_total']; // bind new value
?>
    <tr>
      <th scope="row"><?php echo $print['tgl_update'];?></th>
      <td align="right"><?php echo $tanda;?> - <?php echo number_format($print['osl_total']); ?></td>                            
    </tr>                                
<?php } ;?>