Why doesn't the check for the existence of an N-string[PHP] work?

Question

PHP

The class has a function

public function checkRow($query = null, $params = [])
    {
        $result = $this->link->prepare($query);
        $result->execute($params);
        return $result->fetchColumn();
    }

I call her like this

print_r($db->checkRow('SELECT count(proxy) FROM ' . Config::TABLE_SITE . ' WHERE proxy=' . '1.1.1.1:8080'));

but it does not display anything, it is when using this type of record 1.1.1.1:8080 , but if you just write 11118080 it shows 0 or 1 , depending on the presence in the database. How to fix?

Answer 1

proxy="1.1.1.1:8080"

Answer 2

Check the data types you are using for the fields. For IPv4 use INT UNSIGNED and for INET_ATON and INET_NTOA conversion and keep the port separate.
And use appropriate quotes for tables/columns/values.