Help me with this COUNT query for a php file

Question

$query = 'SELECT COUNT(*) FROM Security WHERE ips=$currentip';

How do i get this to count the $currentip values that i make the variable equal to.

Answer 1

assuming you're using the mysqli function set:

$mysqli=new mysqli('localhost', 'my_user', 'my_password', 'my_db');

$query = 'SELECT COUNT(*) as num FROM Security WHERE ips=$currentip';
$response=$mysqli->query($query);
$row=$response->fetch_assoc();
$count=$row['num'];

It would be preferable to clean $currentip. Or even better to use a prepared statement.