dbtng_example_entry_update

Update an entry in the database.

The former, deprecated techniques used db_query() or drupal_write_record():

 drupal_write_record('dbtng_example', $entry, $entry['pid']);

 db_query(
   "UPDATE {dbtng_example}
    SET name = '%s', surname = '%s', age = '%d'
    WHERE pid = %d",
    $entry['pid']
 );

Parameters

$entry: An array containing all the fields of the item to be updated.

See also

db_update()

Related topics

Example: Database (DBTNG)

Database examples, including DBTNG.

2 calls to dbtng_example_entry_update()

File

dbtng_example/dbtng_example.module, line 131

This is an example outlining how a module can make use of the new DBTNG database API in Drupal 7.

Code

function dbtng_example_entry_update($entry) {
  try {
    // db_update()...->execute() returns the number of rows updated.
    $count = db_update('dbtng_example')
              ->fields($entry)
              ->condition('pid', $entry['pid'])
              ->execute();
  }
  catch (Exception $e) {
    drupal_set_message(t('db_update failed. Message = %message, query= %query', 
      array('%message' => $e->getMessage(), '%query' => $e->query_string)), 'error');
  }
  return $count;
}