<?php
$gebruikersrol = array( "klant", "medewerker","administrator");
include('php_script/beveiliging.php');

if (isset ($_POST['zoek']))
    {
    $query2 = "select * from `faq` where `gebruikersrol` like '%".$_SESSION['gebruikersrol']."%' and `vraag` like '%".$_POST['zoeken']."%' ";

    $result = mysqli_query($db_connection,$query2);
    }
else
{
$query = "select * from `faq` where `gebruikersrol` like '%".$_SESSION['gebruikersrol']."%' ";

$result = mysqli_query($db_connection,$query);
}

echo"
    <div id='icon'>
        <a href='index.php?content=pagina/FAQen'><img src='img/enico.png' alt='English FAQ' /></a>
    </div>

    <h1>F.A.Q Nederlands</h1>
    <div id ='faq'>
    <form action='index.php?content=pagina/FAQ' method='post'>
        <table>
            <tr>
                <td><input type='text' value='Zoeken' name='zoeken'/></td>
                <td><input type='submit' name='zoek' value='Zoek' /></td>
            </tr>

                <th>
                    Vraag:
                </th>
                <th>
                    Antwoord:
                </th>
";

while ($row = mysqli_fetch_array($result))
{
    echo"
                <tr>
                    <td>".$row['vraag']."</td>
                    <td>".$row['antwoord']."</td>
                </tr>";
}

?>
    </table>
</form>

</div>