How to connect with oracle database in codeigniter?

@orpha 

To connect to an Oracle database in CodeIgniter, you will need to follow these steps:

1. Install the latest version of CodeIgniter on your server.
2. Download the Oracle driver from the CodeIgniter's GitHub repository, as it is not included in the standard CodeIgniter installation.
3. Extract the downloaded driver and place it in the application/libraries folder of your CodeIgniter installation.
4. Open the application/config/database.php file and configure your database settings for Oracle. You will need to set the dbdriver to oci8 and provide the necessary connection details such as hostname, username, password, and database name.
5. Load the Oracle database library in your controller or model file using the following code:

1

$this->load->database('oracle', TRUE);

1. Once the database is loaded, you can use CodeIgniter's database functions to execute queries and interact with your Oracle database. For example:

1
2

$query = $this->db->query('SELECT * FROM your_table');
$result = $query->result();

1. Remember to close the database connection once you are done with your queries using the following code:

1

$this->db->close();

By following these steps, you should be able to connect to an Oracle database in CodeIgniter and start working with your data.