protected function _castValue($value, $type) { switch ($type) { case TYPE_INT: case TYPE_PRIMARY: return (int) $value; break; case TYPE_FLOAT: return (double) $value; break; case TYPE_STRING: case TYPE_TEXT: case TYPE_DATE_TIME: case TYPE_DATE: case TYPE_TIME: return DatabaseSql::dbQuote($value); break; default: return DatabaseSql::dbQuote($value); break; } }
public function getAllContainsArray($values) { foreach ($values as $key => $value) { $sql .= $key . ' LIKE ' . DatabaseSql::dbQuote('%' . $value . '%'); if (++$count != count($values)) { $sql .= ' OR '; } } $sql = 'SELECT * FROM `' . $this->getTableName() . '` WHERE ' . $sql; if ($this->_orderBy) { $sql .= ' ORDER BY ' . $this->_orderBy; } $dbh = Database::getInstance(); $dbResult = $dbh->query($sql, PDO::FETCH_ASSOC); if (!$dbResult) { Debug::out($dbh->errorInfo()); } return $this->createObjs($dbResult); }