Revision history [back]

In CodeIgniter, you can test a database connection using the following method:

Step 1: Open the database configuration file located at application/config/database.php.

Step 2: Check the default database connection settings and update them if necessary. Make sure that the hostname, username, password, and database name are correct.

Step 3: Open a controller file for testing the database connection, or use an existing one.

Step 4: Create a function that will test the database connection using the following code:

public function test_db_connection() {
  $this->load->database();
  if ($this->db->conn_id) {
    echo "Database connected successfully!";
  }
  else {
    echo "Failed to connect to database!";
  }
}

This function loads the database library and checks if the connection is successful. If the connection is successful, it will display a message saying "Database connected successfully!" Otherwise, it will display a message saying "Failed to connect to database!".

Step 5: Call the test_db_connection function from a view file, or test it from a web browser. You should see a message indicating whether the database connection was successful or not.

That's it! You have successfully tested a database connection using CodeIgniter.