用PHP代码实现学生选课管理系统
时间: 2024-03-09 07:49:14 浏览: 23
好的,以下是一个简单的学生选课管理系统的PHP代码实现:
### 数据库连接
```php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database_name";
// 创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);
// 检测连接
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
```
### 添加学生信息
```php
if(isset($_POST['add_student'])) {
$name = $_POST['name'];
$age = $_POST['age'];
$gender = $_POST['gender'];
$sql = "INSERT INTO students (name, age, gender) VALUES ('$name', '$age', '$gender')";
if (mysqli_query($conn, $sql)) {
echo "New student added successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
```
### 添加课程信息
```php
if(isset($_POST['add_course'])) {
$name = $_POST['name'];
$teacher = $_POST['teacher'];
$credit = $_POST['credit'];
$sql = "INSERT INTO courses (name, teacher, credit) VALUES ('$name', '$teacher', '$credit')";
if (mysqli_query($conn, $sql)) {
echo "New course added successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
```
### 学生选课
```php
if(isset($_POST['enroll'])) {
$student_id = $_POST['student_id'];
$course_id = $_POST['course_id'];
$sql = "INSERT INTO enrollments (student_id, course_id) VALUES ('$student_id', '$course_id')";
if (mysqli_query($conn, $sql)) {
echo "Student enrolled in course successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
```
### 查询学生选课信息
```php
$sql = "SELECT students.name, courses.name
FROM enrollments
JOIN students ON enrollments.student_id=students.id
JOIN courses ON enrollments.course_id=courses.id";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
echo "Student: " . $row["name"]. " - Course: " . $row["name"]. "<br>";
}
} else {
echo "0 results";
}
```
以上代码只是一个简单的示例,实际上学生选课管理系统需要更复杂的功能和更严谨的代码实现。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)