blacklister/index.php

<?php
error_reporting(E_ALL);
$ip = trim($_GET['ip']);
$token = trim($_GET['token']);
$db = new mysqli('localhost', 'ban', 'Blubb123-', 'ban');
if ($db->connect_errno){
    die($db->connect_error);
}
$db->set_charset('utf8');

function checkToken($token,$db) {
    echo "got token: $token";
    $dbAction = $db->prepare("SELECT description FROM clients WHERE token=?");
    $dbAction->bind_param('s',$token);
    print_r($dbAction);
    $dbAction->execute();
    $dbAction->bind_result($description);
    echo "$description blubb $dbAction->num_rows";
    if ($dbAction->num_rows == 1){
        return true;
    }
    return false;
}

function set($ip,$db) {
    $dbAction = $db->prepare("INSERT INTO list (ip) VALUES (?) ON DUPLICATE KEY UPDATE count = count + 1");
    $dbAction->bind_param('i',$ip);
    return $dbAction->execute();
}

if (checkToken($token,$db)){
    if(set(ip2long($ip),$db)){
        echo " inserted $ip" . PHP_EOL;
    } else {
        echo " fehler" . PHP_EOL;
    };
} else {
    echo "token not exist" . PHP_EOL;
};