File manager - Edit - /home/autoph/public_html/connect/home/prf_showExecomItemApproval.php
Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); 193 * 1067 * 215 $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $myUserID = $user_data['u_id']; //$myDeptID = $user_data['dept_id']; if(isset($_POST['done'])){ $itemID = mysql_escape_string($_POST['itemID']); $getExecomList = mysql_query("SELECT * FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' ORDER BY `id` ASC"); echo "<table style='width:100%'>"; echo "<th style='width:20%'>Date/Time</th>"; echo "<th style='width:30%'>EXECOM</th>"; echo "<th style='width:35%'>Approved Vendor</th>"; echo "<th style='width:5%'> QTY</th>"; echo "<th style='width:15%'>Ammount</th>"; while($row = mysql_fetch_array($getExecomList)){ echo "<tr>"; echo "<td>".$row['date_approved'] ." | ".$row['time_approved']."</td>"; echo "<td>"; $exID = $row['approved_by_execom']; $exFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$exID'"),0); $exLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$exID'"),0); echo strtoupper($exLName). ", ".strtoupper($exFName); echo "</td>"; echo "<td>"; $exVendorID =$row['vendor_id']; $getVenName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$exVendorID'"),0); echo strtoupper($getVenName); echo "</td>"; echo "<td>".$row['canvass_qty']."</td>"; echo "<td>".$row['approved_amount']."</td>"; echo "</tr>"; } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings