示例#1
0
 /**
  * Load rows from a DB table (limited and sorted by method parameters)
  *
  * @param $table db table to use
  * @param string $start start record for limit
  * @param string $limit number of records requested (limit)
  * @param string $orderColumn column to order rows by
  * @param string $order order type
  * @return object db rows
  */
 function loadMany($table, $start = '', $limit = '', $orderColumn = '', $order = 'ASC')
 {
     global $_dibi;
     return $_dibi->fetchAll("SELECT *\n                                 FROM `" . CLE_Ibdi::getNameOfTable($table) . "`\n                                 %if ", $orderColumn, "\n                                    ORDER BY `" . $orderColumn . "` " . $order . "\n                                 %end\n                                 %if", $limit, "LIMIT " . (int) $start . ',' . (int) $limit);
 }