db_update() 、 db_insert()相关操作

最新推荐文章于 2024-08-20 15:19:42 发布

自由客

最新推荐文章于 2024-08-20 15:19:42 发布

阅读量999

点赞数

分类专栏： drupal

本文链接：https://blog.csdn.net/u011944761/article/details/40860669

版权

drupal 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

<?php
$values = array(
  array(
    'title' => 'Example',
    'uid' => 1,
    'created' => REQUEST_TIME,
  ),
  array(
    'title' => 'Example 2',
    'uid' => 1,
    'created' => REQUEST_TIME,
  ),
  array(
    'title' => 'Example 3',
    'uid' => 2,
    'created' => REQUEST_TIME,
  ),
);
$query = db_insert('node')->fields(array('title', 'uid', 'created'));
foreach ($values as $record) {
  $query->values($record);
}
$query->execute();
?>

<?php
/* This is a horrible example as node.status is pulled from node_revision.status table as well, updating it here will do nothing. */
$num_updated = db_update('node')
  ->fields(array(
    'uid' => 5,
    'status' => 1,
  ))
  ->condition('created', REQUEST_TIME - 3600, '>=')
  ->execute();
?>