Home >Backend Development >PHP Tutorial >How to implement a simple online course management system using PHP
How to use PHP to implement a simple online course management system
Introduction:
With the popularity of the Internet, more and more educational institutions are beginning to use online courses to teach. In order to facilitate the management of online course information, we can use PHP language to build a simple online course management system. This article will introduce how to implement such a system using PHP and provide specific code examples.
Step 1: Create a database
First, we need to create a database to store course-related information. You can use tools such as phpMyAdmin to create a database named "course_management" and create a data table named "courses" in it. The specific SQL statements are as follows:
CREATE DATABASE course_management;
USE course_management;
CREATE TABLE courses (
id INT PRIMARY KEY AUTO_INCREMENT,
title VARCHAR( 100) NOT NULL,
description TEXT,
instructor VARCHAR(50) NOT NULL,
start_date DATE,
end_date DATE
);
Here we create a name It is a data table for "courses" and defines some fields, including the course title, description, instructor, start date and end date, etc.
Step 2: Create the page structure
Next, we need to create a page to display course information and provide related operation functions. You can create a file called "index.php" and write HTML and PHP code in it. The specific code is as follows:
<!DOCTYPE html>
<html>
<head>
<title>在线课程管理系统</title>
</head>
<body>
<h1>在线课程管理系统</h1>
<a href="add_course.php">添加课程</a><br><br>
<table>
<tr>
<th>课程标题</th>
<th>讲师</th>
<th>开始日期</th>
<th>结束日期</th>
<th>操作</th>
</tr>
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "root", "", "course_management");
// 查询数据
$query = "SELECT * FROM courses";
$result = mysqli_query($conn, $query);
// 显示数据
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>";
echo "<td>" . $row['title'] . "</td>";
echo "<td>" . $row['instructor'] . "</td>";
echo "<td>" . $row['start_date'] . "</td>";
echo "<td>" . $row['end_date'] . "</td>";
echo "<td><a href='edit_course.php?id=" . $row['id'] . "'>编辑</a> | <a href='delete_course.php?id=" . $row['id'] . "'>删除</a></td>";
echo "</tr>";
}
// 关闭数据库连接
mysqli_close($conn);
?>
</table>
</body>
</html>In this page, we first added a title and an "Add Course" link. Then, connect to the database through PHP code and query all course information. Finally, display the query results in a table, adding an "Edit" and "Delete" link for each course.
Step 3: Add a course
In order to implement the add course function, we need to create a file named "add_course.php" and write HTML and PHP code in it. The specific code is as follows:
<!DOCTYPE html>
<html>
<head>
<title>添加课程</title>
</head>
<body>
<h1>添加课程</h1>
<form method="post" action="save_course.php">
<label for="title">课程标题：</label>
<input type="text" name="title" required><br><br>
<label for="description">课程描述：</label>
<textarea name="description"></textarea><br><br>
<label for="instructor">讲师：</label>
<input type="text" name="instructor" required><br><br>
<label for="start_date">开始日期：</label>
<input type="date" name="start_date" required><br><br>
<label for="end_date">结束日期：</label>
<input type="date" name="end_date" required><br><br>
<input type="submit" value="保存">
</form>
</body>
</html>In this page, we created a form for entering course information. The "action" attribute of the form specifies the address of the URL requested after submitting the form, which we will create in the next step.
Step 4: Save the course
In order to save the course information, we need to create a file named "save_course.php" and write PHP code in it. The specific code is as follows:
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "root", "", "course_management");
// 从表单中获取课程的信息
$title = $_POST['title'];
$description = $_POST['description'];
$instructor = $_POST['instructor'];
$start_date = $_POST['start_date'];
$end_date = $_POST['end_date'];
// 插入数据
$query = "INSERT INTO courses (title, description, instructor, start_date, end_date) VALUES ('$title', '$description', '$instructor', '$start_date', '$end_date')";
mysqli_query($conn, $query);
// 关闭数据库连接
mysqli_close($conn);
// 重定向到首页
header("Location: index.php");
?>In this page, we first connect to the database. Then, get the course information from the form and insert it into the "courses" data table. Finally, close the database connection and redirect the page to the homepage.
Step 5: Edit and delete courses
In order to implement the function of editing and deleting courses, we need to create two files, namely "edit_course.php" and "delete_course.php".
The code of "edit_course.php" is as follows:
<!DOCTYPE html>
<html>
<head>
<title>编辑课程</title>
</head>
<body>
<h1>编辑课程</h1>
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "root", "", "course_management");
// 获取要编辑的课程的ID
$id = $_GET['id'];
// 查询数据
$query = "SELECT * FROM courses WHERE id = $id";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
?>
<form method="post" action="update_course.php">
<input type="hidden" name="id" value="<?php echo $row['id']; ?>">
<label for="title">课程标题：</label>
<input type="text" name="title" value="<?php echo $row['title']; ?>" required><br><br>
<label for="description">课程描述：</label>
<textarea name="description"><?php echo $row['description']; ?></textarea><br><br>
<label for="instructor">讲师：</label>
<input type="text" name="instructor" value="<?php echo $row['instructor']; ?>" required><br><br>
<label for="start_date">开始日期：</label>
<input type="date" name="start_date" value="<?php echo $row['start_date']; ?>" required><br><br>
<label for="end_date">结束日期：</label>
<input type="date" name="end_date" value="<?php echo $row['end_date']; ?>" required><br><br>
<input type="submit" value="保存">
</form>
</body>
</html>In this page, we first connect to the database and get the ID of the course to be edited through the parameters in the URL. Then, query the course information and display it in the form. Finally, submit the request to update the course to "update_course.php".
The code of "delete_course.php" is as follows:
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "root", "", "course_management");
// 获取要删除的课程的ID
$id = $_GET['id'];
// 删除数据
$query = "DELETE FROM courses WHERE id = $id";
mysqli_query($conn, $query);
// 关闭数据库连接
mysqli_close($conn);
// 重定向到首页
header("Location: index.php");
?>In this page, we first connect to the database and get the ID of the course to be deleted through the parameters in the URL. Then, perform the delete operation and close the database connection. Finally, redirect the page to the home page.
Summary:
This article introduces how to use PHP language to implement a simple online course management system. By studying the content of this article, you can learn how to use PHP to connect to the database, execute SQL queries, and perform data addition, deletion, modification and query operations. Hope this article helps you!
The above is the detailed content of How to implement a simple online course management system using PHP. For more information, please follow other related articles on the PHP Chinese website!