• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
What is the right way to use PDO directly in CodeIgniter 3?

#1
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 .
Reply

#2
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.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.