Question

How to count number of rows in a MySQL database table in PHP

Answer 1

$db_host       = 'localhost';
$db_user       = 'username';
$db_pass       = 'password';
$db_database   = 'database_name';
 
$con = mysql_connect($db_host, $db_user, $db_password) or die('Unable to connect to DB');
mysql_select_db($db_database, $con);

$result = mysql_query("SELECT * FROM my_table", $con) or die(mysql_error());
$num_rows = mysql_num_rows($result);
echo $num_rows;

70+ SQL courses for beginners and professionals