include "config.php";
//zoekmachine
if ($_POST['naamvantekstveld']) {
$naamvantekstveld=$_POST['naamvantekstveld'];
// querys, hier plaats je dus je querys die in je tabellen zoeken
$query1="SELECT id, titel, auteur, email FROM `reviews` WHERE titel LIKE '%$naamvantekstveld%' ORDER BY titel ASC";
$query2="SELECT id, titel FROM `downloads` WHERE titel LIKE '%$naamvantekstveld%' ORDER BY titel ASC";
$query3="SELECT id, titel FROM `upcoming` WHERE titel LIKE '%$naamvantekstveld%' ORDER BY titel ASC";
$query4="SELECT id, titel FROM `stream` WHERE titel LIKE '%$naamvantekstveld%' ORDER BY titel ASC";
$query5="SELECT id, titel, datum FROM `s_news` WHERE titel LIKE '%$naamvantekstveld%' ORDER BY titel ASC";
$query6="SELECT titel FROM `imgcat` WHERE titel LIKE '%$naamvantekstveld%' ORDER BY titel ASC";
$query7="SELECT id, titel FROM `posters` WHERE titel LIKE '%$naamvantekstveld%' ORDER BY titel ASC";
// resultaten ophalen
$sql1 = mysql_query($query1) or die (mysql_error());
$aantal1=mysql_num_rows($sql1);
$sql2 = mysql_query($query2) or die (mysql_error());
$aantal2=mysql_num_rows($sql2);
$sql3 = mysql_query($query3) or die (mysql_error());
$aantal3=mysql_num_rows($sql3);
$sql4 = mysql_query($query4) or die (mysql_error());
$aantal4=mysql_num_rows($sql4);
$sql5 = mysql_query($query5) or die (mysql_error());
$aantal5=mysql_num_rows($sql5);
$sql6 = mysql_query($query6) or die (mysql_error());
$aantal6=mysql_num_rows($sql6);
$sql7 = mysql_query($query7) or die (mysql_error());
$aantal7=mysql_num_rows($sql7);
// aantal resultaten
$aantal = $aantal1 + $aantal2 + $aantal3 + $aantal4 + $aantal5 + $aantal6 + $aantal7;
if ($aantal1 == 0 AND $aantal2 == 0 AND $aantal3 == 0 AND $aantal4 == 0 AND $aantal5 == 0 AND $aantal6 == 0 AND $aantal7 == 0) {
echo "Er zijn geen resultaten gevonden";
} else {
echo "$aantal gevonden resultaten:
";
// hier resultaten
echo "$aantal1 gevonden reviews:
";
while ($obj1 = mysql_fetch_object($sql1)) {
echo "id\">$obj1->titel - email\">$obj1->auteur
";
}
echo "
";
echo "$aantal2 gevonden downloads:
";
while ($obj2 = mysql_fetch_object($sql2)) {
echo "id\">$obj2->titel
";
}
echo "
";
echo "$aantal3 gevonden (aankomende) releases:
";
while ($obj3 = mysql_fetch_object($sql3)) {
echo "id\">$obj3->titel
";
}
echo "
";
echo "$aantal4 gevonden streamfiles:
";
while ($obj4 = mysql_fetch_object($sql4)) {
echo "id\">$obj4->titel
";
}
echo "
";
echo "$aantal5 gevonden nieuwsberichten:
";
while ($obj5 = mysql_fetch_object($sql5)) {
echo "id\">$obj5->titel - $obj5->datum
";
}
echo "
";
echo "$aantal6 gevonden imagegalleries:
";
while ($obj6 = mysql_fetch_object($sql6)) {
echo "titel\">$obj6->titel
";
}
echo "
";
echo "$aantal7 gevonden filmposters:
";
while ($obj7 = mysql_fetch_object($sql7)) {
echo "id\">$obj7->titel
";
}
}
}
echo "