File manager - Edit - /home/autoph/public_html/connect/CLR_HRApproval.php
Back
<?php include '../../cfg/asaconn.php'; $mykey = $_GET['keyID']; //========================================================= if($mykey == 10101088991100){ $userID= $_REQUEST['empID']; // Expect LoginName, LoginPassword* $count =0; $rows = Array(); $sql = "SELECT vts_users.u_fname, vts_users.u_lname, vts_users.u_lname, vts_users.u_position, vts_company.comp_code, cl_clearance_header.h_id, cl_clearance_header.cl_h_emp_id, cl_clearance_header.cl_effectivity_date, cl_clearance_header.cl_h_reason, cl_clearance_header.cl_h_date_created, cl_clearance_header.key_code, cl_clearance_header.cl_hr_approval_id FROM cl_clearance_header join vts_users ON cl_clearance_header.cl_h_emp_id = vts_users.u_id join vts_company ON vts_company.comp_id = cl_clearance_header.cl_h_comp_id WHERE cl_clearance_header.cl_hr_approval_id = $userID AND cl_clearance_header.cl_h_hr_approval ='FOR HR APPROVAL' ORDER BY cl_clearance_header.h_id DESC"; $resultA = $conn->query($sql); if ($resultA->num_rows > 0) { while($row = $resultA->fetch_assoc()){ $count = $count + 1; $rows[] = [$row, "Count" =>"$count"]; } } $json = json_encode($rows); } echo $json; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings