CODEWITHSUNDEEP
phpmysqloracle-databasecodeigniter
NDBoost
NDBoost

Reputation: 10634

Codeigniter 2.1, php 5.3, Oracle & MySQL

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.

Upvotes: 0

Views: 1154

Answers (2)

Oliver
Oliver

Reputation: 31

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)

Upvotes: 3

Colin Brock
Colin Brock

Reputation: 21565

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";

Upvotes: 1

Related Questions