Thursday, March 3, 2011

MySQL's Prepared Statements made really easy with PHP

I've been programming a bit with php for first time, realizing that it is true what my friends told me: it is really close to C/C++.
I managed to have an abstract class to handle and execute SQL's prepared statements, and a bit more that I want to share with world.
But first, just an example of how I made prepared statements really easy to handle with only inheriting from my MySQLDatabase class! Specially if you program a singleton class for your database connection and let __construct and __destruct do its magic!

You can really inherit from this class and see how easy is implementing prepared statements in your php project!

Example of usage

And now... the code itself!

Code for MySQLDatabase class

I hope someone find it usefull!