Lưu ý khi sử dụng $query->fetchAll() (hint: it's optional) trong Drupal 7

Lưu ý khi sử dụng $query->fetchAll() (hint: it's optional) trong Drupal 7

Lưu ý khi sử dụng $query->fetchAll() (hint: it's optional) trong Drupal 7

Something that has come up on one of our projects recently is when to use fetchAll() or equivalents like fetchAllAssoc().

When writing a db_query() or db_select() query, you don't always need to use $query->fetchAll() or $query->fetchAllAssoc() to retrieve the result set; it's optional.

Database queries in Drupal 7 are iterator objects, so you can treat them like an array and loop over the results with foreach(). If you're going to do any processing on the results, it'll be quicker and use much less memory this way.

So for example, this will still work, note the lack of fetchAll():

<?php
// Build and run the query.
$results = db_select('node', 'n')
           ->fields('n', array('nid', 'title'))
           ->condition('status', 0, '!=')
           ->execute();

$nodes = array()
// We can use a foreach loop on the $results object.
foreach ($results as $n) {
  // Each $n is an object.
  $nodes[$n->nid] = $n->title;
}
?>

If you need the result as an array, you can use $results->fetchAssoc() to retrieve one item at a time:

<?php
// Build and run the query.
$results = db_select('node', 'n')
           ->fields('n', array('nid', 'title'))
           ->condition('status', 0, '!=')
           ->execute();

$nodes = array()
// We can use a foreach loop on the $results object.
while ($n = $results->fetchAssoc()) {
  // Each $n is an object.
  $nodes[$n['nid']] = $n['title'];
}
?>

One common use-case for using fetchAll() is so you can use count($results) to find out how many items were returned by the query. To get around this, you can use a count query instead. So:

<?php
// Create the query, but don't execute it yet.
$query = db_select('node', 'n')
         ->fields('n', array('nid', 'title'))
         ->condition('status', 0, '!=');

// This runs a COUNT(*) query to count the number of results.
$count = $query->countQuery()->execute()->fetchField();
// Now run the original query and return the result set.
$results = $query->execute();
?>

More details can be found in the DatabaseStatementInterface API documentation, or in the PHP PDO manual.

Bạn thấy bài viết này như thế nào?: 
No votes yet
Ảnh của Khanh Hoang

Khanh Hoang - Kenn

Kenn is a user experience designer and front end developer who enjoys creating beautiful and usable web and mobile experiences.

Advertisement

 

jobsora

Dich vu khu trung tphcm

Dich vu diet chuot tphcm

Dich vu diet con trung

Quảng Cáo Bài Viết

 
Giới thiệu 106 thủ thuật với Microsoft Office

Giới thiệu 106 thủ thuật với Microsoft Office

Bạn có biết là bạn hoàn toàn có thể bổ sung thêm một máy tính vào trong Word không

Làm gì khi Google Chrome bị treo liên tục ?

Làm gì khi Google Chrome bị treo liên tục ?

Google Chrome là một trong những trình duyệt phổ biến và được yêu thích nhất hiện nay.

Disappointing iPhone: Android Device Set to Gain

Disappointing iPhone: Android Device Set to Gain

Asian smartphone makers have a chance to exploit a rare letdown from pacesetter Apple Inc. after the new iPhone 4S failed to wow fans and investors, leaving Android rivals better placed to grab market share.

Công ty diệt chuột T&C

 

Diet con trung