prepare("SELECT id FROM gates WHERE address=:address"); if(!$select->execute(array(":address" => $_SERVER['REMOTE_ADDR']))) error("Unable to retrieve gate details"); if($g = $select->fetch()) { $insert = $db->prepare("INSERT INTO `received` (`sender`, `text`, `gate`) VALUES (:sender, :text, :gate)"); if(!$insert->execute(array(":sender" => $sender, ":text" => $text, ":gate" => $g['id']))) error("Failed to update database: ".$insert->errorInfo()[2]); else echo json_encode(array("id" => $db->lastInsertId())); } else error("You're not allowed to do this"); ?>