function selectAll($from, $to) { //$asc = $asc ? 'ASC' : 'DESC'; $STH = Model::getDBHandler()->prepare("SELECT * FROM image LIMIT {$from},{$to}"); $STH->execute(); $STH->setFetchMode(PDO::FETCH_ASSOC); return Model::fetchAndGetObj($STH); }
function selectAll($from, $to, $type, $asc) { $asc = $asc ? 'ASC' : 'DESC'; $STH = Model::getDBHandler()->prepare("SELECT tbl_image.* FROM tbl_image ORDER BY {$type} {$asc} LIMIT {$from},{$to}"); $STH->execute(); $STH->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'tbl_image'); return Model::fetchAndGetObj($STH); }