PHP 设置考试计划

cha.php

<title>考试系统</title>
<style type="text/css">
.a{
    width:100%;
    height:110%;
    background:linear-gradient(to right, #396BD5 0%, #FFF 190%);
    position:absolute;
min-height:600px;
      min-width:1300px;
    
    }
    *{
        margin:0;
        padding:0}
.beijing
{
    position:absolute;
    top:0px;
    left:0px;}
.biaoti
{
    position:absolute;
    top:80px;
    left:120px;}

.n1
{
    padding-top:100px;
    padding-left:130px;
}
.but
{
    padding-top:80px;
    padding-left:880px;
    font-size:20px;
}
</style>
</head>
<?php
    session_start();
    include("../../config/DBDA.php");
    $db=new DBDA();
    
    if(empty($_SESSION["uid"]))
    {
        header("location:login.php");
        exit;
    }
    
    //查询考试计划表中的所有数据,并按时间降序排列
    $splan="select * from kaoshiplan order by time desc";
    $aplan=$db->Query($splan);
?>
<body  style=" min-height:600px; min-width:1300px;">
<div class="a"> 
<div class="beijing">
<img src="../../未标题-1.png" width="100%" height="35%"  style="min-height:197px; min-width:1300px;"/> 
<div class="biaoti"><img src="../../标题1.png" width="100%" height="100%" /></div>
    <div class="n1">
        <table border="0" cellpadding="0" cellspacing="0" width="1000px" style="font-size:22px">
            <tr height="50px" align="center" style="font-weight:bold">
                <td>考试信息名称</td>
                <td>接收班级</td>
                <td>发布者姓名</td>
                <td>发布时间</td>
                <td>操作</td>
            </tr>
            <?php
                foreach($aplan as $vplan)
                {
                    //处理考试信息名称
                    $peid=$vplan[1];
                    $eeid="select etilte from exeminfo where eid='{$peid}' ";
                    $eid=$db->StrQuery($eeid);
                        
                    //处理班级名称
                    $pclasscode=$vplan[2];
                    $cclasscode="select classname from class where code='{$pclasscode}'";
                    $classcode=$db->StrQuery($cclasscode);
                    
                    //处理发布者姓名
                    $padmin=$vplan[3];
        
                    $uadmin="select name from users where uid='{$padmin}'";
                    $admin=$db->StrQuery($uadmin);
                    
                    //查出发布时间
                    $time=$vplan[4];
                    
                    echo"
                        <tr height='30px' align='center'>
                            <td>{$eid}</td>
                            <td>{$classcode}</td>
                            <td>{$admin}</td>
                            <td>{$time}</td>
                            <td><a href='gai.php?pid={$vplan[0]}'>修改</a>&nbsp&nbsp;<a href='shan.php?pid={$vplan[0]}'>删除</a></td>
                        </tr>";
                }
            ?>
                    </table>
                <div class="but"><a href='zeng.php'>添加考试计划</a></div>
        </div>   
    </div>
</div>

shan.php

<?php
include("../../config/DBDA.php");
$db=new DBDA();

$pid = $_GET["pid"];

$sshan = "delete from kaoshiplan where pid='{$pid}'";
var_dump($sshan);
$shan= $db->StrQuery($sshan,0);
if($shan)
{
    header("location:cha.php");
}
else
{
    echo "删除失败！";
}

zeng.php

<title>考试系统</title>
<style type="text/css">
.a{
    width:100%;
    height:110%;
    background:linear-gradient(to right, #396BD5 0%, #FFF 190%);
    position:absolute;
min-height:600px;
      min-width:1300px;
    
    }
    *{
        margin:0;
        padding:0}
.beijing
{
    position:absolute;
    top:0px;
    left:0px;}
.biaoti
{
    position:absolute;
    top:80px;
    left:120px;}

.n1
{
    padding-top:150px;
    padding-left:350px;
    font-size:22px;
}
.but
{
    padding-top:15px;
    padding-left:250px;
}
</style></head>
<?php
    session_start();
    include("../../config/DBDA.php");
    $db=new DBDA();
    
    if(empty($_SESSION["uid"]))
    {
        header("location:login.php");
        exit;
    }    
?>
<body style=" min-height:600px; min-width:1300px;">
<div class="a"> 
<div class="beijing">
<img src="../../未标题-1.png" width="100%" height="35%"  style="min-height:197px; min-width:1300px;"/> 
<div class="biaoti"><img src="../../标题1.png" width="100%" height="100%" /></div>
    <div class="n1">
<form action="../../chuli/fyy/zengchuli.php" method="post"> 
<?php
        $uid=$_SESSION["uid"];
?>
<div>请选择考试信息名称
    <select name="name" style="width:60px; height:25px; font-size:15px">
        <?php
            $sname="select * from exeminfo";
            $name=$db->Query($sname);
            foreach($name as $vname)
            {
                echo"<option value='{$vname[0]}'>{$vname[1]}</option>";
            }
        ?>
    </select>
</div><br />
<div>请选择接收班级
    <select name="class" style="width:60px; height:25px; font-size:15px">
        <?php
            $sclass="select * from class";
            $class=$db->Query($sclass);
            foreach($class as $vclass)
            {
                echo"<option value='{$vclass[0]}'>{$vclass[1]}</option>";
            }
        ?>
    </select>
</div><br />
<div class="but"><input type="submit" value="添加" style="width:60px; height:25px; font-size:15px"/></div>
</form>
        </div>
    </div>
</div>

zengchuli.php

<?php
session_start();
include("../../config/DBDA.php");
$db=new DBDA();

$name=$_POST["name"];
$class=$_POST["class"];
$admin=$_SESSION["uid"];
$time=date("YmdHis");

$szeng="insert into kaoshiplan values('','{$name}','{$class}','{$admin}','{$time}')";
$zeng = $db->Query($szeng,0);

if($zeng)
{
    header("location:../../module/fyy/cha.php");
}
else
{
    echo "添加失败！";
}

gai.php

<title>考试系统</title>
<style type="text/css">
.a{
    width:100%;
    height:110%;
    background:linear-gradient(to right, #396BD5 0%, #FFF 190%);
    position:absolute;
min-height:600px;
      min-width:1300px;
    
    }
    *{
        margin:0;
        padding:0}
.beijing
{
    position:absolute;
    top:0px;
    left:0px;}
.biaoti
{
    position:absolute;
    top:80px;
    left:120px;}

.n1
{
    padding-top:150px;
    padding-left:350px;
    font-size:22px;
}
.but
{
    padding-top:15px;
    padding-left:250px;
}
</style>
</head>
<?php
    session_start();
    include("../../config/DBDA.php");
    $db=new DBDA();
    
    if(empty($_SESSION["uid"]))
    {
        header("location:login.php");
        exit;
    }
    @$pid=$_GET["pid"];
    
     $splan = "select * from kaoshiplan where pid='{$pid}'";
    $plan = $db->query($splan); 
    @$vid=$plan[0][0];
?>
<body style=" min-height:600px; min-width:1300px;">
<div class="a"> 
<div class="beijing">
<img src="../../未标题-1.png" width="100%" height="35%"  style="min-height:197px; min-width:1300px;"/> 
<div class="biaoti"><img src="../../标题1.png" width="100%" height="100%" /></div>
    <div class="n1">
<form action="../../chuli/fyy/gaichuli.php" method="post">
    <?php
            
            $uid=$_SESSION["uid"];
    ?>
    <div><input name="pid" type="hidden" value="<?php echo $vid ?>"/></div>
    <div>请选择考试信息名称
        <select name="name" style="width:60px; height:25px; font-size:15px" >
            <?php
                
                $sname="select * from exeminfo";
                $name=$db->Query($sname);
                foreach($name as $vname)
                {
                        if($vname[0] == $plan[0][1])
                    {
                        echo "<option selected='selected' value='{$vname[0]}'>{$vname[1]}</option>";
                    }
                    else
                    {
                        echo"<option value='{$vname[0]}'>{$vname[1]}</option>";
                    }    
                }
            ?>
        </select>
    </div><br />
    <div>请选择接收班级
        <select name="class" style="width:60px; height:25px; font-size:15px">
            <?php
                $sclass="select * from class";
                $class=$db->Query($sclass);
                foreach($class as $vclass)
                {
                        if($vclass[0] == $plan[0][2])
                    {
                        echo "<option selected='selected' value='{$vclass[0]}'>{$vclass[1]}</option>";
                    }
                    else
                    {
                        echo"<option value='{$vclass[0]}'>{$vclass[1]}</option>";
                    }    
                }
            ?>
         </select>
    </div><br />
    <div class="but"><input type="submit" value="修改" style="width:60px; height:25px; font-size:15px" /></div>
</form>
        </div>
    </div>
</div>

gaichuli.php

<?php
session_start();
include("../../config/DBDA.php");
$db=new DBDA();

$pid=$_POST["pid"];
$name = $_POST["name"];
$class = $_POST["class"];
$time=date("YmdHis");
$admin=$_SESSION["uid"];

$szeng="Update kaoshiplan set eid='{$name}',classcode='{$class}',admin='{$admin}',time='{$time}' where pid='{$pid}';";

$zeng= $db->query($szeng,0);

if($zeng)
{
    header("location:../../module/fyy/cha.php");
}
else
{
    echo "修改失败！";
}

posted @ 2016-07-14 11:42 Yao1101 阅读(141) 评论(0) 编辑收藏举报

Yao1101

PHP 设置考试计划

公告