connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "INSERT INTO tracker (device, lat, lon) VALUES ('" . mysqli_real_escape_string($conn, $_GET['device']) . "', " . mysqli_real_escape_string($conn, $_GET['lat']) . ", " . mysqli_real_escape_string($conn, $_GET['lon']) . ");"; if (!mysqli_query($conn, $sql)) { die('Error: ' . mysqli_error($conn)); } mysqli_close($conn); echo "OK"; } elseif (isset($_GET["tracker"])) { echo "OK"; } else { header('HTTP/1.0 400 Bad Request'); echo 'This is an endpoint for compatible GPS trackers only.'; }