prepare("SELECT * FROM game_session WHERE LCASE(serverip) = :serverip"); $checkQuery->execute(['serverip' => strtolower($ip)]); if ($checkQuery->rowCount() > 0) { $existingRow = $checkQuery->fetch(PDO::FETCH_ASSOC); $existingId = $existingRow['serverid']; exit("Server already uploaded to the database. Join Game

Details:

Server Id: ".$existingId."

"); } $insertQuery = $pdo->prepare( "INSERT INTO game_session (serverip, port) VALUES (:serverip, :port)" ); $insertSuccess = $insertQuery->execute([ 'serverip' => htmlspecialchars($ip), 'port' => (int)$port, ]); if ($insertSuccess) { $insertedId = $pdo->lastInsertId(); exit("Server uploaded successfully. Join Game

Details:

Server Id: ".$insertedId."

"); } else { exit("An error occurred while uploading the server information."); }