Check codeigniter query errors instead of showing them to the user

Question

How can I check if a query went wrong instead of showing errors to users (containing database info which is unsafe).

Let's say I have such situation where my paging class takes a URI segment to show page example.com/page/uri_segment. If someone write it like this example.com/page/bla_bla_bla I get an error that shows information about my database.

How can I handle this?

clami219 · Accepted Answer · 2019-01-31 11:18:04Z

32

In application/config/database.php set

// suppress error output to the screen
$db['default']['db_debug'] = FALSE;

In your model or controller:

// try the select.
$dbRet = $this->db->select($table, $dataArray);
// select has had some problem.
if( !$dbRet )
{
   $errNo   = $this->db->_error_number();
   $errMess = $this->db->_error_message();
   // Do something with the error message or just show_404();
}

edited Jan 31, 2019 at 11:18

clami219

3,0131 gold badge34 silver badges48 bronze badges

answered Jul 6, 2011 at 17:04

cwallenpoole

82.4k26 gold badges132 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Muhammad Tarique Over a year ago

@clami219 but should I display db error messages to user or should I customize the message for user? what is the best practice?

clami219 Over a year ago

@MuhammadTarique I guess you wrote to the wrong user... I didn't write the answer, I just edited it (to add a semicolon). I guess you meant to address the author of the answer...

cwallenpoole Over a year ago

@MuhammadTarique It is generally best practice to log the error and then show the user a separate, custom message.

Jignesh.Raj · Accepted Answer · 2015-10-21 12:18:02Z

6

You can try this $this->db->error(); , this will get you the ErrorCode & Errormessage in array format.

edited Oct 21, 2015 at 12:18

Jignesh.Raj

6,0074 gold badges30 silver badges57 bronze badges

answered Oct 21, 2015 at 11:53

sushil

611 silver badge1 bronze badge

1 Comment

Ahmed Nabil Over a year ago

Yes using $errors_array['code']; and $errors_array['message']

PvdL · Accepted Answer · 2016-06-07 12:37:00Z

-3

you could check it like:

function myFunction() {
  echo 'Oeps';
}

$res = mysql_query($sql);
if($res && mysql_num_rows($res)>0){
  echo 'Success';
} else {
   myFunction();
}

edited Jun 7, 2016 at 12:37

answered Jul 6, 2011 at 17:05

PvdL

1,5931 gold badge20 silver badges33 bronze badges

Collectives™ on Stack Overflow

Check codeigniter query errors instead of showing them to the user

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related