File manager - Edit - /home/autoph/public_html/connect/BOOKMARK_LOAD.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(). '.'); $reservedKEY= $_REQUEST['reservedKEY']; $myID = $_REQUEST['myID']; $delReq= $_REQUEST['xDELETE']; $delID= $_REQUEST['delID']; //====================================================================== if($saveRes == 72107){ $empID= $_REQUEST['empID']; $unitID= $_REQUEST['unitID']; $Notes = $_REQUEST['Notes']; $brand= $_REQUEST['brand']; $desc= $_REQUEST['desc']; $sql = "INSERT INTO db_sc_request (sc_id, unit_id, request_type, notes,status, brand_name, variant_dest , saved_date) VALUES('$empID', '$unitID','RESERVATION','$Notes','New','$brand','$desc', '$toDate')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $msg ="Reservation request has been sent"; $json = json_encode(["Status"=>$msg]); } //====================================================================== //====================================================================== if($delReq == 101024110706){ mysql_query("UPDATE `db_sc_request` SET `status`='Cancelled' WHERE `req_id` = '$delID'"); $msg ="Record has been deleted from your bookmark list."; $json = json_encode(["Status"=>$msg]); } //======================================================================LOAD LIST if($reservedKEY == 10241024){ $return_dir = Array(); $sql = "SELECT * FROM db_sc_request WHERE `sc_id`='$myID' AND `status` !='Closed' AND `status` !='Cancelled'"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_dir[]= $sqlRecord; } $json = json_encode($return_dir); } 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