Untitled

<!DOCTYPE html>
<html>
<head>
    <title>PW</title>
    <meta charset="utf-8">
    <script src="ckeditor/ckeditor.js"></script>
</head>
<body>
<form method="POST">
    <input type="text" name="nazev">
    <input type="submit">
<?php
$mysqli = new mysqli("localhost","vyukapw2","123456","vyukapw2");

if (!empty($_POST['nazev'])) {
        $nazev = $_POST['nazev'];
        if (empty($_POST['nadrazeny']))
            $nadrazeny = 0;
        else
            $nadrazeny = $_POST['nadrazeny'];
        if (empty($_POST['cesta']))
            $cesta = ';0;';
        else
            $cesta = $_POST['cesta'];
        if (empty($_POST['uroven']))
            $uroven = 0;
        else
            $uroven = $_POST['uroven'];
        $sql = "INSERT INTO `menu` SET `nazev`=?, `nadrazeny`=?, `cesta`=?, `uroven`=?";
        $dotaz = $mysqli->prepare($sql);
        $dotaz->bind_param("sisi",$nazev,$nadrazeny,$cesta,$uroven);
        $dotaz->execute();
}
if (!empty($_GET['id'])) {
    $id = $_GET['id'];

    $sql = "SELECT * FROM `menu` WHERE `id` =?";
    $dotaz = $mysqli->prepare($sql);
    $dotaz->bind_param("i",$id);
    $dotaz->execute();
    $vysledek = $dotaz->get_result();
    $radek = $vysledek->fetch_assos();

    $nazev = $radek['nazev'];
    $nadrazeny = $radek['nadrazeny'];
    $cesta = $radek['cesta'];
    $uroven = $radek['uroven'];

    echo'<input type="text" name="nadrazeny" value="'.$id.'">';
    echo'<input type="text" name="cesta" value="'.$cesta.$id.'">';
    echo'<input type="text" name="uroven" value="'.($uroven+1).'">';
}

?>

<hr>

<?php

function vypismenu($root){
    echo '<ul>';
    global $mysqli;

    $sql = "SELECT * FROM `menu` WHERE `nadrazeny`=?";
    $dotaz = $mysqli->prepare($sql);
    $dotaz->bind_param("i",$root);
    $dotaz->execute();
    $vysledek = $dotaz->get_result();
    while ($radek = $vysledek->fetch_assos()) {
        $id = $radek['id'];
        $nazev = $radek['nazev'];
        $nadrazeny = $radek['nadrazeny'];
        $cesta = $radek['cesta'];
        $uroven = $radek['uroven'];

        echo '<li><a href="index.php?id='.$id.'">'.$nazev.'</a></li>';
         vypismenu($id);
    }
    echo '</ul>';
}
vypismenu(0);

?>
</form>


</body>
</html>