<?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "my_db";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    // prepare and bind
    $stmt = $mysqli->prepare("UPDATE movies SET title = ?,
       brief = ?,
       contents = ?,
       author = ?
       WHERE id = 1");

    // set parameters and execute
    $stmt->bind_param("ssssi", $_POST['title'],
    $_POST['brief'],
    $_POST['contents'],
    $_POST['author']
    $_POST['id']);
    $stmt->execute();
    echo "New records updated successfully";
    $conn->close();
    ?>