Database

Connection

TODO: please contribute to complete this wiki.

Active Record

TODO: please contribute to complete this wiki.

Error Handling

The examples in the user guide enable database debugging. In this mode, database errors are handled by CodeIgniter, so you cannot control the output (errors generate messages). Generally this is not what you want in a production site. To disable debuggin change the following line in config/database.php file:

[code] $db['default']['db_debug'] = TRUE;[/code]

to

[code] $db['default']['db_debug'] = FALSE;[/code]

After setting this, you can use the return value of database operation methods. Example:

[code] if ($this->USER->insert($id, $name, $password) === FALSE) { $data['result'] = 'failed'; } else { $data['result'] = 'successful'; } [/pre]

See: http://codeigniter.com/forums/viewthread/49739/#243753

Category:Databases