Count unique Number from Loop Value - fabulouscode

Saturday, February 9, 2019

Count unique Number from Loop Value


Ref:: http://192.168.13.253/mymun/batch/Knitting_RFT_Report.php


$data="SELECT *
from tbl_Orderinfo";



//print_r('<pre>'.$data);
$dateData= array();
$result=sqlsrv_query($sql_conn,$data);
$flag = 0;
while($row = sqlsrv_fetch_array($result))
{
$flag = 0;
$sl++;


foreach ($dateData as &$value) {
    if( $value[0] ==  $row["ActualDyAopStDate"])
    {
$flag = 1;
$value[1] += 1;
      }
}
  if($flag == 0)
{
      $dateData[$sl-1][0] = $row["ActualDyAopStDate"];
  $dateData[$sl-1][1] =  1 ;

}

$TAVG= $TAVG + count($row["ActualDyAopStDate"]);

 ?>
<tr >
<td style="text-align:center;font-size:12px;"><?php echo date("d-M-Y", strtotime($row["ActualDyAopStDate"]));?></td>
<td style="text-align:center;font-size:12px;"><?php echo date("d-M-Y", strtotime($row["DyAopStDate"]));?></td>
<td style="text-align:center;font-size:12px;" ><?php echo $row["BuyerFullName"];  ?></td>
<td style="text-align:center;font-size:12px;" ><?php echo $row["OrderFullNo"];  ?></td>
</tr>

<?php

}
     foreach ($dateData as &$value) {
$dd=  "Date". $value[0]." ".  $value[1] . "<br/>";
   }

?>

No comments:

Post a Comment

I am Safiqul Islam Tuhin