PHP Criteria::getValues Examples

Example #1

File: Resultset.php Project: thebuggenie/b2db

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

Example #2

File: Statement.class.php Project: oparoz/thebuggenie

 public function printSQL()
 {
     $str = '';
     if ($this->getCriteria() instanceof Criteria) {
         $str .= $this->crit->getSQL();
         foreach ($this->crit->getValues() as $val) {
             if (is_int($val)) {
                 $val = $val;
             } elseif (is_null($val)) {
                 $val = 'null';
             } else {
                 $val = '\'' . $val . '\'';
             }
             $str = substr_replace($str, $val, mb_strpos($str, '?'), 1);
         }
     } else {
         $str = $this->custom_sql;
     }
     return $str;
 }