<? 


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 <B>geen</B> resultaten gevonden"; 
  } else { 
    echo "$aantal gevonden resultaten:<BR><BR>"; 
// hier resultaten 
echo "<b>$aantal1 gevonden reviews:</b><br>";

while ($obj1 = mysql_fetch_object($sql1)) { 
       
echo "<a href=\"review.php?id=$obj1->id\">$obj1->titel</a> - <a href=\"mailto:$obj1->email\">$obj1->auteur</a><br>"; 
      } 
  
        echo "<br>";
        echo "<b>$aantal2 gevonden downloads:</b><br>";

        while ($obj2 = mysql_fetch_object($sql2)) { 
        echo "<a href=\"download.php?id=$obj2->id\">$obj2->titel</a><br>";   
        } 
        echo "<br> ";
        echo "<b>$aantal3 gevonden (aankomende) releases:</b><br>";
     
        while ($obj3 = mysql_fetch_object($sql3)) { 
        echo "<a href=\"upcomingmovie.php?id=$obj3->id\">$obj3->titel</a><br>";   
        } 
        echo "<br> ";
        echo "<b>$aantal4 gevonden streamfiles:</b><br>";
     
        while ($obj4 = mysql_fetch_object($sql4)) { 
        echo "<a href=\"streamfile.php?id=$obj4->id\">$obj4->titel</a><br>";        
        } 
        echo "<br> ";
        echo "<b>$aantal5 gevonden nieuwsberichten:</b><br>";
     
        while ($obj5 = mysql_fetch_object($sql5)) { 
        echo "<a href=\"leesnieuws.php?id=$obj5->id\">$obj5->titel</a> - $obj5->datum<br>";        
        }
        echo "<br> ";
        echo "<b>$aantal6 gevonden imagegalleries:</b><br>";
     
        while ($obj6 = mysql_fetch_object($sql6)) { 
        echo "<a href=\"imglist.php?id=$obj6->titel\">$obj6->titel</a><br>";        
        }
        
        echo "<br> ";
        echo "<b>$aantal7 gevonden filmposters:</b><br>";
     
        while ($obj7 = mysql_fetch_object($sql7)) { 
        echo "<a href=\"imglist.php?id=$obj7->id\">$obj7->titel</a><br>";        
        }
}
 }
echo "<FORM ACTION=\"\" METHOD=\"post\">"; 
echo "<center>Zoeken naar:"; 
echo "<INPUT TYPE=\"text\" NAME=\"naamvantekstveld\"> - "; 
echo "<INPUT TYPE=\"submit\" NAME=\"Zoek\" VALUE=\"Zoek\"></center>"; 
echo "</FORM>"; 

//einde zoekmachine 

?>  