Answers for "how to count number of entries in sql php"

get count sql query in php

$result=mysql_query("SELECT count(*) as total from Students");
$data=mysql_fetch_assoc($result);
echo $data['total'];

mysql count rows php

<?php
$con = mysqli_connect("localhost","root","","test");
if (!$con) 
{
  die('Could not connect: ' . mysqli_error());
}

$result = mysqli_query("select COUNT(*) FROM table");
$row = mysqli_fetch_array($result);

$total = $row[0];
echo "Total rows: " . $total;

mysqli_close($con);
?>