PHP DbSimple_Generic_Database::selectPage 예제들

예제 #1

파일: Image.mapper.class.php 프로젝트: webnitros/ls-plugin_lsgallery

 public function GetImagesByUserMarked($sUserId, &$iCount, $iCurrPage, $iPerPage)
 {
     $sql = "\n                SELECT\n                    image_id\n                FROM\n                    " . Config::Get('db.table.lsgallery.image_user') . "\n                WHERE\n                        target_user_id = ?d\n                AND\n                        status = 'confirmed'\n                LIMIT ?d, ?d ";
     $aImages = array();
     if ($aRows = $this->oDb->selectPage($iCount, $sql, $sUserId, ($iCurrPage - 1) * $iPerPage, $iPerPage)) {
         foreach ($aRows as $aRow) {
             $aImages[] = $aRow['image_id'];
         }
     }
     return $aImages;
 }