Count Records Returned MySQL Doctrine
How do I check the number of records returned from a search of my MySQL database with a statement like thi开发者_C百科s:
$searchKey = 'Something to search for';
$searchResults = Doctrine::getTable('TableName')->createQuery('t')-
>where('columnName LIKE ?','%'.$searchKey.'%')->execute();
maybe
$searchResults->rowCount();
from here
Wouldn't
Doctrine::getTable('TableName')->createQuery('t')
->where('columnName LIKE ?','%'.$searchKey.'%')
->execute()
->rowCount();
fetch the results from the database?
In that case,
Doctrine::getTable('TableName')->createQuery('t')
->where('columnName LIKE ?','%'.$searchKey.'%')
->count()
be a better solution?
精彩评论