Code:
<?PHP $conn = mysql_connect($db_server, $db_user, $db_passwd); $db = mysql_select_db($db_database); $ledition = $_REQUEST['ledition']; $edition = $_REQUEST['edition']; $name = $_REQUEST['name']; $seltenheit = $_REQUEST['seltenheit']; $element = $_REQUEST['element']; $schwaeche = $_REQUEST['schwaeche']; $resistenz = $_REQUEST['resistenz']; $kpvon = $_REQUEST['kpvon']; $kpbis = $_REQUEST['kpbis']; $verknuepfung = $_REQUEST['verknuepfung']; $bild = $_REQUEST['bild']; if (! $kpvon) { $kpvon = 0; } if (! $kpbis) { $kpbis = 250; } if ($ledition) { $query = "SELECT * FROM `karten` WHERE `Edition` = \"$ledition\" ORDER BY `Nummer`;"; } else { $query = "SELECT * FROM `karten` WHERE "; $query .= "(`KP` BETWEEN $kpvon AND $kpbis) "; if ($name) { $query .= "$verknuepfung `Name` LIKE \"$name\" "; } if ($edition != "egal") { $query .= "$verknuepfung `Edition` = \"$edition\" "; } if ($seltenheit != "egal") { $query .= "$verknuepfung `Seltenheit` = \"$seltenheit\" "; } if ($element != "egal") { $query .= "$verknuepfung `Element` = \"$element\" "; } if ($schwaeche != "egal") { $query .= "$verknuepfung `Schwäche` = \"$schwaeche\" "; } if ($resistenz != "egal") { $query .= "$verknuepfung `Resistenz` = \"$resistenz\" "; } if ($bild) { $query .= "$verknuepfung `Bild` IS NOT NULL "; } $query .= "ORDER BY `Nummer`;"; } echo " $query</p>"; if ($res = mysql_query($query)) { while ($karte = mysql_fetch_assoc($res)) { echo " <img src=\"el_" . $karte['Element'] . ".gif\" alt=\"" . $karte['Element'] . "\"> " . $karte['Name'] . " "; echo $karte['Edition'] . ", Nr." . $karte['Nummer'] . ", " . $karte['Seltenheit'] . " "; echo $karte['KP'] . " KP "; echo "Schwäche: " . "<img src=\"el_" . $karte['Schwäche'] . ".gif\" alt=\"" . $karte['Schwäche'] . "\"> "; echo "Resistenz: " . "<img src=\"el_" . $karte['Resistenz'] . ".gif\" alt=\"" . $karte['Resistenz'] ."\">"; if ($bild) { echo " Es ist ein <a href=\"" . $karte['Bild'] . "\" target=\"_blank\">Bild</a> vorhanden.</p>"; } else { echo "</p>"; } } } else { echo " Beim Abfragen der Datenbank trat ein Fehler auf.</p>"; } mysql_close($conn); ?>
Einen Kommentar schreiben: