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']; $regiID = addslashes($_REQUEST['regEMPID']); $regFName = addslashes($_REQUEST['regEMPFname']); $regLName = addslashes($_REQUEST['regEMPLName']); $regCompany = addslashes($_REQUEST['regEMPCompCode']); //====================================================================== //========================================================= if($apiKey === '124154977102400010001'){ $compCode = mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$regCompany'"),0); $myFrame = ""; $myFrame = mysql_real_escape_string($myFrame); //mysql_query("UPDATE `vts_users` SET `long` = '$myFrame' WHERE `employee_id` = '$regiID'"); mysql_query("UPDATE `vts_users` SET `long` = '$myFrame' WHERE `employee_id` = '$regiID'"); $json = json_encode(["Status" => $regFName,"Visible" => "True"]); } // //echo $json; ?>