In part 1 of this series of articles, I discussed D7’s new database layer and we started looking at what to expect with examples of static and dynamic queries. Those queries are for fetching information from a database, but what’s changed from D6 to D7 when it comes to manipulating the information in our database? The answer: a lot.
We’ll start with INSERT queries. In D6 we were relegated to two options when it came to INSERT queries. We could either write out an INSERT query the long way:
<?php
$query = "INSERT INTO {node} (title, uid, created) VALUES ('%s', %d, %d)";
db_query($query, 'Example', 1, $timestamp);
?>
Or, we could use the function drupal_write_record():
<?php
$record = new stdClass();
$record->title = 'Example';
$record->uid = 1;
$record->created = time();
drupal_write_record('node', $record);
?>
This was a vast improvement over D5 certainly, but could still result in some cumbersome code. Looking back to the first article in this series I discussed how D7's database layer is now built on top of PDO. Let's see how we handle an INSERT query in D7 utilizing this new API.
Recent comments
17 weeks 17 hours ago
22 weeks 4 hours ago
25 weeks 16 hours ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 18 weeks ago
1 year 18 weeks ago
1 year 19 weeks ago
1 year 19 weeks ago