File manager - Edit - /home/autoph/public_html/pms_v1/pef/countPEFApproval.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); // error_reporting(0); if(isset($_POST['code'])){ $userID = $_POST['userID']; $count=0; $mCount=0; $getMyProfile = "SELECT * FROM `tempmarviews` WHERE `owner_id`='$userID' ORDER BY `last_name` ASC"; $getMyPro = mysqli_query($conn,$getMyProfile); while($row = mysqli_fetch_array($getMyPro)){ $empIDinPCP = $row['emp_rec_id']; $getPCPHeader = "SELECT * FROM `pcp_headers` WHERE `deleted`=0 AND `employee_id` ='$empIDinPCP' AND `pef_status` != 2 AND `deleted`=0 ORDER BY `year` DESC"; $empPCP = mysqli_query($conn,$getPCPHeader); while($cnt=mysqli_fetch_array($empPCP)){ $count = $count + 1; } } echo $count; $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings