Php Tutorials

Php Count() Function Syntax:

 count(array,mode) 

array: Required. Specifies an array.

mode: Optional. Specifies the mode of the function.

Php Count() Function Examples:

Example 1

<?php
$fruits = array("Orange", "Apple", "Leech", "Mango");
$count = count($fruits);
echo "There are $count type of fruits";
?>

Output:

There are 4 type of fruits

Example 2

<?php
$value= array(1,2,3,4,5);
$count = count($value);
echo "There are $count Values in the Array";?>

Output:

There are 5 Values in the Array

Example 3

<?php
$n[0] = 'column one';
$n[1] = 'column two';
$n[2] = 'column three';
$result = count($n);
echo "There are $result Columns";
?>

Output:

There are 3 Columns

MySql Count() Fucntion

The MySql Count() function returns the number of rows in a query. The MySql Count() function will only count those records in which the field in the brackets is NOT NULL.

Syntax

SELECT COUNT(expression)
FROM tables
WHERE predicates;

Examples

Example 1

if you have the following table in your MySql Datbase, called students:

<?php
/// Counting number of students in the students table
$query = "SELECT COUNT(Student_Name) FROM students";
$result = @mysql_query($query);
while($row = @mysql_fetch_array($result)){
	echo "There are ". $row['COUNT(Student_Name)']. "Students in the Database";
}?>

Output:

There are 3 Students in the Database

Example 2

While the result for the next query will only return 1, since there is only one row in the students table where the “Father_name” field is NOT NULL.

<?php
/// Counting students with father name in the students table
$query = "SELECT COUNT(Father_Name) FROM students";
$result = @mysql_query($query);
while($row = @mysql_fetch_array($result)){
	echo "There is ". $row['COUNT(Student_Name)']. "Student with Father Name";
}?>

Output:

There is 1 Student with Father Name

Counting Multiple MySql Database Records

The COUNT function is an aggregate function that simply counts all the items that are in a group. One use of COUNT might be to find out how many Students are in the each “City”

Examples:

Example 1

<?php
$query = "SELECT City, COUNT(Student_Name) FROM students GROUP BY City";
$result = @mysql_query($query);
while($row = @mysql_fetch_array($result)){
	echo "There are ". $row['COUNT(Student_Name)'] ." Students from ". $row['City'] ."";
	echo "<br />";
}
?>

Output:

There are 3 Students from  England.
There are 3 Students from  Canada.
There are 2 Students from  USA.