File manager - Edit - /home/autoph/public_html/connect/home/prf_UpdateSupplier.php
Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; if(isset($_POST['done'])){ $vendorID = mysql_escape_string($_POST['vendorID']); $MyVendorCode = mysql_escape_string($_POST['EMyVendorCode']); $vendorNotes = mysql_escape_string($_POST['EvendorNotes']); $vendorName = mysql_escape_string($_POST['EvendorName']); $vendorTerm = mysql_escape_string($_POST['EvendorTerm']); $vendorTIN = mysql_escape_string($_POST['EvendorTIN']); $vendorAddress = mysql_escape_string($_POST['EvendorAddress']); $vendorFax = mysql_escape_string($_POST['EvendorFax']); $vendorLandline = mysql_escape_string($_POST['EvendorLandline']); $vendorContactPerson = mysql_escape_string($_POST['EvendorContactPerson']); $vendorMobile = mysql_escape_string($_POST['EvendorMobile']); $vendorEmail = mysql_escape_string($_POST['EvendorEmail']); mysql_query("UPDATE `prf_suppliers` SET sup_code='$MyVendorCode', sup_name='$vendorName', address='$vendorAddress', landline='$vendorLandline', vendor_fax='$vendorFax', contact_person='$vendorContactPerson', contact_person_email='$vendorEmail', contact_person_mobile='$vendorMobile', terms='$vendorTerm', tin_number='$vendorTIN', supplied_items='$vendorNotes' WHERE `id`='$vendorID' "); ?> <table> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_suppliers` WHERE `deleted`='0' ORDER BY `sup_name` LIMIT 50"); while($row=mysql_fetch_array($getItemHdr)){ ?><tr onclick="javascript:getRecordID(this);" onDblclick="javascript:viewEditForm(this);" ><?php echo "<td style='width:3%'>".$row['id']."</td>"; echo "<td style='width:5%'>".strtoupper($row['sup_code'])."</td>"; echo "<td style='width:15%'>".strtoupper($row['sup_name'])."</td>"; echo "<td style='width:15%'>".strtoupper($row['address'])."</td>"; echo "<td style='width:5%'>".strtoupper($row['landline'])."</td>"; echo "<td style='width:5%'>".strtoupper($row['vendor_fax'])."</td>"; echo "<td style='width:5%;text-align:left'>".strtoupper($row['terms'])."</td>"; echo "<td style='width:8%;text-align:left'>".strtoupper($row['contact_person'])."</td>"; echo "<td style='width:10%'>".$row['contact_person_email']."</td>"; echo "<td style='width:5%'>".$row['contact_person_mobile']."</td>"; echo "<td style='width:5%'>".$row['tin_number']."</td>"; echo "<td style='width:25%;text-align:left'>".strtoupper($row['supplied_items'])."</td>"; echo "</tr>"; } ?> <tr><td colspan='12' ><hr style='padding:0px;background:transparent;border:0px;border-bottom:1px solid gray'></td> <tr> <td colspan='2' style='background:white;font-family:Yu Gothic; font-size:13px;color: #f97d43 ;height:20px;font-weight:normal'>Selected Record:</td> <td colspan='10' style='background:white;'> <input type='hidden' id='selectedPRFHeaderID' class='TableBottomLabel'> <input disabled type='text' id='selectedPRFHeaderIDLabel' style='background:white;border:0px;font-family:Yu Gothic;font-size:14px;color: #f97d43 ;font-weight:normal'> </td> </tr> </table> <?php } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings