Comment interroger la base de données avec une requête facilement modifiable en Drupal

Question

Pour interroger la base de données avec une requête facilement altérable, que puis-je utiliser en bonne pratique ?

Accepted Answer

$query = db_query("SELECT nid, title FROM {node} WHERE created > :created", array(
      ':created' => REQUEST_TIME - 3600,
    ));

Answer

$query = db_select('node', 'n')
      ->fields('n', array('nid', 'title'))
      ->condition('created', REQUEST_TIME - 3600)
      ->execute();

Answer

$query = "SELECT nid, title FROM {node} WHERE created > REQUEST_TIME - 3600";

Answer

$query = db_select("SELECT nid, title FROM {node} WHERE created > REQUEST_TIME - 3600");

Answer

$query = db_select("SELECT nid, title FROM {node} WHERE created > :created", array(
      ':created' => REQUEST_TIME - 3600,
    ));

Answer

$query = db_query("SELECT nid, title FROM {node} WHERE created > REQUEST_TIME - 3600");

Question du test Drupal 7