real_escape_string($_GET['txtNotes']); $inputFname = $conn->real_escape_string($_GET['inputFname']); $inputLName = $conn->real_escape_string($_GET['inputLName']); $InputMobile = $_GET['InputMobile']; $InputEmail = $conn->real_escape_string($_GET['InputEmail']); $InputFBPage = $conn->real_escape_string($_GET['InputFBPage']); $InputIGPage = $conn->real_escape_string($_GET['InputIGPage']); $selectBrand = $_GET['selectBrand']; $selectModel = $_GET['selectModel']; $status = "New"; $sql = "INSERT INTO aha_sales_prospect (`asa_user_id`,`first_name`,`last_name`,`cust_mobile`,`cust_fb_page`,`cust_ig`,`cust_email`,`inquire_brand`,`inquire_model`,`notes`,`datetime_created`,`datetime_updated`) VALUES ('$userID','$inputFname','$inputLName','$InputMobile','$InputFBPage','$InputIGPage','$InputEmail','$selectBrand','$selectModel','$txtNotes','$myTimeStamp','$myTimeStamp')"; if ($conn->query($sql) === TRUE) { $stat="New record has been saved."; } else { $stat="Error, unable to save record."; } header('Content-Type: application/json'); echo json_encode(["status" =>$stat]); } $conn->close(); ?>