Banking integration

Question

Good afternoon! I need guidance/suggestion. Here’s the thing: we have a clock software where it records all the markings in a MS Access database. I need to create a report of each employee on the company’s intranet, where it is in PHP and Mysql using Codeigniter framework. I wonder if the ideal would be to synchronize the MS Access database with Mysql and if this is possible. I need to query the data in MS Access and also record some information in it. I tried to create a new connection within the codeigniter itself with Access, but I did not succeed. If anyone can guide me please.

Answer 1

Yes it is possible to integrate Access in PHP through PDO, just a connectionString correct. But you can also use CI. See this answer to have a basis of how to configure the connection inside it.

Other threads below can help you too

• https://stackoverflow.com/questions/178860/how-do-i-add-an-msaccess-connection-to-codeigniter-or-cakephp
• https://forum.codeigniter.com/thread-429.html

But if the intranet is in Mysql, I think it would be more feasible to use it instead of Oledb, and it’s much more robust as well. The other option is also to create a job to upload to Mysql, but in this case you would need to make the connection open and create another script that would send this.

Anyway the two ways are valid, but it would be more advantageous to have everything in a single database.