File manager - Edit - /home/autoph/public_html/connect/UpdateUserData.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['ApiKey']; // Expect LoginName, LoginPassword //========================================================= if($ApiKey == 541545451549797){ $companyID= $_REQUEST['companyID']; // Expect LoginName, LoginPassword* $dealerID= $_REQUEST['dealerID']; // Expect LoginName, LoginPassword* $brandID= $_REQUEST['brandID']; // Expect LoginName, LoginPassword* $employeeID= $_REQUEST['employeeID']; // Expect LoginName, LoginPassword* //$brandName= $_REQUEST['brandName']; // Expect LoginName, LoginPassword* $userRecordID = mysql_result(mysql_query("SELECT `u_id` FROM `vts_users` WHERE `employee_id`='$employeeID'"),0); $brandName = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='$brandID'"),0); $sql = "INSERT INTO brand_access (user_id, comp_id, dealer_id, brand_id, brand_name) VALUES('$userRecordID', '$companyID','$dealerID','$brandID','$brandName')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); mysql_query("UPDATE vts_users SET account_type = 'Admin' WHERE u_id='$userRecordID'"); $json = json_encode(["Status" => "Access Granted","Visible" => "True"]); } 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