I’m building an extremely basic Guestbook app, for kicks, and wondered if someone would be kind enough to post or link me to a solid Database PHP Class.
I’m hoping it would allow for the usual CRUD operations, so ultimately in a script I could run something like:
$this->mysql_insert('news',$data);
And this would insert my data into the table.
Or perhaps
$this->mysql_select('news');
would retrieve records.
Any escaping functions in the class would be a bonus
Alternatively, look for the PDO abstraction class on the phpclasses site, they have a neat class on there. I cant login at the moment (away from home and cant remember my goddam password). But search for that, its the one I use alot, veruy flexible and handy.
Having used CI and looking at your request it seems their version of ActiveRecord is what you want, else for simple single table CRUD support look up that ActiveRecord pattern.
I think I remember seeing someone posting something like that which was PDO-based, but am unable to find it.