Count

A Simple COUNT

The count method returns the number of matching rows, rather than the rows themselves. Here is an example of a simple COUNT query:

// Select the table
$table = db('mytable');

// Query the database
$count = $table->count()
           ->where('user','=','Evan')
           ->execute();

You can use the total method to count all the rows in a table:

$count = $table->total();