How to use PHP to implement a simple online movie on-demand and playback system

<?php
// 处理用户注册
if($_SERVER['REQUEST_METHOD'] == 'POST') {
    // 获取表单数据
    $username = $_POST['username'];
    $password = $_POST['password'];
    $email = $_POST['email'];

    // 将用户信息插入数据库
    // 注意：此处需要使用密码加密算法，如md5或sha1
    $hashedPassword = md5($password);
    
    // 连接数据库
    $db = new mysqli('localhost', 'root', 'password', 'movie_system');
    
    // 插入用户信息
    $sql = "INSERT INTO users (username, password, email) VALUES ('$username', '$hashedPassword', '$email')";
    $result = $db->query($sql);
    
    if($result) {
        echo '注册成功！';
    } else {
        echo '注册失败，请重试！';
    }
    $db->close();
}
?>

<!-- 用户注册表单 -->
<form method="POST">
    <label>用户名：</label>
    <input type="text" name="username" required><br>

    <label>密码：</label>
    <input type="password" name="password" required><br>

    <label>邮箱：</label>
    <input type="email" name="email" required><br>

    <input type="submit" value="注册">
</form>

<?php
// 处理用户登录
if($_SERVER['REQUEST_METHOD'] == 'POST') {
    // 获取表单数据
    $username = $_POST['username'];
    $password = $_POST['password'];

    // 连接数据库
    $db = new mysqli('localhost', 'root', 'password', 'movie_system');
    
    // 查询用户信息
    $sql = "SELECT * FROM users WHERE username='$username' AND password='$password'";
    $result = $db->query($sql);
    
    if ($result->num_rows > 0) {
        echo '登录成功！';
    } else {
        echo '登录失败，请重试！';
    }
    $db->close();
}
?>

<!-- 用户登录表单 -->
<form method="POST">
    <label>用户名：</label>
    <input type="text" name="username" required><br>

    <label>密码：</label>
    <input type="password" name="password" required><br>

    <input type="submit" value="登录">
</form>

<?php
// 处理电影上传
if($_SERVER['REQUEST_METHOD'] == 'POST') {
    // 获取表单数据
    $title = $_POST['title'];
    $description = $_POST['description'];
    $image = $_FILES['image']['name'];
    $video = $_FILES['video']['name'];

    // 连接数据库
    $db = new mysqli('localhost', 'root', 'password', 'movie_system');
    
    // 上传电影文件
    move_uploaded_file($_FILES['image']['tmp_name'], 'images/' . $_FILES['image']['name']);
    move_uploaded_file($_FILES['video']['tmp_name'], 'videos/' . $_FILES['video']['name']);
    
    // 将电影信息插入数据库
    $sql = "INSERT INTO movies (title, description, image, video) VALUES ('$title', '$description', '$image', '$video')";
    $result = $db->query($sql);
    
    if($result) {
        echo '上传成功！';
    } else {
        echo '上传失败，请重试！';
    }
    $db->close();
}
?>

<!-- 电影上传表单 -->
<form method="POST" enctype="multipart/form-data">
    <label>电影标题：</label>
    <input type="text" name="title" required><br>
    
    <label>电影描述：</label>
    <textarea name="description"></textarea><br>
    
    <label>电影封面：</label>
    <input type="file" name="image" required><br>
    
    <label>电影文件：</label>
    <input type="file" name="video" required><br>
    
    <input type="submit" value="上传">
</form>

<?php
// 获取电影ID
$id = $_GET['id'];

// 连接数据库
$db = new mysqli('localhost', 'root', 'password', 'movie_system');

// 查询电影信息
$sql = "SELECT * FROM movies WHERE id='$id'";
$result = $db->query($sql);
$row = $result->fetch_assoc();

// 输出电影标题
echo '<h1>' . $row['title'] . '</h1>';

// 输出电影描述
echo '<p>' . $row['description'] . '</p>';

// 输出电影封面
echo '<img  src="images/' . $row['image'] . '" alt="How to use PHP to implement a simple online movie on-demand and playback system" >';

// 输出电影视频
echo '<video src="videos/' . $row['video'] . '" controls autoplay></video>';

$db->close();
?>