File manager - Edit - /home/autoph/public_html/connect/home/PRF_DELETEEndorsedCanvass.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"); $uniqueRefID=$user_data['u_id']; $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); if(isset($_POST['done'])){ $ENmyCanvassCode = mysql_escape_string($_POST['ENmyCanvassCode']); $ENmyVendorCode = mysql_escape_string($_POST['ENmyVendorCode']); $ItemRecordID = mysql_escape_string($_POST['ItemRecordID']); $cvssID = mysql_result(mysql_query("SELECT `id` FROM `prf_uploadedcanvass` WHERE `ref_code`='$ENmyCanvassCode'"),0); mysql_query("DELETE FROM `prf_canvass_sheet` WHERE `item_id`='$ItemRecordID' AND `canvass_id`='$cvssID'"); } ?> <table> <?php $getActiveProposals = mysql_query("SELECT * FROM `prf_canvass_sheet` WHERE `deleted`=0 AND item_id='$ItemRecordID'"); while($csRow = mysql_fetch_array($getActiveProposals)){ $cvsID = $csRow['id']; $cvID = mysql_result(mysql_query("SELECT `canvass_id` FROM `prf_canvass_sheet` WHERE `id`='$cvsID'"),0); $venCode = mysql_result(mysql_query("SELECT `vendor_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $cvCode = mysql_result(mysql_query("SELECT `ref_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $venName = mysql_result(mysql_query("SELECT `vendor_name` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); $cvFileCode = mysql_result(mysql_query("SELECT `file_code` FROM `prf_uploadedcanvass` WHERE `id`='$cvID'"),0); ?><tr onClick ="javascript:getEndorsedCanvassInfo(this);" onDblClick="javascript:showRemoveCanvassOption(this);"><?php echo "<td style='width:15%;font-size:12px;padding:3px;color:black'>".$cvCode."</td>"; echo "<td style='width:15%;font-size:12px;padding:3px;color:black'>"; echo $venCode; echo "</td>"; echo "<td style='width:40%;font-size:12px;padding:3px;color:black'>"; echo strtoupper($venName); echo "</td>"; echo "<td style='width:10%;font-size:12px;padding:3px;color:black;text-align:center'>".$csRow['quantity']."</td>"; echo "<td style='width:15%;font-size:12px;padding:3px;color:black;text-align:right'>".$csRow['amount']."</td>"; echo "<td style='width:5%;text-align:center'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$cvFileCode."' target='_blank'>📑</a></td>"; echo "</tr>"; } ?> </table>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings