<?php
// Create connection
$servername = "localhost";
$username = "root";
$password = "Skid4Life";
$dbname = "AntiBotServers";
$conn = new mysqli($servername, $username, $password, $dbname);

$ip = $conn->real_escape_string($_GET['ip']);

if ($conn->connect_error) {
    die();
}

$sql = "CREATE TABLE IF NOT EXISTS Servers (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,IP VARCHAR(30) NOT NULL)";
$conn->query($sql);

$sql3 = "SELECT id FROM Servers WHERE IP = '$ip'";
$result = $conn->query($sql3);

if ($result->num_rows == 0) {
  echo "0 results";
  $sql2 = "INSERT INTO Servers (IP) VALUES ('$ip')";
  $conn->query($sql2);
}

$conn->close();
?>