📄 hyadd.php
字号:
<?php
require_once('conn.php');
session_start();
$a=$_POST['a'];
$b=$_POST['b'];
$c=$_POST['c'];
if ($_SESSION['web']=="system")
{
$myname="sys".$a.$b.$c;
}
ELSE
{
$myname="hy".$a.$b.$c;
}
$pass=$_POST['pass'];
$pass2=$_POST['pass2'];
if ($pass!=$pass2 or empty($pass))
{
echo "<script>confirm('两次输入密码不一样!');history.go(-1);</script>";
Exit;
}
$mc=$_POST['mc'];
$dh=$_POST['dh'];
$edu=$_POST['edu'];
if (empty($edu))
{
echo "<script>confirm('信用额度不能少于1000!');history.go(-1);</script>";
Exit;
}
if ($edu<1000)
{
echo "<script>confirm('信用额度不能少于1000!');history.go(-1);</script>";
Exit;
}
$yx="有效";
$sj=date("Y-m-d", time());
//判断会员是否注册过
if ($_SESSION['web']=="system") {
$exec="SELECT * from hy2 where name='".$myname."'";
} ELSE {
$exec="SELECT * from hy3 where name='".$myname."'";
}
mysql_query("set names gbk");
$resu=mysql_query($exec);
if($rs=mysql_fetch_object($resu))
{
header("Location: home.php");
Exit;
}
if ($_SESSION['web']!="system") {
//获取用户额度总数
$exec="SELECT * from hy3 where hy2='".$_SESSION['web']."' order by id";
mysql_query("set names gbk");
$resu=mysql_query($exec);
while($rs=mysql_fetch_object($resu))
{
$exec2="SELECT * from edu where name='".$rs->name."'";
mysql_query("set names gbk");
$resu2=mysql_query($exec2);
$rs2=mysql_fetch_object($resu2);
$eduz=$eduz+$rs2->edu;
}
$eduz=$eduz+$edu;
//判断额度是否超出
$exec="SELECT * from edu where name='".$_SESSION['web']."'";
mysql_query("set names gbk");
$resu=mysql_query($exec);
$rs=mysql_fetch_object($resu);
if ($eduz>$rs->edu)
{
echo "<script>confirm('你的信用额度不足.');history.go(-1);</script>";
exit;
}
}
//添加会员
if ($_SESSION['web']=="system") {
$exec="insert into hy2 (name,pass,mc,dh,hy,yx,sj) values ('".$myname."','".$pass."','".$mc."','".$dh."','".$_SESSION['web']."','".$yx."','".$sj."')";
} ELSE {
$exec="insert into hy3 (name,pass,mc,dh,hy2,yx,sj) values ('".$myname."','".$pass."','".$mc."','".$dh."','".$_SESSION['web']."','".$yx."','".$sj."')";
}
mysql_query("set names gbk");
mysql_query($exec);
//添加帐号
$exec="insert into edu (name,edu,yu,qi) values ('".$myname."','".$edu."','".$edu."','#')";
mysql_query("set names gbk");
mysql_query($exec);
//添加退水
$s=$_POST['s'];
$s2=explode("\n",$s);
for ($i=0;$i<count($s2);$i++)
{
$sj=explode(";",$s2[$i]);
$exec="insert into s (name,s,dz,dc,zg,c,c2) values ('".$myname."','".$sj[1]."','".$sj[2]."','".$sj[3]."','".$sj[4]."','".$sj[5]."','".$sj[6]."')";
mysql_query("set names gbk");
mysql_query($exec);
}
header("Location: home.php");
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -