db_select([$database = ''])

class CI_DB_query_builder reset_query()

get_compiled_delete([$table = ''[, $reset = TRUE]])

select_avg([$select = ''[, $alias = '']])

limit($value[, $offset = 0])

CodeIgniter has a config file that lets you store your database connection values (username, password, database name, etc.). The config file is located at application/config/database

Query Basics Regular Queries To submit a query, use the query function:

trans_off()

set_update_batch($key[, $value = ''[, $escape = NULL]])

initialize()