<?php
    session_start();
    include("includes/connect_db.php");

    if($_POST['submit']){
        mysql_query("UPDATE werkzaamheden SET naam='".$_POST['naam']."', Beschrijving='".$_POST['beschrijving']."' WHERE werkzaamheidid='".$_POST['werkzaamheidid']."'");
        }elseif($_GET['id']){
        $get_client = mysql_query("SELECT * FROM werkzaamheden WHERE werkzaamheidid='".$_GET['id']."'");
        if(mysql_num_rows($get_client) == 1){
            $client = mysql_fetch_array($get_client);
            ?>
        <form name="form" action=".php" method="post">
            <table cellpadding="1" cellspacing="1" border="0" width="98%" align="center">
                <tr>
                    <td>
                        <b>Naam:</b>
                    </td>
                    <td>
                        <input size="50" type="text" name="name" value="<? print $client['name']; ?>"/>
                    </td>
                </tr>
                <tr>
                    <td>
                        <b>beschrijving:</b>
                    </td>
                    <td>
                         <input size="10000" type="text" name="Beschrijving" value="<? print $client['Beschrijving']; ?>"/>
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="center">
                        <input type="hidden" name="werkzaamheidid" value="<? print $client['werkzaamheidid']; ?>" />
                        <input type="submit" name="submit" value="Update" class="button" />
                        <input type="reset" value="Reset" class="button" />
                    </td>
                </tr>
            </table>
        </form>
    <?php
        }
    }else{
    ?>
<table>
    <tr>
        <td>
         <strong>Naam</strong>
       </td>
       <td>
          <strong>Beschrijving</strong>
        </td>
    </tr>
<?php
    $get_clients = mysql_query("SELECT * FROM werkzaamheden");
    if(mysql_num_rows($get_clients) > 0 ){
        while($clients = mysql_fetch_array($get_clients)){
            print "<tr><td>".$clients['naam']."</td>";
            print "<td>".$clients['beschrijving']."</td>";
            print "<td><a href='.php?id=".$clients['werkzaamheidid']."'>Change</a></td></tr>";
            }
        print "</table>";
        }
    }
?>