 GPT答： |
7i24.cn
|
<!DOCTYPE html>
<html>
<head>
<title>学生信息管理系统</title>
<meta charset="UTF-8">
<style type="text/css">
body {
font-family: Arial, sans-serif;
background-color: #f2f2f2;
margin: 0;
padding: 0;
}
h1 {
text-align: center;
color: #333333;
margin-top: 50px;
}
form {
margin-top: 30px;
width: 500px;
margin-left:auto;
margin-right:auto;
}
label {
display:inline-block;
width :100px ;
text-align:right ;
}
input[type=text], select {
width :200px ;
padding :5px ;
border-radius :5px ;
border:none ;
box-shadow :1px 1.5 px #ccc inset ;
}
input[type=submit]{
background-color:#4CAF50 ;
color:white ;
padding :10 px20 px ;
border:none ;
cursor:pointer ;
}
table{
width:auto
}
th, td{
padding:.7em
}
th{
background-color:#4CAF50;color:white
text-align:left
font-weight:normal
border-bottom:solid white .3em
}
td{background-color:#fff;border-bottom:solid grey .1em}
tr:nth-child(even) td{background-color:#f2f2f2}
tr:hover td{background-color:#ddd}
.button-group button:first-child{border-radius:.6em .6em 0 0}
.button-group button:last-child{border-radius:.6em .6em}
</style>
</head>
<body>
<h1>学生信息管理系统</h1>
<form action="" method="post">
<label for="name">姓名:</label><input type="text" name="name" id="name"><br><br>
<label for="age">年龄:</label><input type="text" name= "age" id= "age"><br><br>
<label for ="gender">性别:</label>
<select name = "gender">
<option value = "male">男性</option>
<option value = "female">女性</option></select><br/><br/>
<label for ="department">所在院系:</label>
<select name = "department">
<option value = "计算机科学与技术系 ">计算机科学与技术系 </option>
<option value ="软件工程系 ">软件工程系 </option></select><br/><br/>
<input type ="submit" name= 'add' value ='添加'>
<input type ="submit" name='update' value ='修改'>
<input type ="submit"name='delete' value ='删除'>
<br/><hr/>
<table >
<thead >
<tr ><th >ID号码 </th ><th >姓名 </th ><th >年龄 </th ><th >性别 </th ><td>所在院系</td ></tr ></thead >
<tbody >
<tr ><td >001 </td ><td >张三 </td ><td >20岁 </td ><td>男性<td/>计算机科学与技术系<td/></tr >
<tr class='even'><td>002<td/>李四<td/>22岁 <TD>FEMALE<TD/>软件工程系<TD/></tr >
<tr class='odd'><TD>003<TD/>王五<TD />18岁 <TD>Male<TD />计算机科学与技术系 <TD /></TR></tbody ></table >
<div class ='button-group'>
<button onclick="">上一页<button/>
<button onclick="">下一页<button/>
<div/>
<footer style="
position:absolute;width:
100%;height:
60 px;background - color:
#4CAF50;text - align:center;padding :
20 px;">
<p style="
color:white;font-size :
16 px;">版权所有 © 学生信息管理系统，保留所有权利。</p></footer>
<?php
//连接数据库
$servername = "";
$username ="";
$password ="";
$dbname ="";
$conn=mysqli_connect($servername,$username,$password,$dbname);
if(!$conn){
die("Connection failed:".mysqli_connect_error());
}
//添加数据
if(isset($_POST['add'])){
$name=$_POST['name'];
$age=$_POST['age'];
$gender=$_POST['gender'];
$department=$_POST['department'];
$sql_insert=
"
INSERT INTO student_info(name, age, gender, department)
VALUES('$name','$age','$gender','$department')
";
if(mysqli_query($conn,$sql_insert)){
echo "<script>alert('数据已成功添加');</script>";
}else{
echo "<script>alert('数据未能成功添加，请检查输入是否正确');</script>";
}}
//更新数据
if(isset($_POST['update'])){
$name=$_POST['name'];
$age=$_POST ['age'];
$sql_update=
"
UPDATE student_info SET age='$age'
WHERE name='$name'
";
if(mysqli_query($conn,$sql_update)){
echo "<script>alert('数据已成功更新');</script>";
}else{
echo "<script>alert('无法更新，请检查输入是否正确或该记录不存在');</script>";
}}
//删除数据
if(isset($_POST ['delete'])){
$name=$_ POST ['name'];
$sql_delete=
"
DELETE FROM student_info WHERE name='$Name'
";
if(mysqli_query ($conn ,$sql_delete)){
echo"< script>alert ('该记录已被删除');< / script>";}
else {echo"< script>alert ('无法删除，请检查输入是否正确或该记录不存在');< / script>";}}?>
<footer style="
position:absolute;width:
100%;height:
60 px;background - color:
#4CAF50;text - align:center;padding :
20 px;">
<p style="
color:white;font-size :
16 px;">版权所有 © 学生信息管理系统，保留所有权利。</p></footer>
<script src="//code.jquery.com/jquery-3.3.1.min.js"></scrip t>
<script src="//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></scri pt>
<link rel="//cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css"/>
<script>$("table").DataTable();< / scri pt>
<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"/rel="">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.
|
