修改页面前端
文件名:E:\phpstudy_pro\WWW\xsxxgl\xiugai.php
<?php
session_start();
//先判断是否正常登陆,根据是否有$_session['yhm']
if ($_SESSION['yhm']==null) {
echo "<script>location='denglu.html';</script>";
}
$id=$_GET['id'];
// echo $id;
$sql="select * from xsb where id=".$id;
// echo $sql;
$pdo = new PDO('mysql:dbname=mydb;host=localhost', 'root', '123456');
$arr = $pdo->query($sql)->fetchAll(PDO::FETCH_NUM);
// var_dump($arr);
$id=$arr[0][0];
$xh=$arr[0][1];
$xm=$arr[0][2];
$xb=$arr[0][3];
$nl=$arr[0][4];
$zy=$arr[0][5];
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link rel="stylesheet" href="css/comm.css">
<link rel="stylesheet" href="css/xiugai.css">
</head>
<body>
<h1>修改</h1>
<hr>
<div class="da">
<form action="xiugaiCL.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="id" value="<?php echo $id; ?>">
<div class="hang">
<div class="zuo">学号</div>
<div class="you"> <input type="text" name="xh" id="" required autofocus value="<?php echo $xh ?>"
class="wbk">
</div>
</div>
<div class="hang">
<div class="zuo">姓名</div>
<div class="you"> <input type="text" name="xm" id="" class="wbk" required value="<?php echo $xm ?>">
</div>
</div>
<div class="hang">
<div class="zuo">性别</div>
<div class="you"> <input type="radio" name="xb" id="" checked value="男"
<?php if($xb=='男') echo 'checked' ?>>男
<input type="radio" name="xb" id="" value="女" <?php if($xb=='女') echo 'checked' ?>>女
</div>
</div>
<div class="hang">
<div class="zuo">年龄</div>
<div class="you"> <input type="number" name="nl" class="wbk" id="" required value="<?php echo $nl ?>">
</div>
</div>
<div class="hang">
<div class="zuo">专业</div>
<div class="you">
<select name="zy" id="" class="wbk">
<option value="计算机网络" <?php if($zy=='计算机网络') echo 'selected'; ?>>计算机网络</option>
<option value="计算机软件" <?php if($zy=='计算机软件') echo 'selected'; ?>>计算机软件</option>
<option value="计算机应用" <?php if($zy=='计算机应用') echo 'selected'; ?>>计算机应用</option>
</select>
</div>
</div>
<div class="hang">
<div class="zuo">照片</div>
<div class="you"> <input type="file" name="zhaopian" class="wbk"> </div>
</div>
<div class="hang">
<div class="zuo"></div>
<div class="you"> <input type="submit" value="修改" class="xg"> </div>
</div>
</form>
</div>
</body>
</html>
修改页面css文件:E:\phpstudy_pro\WWW\xsxxgl\css\xiugai.css
.da {
width: 350px;
margin: 100px auto;
background-color: #bee4a8;
padding: 20px;
font-size: 18px;
}
.xg {
border: 1px solid black;
display: inline-block;
width: 60px;
height: 30px;
background-color: #7f945d;
text-align: center;
font-size: 20px;
box-sizing: border-box;
line-height: 30px;
margin-left: 150px;
border-radius: 3px;
cursor: pointer;
}
.zuo,
.you {
float: left;
}
.zuo {
width: 60px;
height: 50px;
}
.hang {
height: 50px;
line-height: 50px;
}
.wbk {
height: 35px;
width: 220px;
font-size: 16px;
padding-left: 20px;
border-radius: 5px;
}
a {
cursor: default;
}
h1 {
text-align: center;
margin-top: 50px;
font-weight: 500;
}
hr {
height: 2px;
background-color: #a9d311;
}
修改页面后端
文件名:E:\phpstudy_pro\WWW\xsxxgl\xiugaiCL.php
<?php
session_start();
//先判断是否正常登陆,根据是否有$_session['yhm']
if ($_SESSION['yhm'] == null) {
echo "<script>location='denglu.html';</script>";
}
// UPDATE `xsb` SET `xh`='789',`xm`='aaa',`xb`='女',`nl`='30',`zy`='计算机网络' WHERE id=25
$xh = $_POST['xh'];
$xm = $_POST['xm'];
$xb = $_POST['xb'];
$nl = $_POST['nl'];
$zy = $_POST['zy'];
$id = $_POST['id'];
$zhaopian = $_FILES['zhaopian'];
$zhaopianming = $zhaopian['name']; //照片名
$pdo = new PDO('mysql:dbname=mydb;host=localhost', 'root', '123456');
//照片名为空则不修改照片
$sql = "UPDATE `xsb` SET `xh`='{$xh}',`xm`='$xm',`xb`='$xb',`nl`='{$nl}',`zy`='{$zy}' WHERE id={$id}";
// echo $sql;
//照片名不为空则修改照片
if ($zhaopianming != '') {
$sql = "UPDATE `xsb` SET `xh`='{$xh}',`xm`='$xm',`xb`='$xb',`nl`='{$nl}',`zy`='{$zy}',`zp`='{$zhaopianming}' WHERE id={$id}";
$b = move_uploaded_file($zhaopian['tmp_name'], 'imgs\\' . $zhaopian['name']); //保存照片
//删除原照片文件
$zpwjm = $pdo->query("select * from xsb where id={$id}")->fetchAll()[0][6]; //照片文件名
if (file_exists('imgs/'.$zpwjm)) {
unlink('imgs/'.$zpwjm);//删除照片文件
}
}
// echo $sql;
$n = $pdo->exec($sql); //如果不成功,返回false,成功则返回受影响的行数
if ($n === 1 || $n === 0) { //如果没有改动,但成功执行语句,会返回0,为了区分返回false,故三等号,判断是否绝对相等
echo "<script>alert('修改学生成功!');location='zhuye.php';</script>";
} else {
echo "<script>alert('修改学生失败!');location='xiugai.php?id={$id}';</script>";
}