Table MetaData These functions let you fetch table information. List the Tables in Your Database

last_row([$type = 'object'])

escape_str($str[, $like = FALSE])

add_key($key[, $primary = FALSE])

elapsed_time([$decimals = 6])

db_select([$database = ''])

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

count_all([$table = ''])

trans_off()

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