1: <?php
2: namespace codemania\library\database;
3: 4: 5: 6: 7: 8: 9: 10: 11: 12:
13: defined('CM_ROOT') or exit('Заперт доступа!');
14:
15: class QueryBuilder {
16: private $_query;
17: public function select($table, $p = '*') {
18: if (is_array($p)) {
19: foreach ($p as $val) {
20: $arr[] = '`'. $val .'`';
21: }
22: $p = implode(',', $arr);
23: }
24: $this->_query .= 'SELECT ('. (string)$p .')FROM `'. (string)$table .'` ';
25: return $this;
26: }
27: public function where($key, $value) {
28: $this->_query .= 'WHERE `'. (string)$key .'` = \''. (string)$value .'\' ';
29: return $this;
30: }
31: public function limit($limit) {
32: $this->_query .= 'LIMIT '. $limit .'';
33: return $this;
34: }
35: }