mambax7 /
bookshop
| @@ 383-390 (lines=8) @@ | ||
| 380 | global $myts; |
|
| 381 | $ret = array(); |
|
| 382 | $sql = 'SELECT book_id, book_title FROM ' . $this->table; |
|
| 383 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 384 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 385 | if ($criteria->getSort() != '') { |
|
| 386 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 387 | } |
|
| 388 | $limit = $criteria->getLimit(); |
|
| 389 | $start = $criteria->getStart(); |
|
| 390 | } |
|
| 391 | $result = $this->db->query($sql, $limit, $start); |
|
| 392 | if (!$result) { |
|
| 393 | return $ret; |
|
| @@ 152-159 (lines=8) @@ | ||
| 149 | $ret = array(); |
|
| 150 | $limit = $start = 0; |
|
| 151 | $sql = 'SELECT * FROM ' . $this->table; |
|
| 152 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 153 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 154 | if ($criteria->getSort() != '') { |
|
| 155 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 156 | } |
|
| 157 | $limit = $criteria->getLimit(); |
|
| 158 | $start = $criteria->getStart(); |
|
| 159 | } |
|
| 160 | $result = $this->db->query($sql, $limit, $start); |
|
| 161 | if (!$result) { |
|
| 162 | return $ret; |
|
| @@ 262-269 (lines=8) @@ | ||
| 259 | $sql .= ', ' . $this->identifierName; |
|
| 260 | } |
|
| 261 | $sql .= ' FROM ' . $this->table; |
|
| 262 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 263 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 264 | if ($criteria->getSort() != '') { |
|
| 265 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 266 | } |
|
| 267 | $limit = $criteria->getLimit(); |
|
| 268 | $start = $criteria->getStart(); |
|
| 269 | } |
|
| 270 | $result = $this->db->query($sql, $limit, $start); |
|
| 271 | if (!$result) { |
|
| 272 | return $ret; |
|
