File manager - Edit - /home/autoph/public_html/connect/home/userApprovalClick.php
Back
<?php include_once 'core/init.php'; $userID = $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` ='$userID' AND `deleted` = 0 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(1) FROM `prf_request_detl` WHERE `header_ref_code`='$hdrRefCode' AND `user_canvass_approval`= 1 AND `user_approval_ts`='' AND `create_canvass_sheet`= '0' AND `deleted`=0 AND `canvass_review_date`!=''"),0); $userCanvassApproval = $userCanvassApproval + $getMyuserApproval; } if($userCanvassApproval == ''){ $userCanvassApproval = '0'; } echo $userCanvassApproval; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings