/** * Proxies this request to @see $db */ function escape($s, $isIndent = false) { return $this->db->escape($s, $isIndent); }
protected function _getSqlWithArrayConditions($sql, $conditions) { $i = 0; foreach ($conditions as $k => $v) { $sql .= $i == 0 ? " WHERE" : " AND"; if (is_array($v)) { $sql .= sprintf(" %s IN (%s)", $this->_db->escape($k, true), $this->_escapeJoinArray($v)); } elseif (is_null($v)) { $sql .= sprintf(" %s IS NULL", $this->_db->escape($k, true)); } else { $sql .= sprintf(" %s=%s", $this->_db->escape($k, true), $this->_db->escape($v)); } $i++; } return $sql; }
protected function _getSqlWithArrayConditions($sql, $conditions) { $i = 0; foreach ($conditions as $k => $v) { $sql .= $i == 0 ? " WHERE" : " AND"; if (is_array($v)) { $sql .= sprintf(" %s IN (%s)", $this->_db->escape($k, true), $this->_escapeJoinArray($v)); } elseif (is_null($v)) { $sql .= sprintf(" %s IS NULL", $this->_db->escape($k, true)); } elseif ($v && substr($v, 0, 2) == '<=') { $v = substr($v, 2); $sql .= sprintf(" %s<=%s", $this->_db->escape($k, true), $this->_db->escape($v)); } elseif ($v && substr($v, 0, 2) == '>=') { $v = substr($v, 2); $sql .= sprintf(" %s>=%s", $this->_db->escape($k, true), $this->_db->escape($v)); } elseif ($v && substr($v, 0, 2) == '<>') { $v = substr($v, 2); $sql .= sprintf(" %s<>%s", $this->_db->escape($k, true), $this->_db->escape($v)); } elseif ($v && $v[0] == '<') { $v = substr($v, 1); $sql .= sprintf(" %s<%s", $this->_db->escape($k, true), $this->_db->escape($v)); } elseif ($v && $v[0] == '>') { $v = substr($v, 1); $sql .= sprintf(" %s>%s", $this->_db->escape($k, true), $this->_db->escape($v)); } else { $sql .= sprintf(" %s=%s", $this->_db->escape($k, true), $this->_db->escape($v)); } $i++; } return $sql; }