File manager - Edit - /home/autoph/public_html/connect/api/prf/prfApprovedPO.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 //========================================================= if($ApiKey == 'AAA1024197710262009EEE_ApprovedPO'){ $userID = $_REQUEST['userID']; $poNumber = $_REQUEST['poNumber']; $approvalCodeGet = $_REQUEST['approvalCode']; if($approvalCodeGet!=3){ $approvalCode=9; }else{ $approvalCode=3; } mysql_query("UPDATE `prf_purchase_order` SET `po_status`='$approvalCode',`approved_by`='$userID',`date_approved`='$toDate' WHERE `po_number`='$poNumber'"); mysql_query("INSERT INTO prf_changes_logs(id,action_taken,user_id,old_info,new_info, ref_number) VALUES('','Approved PO via APP','{$userID}','New','{$approvalCode}','{$poNumber}')"); $Approved ="PO #".$poNumber . " has been approved."; $json = json_encode(["Status" => "$Approved"]); } echo $json; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings