Simple PHP Database PDO Wrapper
Default Columns on All Tables
The following columns are included on all tables.
id
INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
updated
TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
created
INT(10) UNSIGNED NOT NULL DEFAULT 0,
// This method may be defined and included prior to including db.php // All rows returned will be passed to this method first for any altering/transformations function db_decode_rows($rows) { foreach ($rows AS $k => $v) { $rows[$k]->created = date('Y-m-d H:i:s', $v->created); } return $rows; }
// This method will be called first for any db_save() call. This allows for // encoding or setting any default properties. function db_encode_object($obj) { if ( isset($obj->created) && empty($obj->created) ) { $obj->created = time(); } return $obj; }