drupal7 增 删 改 查

增

$item['mlid'] = db_insert('menu_taxonomy_rel')
      ->fields(array(
        'mlid' => $item['mlid'],
        'tid' => $tid_str,
      ))
      ->execute();

删

db_delete('menu_taxonomy_rel')->condition('mlid', $item['mlid'])->execute();

改

db_update('menu_taxonomy_rel')
      ->fields(array(
        'tid' => $tid_str,
      ))
      ->condition('mlid', $item['mlid'])
      ->execute();

查

db_query('SELECT tid FROM {menu_taxonomy_rel} where mlid='.$item['mlid'])->fetchAllAssoc('name', PDO::FETCH_ASSOC);