学生信息管理系统php+mysql

以下是一个简单的学生信息管理系统的PHP+MySQL实现，包括添加、删除、修改和查看学生信息的功能：

1. 首先需要创建一个MySQL数据库，包含一个名为“students”的表，表结构如下：

CREATE TABLE students (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(30) NOT NULL,
  age INT(3) NOT NULL,
  gender VARCHAR(10) NOT NULL,
  email VARCHAR(50),
  phone VARCHAR(20)
)

2. 然后创建一个PHP页面，用于连接数据库并实现学生信息管理的功能。以下是一个简单的示例代码：

<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");

// 检查连接是否成功
if (!$conn) {
  die("连接失败: " . mysqli_connect_error());
}

// 添加学生信息
if (isset($_POST['add'])) {
  $name = $_POST['name'];
  $age = $_POST['age'];
  $gender = $_POST['gender'];
  $email = $_POST['email'];
  $phone = $_POST['phone'];

  $sql = "INSERT INTO students (name, age, gender, email, phone) VALUES ('$name', '$age', '$gender', '$email', '$phone')";

  if (mysqli_query($conn, $sql)) {
    echo "添加成功";
  } else {
    echo "添加失败: " . mysqli_error($conn);
  }
}

// 删除学生信息
if (isset($_GET['delete'])) {
  $id = $_GET['delete'];

  $sql = "DELETE FROM students WHERE id=$id";

  if (mysqli_query($conn, $sql)) {
    echo "删除成功";
  } else {
    echo "删除失败: " . mysqli_error($conn);
  }
}

// 修改学生信息
if (isset($_POST['update'])) {
  $id = $_POST['id'];
  $name = $_POST['name'];
  $age = $_POST['age'];
  $gender = $_POST['gender'];
  $email = $_POST['email'];
  $phone = $_POST['phone'];

  $sql = "UPDATE students SET name='$name', age='$age', gender='$gender', email='$email', phone='$phone' WHERE id=$id";

  if (mysqli_query($conn, $sql)) {
    echo "修改成功";
  } else {
    echo "修改失败: " . mysqli_error($conn);
  }
}

// 查询学生信息
$sql = "SELECT * FROM students";
$result = mysqli_query($conn, $sql);

// 输出学生信息表格
echo "<table>";
echo "<tr><th>ID</th><th>姓名</th><th>年龄</th><th>性别</th><th>邮箱</th><th>电话</th><th>操作</th></tr>";
while ($row = mysqli_fetch_assoc($result)) {
  echo "<tr>";
  echo "<td>" . $row['id'] . "</td>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['age'] . "</td>";
  echo "<td>" . $row['gender'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "<td>" . $row['phone'] . "</td>";
  echo "<td><a href='edit.php?id=" . $row['id'] . "'>编辑</a> <a href='index.php?delete=" . $row['id'] . "'>删除</a></td>";
  echo "</tr>";
}
echo "</table>";

// 关闭数据库连接
mysqli_close($conn);
?>

3. 创建一个添加学生信息的表单页面，用于向数据库中添加学生信息。以下是一个简单的示例代码：

<form method="post" action="index.php">
  <label>姓名：</label>
  <input type="text" name="name" required><br>
  <label>年龄：</label>
  <input type="number" name="age" required><br>
  <label>性别：</label>
  <input type="radio" name="gender" value="男" required>男
  <input type="radio" name="gender" value="女" required>女<br>
  <label>邮箱：</label>
  <input type="email" name="email"><br>
  <label>电话：</label>
  <input type="tel" name="phone"><br>
  <input type="submit" name="add" value="添加">
</form>

4. 创建一个编辑学生信息的表单页面，用于修改数据库中的学生信息。以下是一个简单的示例代码：

<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");

// 检查连接是否成功
if (!$conn) {
  die("连接失败: " . mysqli_connect_error());
}

// 获取要编辑的学生信息
$id = $_GET['id'];
$sql = "SELECT * FROM students WHERE id=$id";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);

// 关闭数据库连接
mysqli_close($conn);
?>

<form method="post" action="index.php">
  <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
  <label>姓名：</label>
  <input type="text" name="name" value="<?php echo $row['name']; ?>" required><br>
  <label>年龄：</label>
  <input type="number" name="age" value="<?php echo $row['age']; ?>" required><br>
  <label>性别：</label>
  <input type="radio" name="gender" value="男" <?php if ($row['gender'] == '男') echo 'checked'; ?> required>男
  <input type="radio" name="gender" value="女" <?php if ($row['gender'] == '女') echo 'checked'; ?> required>女<br>
  <label>邮箱：</label>
  <input type="email" name="email" value="<?php echo $row['email']; ?>"><br>
  <label>电话：</label>
  <input type="tel" name="phone" value="<?php echo $row['phone']; ?>"><br>
  <input type="submit" name="update" value="保存">
</form>