Example #1
0
 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);
 }
Example #2
0
 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);
 }