File manager - Edit - /home/autoph/public_html/connect/CL_History.php
Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("Y/m/d"); $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $ApiKey= $_REQUEST['keyID']; // Expect LoginName, LoginPassword //========================================================= if($ApiKey == 10101088991100){ $userID= $_REQUEST['empID']; // Expect LoginName, LoginPassword* $return_tag = Array(); $sql = "SELECT vts_users.u_fname, vts_users.u_lname, vts_users.u_lname, cl_clearance_header.cl_h_emp_id, cl_clearance_header.cl_h_reason, cl_clearance_header.cl_h_date_created, cl_clearance_data.cl_approver_id_a, cl_clearance_data.cl_approver_id_b, cl_clearance_data.cl_id, cl_clearance_data.deleted, cl_clearance_data.cl_sla_start, cl_clearance_data.cl_unit_id, cl_clearance_data.cl_approved_date, cl_clearance_data.cl_approved_date, cl_approving_unit.id, cl_approving_unit.cl_unit_name FROM cl_clearance_header join vts_users ON cl_clearance_header.cl_h_emp_id = vts_users.u_id join cl_clearance_data ON cl_clearance_header.key_code = cl_clearance_data.key_code join cl_approving_unit ON cl_clearance_data.cl_unit_id = cl_approving_unit.id WHERE cl_clearance_header.key_code = cl_clearance_data.key_code AND cl_clearance_data.cl_approver_id_b = $userID AND cl_clearance_data.hdr_status = 1 AND cl_clearance_data.deleted='No' AND cl_clearance_data.cl_unit_id = cl_approving_unit.id || cl_clearance_header.key_code = cl_clearance_data.key_code AND cl_clearance_data.cl_approver_id_a = $userID AND cl_clearance_data.hdr_status = 1 AND cl_clearance_data.deleted='No' AND cl_clearance_data.cl_unit_id = cl_approving_unit.id ORDER BY cl_clearance_data.cl_id DESC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $count = $count + 1; $return_tag[]= $sqlRecord; } if($count > 0){ $visible="false"; }else{ $visible="true"; } $json = json_encode([$return_tag,"Visible" => "$visible"]); } if($did_something === 0) { $msg = did_nothing_message; $json = json_encode(["status" => "$MyCustomerID", "statusCode" => "$customerType"]); } echo $json; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings