query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' ")) { while ($row = $result->fetch_assoc() ) { $stdd=$stdd. ""; } } $connect->close(); ?>
My work orders | .......... | ...... |
---|
...... | ....... | ..... |
---|
LPO.DATE | LPO.NO. | SERVICE.PROVIDER | SUB.TOTAL | TAX | GRAND.TOTAL | DELIVERY.STATUS | REQUIRED.DATE | ACTION | ".$res['TIMESTAMP']." | "; echo "".$res['LPONO']." | "; echo "".$res['SERVICEPROVIDER']." | "; echo "".$res['SUBTOTAL']." | "; echo "".$res['TAX']." | "; echo "".$res['TOTALCOST']." | "; echo "".$res['DELIVERYSTATUS']." | "; echo "".$res['DATEREQUIRED']." | "; echo "Update | Print | "; } ?>
---|
.........
ID | SERVICE PROVIDER | TYPE | FRAME WORK DETAILS | AGE | STATUS | ACTION | |
---|---|---|---|---|---|---|---|
ID | SERVICE PROVIDER | TYPE | FRAME WORK DETAILS | AGE | STATUS | ACTION | ".$res['id']." | "; echo "".$res['SERVICEPROVIDER']." | "; echo "".$res['TYPE']." | "; echo "".$res['ENTITYCODE']." ".$res['FRAMEWORKID']."/ ".$res['FRAMEWORKPERIOD']." : ".$res['FRAMEWORKDETAILS']." | "; echo "".$res['age']." | "; echo "".$res['STATUS']." | "; echo ''; echo " | Delete | "; } ?>
S/NO | SERVICE PROVIDER | CONTRACT | CONTRACT VALUE | PAYMENT SHEDULE | STATUS | ACTION | TRUNCATE |
---|---|---|---|---|---|---|---|
S/NO | SERVICE PROVIDER | CONTRACT | CONTRACT VALUE | PAYMENT SHEDULE | STATUS | ACTION | TRUNCATE | ".$res['id']." | "; echo "".$res['SERVICEPROVIDER']." | "; echo "".$res['CONTRACT']." | "; echo "".$res['CONTRACTVALUE']." | "; echo "".$res['PAYMENTSHEDULE']." | "; echo "".$res['STATUS']." | "; echo ''; echo " | Delete | "; } ?>
.........
............