PHP B2DBCriteria::getSQL Examples

Example #1

File: B2DBResultset.class.php Project: ronaldbroens/thebuggenie

 public function printSQL()
 {
     $str = '';
     if ($this->crit instanceof B2DBCriteria) {
         $str .= $this->crit->getSQL();
         foreach ($this->crit->getValues() as $val) {
             if (!is_int($val)) {
                 $val = '\'' . $val . '\'';
             }
             $str = substr_replace($str, $val, strpos($str, '?'), 1);
         }
     }
     return $str;
 }

Example #2

File: B2DBStatement.class.php Project: ronaldbroens/thebuggenie

 public function printSQL()
 {
     $str = '';
     if ($this->getCriteria() instanceof B2DBCriteria) {
         $str .= $this->crit->getSQL();
         foreach ($this->crit->getValues() as $val) {
             if (is_object($val)) {
                 throw new B2DBException('waat');
             }
             if (is_int($val)) {
                 $val = $val;
             } elseif (is_null($val)) {
                 $val = 'null';
             } else {
                 $val = '\'' . $val . '\'';
             }
             $str = substr_replace($str, $val, strpos($str, '?'), 1);
         }
     }
     return $str;
 }