<?php 
$editId = $_GET['editFilm'];
echo($editId);

        $statement = $LINK->prepare("SELECT title, kdm FROM CineFilms WHERE pk_film=?");
        $statement->bind_param('i', $editId);
        $statement->execute();
        $result = $statement->get_result();

        if ($result) {
            $row = $result->fetch_assoc();
            ?>
           <h2>Edit Film</h2>
            <form method="POST" action="">
                <input type="hidden" name="film_id" value="<?= $editId ?>">
                
                <label for="name">Title:</label>
                <input type="text" name="name" value="<?= htmlspecialchars($row['title']) ?>">
                <br>
                
                <label for="KMD">KDM:</label>
                <input type="label" name="kdm" min="0" value="<?= $row['kdm'] ?>">
                <br>
                
                <button type="submit" name="update">Save Changes</button>
                <a href="?extra"><button type="button">Cancel</button></a>
            </form>               
            <?php

            if(isset($_POST['update']))
            {
                $title=$_POST['name'];
                $kdm=$_POST['kdm'];

                $statement1 = $LINK->prepare("UPDATE CineFilms SET title = ?, kdm = ? WHERE pk_film = ?");
                $statement1->bind_param('ssi',$title,$kdm,$editId);
                $statement1->execute();
                header('Location:?Film');
                exit();
            }
            
        }
?>