PEAR Manual
Prev		Next

->count()

->count() -- Perform a select count() request

Synopsis

int $DB_DataObject->count ()

Description

It performs a select count() request on the tables key column and returns the number of resulting rows. The default condition applied to the count() is a combination of the object variables and whereAdd settings. If the constant DB_DATAOBJECT_WHEREADD_ONLY is passed in as the first parameter then only the whereAdd settings will be used.

Parameter

boolean $useWhereAddOnly - use only the whereAdd conditions (by default, count will only use both the object settings and the whereAdd conditions)

Return value

int - number of results

Note

This function can not be called statically.

Example

Example 21-1. Simple find and fetch of data based on Object Vars

$person = new DataObjects_Person;  $person->whereAdd('name like '%test%'); $total = $person->count();  echo "There are {$total} people with a name like test";

Example 21-2. Resulting SQL

SELECT count(id) FROM person WHERE name like '%test%'

Prev	Home	Next
->fetch()	Up	->insert()

Who's Online
Guest Users: 6

Free Sample Chapters
	Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
More Sample Chapters

PHP General