|
@@ -115,7 +115,7 @@ discard block |
|
|
block discarded – undo |
115
|
115
|
* Returns a single record for a select query for the chosen table
|
116
|
116
|
* @param string $table This should be the table you wish to select the values from
|
117
|
117
|
* @param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
118
|
|
- * @param string|array $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
|
|
118
|
+ * @param string $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
|
119
|
119
|
* @param array|string $order This is the order you wish the results to be ordered in should be formatted as follows array('fieldname' => 'ASC') or array("'fieldname', 'fieldname2'" => 'DESC')
|
120
|
120
|
* @param boolean $cache If the query should be cached or loaded from cache set to true else set to false
|
121
|
121
|
* @return array Returns a single table record as the standard array when running SQL queries
|
|
@@ -130,9 +130,9 @@ discard block |
|
|
block discarded – undo |
130
|
130
|
* @param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
131
|
131
|
* @param string|array $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
|
132
|
132
|
* @param array|string $order This is the order you wish the results to be ordered in should be formatted as follows array('fieldname' => 'ASC') or array("'fieldname', 'fieldname2'" => 'DESC')
|
133
|
|
- * @param integer|array $limit The number of results you want to return 0 is default and returns all results, else should be formated either as a standard integer or as an array as the start and end values e.g. array(0 => 150)
|
|
133
|
+ * @param integer $limit The number of results you want to return 0 is default and returns all results, else should be formated either as a standard integer or as an array as the start and end values e.g. array(0 => 150)
|
134
|
134
|
* @param boolean $cache If the query should be cached or loaded from cache set to true else set to false
|
135
|
|
- * @return array Returns a multidimensional array with the chosen fields from the table
|
|
135
|
+ * @return boolean Returns a multidimensional array with the chosen fields from the table
|
136
|
136
|
*/
|
137
|
137
|
public function selectAll($table, $where = array(), $fields = '*', $order = array(), $limit = 0, $cache = true){
|
138
|
138
|
$this->buildSelectQuery(SafeString::makeSafe($table), $where, $fields, $order, $limit);
|
|
@@ -367,7 +367,7 @@ discard block |
|
|
block discarded – undo |
367
|
367
|
* @param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
368
|
368
|
* @param string|array $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
|
369
|
369
|
* @param array $order This is the order you wish the results to be ordered in should be formatted as follows array('fieldname' => 'ASC') or array("'fieldname', 'fieldname2'" => 'DESC') so it can be done in both directions
|
370
|
|
- * @param integer|array $limit The number of results you want to return 0 is default and returns all results, else should be formated either as a standard integer or as an array as the start and end values e.g. array(0 => 150)
|
|
370
|
+ * @param integer $limit The number of results you want to return 0 is default and returns all results, else should be formated either as a standard integer or as an array as the start and end values e.g. array(0 => 150)
|
371
|
371
|
*/
|
372
|
372
|
protected function buildSelectQuery($table, $where = array(), $fields = '*', $order = array(), $limit = 0){
|
373
|
373
|
if(is_array($fields)){
|
|
@@ -475,7 +475,7 @@ discard block |
|
|
block discarded – undo |
475
|
475
|
|
476
|
476
|
/**
|
477
|
477
|
* Returns the limit SQL for the current query as a string
|
478
|
|
- * @param integer|array $limit This should either be set as an integer or should be set as an array with a start and end value
|
|
478
|
+ * @param integer $limit This should either be set as an integer or should be set as an array with a start and end value
|
479
|
479
|
* @return string|false Will return the LIMIT string for the current query if it is valid else returns false
|
480
|
480
|
*/
|
481
|
481
|
private function limit($limit = 0){
|