📄 mng_stu_add_unregister.php

📁 在实际教学应用中
💻 PHP
字号:
<?php session_start(); if(!$_SESSION['teacher']) {echo '<SCRIPT LANGUAGE="JavaScript">location.replace(\'mng.php\');</script>';exit;}?>
<html>
<head>
<title>EasyTeacher信息技术课堂教学助手(ItAssis)-分班浏览学生信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="et.css" rel="stylesheet" type="text/css">
<style type="text/css">
body,td,th {font-size: 14px;}
</style>
</head>
<body>

<?php
	include "config.inc.php";
	include "conn.inc.php";
	$db=Connect_db($CFG_DB_ADDRESS,$CFG_DB_PORT,$CFG_DB_NAME,$CFG_DB_OWNER,$CFG_DB_PWD);
		
	//添加学生名单到临时数据库中
	if(isset($_POST['data'])){
		$sql="DROP TABLE IF EXISTS tmp_stu";
		mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());

		$sql="CREATE TABLE IF NOT EXISTS tmp_stu(
				name char(20) not null,
				grade int unsigned,
				class int unsigned)
				TYPE=HEAP";
		mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());

		$line=split("\n",trim($_POST['data']));
		$line=preg_replace("/\s|　/","",$line);//去除字符间的空格
		
		$values="";
		while(list($key,$value)=each($line)){
			$data=split(",|，",$value);
			if(isset($data[1]))
				$values.="(\"$data[0]\",$data[1],$data[2]),";	
		}
		$values=substr($values,0,-1);//去除最后一个逗号，不然插入报错
		if($values=="") exit;

		$sql="INSERT INTO tmp_stu(name,grade,class) VALUES $values";
		mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
		
		$sql="SELECT name,grade,class FROM tmp_stu";
		$source=mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());

		echo 
			"<table width=740 align=center></div>
			<tr><td><div align=center>下面是即将插入数据库的学生记录:&nbsp;&nbsp;
			<a href=".$_SERVER['PHP_SELF']."?action=sure>确定</a>&nbsp;&nbsp;
			<a href=".$_SERVER['PHP_SELF']."?action=cancel>取消</a>
			</div></td></tr>";
		while($stu=mysql_fetch_array($source))
			echo "<tr><td><div align=center>".$stu['name']."&nbsp;&nbsp;".$stu['grade']."(".$stu['class'].")班</div></td></tr>";
		echo "</table>";
		exit;
	}

	//添加名单到未注册数据库中
	if(isset($_GET['action']) && $_GET['action']=="sure"){
		$sql="INSERT INTO unregiester(name,grade,class)";
		$sql.=" SELECT name,grade,class FROM tmp_stu";
		mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());

		$sql="DROP TABLE IF EXISTS tmp_stu";
		mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
		echo "名单添加成功！";
	}

	//删除临时数据库中学生名单
	if(isset($_GET['action']) && $_GET['action']=="cancel"){
		$sql="DROP TABLE IF EXISTS tmp_stu";
		mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
		echo "<p align=center>名单已撤消！</p>";
	}
?>
<table width="740"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30" background="images/top_bg.jpg"><div align="left">&nbsp;&nbsp;位于：<a href="mng_stu_list.php">已注册学生</a>&nbsp;&nbsp;<a href="mng_stu_mng_unregister.php">待注册学生</a>&nbsp;&nbsp;<strong class="red">添加名单</strong></div></td>
    <td width="100" background="images/top_bg.jpg"><div align="left">[<a href="#explain">说明</a>]</div></td>
  </tr>
</table>
<form name="form2" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  <table width="740"border="0" align="center">
    <tr>
      <td width="26%" height="208" align="right" valign="top" bgcolor="#F7F7F7"><p align="center">
        <textarea name="data" cols="16" rows="10"></textarea> 
        <p align="center">
          <input type=submit value=提交>
      </td>
      <td width="74%" bgcolor="#F5F5F5"><p><span class="explain_hight">每行数据格式：</span><span class="red">姓名,年级,班级</span><span class="explain_hight"> 数据间用</span><span class="red">逗号</span><span class="explain_hight">隔开，如下： </span>
          <p class="explain_hight"><strong>张三,1,1<br>
        李四,2,1 </strong></p>
          <p><span class="explain_hight">注意：<br>
        1）年级，班级必须用<strong>西文数字</strong>。<br>
        2）重名问题在学生注册时系统会自动处理。也可以提前处理。</span> </p></td>
    </tr>
  </table>
</form>

<table width="740" align="center">
  <tr>
    <td><div align="center"></div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<p></p>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -