Database wrapper for PDO with proper error handling

[Azsen]

Has anyone seen a decent database class for nicely wrapping up all the PDO functions? Ideally I'm after an example to handle database errors properly, insert/update/select queries, prepared statements and transactions. I've had a crack at writing my own and it's a bit messy with error handling everywhere. Maybe I need to put that in a separate class or something.

 

E.g. here's how I'd do a database update:

$db = new Database();	   // In page controller
$params['type'] = $type;
$params['details'] = $details;
$query = 'insert into site_logs (type, details) values (:type, :details)';
$result = $db->preparedUpdate($query, $params);   // returns false if error or # of rows if successful

 

Just some examples would be great and I'll re-factor my one to make it better. Thanks!

[ManiacDan]

PEAR DB or ADODB.

[Doug G]

You could look at ModX CMS code, it's a PDO based system.  Maybe their code could give you some ideas.