• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQLite problem

#11
[eluser]Unknown[/eluser]
You're close to getting sqlite3 to work with CI 1.7.1. I followed the steps like you'v done here. Here's my database.php settings that worked for me.
Code:
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "";
$db['default']['password'] = "";
$db['default']['database'] = "sqlite:blog.db3";
$db['default']['dbdriver'] = "pdo";

It's important to have "sqlite:" and the extension ".db3" to get this working. So far I haven't ran into any DB API issues yet so I'm excited to get going with some of my projects using sqlite3! You can even set a relative location to your db file outside your webroot location for a simple security solution.
Code:
$db['default']['database'] = "sqlite:../../blog.db3";


Messages In This Thread
SQLite problem - by El Forum - 08-22-2008, 05:09 AM
SQLite problem - by El Forum - 04-06-2009, 04:09 AM
SQLite problem - by El Forum - 04-06-2009, 05:55 AM
SQLite problem - by El Forum - 04-06-2009, 06:12 AM
SQLite problem - by El Forum - 04-06-2009, 06:40 AM
SQLite problem - by El Forum - 04-06-2009, 06:52 AM
SQLite problem - by El Forum - 04-06-2009, 07:12 AM
SQLite problem - by El Forum - 04-06-2009, 07:18 AM
SQLite problem - by El Forum - 04-06-2009, 07:36 AM
SQLite problem - by El Forum - 04-06-2009, 07:40 AM
SQLite problem - by El Forum - 04-06-2009, 11:46 AM
SQLite problem - by El Forum - 04-17-2009, 02:19 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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