Example: Database (DBTNG)

Database examples, including DBTNG.

'DBTNG' means 'Database: The Next Generation.' Yes, Drupallers are nerds.

General documentation is available at database abstraction layer documentation and at Database API.

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:

// INSERT INTO {dbtng_example} (name, surname) VALUES('John, 'Doe')
db_insert('dbtng_example')->fields(array(
    'name' => 'John',
    'surname' => 'Doe',
))
    ->execute();

db_update() example:

// UPDATE {dbtng_example} SET name = 'Jane' WHERE name = 'John'
db_update('dbtng_example')->fields(array(
    'name' => 'Jane',
))
    ->condition('name', 'John')
    ->execute();

db_delete() example:

// DELETE FROM {dbtng_example} WHERE name = 'Jane'
db_delete('dbtng_example')->condition('name', 'Jane')
    ->execute();

See Database Abstraction Layer

See also

db_insert()

db_update()

db_delete()

drupal_write_record()

Parent topics

File

dbtng_example/dbtng_example.module, line 15

Functions

Classes