<?php
    if(isset($_POST["aendern"])){
        $sql="UPDATE tab_adressen SET "
            ."name ='".$_POST["name"]."',"
            ."vname ='".$_POST["vname"]."',"
            ."geb =  '".$_POST["geb"]."',"
            ."tel = '".$_POST["tel"]."',"
            ."email ='".$_POST["email"]."'"
            ."WHERE id = ".$_POST["id"];
        include("verbinden.php");
        include("index.php");
    }
    else{
        include("index.php");
        $id=$_GET["id"] ;
        $sql="SELECT * FROM tab_adressen WHERE id = $id" ;
        include("verbinden.php");
        $dsatz = mysqli_fetch_assoc($result);
        echo"<form action='aendern.php' method='POST'>
            <table>
                <tr>
                    <td></td>
                    <td><input type='hidden' name='id' value={$dsatz['id']} ></td>
                </tr>
                <tr>
                    <td>Name: </td>
                    <td><input type='text' name='name' value={$dsatz['name']} ></td>
                </tr>
                <tr>
                    <td>Vorname: </td>
                    <td><input type='text' name='vname' value={$dsatz['vname']} ></td>
                </tr>
                <tr>
                    <td>Geb.-Datum: </td>
                    <td><input type='date' name='geb' value={$dsatz['geb']} ></td>
                </tr>
                <tr>
                    <td>Telefon: </td>
                    <td><input type='text' name='tel' value={$dsatz['tel']} > </td>
                </tr>
                <tr>
                    <td>E-Mail: </td>
                    <td><input type='email' name='email' value={$dsatz['email']} ></td>
                </tr>
            </table>
            <hr>
            <input type='submit' name='aendern' value='Ändern'>
        </form>
        " ;
    }
?>