Codeigniter 2.1, php 5.3, Oracle & MySQL

Question

I am developing a reporting web app for a client of mine. Their accounting software runs off of an oracle db.

While i know there is a possibility of creating a connection to oracle via codeigniter. Im not sure of how to go about it. Can someone provide a list of differences between connecting via mysql and oracle.. or even just an example.

The framework will use a mysql db to store app specific information (credentials, visitor statistics, email information, logs, etc). However all accounting information is pulled from the oracle server.

Doctrine works very well with Oracle. You can integrate Doctrine into Codeigniter rather easily. Make sure you install the pdo_oci php extension. — Flukey
– Flukey, Commented Mar 22, 2012 at 15:14

akjoshi · Accepted Answer · 2012-11-24 14:58:47Z

3

I had issues until I have put everything in UPPERCASE, also when doing sql queries in the Model, etc. put Table Names in uppercase! (I use Oracle XE)

edited Nov 24, 2012 at 14:58

akjoshi

15.8k13 gold badges108 silver badges122 bronze badges

answered Nov 24, 2012 at 14:39

Oliver

312 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Colin Brock · Accepted Answer · 2012-03-22 15:27:20Z

1

It might be more helpful to give it a shot yourself and then come back with any specific issues you run into, but here's a snippet of /config/database.php from a CodeIgniter app that connects to an Oracle database:

$db['default']['hostname'] = "[Database Name]";
$db['default']['username'] = "[User/Schema]";
$db['default']['password'] = "**********";
$db['default']['database'] = "";
$db['default']['dbdriver'] = "oci8";

answered Mar 22, 2012 at 15:27

Colin Brock

21.6k9 gold badges51 silver badges62 bronze badges

Collectives™ on Stack Overflow

Codeigniter 2.1, php 5.3, Oracle & MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related