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