File manager - Edit - /home/autoph/public_html/connect/api/prf/prfUserRecommendation.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"); $prfTime = date('H:i:s'); $ts = $toDate . " ". $prfTime; $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 //=========================================================USER ACTION if($ApiKey == 'AAA1024197710262009EEE_RECOMMEND'){ $userID = $_REQUEST['userID']; $canvassID = $_REQUEST['canvassID']; $rank_number = $_REQUEST['rank_number']; $itemID = $_REQUEST['itemID']; mysql_query("UPDATE `prf_canvass_sheet` SET `user_feedback`='$rank_number' WHERE `id`='$canvassID'"); $json = json_encode(["feedback" => "complete"]); } //=========================================================RECANVASS ACTION if($ApiKey == 'AAA1024197710262009EEE_RECANVASS'){ $itemID = $_REQUEST['itemID']; mysql_query("UPDATE `prf_request_detl` SET `user_canvass_approval`='0',`user_approval_ts`='' WHERE `id`='$itemID'"); $json = json_encode(["feedback" => "complete"]); } //=========================================================SUBMIT if($ApiKey == 'AAA1024197710262009EEE_SUBMIT'){ $itemID = $_REQUEST['itemID']; $chkIfEndorsed=mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_canvass_sheet` WHERE `item_id`=$itemID AND `user_feedback`!=0"),0); if($chkIfEndorsed == 0){ $json = json_encode(["feedback" => "Error"]); }else{ mysql_query("UPDATE `prf_request_detl` SET `user_approval_ts`='$ts',`create_canvass_sheet`='1' WHERE `id`='$itemID'"); $json = json_encode(["feedback" => "complete"]); } } echo $json; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings