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