I can not get the IP from the database, who can help?

Question

Zend Framework

'id' => new Expression('(SELECT COUNT(`id`) FROM ' . $this->getTable() . ' WHERE `ip` = INET_ATON(' .  "$ip" . '))', []),

ERROR
Statement could not be executed (42000 - 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.0.1)) AS `id` FROM `survey_vote` ' at line 1)

Answer 1

Output the generated text of your request, find the place indicated in the error and look carefully.

Decision

INET_ATON принимает на вход строку.

Answer 2

When applying an aggregating function to a field, if you later need to refer to this field by name, you must specify an alias for the field, for example:
select count(id) as id from