时间:2021-07-01 10:21:17 帮助过:5人阅读
分享到:
退选课题
//######################退选课题界面3##########################
include "config.php";
include "header.php";?>
extract($_POST);
$query="select * from $student_table where xuehao='".$xuehao."'";
mysql_query("set names 'GB2312'");
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$id=$row['id'];
$query1="select number as sn,surplus as ssn from $jiaoshi_table where id='$id'";
mysql_query("set names 'GB2312'");
$result1=mysql_query($query1);
$row1=mysql_fetch_array($result1);
if($row1['sn']==1)
{
$query2=mysql_query("update $jiaoshi_table set xuehao='未选' where id='$id'");
$query3=mysql_query("update $jiaoshi_table set surplus=surplus+1 where id='$id'");
}
else
{
if(($row1['sn']-$row1['ssn'])==1)
$query7=mysql_query("update $jiaoshi_table set xuehao='未选' where id='$id'");
else
$query6=mysql_query("update $jiaoshi_table set xuehao=replace(xuehao,concat('".$xuehao."','\n'),'') where id='$id'");
$query8=mysql_query("update $jiaoshi_table set surplus=surplus+1 where id='$id'");
$query5="update $student_table set id=0 where xuehao='".$xuehao."'";
mysql_query("set names 'GB2312'");
$result5=mysql_query($query5);
if($result5==true)
{
echo"退选课题成功!";
echo "";
exit;
}
else
{
echo"退选出错,请返回重新退选
";
echo "";
exit;
}
}
?>