📄 addcet.php
字号:
<html>
<body>
<?
mysql_connect("localhost","jsjdj","jsjdj.2004") or die ("Problem connecting to DataBase");
$vnumber=$vnumber;
$vname=$vname;
$vgrade=$vgrade;
$vclass=$vclass;
$vsfid=$vsfid;
$vdepart=$vdepart;
$vdj=$vdj;
$vbj=$vbj;
$query="select xh from login where xh='$vnumber'";
$compare=mysql_db_query("jsjdj",$query);
if($s=mysql_fetch_array($compare))
{
if($vname&&$vnumber&&$vgrade)
{
$query="select count(*) from cet where xhid='$vnumber'";
$xhok=mysql_db_query("jsjdj",$query);
$renshu=mysql_fetch_array($xhok);
if($renshu[0]>0)
{
echo "<h2 align=center>您已报过名</h2>";
?><meta http-equiv="refresh" content="3;URL=addform.php"><a href="addform.php">页面2秒钟跳转至首页...</a><?
exit(0);}
if(strlen($vsfid)==15||strlen($vsfid)==18)
{$query="insert into cet(xhid,name,grade,class,sfid,depart,dj,bj) values('$vnumber','$vname','$vgrade','$vclass','$vsfid','$vdepart','$vdj','$vbj')";
$result=mysql_db_query("jsjdj",$query);
echo "<h2 align=center>您的报名信息已录入数据库</h2>";?>
<meta http-equiv="refresh" content="3;URL=addform.php"><a href="addform.php">页面2秒钟跳转至首页...</a><?}
else
{
echo "<h2 align=center>身份证位数为15位或18位!</h2>";?>
<meta http-equiv="refresh" content="2;URL=addform.php"><a href="addform.php">页面2秒钟跳转至首页...</a><?
}
}
else
{echo "对不起，您输入的信息不完整，请重新输入";
?><meta http-equiv="refresh" content="10;URL=addform.php"><a href="addform.php">页面2秒钟跳转至首页...</a><?}
}
else
{echo "<h2 align=center>抱歉，您无法报名，系统数据库中您的信息！</h1>";
?><meta http-equiv="refresh" content="2;URL=addform.php"><a href="addform.php">页面2秒钟跳转至首页...</a><?}
mysql_close();
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -