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); }
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); }
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); } }