query("SELECT FINANCIALPERIOD FROM procplanning GROUP BY FINANCIALPERIOD DESC"))
{ while ($row = $result->fetch_assoc() ) { $stss=$stss. ""; }
}
$connect->close();
?>
Procurement Plan from to
S/no.
Objective
Item description
Code
Sub item
1st Qtr
2nd Qtr
3rd Qtr
4th Qtr
Amount
prepare("SELECT * FROM procplanning WHERE FINANCIALPERIOD BETWEEN :a AND :b ORDER by id DESC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
Total:
prepare("SELECT sum(FIRSTQTR) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :a AND :b");
$results->bindParam(':a', $d1);
$results->bindParam(':b', $d2);
$results->execute();
for($i=0; $rows = $results->fetch(); $i++){
$dsdsd=$rows['sum(FIRSTQTR)'];
echo formatMoney($dsdsd, true);
}
?>
prepare("SELECT sum(SECONDQTR) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(SECONDQTR)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(THIRDQTR) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(THIRDQTR)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(FOURTHQTR) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(FOURTHQTR)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(BUDGETAMOUNT) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(BUDGETAMOUNT)'];
echo formatMoney($zxc, true);
}
?>