File manager - Edit - /home/autoph/public_html/connect/PRF_loadMyDeptPRF.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 == 'AAA1024197710262009EEE'){ $dataID= $_REQUEST['dataID']; $keyCode= mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_data` WHERE `cl_id`='$dataID'"),0); $return_tag = Array(); $sql = "SELECT prf_request_hdr.reference_code, prf_request_hdr.request_by, prf_request_hdr.dept_head_id, prf_request_hdr.date_needed, prf_request_detl.id, prf_request_detl.header_ref_code, prf_request_detl.item_description, vts_users.u_id, vts_users.u_fname, vts_users.u_lname FROM prf_request_hdr JOIN prf_request_detl ON prf_request_hdr.reference_code = prf_request_detl.header_ref_code JOIN vts_users ON vts_users.u_id!='' WHERE prf_request_hdr.dept_head_id = 481"; echo 'test'; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $count = $count + 1; $return_tag[]= $sqlRecord; } echo $count; $json = json_encode($return_tag); //} echo $json; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings