Welcome Guest, Not a member yet? Register   Sign In
What is the right way to use PDO directly in CodeIgniter 3?

I prefer to use PDO rather than codeigniter provided db class. i want to execute fetchAll(), prepare() statements which is not supported in db class provided by codeigniter

If i want to use PDO directly , should i place $db = new PDO($dsn,$username,$password); in every model class ? .

Is that bad ? What is the right way?

i am a newbie .

(This post was last modified: 09-27-2017, 08:18 AM by skunkbad.)

Extend PDO in a library. Load or autoload the library and make your connection in the constructor using custom configuration. You can see examples of this all over the internet. Since you're a newbie, this is a good way to learn how to use libraries with CodeIgniter. The problem would be that some other CodeIgniter libraries (or at least 1) depend on the CodeIgniter database connection. Sessions do if you use the database sessions.

Theme © iAndrew 2016 - Forum software by © MyBB