where.class.php

Go to the documentation of this file.

<?php
class db_where extends object implements Countable {

        protected $clauses;

        protected function afterInit() {
                if (is_array($this->cfg->clauses))
                        $this->clauses = $this->cfg->clauses;
                else
                        $this->clauses = array($this->cfg->clauses);
        }

        public function getDb() {
                return $this->cfg->db;
        }

        public function clear() {
                $this->clauses = array();
        }

        public function getClauses() {
                return $this->clauses;
        }

        public function setClauses(array $clauses) {
                $this->clauses = $clauses;
        }

        public function add($prm) {
                if (is_array($prm) && !config::initTab($prm, array(
                                'field'=>null,
                                'op'=>'=',
                                'val'=>null
                        )))
                        return;
                $this->clauses[] = $prm;
        }

        public function toArray() {
                $bind = array();
                $where = array();

                foreach($this->clauses as $c) {
                        if ($c instanceof db_where) {
                                $tmp = $c->toArray();
                                $where[] = $tmp['where'];
                                $bind = array_merge($bind, $tmp['bind']);
                        } else if ($c instanceof db_whereClause) {
                                $where[] = ''.$c;
                        } else if (is_array($c)) {
                                $where[] = $this->getDb()->quoteIdentifier($c['field']).' '.$c['op'].' ?';
                                $bind[] = is_array($c['val']) ? '('.implode(',', $c['val']).')' : $this->getDb()->quoteValue($c['val']);
                        } else {
                                // Should be a raw string
                                $where[] = $c;
                        }
                }

                return array(
                        'bind'=>$bind,
                        'where'=>'('.implode(') '.$this->cfg->op.' (', $where).')',
                );
        }

        public function count() {
                return count($this->clauses);
        }

        public function toString() {
                $prm = $this->toArray();

                $tmp = explode('?', $prm['where'], count($prm['bind'])+1);
                array_splice($prm['bind'], count($tmp));

                $where = '';
                while($tmp2 = array_shift($tmp)) {
                        $where.= $tmp2.array_shift($prm['bind']);
                }
                return $where;
        }

        public function __toString() {
                return $this->toString();
        }

}