PHP SQL Number of Rows

To understand how to count the number of rows in a table, we have created a sql_num_rows.php file.

Ads

PHP SQL Number of Rows

     

This example illustrates how to count the rows of the table.

To understand how to count the number of rows in a table, we have created a sql_num_rows.php file. If you are not connected to the database, then create a connection first using mysql_connect("hostName", "userName", "Password") and mysql_select_db("databaseName", connectionObject). Now the query can be executed using mysql_query("SELECT * FROM tableName"). The number of rows are returned by the mysql_num_rows() method.

 

 

 

Table: users

 

Source Code of sql_num_rows.php 

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

  $sql = "SELECT * from users";

  $res = mysql_query($sql);

  if (!$res) {
  print("SQL statement failed with error:\n");
  print(mysql_error($con));
  else {
  $number_of_rows = mysql_num_rows($res);
  print("$number_of_rows rows found");
  }  
  mysql_close($con);
?>
Download Source Code

 

Output:

Advertisements

Share on Google+Share on Google+

PHP SQL Number of Rows

Posted on: January 20, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: PHP SQL Number of Rows  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads