EllisLab text mark
Advanced Search
     
Prevent connection errors to pop up ...
Posted: 13 October 2012 03:43 PM   [ Ignore ]
Joined: 2011-06-24
101 posts

I’m checking for a connection with (yes, I know it’s not properly escaped):

$db_conn = new mysqli($this->input->post('host'), $this->input->post('mysql_admin'), $this->input->post('mysql_password'));
  
  if (
$db_conn->connect_errno)
  
{
   
return false;
  
}
  
else
  
{
   
return true;
  

I’m retreving the result in another function which is supposed to handle the different views. But when the connection fails, due to wrong credentials, I get PHP errors popping up in the view.

Messagemysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'blabla'@'blabla' (using passwordYES

How do I avoid that, and handle them myself?

And I’m looking for a non specific server solution, as I’ll be running this on various servers over which I have no control. So I’m not looking for error_reporting reconfigurations.

 
Posted: 13 October 2012 04:17 PM   [ Ignore ]   [ # 1 ]   [ Rating: 0 ]
Joined: 2011-06-24
101 posts

I tried with a try / catch routine. But it still gave med PHP errors in the views. So I ended up adding a @ before new mysqli ... but it stills seems like a hack of sorts.