master

分支 (1)

管理

管理

master

software
/
Adminedit.php


<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>编辑</title>
    <link rel="stylesheet" href="css/bootstrap.min.css">

    <script src="js/jquery-3.3.1.min.js" type="text/javascript"></script>
    <script src="js/bootstrap.min.js" type="text/javascript"></script>
    <link rel="stylesheet" type="text/css" href="css/header2.css" />
    <link rel="stylesheet" href="css/Adminedit.css">
    <!--    <link rel="stylesheet" type="text/css" href="css/footer.css" />-->

    <style type="text/css">


    </style>
</head>
<body>
<?php
include("header2.php");
if(isset($_GET['kind']))
{
    $kind=$_GET['kind'];
}else{
    //未知访问
    exit();
}

include_once ("./conn.php");
if($kind=="editmajor")
{
    $majorid=$_GET['majorid'];
    $sql="select * from major where majorid='$majorid'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    $row=mysqli_fetch_assoc($result);
    ?>
    <section class="secright sec03" >
        <div class="table-title">
            <h3>专业管理 - 编辑</h3>
            <hr/>
        </div>
        <form name="f1" action="Admineditserver.php" method="post">
            <input type="hidden" name="action" value="editmajor" >
            <input type="hidden" name="majorid" value="<?=$row['majorid']?>" >
            <table>
                <tr>
                    <td>专业号:</td>
                    <td><?=$row['majorid']?></td>
                </tr>
                <tr>
                    <td>就读专业:</td>
                    <td><input type="text" id="majorname" name="majorname" value="<?=$row['majorname']?>"></td>
                </tr>

                <tr>
                    <td>学分限制:</td>
                    <td><input type="number" id="creditlimit" name="creditlimit" value="<?=$row['creditlimit']?>"></td>
                </tr>

                <tr>
                    <td><a href="javascript:history.back(-1)">
                            <input type="button" name="returnback" value="返回">
                        </a></td>
                    <td><a class="savepms">
                            <input type="submit" name="save" value="保存修改">
                        </a></td>
                </tr>
            </table>
        </form>
    </section>

    <?php


}
else if($kind=="editstudent")
{
    $username=$_GET['username'];
    $sql="select * from accounts as a,major as m where a.majorid=m.majorid and a.username='$username'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    $row=mysqli_fetch_assoc($result);
    $gender=array('男','女');
    date_default_timezone_set("PRC");//消除时差
    $birthday=date("Y-m-d",(int)$row['birthday']);
    ?>
    <section class="secright sec03" >
        <div class="table-title">
            <h3>学生管理 - 编辑</h3>
            <hr/>
        </div>
        <form name="f2" action="Admineditserver.php" method="post">
            <input type="hidden" name="action" value="editstudent" >
            <input type="hidden" name="username" value="<?=$row['username']?>" >
            <table>
                <tr>
                    <td>就读专业:</td>
                    <td><?php echo $row['majorname']; ?></td>
                </tr>
                <tr>
                    <td>入学年份:</td>
                    <td><?php echo $row['enteryear']; ?></td>
                </tr>
                <tr>
                    <td>性别:</td>
                    <td><input type="text" id="gender" name="gender" value="<?php echo $gender[$row['gender']]; ?>"></td>
                </tr>

                <tr>
                    <td>真实姓名:</td>
                    <td><input type="text" id="realname" name="realname" value="<?php echo $row['realname']; ?>"></td>
                </tr>
                <tr>
                    <td>邮箱:</td>
                    <td><input type="email" id="email" name="email" value="<?php echo $row['email']; ?>"></td>
                </tr>
                <tr>
                    <td>出生日期:</td>
                    <td><input type="date" id="birthday" name="birthday" value="<?php echo $birthday; ?>"</td>
                </tr>
                <tr>
                    <td>身份证号:</td>
                    <td><input type="text" id="identity" name="identity" value="<?php echo $row['identity']; ?>"></td>
                </tr>
                <tr>
                    <td>现住址:</td>
                    <td><input type="text" id="address" name="address" value="<?php echo $row['address']; ?>"></td>
                </tr>
                <tr>
                    <td>手机号码:</td>
                    <td><input type="number" id="tel" name="tel" value="<?php echo $row['tel']; ?>"></td>
                </tr>

                <tr>
                    <td><a href="javascript:history.back(-1)">
                            <input type="button" name="returnback" value="返回">
                        </a></td>
                    <td><a class="savepms">
                            <input type="submit" name="save" value="保存修改">
                        </a></td>
                </tr>
            </table>
        </form>
    </section>

    <?php


}
else if($kind=="editteacher"){
    $teacherid=$_GET['teacherid'];
    $sql="select * from teacher where teacherid='$teacherid'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    $row=mysqli_fetch_assoc($result);
    ?>
    <section class="secright sec03" >
        <div class="table-title">
            <h3>教师管理 - 编辑</h3>
            <hr/>
        </div>
        <form name="f3" action="Admineditserver.php" method="post">
            <input type="hidden" name="action" value="editteacher" >
            <input type="hidden" name="teacherid" value="<?=$row['teacherid']?>" >
            <input type="hidden" name="introduceid" value="0" >
<!--            这个是介绍文件教师暂时不开放-->
            <table>
                <tr>
                    <td>教师号:</td>
                    <td><?=$row['teacherid']?></td>
                </tr>
                <tr>
                    <td>教师名字:</td>
                    <td><input type="text" id="teachername" name="teachername" value="<?=$row['teachername']?>"></td>
                </tr>


                <tr>
                    <td><a href="javascript:history.back(-1)">
                            <input type="button" name="returnback" value="返回">
                        </a></td>
                    <td><a class="savepms">
                            <input type="submit" name="save" value="保存修改">
                        </a></td>
                </tr>
            </table>
        </form>
    </section>

    <?php
}
else if($kind=="editcourse")
{
    $courseid=$_GET['courseid'];
    $sql="select * from course as c,introduce as i where c.introduceid=i.introduceid and courseid='$courseid'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    $row=mysqli_fetch_assoc($result);
    ?>
    <section class="secright sec03" >
        <div class="table-title">
            <h3>课程管理 - 编辑</h3>
            <hr/>
        </div>
        <form name="f5" action="Admineditserver.php" enctype="multipart/form-data" method="post">
            <input type="hidden" name="action" value="editcourse" >
            <input type="hidden" name="courseid" value="<?=$row['courseid']?>" >
            <input type="hidden" name="introduceid" value="<?=$row['introduceid']?>" >
            <input type="hidden" name="picnameinfile" value="<?=$row['picnameinfile']?>" >
            <input type="hidden" name="introducenameinfile" value="<?=$row['introducenameinfile']?>" >
            <table>
                <tr>
                    <td>课程号:</td>
                    <td><?=$row['courseid']?></td>
                </tr>
                <tr>
                    <td>当前选修人数:</td>
                    <td><?=$row['nowpeople']?></td>
                </tr>
                <tr>
                    <td>选修人数限制:</td>
                    <td><input type="number" id="numpeople" name="numpeople" value="<?=$row['numpeople']?>"></td>
                </tr>
                <tr>
                    <td>课程名字:</td>
                    <td><input type="text" id="coursename" name="coursename" value="<?=$row['coursename']?>"></td>
                </tr>
                <tr>
                    <td>任课教师号:</td>
                    <td><input type="number" id="teacherid" name="teacherid" value="<?=$row['teacherid']?>"></td>
                </tr>
                <tr>
                    <td>课程学分:</td>
                    <td><input type="number" id="credit" name="credit" value="<?=$row['credit']?>"></td>
                </tr>
                <tr>
                    <td>课程类别:</td>
                    <td>
                        <select  name="kind">
                            <option  value="1" <?php if($row['kind']==1)echo 'selected = "selected"'; ?>>专业选修</option>
                            <option  value="2" <?php if($row['kind']==2)echo 'selected = "selected"'; ?>>通识选修</option>
                            <option  value="3" <?php if($row['kind']==3)echo 'selected = "selected"'; ?>>技能选修</option>
                        </select>
                    </td>
                </tr>
                <tr>
                    <td>当前封面:</td>
                    <td><?=$row['picname']?></td>
                </tr>
                <tr>
                    <td>更换封面:</td>
                    <td>
                        <p>图片(建议比例：660*480)：</p>
                        <p><input id="file1" name="file1" type="file" accept="image/png,image/jpg,image/jpeg,image/gif,image/bmp"></p>
                        <p><img id="preview" src="courselib/pic/<?=$row['picnameinfile']?>?f=<?php echo mt_rand(100,900); ?>"></p>

                    </td>
                </tr>
                <tr>
                    <td>课程简介文本:<br>(255字节限制)</td>
                    <td>
                        <textarea rows="3" cols="20" name="introducetext" id="introducetext"><?=$row['introducetext']?></textarea>

                    </td>
                </tr>
                <tr>
                    <td>当前课程介绍文件:</td>
                    <td><?=$row['introducename']?></td>
                </tr>

                <tr>
                    <td>更换课程介绍文件:</td>
                    <td>
                        <p>文件(zip)：</p>
                        <p><input id="file2" name="file2" type="file"></p>
                        <p><a target="_blank" href="Courseintroduce.php?src=0&title=介绍文件说明书">什么是课程介绍文件？</a></p>

                    </td>
                </tr>


                <tr>
                    <td><a href="javascript:history.back(-1)">
                            <input type="button" name="returnback" value="返回">
                        </a></td>
                    <td><a class="savepms">
                            <input type="submit" name="save" value="保存修改">
                        </a></td>
                </tr>
            </table>
        </form>
    </section>
    <script>
    // 选择文件上传控件
    var file = document.querySelector('#file1');
    // 选择图片控件
    var preview = document.querySelector('#preview');
    // 当用户选择完文件以后
    file.onchange = function(){
    // 创建文件读取对象
    var reader = new FileReader();
    // 在文件上传控件中有一个 files 属性，代表用户选择的文件列表，files[0] 表示第一个文件
    // 如果加了 multiple 属性上传多个文件的话，files[1] 就是第二个文件，files[2] 就是第三个文件 ...
    // 读取文件
    reader.readAsDataURL(this.files[0]);
    // 监听onload事件
    reader.onload = function(){
    // 将文件读取的结果显示在页面中
    preview.src=reader.result;
    }
    }
    </script>

    <?php
}
else if($kind=="editadpic")
{
    $adid=$_GET['adid'];
    $sql="select * from adpic where adid='$adid'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    $row=mysqli_fetch_assoc($result);
    ?>
    <section class="secright sec03" >
        <div class="table-title">
            <h3>首页轮播图广告管理 - 编辑</h3>
            <hr/>
        </div>
        <form name="f5" action="Admineditserver.php" enctype="multipart/form-data" method="post">
            <input type="hidden" name="action" value="editadpic" >
            <input type="hidden" name="adid" value="<?=$row['adid']?>" >
            <input type="hidden" name="picnameinfiles" value="<?=$row['picnameinfiles']?>" >
            <table>
                <tr>
                    <td>轮播图编号:</td>
                    <td><?=$row['adid']?></td>
                </tr>
                <tr>
                    <td>排序权重:</td>
                    <td>
                        <p>(数值越大排序越前)</p>
                        <p><input type="number" id="sequence" name="sequence" value="<?=$row['sequence']?>"></p>
                    </td>
                </tr>
                <td>跳转url:</td>
                <td>
                    <p>(课程详情链接跳转格式->  Courseintroduce.php?courseid=课程号)</p>
                    <p>(站外网站跳转->如:  https://www.baidu.com/)</p>
                    <p><input style="width: 400px" type="text" id="tourl" name="tourl" value="<?=$row['tourl']?>"></p>
                </td>

                <tr>
                    <td>当前轮播图:</td>
                    <td><?=$row['picname']?></td>
                </tr>
                <tr>
                    <td>更换轮播图:</td>
                    <td>
                        <p>选择一张图片作为新的轮播广告图(建议比例：1000*350)：</p>
                        <p><input id="file1" name="file1" type="file" accept="image/png,image/jpg,image/jpeg,image/gif,image/bmp"></p>
                        <p><img style="width: 500px;height: 175px;" id="preview"src="adpic/pics/<?=$row['picnameinfiles']?>?f=<?php echo mt_rand(100,900); ?>"></p>

                    </td>
                </tr>


                <tr>
                    <td><a href="javascript:history.back(-1)">
                            <input type="button" name="returnback" value="返回">
                        </a></td>
                    <td><a class="savepms">
                            <input type="submit" name="save" value="保存修改">
                        </a></td>
                </tr>
            </table>
        </form>
    </section>
    <script>
        // 选择文件上传控件
        var file = document.querySelector('#file1');
        // 选择图片控件
        var preview = document.querySelector('#preview');
        // 当用户选择完文件以后
        file.onchange = function(){
            // 创建文件读取对象
            var reader = new FileReader();
            // 在文件上传控件中有一个 files 属性，代表用户选择的文件列表，files[0] 表示第一个文件
            // 如果加了 multiple 属性上传多个文件的话，files[1] 就是第二个文件，files[2] 就是第三个文件 ...
            // 读取文件
            reader.readAsDataURL(this.files[0]);
            // 监听onload事件
            reader.onload = function(){
                // 将文件读取的结果显示在页面中
                preview.src=reader.result;
            }
        }
    </script>

    <?php
}


?>

<?php
$link->close();
?>
</body>
</html>