I created LiteMySQL so I wouldn't have to rewrite a lot of MySQL code for all the small projects I develop. It's boring to write (or copy/paste) the same loops and such that walk over result resources and more.

News

25-May-2009:

Released LiteMySQL 1.1.2. See ChangeLog.txt file for a list of changes since v1.1.

21-May-2009:

LiteMySQL 1.1 has lots of small updates, and fixes to some SERIOUS bugs. If you're using LiteMySQL for anything, I highly recommend you update it. I now consider LiteMySQL robust enough so I'm using it in a real (but very small) project at work.

Check the ChangeLog.txt file for details.

Please report any issues you find on the Issues page. Thanks :)

16-Dec-2007:

LiteMySQL v1.0.2 fixes two bugs (one of which seriously annoying, the other just annoying), and adds the ability to load settings from an array directly, and not only from a php file with a $database_settings variable defined as an array with the settings in it.

On a funny note, I'd like to thank Analyzer X for pointing out the bugs to me. He called me from a bar two hours ago as he and some of his friends were getting drunk and theorizing about SQL, and using a pen modifying a printed copy of LiteMySQL which Analyzer X for some reason happened to have with him to a bar at 2am... lol

14-Dec-2007:

I found a small possible security issue with the 1.0 release in regard to how it handles conditions. I've fixed the issue and updated LiteMySQL to v1.0.1.

The issue was how conditions input as an array was handled. The condition value did not escape special characters. Bellow is an example of how this issue can become a BIG problem.

$sql->find_all(array('category' => $_GET['category']));

Of course using unfiltered data like that isn't the good way to do stuff. But LiteMySQL is supposed to let you not have to worry about filtering (most) stuff you feed it.

13-Dec-2007:

The initial release is now available for download. I'll update here as soon as I have time, for today at least I've only had time to finish and upload the script.

There's a bunch of code examples in the header comment in litemysql.lib.php which covers most uses of the class.

Example Code

Please see the Examples page.

Contact

If you have any problems, questions or suggestions please create a new issue, or feel free to drop me a mail: contact at jimeh dot me