• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Testing database connections

#1
Hello, I'm still learning CodeIgniter so please forgive me if my question is ridiculous. In a previous version of CI, I would set the 'autoinit' variable in the database config file to false, and initialize my database in an if statement which would return true or false if the connection couldn't be made without throwing any warnings. If false I would load a page giving instructions on how to set the database config file. I'm not seeing a choice for autoinit in CI 3, so I assume I need to find another solution. Could anyone point me in the right direction? Thanks!
Reply

#2
It looks like they removed the option and it "autoinits" when it gets loaded. So don't autoload it in config/autoload.php, do your checks and then use $this->load->database(); to load it AND init it. http://www.codeigniter.com/userguide3/da...cting.html
Reply

#3
That makes sense. The following is working for me as far as I can tell. Anyone see any problems?
PHP Code:
    public function check_database()
    {
        
        
ini_set('display_errors''Off');
        
        
//  Load the database config file.
        
if(file_exists($file_path APPPATH.'config/database.php'))
        {
            include(
$file_path);
        }
        
        
$config $db[$active_group];
        
        
//  Check database connection if using mysqli driver
        
if( $config['dbdriver'] === 'mysqli' )
        {
            
$mysqli = new mysqli$config['hostname'] , $config['username'] , $config['password'] , $config['database'] );
            if( !
$mysqli->connect_error )
            {
                return 
true;
            }
            else{
                return 
false;
            }
        }
        else
        {
            return 
false;
        }
    } 
Reply

#4
Why not just use $this->load->database(), which does everything you are doing manually and more?

PHP Code:
$this->load->database(); //loads "default" group config from /config/database.php
//$this->db is now using the default database connection

$this->load->database('group_two'); //loads "group_two" group config from /config/database.php
//$this->db is now using the "group_two" database connection 
http://www.codeigniter.com/userguide3/da...cting.html
Reply

#5
Using $this->load->database(); will throw a error page if the connection failed or for example the config file does not exists. And this behavior can not be overwritten.

From @BenHeadrick first post, that is exactly what he wants to get away from.

(03-30-2015, 10:24 PM)BenHeadrick Wrote: ... without throwing any warnings. ...

As far as I know, CI does not have a function that only check if it can connect to the database or not, and return true/false.

For the solution though, I would close the connection before returning true/false. And then later when you need to actually use the DB, you connect with $this->load->database(); so you can use CIs query builder and more as usual.

Here is an updated example. I also removed all else statement as they are not needed.
PHP Code:
public function check_database()
{
 
   
    ini_set
('display_errors''Off');
 
   
    
//  Load the database config file.
 
   if(file_exists($file_path APPPATH.'config/database.php'))
 
   {
 
       include($file_path);
 
   }
 
   
    $config 
$db[$active_group];
 
   
    
//  Check database connection if using mysqli driver
 
   if$config['dbdriver'] === 'mysqli' )
 
   {
 
       $mysqli = new mysqli$config['hostname'] , $config['username'] , $config['password'] , $config['database'] );
 
       if( !$mysqli->connect_error )
 
       {
 
           $mysqli->close();
 
           return true;
 
       }
 
       
        $mysqli
->close();
 
   }
 
   
    return false
;

Reply

#6
Thanks for the tips guys. I tried to find a way to get $this->load->database(); to work but didn't have any luck. With display errors set to off and db_debug set to false, I was able to prevent the error page, but couldn't find a way to test the connection like I could with $mysqli->connect_error. Too bad. It would be more versatile and I could test the connection with other drivers if I could use a built in CI function.

Anyway, Silentium, I took your advice on closing the connection and good call on the else statements. I'm still learning. Thanks again guys!
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.