
Connecting backend CodeIgniter to two databases after receiving an API call
by bernt & torsten
The use case I got was to connect to a 2nd Db, to retrieve data from a 2nd database and respond with a JSON string, the request would come in as an API call that looks like this “localhost/api/1/noonreport?API-KEY=oBThDgLsHOi8WJpwgf6IvJVQQ45E9LTudUN9i1RL”
I’m using CodeIgniter in the backend server, with MVC and RESTful API support.
The first thing I did was to change the file database.php to add an additional database group to the configuration, like this

As you can see I added a 2nd database group and called it noon, the default group will be loaded automatically during $this->db call.
Then I created a new API function for noonreport as shown here

As you can see I connected to the 2nd database, I fetch the data I needed from the 2nd database – closed the 2nd database connection and created a JSON response, that is all.
If you need help or would like to ask a question, please comment.

Navigating the Procrastination Pitfalls of the AI Tool Explosion
Maintaining focus and productivity is crucial in an era defined by a constant influx of AI...

The Impact of Living Abroad on Pension Eligibility and Income
Understanding how pension systems interact becomes crucial when people work across multiple...

Tech Disillusionment
For four decades, I have worked in the tech industry. I started in the 1980s when computing...