You are here
drupal db_query count get count with db_select 有大用
星期四, 2017-12-14 13:16 — adminshiping1
Posted by tomas.teicher on
Hi,
is it possible to get number of results with db_select function?
普通分类:
Comments
The easiest way would
The easiest way would be:
$results = db_select('table')->fields(NULL, array('field'))->execute()->fetchAll();$count = count($results);Log in or register to post comments
Best way to do this...
$result = db_select('table_name', 'table_alias') ->fields('table_alias') ->execute(); $num_of_results = $result->rowCount();Log in or register to post comments
thank you both, I think
thank you both,
I think better is rowCount(),
but count() works too
thanks
Tomas
Log in or register to post comments
Diference
The difference here is:
If you use
count()you need to executefetchAll()first, this means you need to get all data from your database first. So, if your result have 10.000 rows, than you will need to fetch it from your database and load into memory (assign it to a variable).With
rowCount()you don't need to fetch data from database, so it is more efficient.Log in or register to post comments
similarly, you can add an
similarly, you can add an expression. See http://drupal.org/node/1266664
Log in or register to post comments
$countnode = db_query("SELECT
or
$countnode = db_query("SELECT COUNT(nid) AS count FROM {taxonomy_index} WHERE tid = :tid", array(':tid' => $tid))->fetchField();http://jobs68.com
Build Drupal website please contact me itqn2004@gmail.com
TanTran
Log in or register to post comments
The other way : countQuery()
countQuery() with dynamic queries is also one of the way to acheive this.
$results = db_select('table')->fields(NULL, array('field'))->countQuery()->execute()->fetchField();print_r($results);Log in or register to post comments
This is 10x more efficient
This is 10x more resource efficient than using ->rowCount() after execute()
A healthy disregard for the impossible.
Log in or register to post comments
This is the proper way. Be
This is the proper way. Be warned though—stupidly it returns the integer count as a string.
_________
http://marmaladesoul.com
Log in or register to post comments
get count with db_select
Hi
Get count with db_select working fine. In the below code:
$query = db_select('node', 'n') ->condition('n.type', 'article', '=') ->fields('n', array('nid','title')) ->execute(); $num = $query->rowCount();