zocke.es Suchergebnisse für
prepare("SELECT g.id, g.title, g.description, g.plays, g.thumbnail, c.name FROM `games` g
LEFT JOIN `categories` c on c.id=g.category
WHERE g.title LIKE :search OR g.description LIKE :search
ORDER BY (CASE WHEN g.title LIKE :search THEN 1 ELSE 0 END) DESC LIMIT 30");
if ($statement->execute(array(':search' => "%" . $q . "%"))) {
$AnzGames = $statement->rowCount();
while ($games = $statement->fetch()) {
$num = 0;
$gezeigteGames = 0;
$gameurl = cleanGameURL($games['title']);
$games['description'] = stripslashes($games['description']);
if (strlen($games['description']) > 145) {
$games['description'] = substr($games['description'], 0, 145) . "...";
} else {
$games['description'] = $games['description'];
}
$num++;
$gezeigteGames++;
if (substr($games['thumbnail'], 0, 4) != "http") {$games['thumbnail'] = $siteurl . $games['thumbnail'];}
echo ' ';
}
if ($gezeigteGames == $AnzGames && $num != 2) {echo '
';}
if ($num == 2) {
echo '
'; $num = 0;} if ($gezeigteGames != $AnzGames && $num != 2) {echo "
";}
}
} else {
$AnzGames = 0;
echo "SQL Error ';
$row['title'] = str_replace("&", "&", $row['title']);
if ($seo == 'yes') {
echo '' . cleanGameCatName($games['title']) . '
';
} elseif ($seo == 'no') {
echo '' . cleanGameCatName($games['title']) . ' ' . $num . '
' . $games['description'] . '
' . $games['description'] . '
'; $num = 0;} if ($gezeigteGames != $AnzGames && $num != 2) {echo "
"; echo $statement->queryString . "
"; echo $statement->errorInfo()[2]; } } if ($AnzGames == 0) { echo "
Leider habe ich zu deinem Suchwort/deiner Suchphrase ($q) nichts gefunden!
"; $zwischenDIV = ''; //echo "'; } echo '