Code: Select all
function country($woord1, $woord2) {
echo "Zoeken naar" .$woord1. " en ".$woord2;
$link = mysql_connect("localhost", "root", "");
if (!mysql_select_db("Project1", $link))
echo "Er is een probleem met de databankconnectie!";
$country = mysql_query("SELECT * FROM Countries;");
while ($row = mysql_fetch_assoc($country)) {
foreach ($row as $col) {
if($col == $woord1 || $col == $woord2){
$Resultaat = X;
echo "<table width='90%' border='0' cellpadding='0' cellspacing='2'>";
echo "<tr>";
echo "<td class='header' width='16%'>Naam:</td>";
echo "<td class='header' width='12%'>Populatie:</td>";
echo "<td class='header' width='20%'>Leider:</td>";
echo "<td class='header' width='20%'>Hoofdstad:</td>";
echo "<td class='header' width='8%'>Aantal Kranten:</td>";
echo "<td class='header' width='8%'>Opp. (km²):</td>";
echo "<td class='header' width='26%'>Taal:</td>";
echo "</tr>";
echo "<tr>";
echo "<td class='content'>".$rowї"naam"]."</td>";
echo "<td class='content'>".$rowї"populatie"]."</td>";
echo "<td class='content'>".$rowї"leider"]."</td>";
echo "<td class='content'>".$rowї"hoofdstad"]."</td>";
echo "<td class='content'>".$rowї"kranten"]."</td>";
echo "<td class='content'>".$rowї"oppervlakte"]."</td>";
echo "<td class='content'>".$rowї"taal"]."</td>";
echo "</tr>";
echo "</table>";
}
}
}
if (!($Resultaat)){
echo "<br><b>".$woord1."</b> werd niet in de databank gevonden!";
}
mysql_close($link);
}