php学生信息管理后台系统

<?php $sid=$_GET['sid']; if(!$sid) jump('home.php?id=4'); $info=select('student','id',$sid); if($info['sex']=='m') $info['sex']='男'; else $info['sex']='女'; //////////////////////////////// //进行删除操作 if($_GET['del']){ $del=$_GET['del']; $did=$_GET['did']; if($del==1){ $sql="delete from `change` where `id`='$did' limit 1"; $DB->query($sql); }elseif($del==2){ $sql="delete from `reward` where `id`='$did' limit 1"; $DB->query($sql); }elseif($del==3){ $sql="delete from `punishment` where `id`='$did' limit 1"; $DB->query($sql); } } if($_GET['tf']){ $tf=$_GET['tf']; $sql="UPDATE `punishment` set `enable`='F' where `id`='$tf' limit 1"; $DB->query($sql); } $change=get_xinfo('change','student',$sid); $reward=get_xinfo('reward','student',$sid); $punishment=get_xinfo('punishment','student',$sid); ?> <h2><span><?=WEBNAME?></span>基本信息修改——<?=$info['name']?> 【学号：<?=$info['id']?>】</h2> <div class="info textc"> <div style="padding:25px 50px;text-align:left;"> <div class="key"> <strong class="xr"><?=$info['name']?>基本信息：</strong> <br/> <p style="font-size:14px;margin-top:10px;"> <b>姓名:</b><?=$info['name']?>&nbsp; <b>学号:</b><?=$info['id']?>&nbsp; <b>性别:</b><?=$info['sex']?>&nbsp; <b>学院:</b><?php $x=get_dename($info['department']);echo $x['name'];?> <b>班级:</b><?=get_classname($info['class'])?> <b><a href="home.php?id=6&sid=<?=$sid?>">&raquo;修改基本信息</a></b> </p> </div> <?php if($change!=1){ ?> <h3 class="l">&raquo;该生<font color="#FF0000">学籍变更信息</font></h3> <div class="last"> <p style="font-weight:bold;background:#ccc;"> <span style="width:120px;border-right:1px solid #777;">变更名称</span> <span style="width:120px;border-right:1px solid #777;">记录时间</span> <span style="width:450px;border-right:1px solid #777;">描述信息</span> <span style="width:120px;">相关操作</span> </p> <?php $i=0; foreach ($change as $v){ if($i%2==1) $q='style="background:#efefef;"'; ?> <p <?=$q?>> <span style="width:120px;border-right:1px solid #777;"><?=get_code(1,$v['change']+1)?></span> <span style="width:120px;border-right:1px solid #777;"><?=$v['rec_time']?></span> <span style="width:430px;border-right:1px solid #777;padding:0 5px 0 15px;text-align:left;"><?=$v['description']?></span> <span style="width:120px;"> <a href="home.php?id=5&sid=<?=$sid?>&del=1&did=<?=$v['id']?>">&raquo;删除</a>&nbsp;&nbsp; <a href="home.php?id=1&change=yes&cid=<?=$v['id']?>" target="_blank">&raquo;修改</a> </span> </p> <?php $q=''; $i++; } ?> </div> <?php } ?> <?php if($reward!=1){ ?> <h3 class="l">&raquo;该生<font color="#FF0000">获得奖励信息</font></h3> <div class="last"> <p style="font-weight:bold;background:#ccc;"> <span style="width:120px;border-right:1px solid #777;">变更名称</span> <span style="width:120px;border-right:1px solid #777;">记录时间</span> <span style="width:450px;border-right:1px solid #777;">描述信息</span> <span style="width:120px;">相关操作</span> </p> <?php $i=0; foreach ($reward as $v){ if($i%2==1) $q='style="background:#efefef;"'; ?> <p <?=$q?>> <span style="width:120px;border-right:1px solid #777;"><?=get_code(2,$v['levels']+1)?></span> <span style="width:120px;border-right:1px solid #777;"><?=$v['rec_time']?></span> <span style="width:430px;border-right:1px solid #777;padding:0 5px 0 15px;text-align:left;"><?=$v['description']?></span> <span style="width:120px;"> <a href="home.php?id=5&sid=<?=$sid?>&del=2&did=<?=$v['id']?>">&raquo;删除</a>&nbsp;&nbsp; <a href="home.php?id=2&change=yes&cid=<?=$v['id']?>" target="_blank">&raquo;修改</a> </span> </p> <?php $q=''; $i++; } ?> </div> <?php } ?> <?php if($punishment!=1){ ?> <h3 class="l">&raquo;该生<font color="#FF0000">受到惩罚信息</font></h3> <div class="last"> <p style="font-weight:bold;background:#ccc;"> <span style="width:120px;border-right:1px solid #777;">变更名称</span> <span style="width:120px;border-right:1px solid #777;">记录时间</span> <span style="width:420px;border-right:1px solid #777;">描述信息</span> <span style="width:150px;">相关操作</span> </p> <?php $i=0; foreach ($punishment as $v){ if($i%2==1) $q='style="background:#efefef;"'; if($v['enable']=='F'){ $echo1='<font color="#CC0000" style="text-decoration:underline;"><small>(已解除)</small></font>'; }else{ $echo2='<a href="home.php?id=5&sid='.$sid.'&tf='.$v["id"].'">&raquo;解除</a>&nbsp;&nbsp;'; } ?> <p <?=$q?>> <span style="width:120px;border-right:1px solid #777;"><?=get_code(3,$v['levels']+1)?><?=$echo1?></span> <span style="width:120px;border-right:1px solid #777;"><?=$v['rec_time']?></span> <span style="width:400px;border-right:1px solid #777;padding:0 5px 0 15px;text-align:left;"><?=$v['description']?></span> <span style="width:150px;"> <?=$echo2?> <a href="home.php?id=5&sid=<?=$sid?>&del=3&did=<?=$v['id']?>">&raquo;删除</a>&nbsp;&nbsp; <a href="home.php?id=3&change=yes&cid=<?=$v['id']?>" target="_blank">&raquo;修改</a> </span> </p> <?php $q=''; $i++; } ?> </div> <?php } ?> </div> </div>