The Database Caching Class permits you to cache your queries as text files for reduced database load.

update([$table = ''[, $set = NULL[, $where = NULL[, $limit = NULL]]]])

escape_identifiers($item)

group_start()

CodeIgniter’s database abstraction allows you to use transactions with databases that support transaction-safe table types. In MySQL, you’ll need to be running InnoDB or BDB

escape($str)

Information From Executing a Query $this->db->insert_id() The insert ID number when

$this->db->call_function(); This function enables you to call PHP database functions that are not natively included in CodeIgniter,

cache_delete_all()

trans_strict([$mode = TRUE])