Drupal でSQLを書く – example

Ayumi

9 years ago

nodeテーブルからtypeをWhereに入れてSELECT

//nidだけを知りたいだけ
$results = db_select('node', 'n')
  ->fields('n', array('nid'))
  ->condition('type', 'article')
  ->execute()
  ->fetchCol();

//複数のfieldsがほしいなら
$results = db_select('node', 'n')
  ->fields('n', array('nid', 'title'))
  ->condition('type', 'article')
  ->execute();
foreach($results as $row){
 var_dump($row);
}

//countなら
$results = db_select('node', 'n')
  ->fields('n', array('nid', 'title'))
  ->condition('type', 'article')
  ->execute()
　->rowCount();

//queryを確認したいなら
$results = db_select('node', 'n')
  ->fields('n', array('nid', 'title'))
  ->condition('type', 'article')
  ->execute()
　->getQueryString();

//nidだけを知りたいだけ

$results = db_select('node', 'n')

->fields('n', array('nid'))

->condition('type', 'article')

->execute()

->fetchCol();

//複数のfieldsがほしいなら

$results = db_select('node', 'n')

->fields('n', array('nid', 'title'))

->condition('type', 'article')

->execute();

foreach($results as $row){

var_dump($row);

}

//countなら

$results = db_select('node', 'n')

->fields('n', array('nid', 'title'))

->condition('type', 'article')

->execute()

　->rowCount();

//queryを確認したいなら

$results = db_select('node', 'n')

->fields('n', array('nid', 'title'))

->condition('type', 'article')

->execute()

　->getQueryString();

field_data_field_package_periodテーブルから日付をWhereに入れてSELECT

$date = new DateTime();
$results = db_select('field_data_field_package_period', 'fpp')
  ->fields('fpp', array('field_package_period_value2'))
  ->condition('field_package_period_value2', $date->format('Y-m-d H:i:s'), '<')
  ->execute()
  ->fetchCol();

$date = new DateTime();

$results = db_select('field_data_field_package_period', 'fpp')

->fields('fpp', array('field_package_period_value2'))

->condition('field_package_period_value2', $date->format('Y-m-d H:i:s'), '<')

->execute()

->fetchCol();

field_data_field_package_periodテーブルからentity_idをINでSELECT

$results = db_select('field_data_field_package_level', 'fpl')

  ->fields('fpl', array('field_package_level_value'))

  ->condition('entity_id', array(1,2,3), 'IN')

  ->condition('field_package_level_value', 0, '!=')

  ->execute()

Tags: Drupal, SQL

Related posts