";
}
//Declaraties
$file=$_GET["file"];
$zoekterm=$_GET["woord"];
//Database login
$serv = "localhost";
$user = "janson21_schalken";
$pass = "bruggendorp";
$db = "janson21_schalkenfiles";
//Create connection
$conn = new mysqli($serv, $user, $pass, $db);
mysqli_set_charset($conn,"utf8");
//Check connection
if ($conn->connect_error) {
die("Connectie mislukt: " . $conn->connect_error);
}
//Query
$sql="SELECT d.id, d.titel, d.filenaam, w.woord FROM `woorden` AS w INNER JOIN `data` AS d ON w.koppeling = d.id WHERE d.filenaam = \"$file\" GROUP BY d.filenaam";
$result=mysqli_query($conn,$sql);
while($resultaat=mysqli_fetch_array($result,MYSQLI_BOTH)){
echo "
Gezocht op ".$zoekterm.": gevonden in \"";
echo $resultaat["titel"]."\".
";
echo "![](\"https://www.oudstompwijk.nl/afbeeldingen_schalken/";)
";
}
$extended=$file." ; ".$zoekterm;
schrijfWeg($extended,"Schalken");
$conn->close();
?>
