Database Examples
These examples show basic database examples, including DBTNG.
General documentation is available at Database abstraction layer documentation @endlink and at @link http://drupal.org/node/310069.
The several examples here demonstrate basic database usage.
In Drupal 6, the recommended method to save or update an entry in the database was drupal_write_record() or db_query().
In Drupal 7 and forward, the usage of db_query() for INSERT, UPDATE, or DELETE is deprecated, because it is database-dependent. Instead specific functions are provided to perform these operations: db_insert(), db_update(), and db_delete() do the job now. (Note that drupal_write_record() is also deprecated.)
db_insert() example:
<?php
// INSERT INTO {dbtng_example} (name, surname) VALUES('John, 'Doe')
db_insert('dbtng_example')
->fields(array('name' => 'John', 'surname' => 'Doe'))
->execute();
?>db_update() example:
<?php
// UPDATE {dbtng_example} SET name = 'Jane' WHERE name = 'John'
db_update('dbtng_example')
->fields(array('name' => 'Jane'))
->condition('name', 'John')
->execute();
?>db_delete() example:
<?php
// DELETE FROM {dbtng_example} WHERE name = 'Jane'
db_delete('dbtng_example')
->condition('name', 'Jane')
->execute();
?>See Database Abstraction Layer
See also
Functions & methods
| Name | Description |
|---|---|
| dbtng_example_entry_delete | Delete an entry from the database. |
| dbtng_example_entry_insert | Save an entry in the database. |
| dbtng_example_entry_load | Read from the database using a filter array. |
| dbtng_example_entry_update | Update an entry in the database. |
examples/
