foreach ($_REQUEST as $var => $val)
$$var = $val;
// This replicates register_globals in PHP 5.4+
foreach (array_merge($_GET, $_POST) as $key => $val) {
global $$key;
$$key = addslashes($val);
}
if (!$suchtext) {die ("
Leere Anfrage!
\n");}
if (!$suchfelder) {die ("
Keine Suchfelder!
\n");}
include("./dbopen.php");
//echo $suchtext;
//echo $suchfelder;
//echo "
";
//$sql="SELECT * FROM kutsch WHERE titel LIKE '%$suchtext%' ";
$anzeigefelder="$suchfelder , titel, untertitel, verfasser, erscheinun, jahrauflag, inventarnu";
$sql="SELECT $anzeigefelder FROM kutsch WHERE $suchfelder LIKE '%$suchtext%' ORDER BY $suchfelder ";
//echo $sql;
echo "
";
//echo "
";
$result=mysql_query($sql, $conn);
if ($result)
{
$number = mysql_num_rows($result);
if ($number==0){echo "Ihre Suche hat keine Treffer ergeben.";}
else {
echo "Ihre Suche hat $number Treffer ergeben.";
echo "
";
echo " ";
//echo "
";
$row = mysql_fetch_array($result, MYSQL_ASSOC);
while ($field = key($row)) {
echo " | $field | "; next($row);
}
echo " Details | ";
echo "
";
echo " |
";
echo implode(" | ",$row);
?>
|
echo " |
";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo " |
";
echo implode(" | ",$row);
?>
|
echo " |
";
}
echo " |
";
//echo " Abfrage: $sql";
}
} else {
echo "
".mysql_error($conn);
}
mysql_close($conn);
?>
Neue Suche
Schnuppertipps