count sql query in php

The solution for this is noted below

count sql query in php

Solution

$sql = "SELECT COUNT(*) AS total from Members";
$result = $conn->query($sql);
$data =  $result->fetch_assoc();
echo $data['total'];

Try other methods by searching on the site. That is if this doesn’t work