Exemple #1
0
 public function getSQL($key, $value, $parent_key, IPrepareValues $PrepareValues = NULL)
 {
     if (is_array($value)) {
         trigger_error('Value should not be array, wrong filter', E_USER_NOTICE);
         return false;
     }
     if (!empty($PrepareValues)) {
         $value = $PrepareValues->getPreparedValue($parent_key, $value);
     }
     $parent_key = '`' . addslashes($parent_key) . '`';
     return $this->getExpression($parent_key, $value);
 }
Exemple #2
0
 public function getSQL($key, $value, $parent_key, IPrepareValues $PrepareValues = NULL)
 {
     if (!is_array($value)) {
         trigger_error('Wrong filter syntax', E_USER_NOTICE);
         return false;
     }
     $value = array_values($value);
     if (!empty($PrepareValues)) {
         $value = $PrepareValues->getPreparedValue($parent_key, $value);
     } else {
         foreach ($value as $k => $v) {
             if (!is_numeric($v)) {
                 $value[$k] = "'{$v}'";
             }
         }
     }
     $parent_key = '`' . addslashes($parent_key) . '`';
     return $this->getExpression($parent_key, $value);
 }
Exemple #3
0
 public function getSQL($key, $value, $parent_key, IPrepareValues $PrepareValues = NULL)
 {
     if (!is_array($value)) {
         if (!empty($PrepareValues)) {
             $prepared_value = $PrepareValues->getPreparedValue($key, $value);
             if ($prepared_value === false) {
                 return $value;
             }
             $value = $prepared_value;
         } elseif (!is_numeric($value)) {
             $value = "'{$value}'";
         }
         return '`' . addslashes($key) . '` = ' . $value;
     }
     if (count($value) > 1) {
         if ($key !== $this->key) {
             return false;
         } else {
             return '(' . implode(' AND ', $value) . ')';
         }
     } else {
         return current($value);
     }
 }