创建数据库：使用MySQL或其他关系型数据库创建一个名为cinema的数据库。创建表：在cinema数据库中创建user和movie两个表。user表用于存储用户信息，movie表用于存储电影信息。注册页面：创建一个register.php页面，包含用户名、密码、确认密码等表单项。将表单数据插入到user表中。登录页面：创建一个login.php页面，包含用户名、密码等表单项。查询user表中是否存在该用户。管理页面：创建一个admin.php页面，用于管理电影信息。在该页面中，可以添加、删除、修改电影信息。将电影信息插入到movie表中。显示页面：创建一个show.php页面，用于展示电影信息。查询movie表中的电影信息，并将其展示在页面上。

时间: 2024-02-18 20:59:41 浏览: 89

好的，以下是一个简单的电影院注册登录管理页面的PHP代码实现： 1. 创建数据库和表： ``` CREATE DATABASE cinema; USE cinema; CREATE TABLE user ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(30) NOT NULL, password VARCHAR(30) NOT NULL ); CREATE TABLE movie ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, title VARCHAR(30) NOT NULL, director VARCHAR(30) NOT NULL, release_date DATE ); ``` 2. 注册页面(register.php)： ``` <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Register</title> </head> <body> <h2>Register</h2> <form action="register.php" method="post"> <label>Username:</label><br> <input type="text" name="username"><br> <label>Password:</label><br> <input type="password" name="password"><br> <label>Confirm Password:</label><br> <input type="password" name="confirm_password"><br> <input type="submit" value="Register"> </form> <?php // Connect to database $conn = mysqli_connect("localhost", "username", "password", "cinema"); // Check if form is submitted if ($_SERVER["REQUEST_METHOD"] == "POST") { $username = $_POST["username"]; $password = $_POST["password"]; $confirm_password = $_POST["confirm_password"]; // Check if passwords match if ($password != $confirm_password) { echo "Passwords do not match."; } else { // Insert user into database $sql = "INSERT INTO user (username, password) VALUES ('$username', '$password')"; if (mysqli_query($conn, $sql)) { echo "Registration successful."; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } } // Close database connection mysqli_close($conn); ?> </body> </html> ``` 3. 登录页面(login.php)： ``` <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Login</title> </head> <body> <h2>Login</h2> <form action="login.php" method="post"> <label>Username:</label><br> <input type="text" name="username"><br> <label>Password:</label><br> <input type="password" name="password"><br> <input type="submit" value="Login"> </form> <?php // Start session session_start(); // Connect to database $conn = mysqli_connect("localhost", "username", "password", "cinema"); // Check if form is submitted if ($_SERVER["REQUEST_METHOD"] == "POST") { $username = $_POST["username"]; $password = $_POST["password"]; // Check if user exists in database $sql = "SELECT * FROM user WHERE username='$username' AND password='$password'"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) == 1) { // User exists, set session variables and redirect to admin page $_SESSION["username"] = $username; header("Location: admin.php"); } else { // User does not exist, display error message echo "Invalid username or password."; } } // Close database connection mysqli_close($conn); ?> </body> </html> ``` 4. 管理页面(admin.php)： ``` <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Admin</title> </head> <body> <?php // Start session session_start(); // Check if user is logged in if (!isset($_SESSION["username"])) { header("Location: login.php"); } // Connect to database $conn = mysqli_connect("localhost", "username", "password", "cinema"); // Check if form is submitted if ($_SERVER["REQUEST_METHOD"] == "POST") { $title = $_POST["title"]; $director = $_POST["director"]; $release_date = $_POST["release_date"]; // Insert movie into database $sql = "INSERT INTO movie (title, director, release_date) VALUES ('$title', '$director', '$release_date')"; if (mysqli_query($conn, $sql)) { echo "Movie added successfully."; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } // Retrieve movies from database $sql = "SELECT * FROM movie"; $result = mysqli_query($conn, $sql); // Display movies in table echo "<h2>Admin</h2>"; echo "<form action='admin.php' method='post'>"; echo "<label>Title:</label><br>"; echo "<input type='text' name='title'><br>"; echo "<label>Director:</label><br>"; echo "<input type='text' name='director'><br>"; echo "<label>Release Date:</label><br>"; echo "<input type='date' name='release_date'><br>"; echo "<input type='submit' value='Add Movie'>"; echo "</form>"; echo "<br>"; echo "<table>"; echo "<tr><th>Title</th><th>Director</th><th>Release Date</th><th></th><th></th></tr>"; while ($row = mysqli_fetch_assoc($result)) { echo "<tr>"; echo "<td>" . $row["title"] . "</td>"; echo "<td>" . $row["director"] . "</td>"; echo "<td>" . $row["release_date"] . "</td>"; echo "<td><a href='delete.php?id=" . $row["id"] . "'>Delete</a></td>"; echo "<td><a href='edit.php?id=" . $row["id"] . "'>Edit</a></td>"; echo "</tr>"; } echo "</table>"; // Close database connection mysqli_close($conn); ?> <br> <a href="logout.php">Logout</a> </body> </html> ``` 5. 显示页面(show.php)： ``` <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Show</title> </head> <body> <h2>Show</h2> <?php // Connect to database $conn = mysqli_connect("localhost", "username", "password", "cinema"); // Retrieve movies from database $sql = "SELECT * FROM movie"; $result = mysqli_query($conn, $sql); // Display movies in table echo "<table>"; echo "<tr><th>Title</th><th>Director</th><th>Release Date</th></tr>"; while ($row = mysqli_fetch_assoc($result)) { echo "<tr>"; echo "<td>" . $row["title"] . "</td>"; echo "<td>" . $row["director"] . "</td>"; echo "<td>" . $row["release_date"] . "</td>"; echo "</tr>"; } echo "</table>"; // Close database connection mysqli_close($conn); ?> </body> </html> ``` 以上代码仅供参考，具体实现还需要根据具体需求进行调整。同时，使用PHP开发需要注意安全性问题，如SQL注入等。

阅读全文

CSDN会员

开通CSDN年卡参与万元壕礼抽奖

海量 VIP免费资源千本正版电子书商城会员专享价千门课程&专栏

全年可省5,000元立即开通

大家在看

中国移动5G规模试验测试规范--核心网领域--SA基础网元性能测试分册.pdf

CAN分析仪 解析 DBC uds 源码

MIPI-D-PHY-specification-v1.1.pdf

收放卷及张力控制-applied regression analysis and generalized linear models3rd

彩虹聚合DNS管理系统V1.3+搭建教程

最新推荐

国家开放大学 MySQL数据库应用 实验训练1 在MySQL中创建数据库和表

实验训练1 在MySQL中创建数据库和表.docx

MySql添加新用户及为用户创建数据库和给用户分配权限方法介绍

C#实现根据实体类自动创建数据库表

mysql数据库实验报告 数据表的操作

AkariBot-Core：可爱AI机器人实现与集成指南

管理建模和仿真的文件

CC-LINK远程IO模块AJ65SBTB1现场应用指南：常见问题快速解决

switch语句和for语句的区别和使用方法

易语言实现程序启动限制的源码示例

CAN分析仪解析 DBC uds 源码

国家开放大学 MySQL数据库应用实验训练1 在MySQL中创建数据库和表

mysql数据库实验报告数据表的操作