File manager - Edit - /home/autoph/public_html/connect/home/PRF_Update_USERCANVASSFORAPPROVAL.PHP
Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; if(isset($_POST['trans'])){ $trans = mysql_escape_string($_POST['trans']); $getItemUsrApproval = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `request_by` ='$myUID' AND `deleted` = 0 AND `current_status` = 4 ORDER BY id DESC"); while($row=mysql_fetch_array($getItemUsrApproval)){ $chkIfForUSRApproval=$row['user_canvass_approval']; $hdrRefCode = $row['reference_code']; $getMyuserApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$hdrRefCode' AND `user_canvass_approval`=1 AND `user_approval_ts`='' AND `create_canvass_sheet`= 0"),0); $userCanvassApproval = $userCanvassApproval + $getMyuserApproval; } echo $userCanvassApproval; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings