| public get ( string $Table = '', string $OrderFields = '', string $OrderDirection = 'asc', integer $Limit = false, integer $PageNumber = false ) : Gdn_DataSet | ||
| $Table | string | The table from which to select data. Adds to the $this->_Froms collection. |
| $OrderFields | string | A string of fields to be ordered. |
| $OrderDirection | string | The direction of the sort. |
| $Limit | integer | Adds a limit to the query. |
| $PageNumber | integer | The page of data to retrieve. |
| return | Gdn_DataSet | |
public function get($Table = '', $OrderFields = '', $OrderDirection = 'asc', $Limit = false, $PageNumber = false)
{
if ($Table != '') {
//$this->MapAliases($Table);
$this->from($Table);
}
if ($OrderFields != '') {
$this->orderBy($OrderFields, $OrderDirection);
}
if ($Limit !== false) {
if ($PageNumber == false || $PageNumber < 1) {
$PageNumber = 1;
}
$Offset = ($PageNumber - 1) * $Limit;
$this->limit($Limit, $Offset);
}
$Result = $this->query($this->getSelect());
return $Result;
}