Untitled

<?php

$host = "localhost";
$user = "root";
$pass = "coderslab";
$db = "cinemas_ex"; //nazwa bazy

$conn = new PDO( //Łączenie sie z bazą danych
    "mysql:host=$host;dbname=$db;charset=UTF8",
    $user, //root
    $pass,//coderslab
    [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC //domyslny sposob pobierania danych
    ]
);


if ($_SERVER['REQUEST_METHOD'] === 'POST') { //obsluga formualrza
    if (isset($_POST['movie']) && is_numeric($_POST['movie'])) { //sprawdzamy czy sa poprawne dane
        $id = $_POST['movie']; //pobieramy ID z posta
        $sql = 'DELETE FROM Movies WHERE id=:id'; //usuwamy konkretny element z bazy danych
        $stmt = $conn->prepare($sql); //zabezpieczenie przed sqlinjection
        $stmt->execute([
            'id' => $id
        ]);
    } else {
        echo 'Wypełnij formularz;';
    }
}

?>
<!doctype html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta name="viewport"
	      content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">
	<title>Zadanie 2 - usuwanie filmu</title>
	<!-- Latest compiled and minified CSS -->
	<link rel="stylesheet" media="screen" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
</head>
<body>
<div class="container">
	<div class="row">
		<div class="col-xs-4 col-sm-4 col-md-4 col-lg-4">

		</div>
		<div class="col-xs-4 col-sm-4 col-md-4 col-lg-4">
			<form action="" method="post" role="form">
				<legend>Remove movie</legend>
				<div class="form-group">
					<label for="">Movie</label>
					<select name="movie" id="movie" class="form-control">
						<option value=""> -- Select movie --</option>
                        <?php

                        $sql = 'SELECT id, name FROM Movies;'; //pobieramy wszystkie filmy

                        $res = $conn->query($sql); //to co wyzej

                        foreach ($res as $row) {
                            echo "<option value='{$row['id']}'>{$row['name']}</option>"; //Generujemy linki dla kazdego z rekordów
                        }
                        ?>
					</select>
				</div>
				<button type="submit" value="remove" class="btn btn-danger">REMOVE</button>
			</form>
		</div>
		<div class="col-xs-4 col-sm-4 col-md-4 col-lg-4">

		</div>
	</div>
</div>
</body>
</html>