The total number of rows count using PHP and MySQL .you can count using two methods. First of all, you can use count() function. You have to need to define the count() function under the MySQL query.
$sql="select count('1') from users";
We have used = count(1) function also we can use count(*) replace count(1) because. COUNT(*) counts the number of rows. Since both 0 and 1 are non-null values, COUNT(0)=COUNT(1) and they both will be equivalent to the number of rows COUNT(*). That is a different concept, but the result produce will be the same
The second method -
In the second method, you count the MySQL table rows using
Hope it will help.
$sql="select count('*') from users";
$mysqliStatus = $mysqli->query($sql);
$rows_count_value = mysqli_num_rows($mysqliStatus);