File manager - Edit - /home/autoph/public_html/connect/home/PRF_UpdateCanvassCount.php
Back
<?php include_once 'core/init.php'; $userID = $user_data['u_id']; if(isset($_POST['trans'])){ $trans = mysql_escape_string($_POST['trans']); $getItemHdrX = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND `for_execom_canvass_approval`=0 AND `for_canvass` = 1 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdrX)){ $itemRefCodeX=$row['header_ref_code']; $getPRFApprovalCodeX = mysql_result(mysql_query("SELECT current_status FROM prf_request_hdr WHERE reference_code='$itemRefCodeX' "),0); if($getPRFApprovalCodeX == 4){ $forCanvassCountX = $forCanvassCountX + 1; } } echo $forCanvassCountX; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings