$filters = "SELECT
filter_borvidek AS borvidek,
filter_pince AS pince
FROM users
WHERE username = '$username'";
$filters_query = mysql_query($filters) or die(mysql_error());
$filter = mysql_fetch_array($filters_query);
function array_gen($name) {
global $filter;
$e = explode(', ', $filter[$name]);
$v = trim($filter[$name]);
if (empty($v)) {
unset($e[0]);
} else {
$e = array_fill_keys($e, $name);
}
return $e;
}
$results = array_merge(array_gen('borvidek'), array_gen('pince'));
$sql = "SELECT * FROM borutak";
if (count($results) >= 1) {
$sql .= ' WHERE ';
$sql .= implode(' OR ', array_map(function ($k, $v) { return $k . ' LIKE ' . '\'%' . $v . '%\''; }, $results, array_keys($results)));
}
$sql .= ';';
echo $sql . '<br />';
die();