Zend_Db: How to get the number of rows from a table?

mysql zend-framework zend-db-table
Andrew picture Andrew · Dec 18, 2009 · Viewed 22.5k times · Source

I want to find out how many rows are in a table. The database that I am using is a MySQL database. I already have a Db_Table class that I am using for calls like fetchAll(). But I don't need any information from the table, just the row count. How can I get a count of all the rows in the table without calling fetchAll()?

Answer

Decent Dabbler picture Decent Dabbler · Dec 19, 2009 
$count = $db->fetchOne( 'SELECT COUNT(*) AS count FROM yourTable' );

Related questions

How do I add more than one row with Zend_Db?

I have an array with information which looks more or less like this: $data[] = array('content'=>'asd'); $data[] = array('content'=>'asdf'); And I want to add both entries into the Database. $db->insert('table', $data); does not …

Read More
How can I Select the MAX of a Column using Zend_Db_Table?

What is the easiest, simplest way to select the max of a column from a table using Zend_Db_Table? Basically, I just want to run this query in Zend: SELECT MAX(id) AS maxID FROM myTable;

Read More
"IS NULL" in Zend_Db_Table select not working

I'm trying to do a join on 2 tables in Zend, using the DbTable / model / mapper structure. If, in my mapper, I do this: $select = $this->getDbTable()->select(Zend_Db_Table::SELECT_WITH_FROM_PART) ->setIntegrityCheck(…

Read More