We are looking at using some code that abstracts the database so you will be able to use any db that you choose (provided it's supported by the abstraction code!). Before I dive into it too far, I'd just like to gauge how easy it is for everyone to install this stuff. While I would like to just include the code with our files, that would put an unnecessarily large burden on us to maintain it. Therefore, I will paste some rough directions below and see how well it goes. Feel free to PM me with comments/suggestions, since you will be unable to reply to this post.
The abstraction we are using is part of the [url=http://pear.php.net/]PEAR[/url] (PHP Extension and Application Repository) set of code. Specifically, I am looking at [url=http://pear.php.net/manual/en/package.database.mdb2.php]MDB2[/url].
PEAR INSTALLATION INSTRUCTIONS:
Windows:
If you have XAMPP installed, I'm informed PEAR may already be installed. Otherwise, follow the directions on PEAR's site: [url=http://pear.php.net/manual/en/installation.getting.php]Getting the manager[/url]. This will install the pear manager, which will allow you to install the required MDB2 files.
Continue on after the linux section for MDB2 installation.
Linux
If you are using a debian system, you should be able to "apt-get install php-pear" to get the manager.
MDB2 INSTALLATION INSTRUCTIONS
Type "pear install MDB2 MDB2_driver_mysql" into your command line. If pear is not in your path, you will have to switch to that directory to run this command. You can replace "MDB2_driver_mysql" with any supported DB listed on [url=http://pear.php.net/manual/en/package.database.mdb2.intro-dsn.php]this page[/url]. You may have to use "pear install --nodeps MDB2_Driver_mysqli" if it complains about the php extension not being installed (but do it only if you are sure it is). You may also have to call "pear channel-update pear.php.net" if it tells you to do so.
From there on you should be good. If you would like, I can build a test file that you can use to verify your install. But generally, I just want to see how easy this is for everyone to install. Let me know your results/suggestions!
|