Tuesday, September 2, 2014 02:49 pm EDT

An Example of Using db_query in Drupal 7

Bri's picture

If you are writing your own modules, there is a good chance you have used db_query quite a bit in the past. The database layer has been overhauled in Drupal 7, and as a result, the way you get query results has changed slightly. Here is an example to how you how it's used.

// Notice the place holders are now done using the same syntax as PDOs (:uid)
// Placeholders also don't need to be quoted anymore.
$uid = 1;
$result = db_query('SELECT n.nid, n.title, n.created
FROM {node} n WHERE n.uid = :uid', array(':uid' => $uid));
// Result is returned as a iterable object that returns a stdClass object on each iteration

foreach ($result as $record) {
  // Perform operations on $record->title, etc. here.
  // in this example the available data would be mapped to object properties:
  // $record->nid, $record->title, $record->created
}

Comments

Anonymous's picture

Thanks

Thanks

Anonymous's picture

Saved by this same blog post

Saved by this same blog post once again...

Anonymous's picture

Senthil

Useful information. Thanks.