Overview

Namespaces

  • codemania
    • core
      • exception
    • library
      • database
        • drivers
  • None
  • PHP

Classes

  • DataBase
  • QueryBuilder

Exceptions

  • DataBaseException
  • Overview
  • Namespace
  • Class
  • Tree
  • Deprecated
  • Todo
  • Download
 1: <?php
 2: namespace codemania\library\database;
 3: /**
 4:  * CodeMania Framework
 5:  * 
 6:  * @author CodeMania Team <team@codemania.ru>
 7:  * @license http://codemania.ru/license.html
 8:  * @package CodeMania
 9:  * @version 1.0.0
10:  * @copyright (c) 2012, CodeMania Team
11:  * @link  http://codemania.ru/
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: }
CodeMania Framework API documentation generated by ApiGen 2.8.0