How to catch DB errors in CodeIgniter PHP

Question

I am new to CodeIgniter, PHP and MySQL. I want to handle the DB generated errors. From one of the post in Stackoverflow, I knew that by following statement one can catch the error.

 $this->db->_error_message();

But I cannot figure out the exact syntax of using that. Suppose I want to update the records of table named "table_name" by the following statement:

$array['rank']="8";
$array['class']="XII";
$this->db->where('roll_no',$roll_no);
$this->db->update("table_name", $array);

Here in the above code I want to catch the DB error whenever any DB level violation occurs i.e. either field name is not valid or some unique constraint violation occurs. If anyone helps me to fix that I would be really grateful. Thank you.

Have you tried try..catch block? Catch(Exception $e) { echo $e->getMessage(); } — George Kagan
– George Kagan, Commented Jul 29, 2013 at 12:00

Erman Belegu · Accepted Answer · 2013-07-29 12:02:01Z

5

You can debug the database error on database configuration in (config/database.php) like this:

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

Comments

Rajeev Ranjan · Accepted Answer · 2013-07-29 12:45:28Z

5

codeIgniter has functions for it

$this->db->_error_message(); 
$this->db->_error_number(); 


if(!$this->db->update("table_name", $array))
{
    $this->db->_error_message(); 
    $this->db->_error_number(); 
}

edited Jul 29, 2013 at 12:45

answered Jul 29, 2013 at 11:59

Rajeev Ranjan

4,1523 gold badges30 silver badges42 bronze badges

2 Comments

Joy Over a year ago

I know these two functions. Could you please tell me where should I put it in the above code and how?

always-a-learner Over a year ago

i don't get that how to apply or use this "$this->db->_error_message();" so can you help me over this ?? @RajeevRanjan

Sultan · Accepted Answer · 2016-11-17 08:12:49Z

2

On Codeigniter version 2,

$this->db->_error_message(); 
$this->db->_error_number();

On Codeigniter version 3,

$db_error = $this->db->error();
echo '<pre>';print_r($db_error);echo '</pre>';

answered Nov 17, 2016 at 8:12

Sultan

6676 silver badges14 bronze badges

Collectives™ on Stack Overflow

How to catch DB errors in CodeIgniter PHP

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related