<?php
require '../include/smarty.inc.php';
require '../include/mysql.inc.php';session_start();
$u_name=@$_POST['u_name'];
$u_pwd=@$_POST['u_pwd'];
$u_pwd_check=@$_POST['u_pwd_check'];
$e_mail=@$_POST['e_mail'];
$u_phone=@$_POST['u_phone'];
$u_add=@$_POST['u_add'];
$u_yzm=@$_POST['u_yzm'];
$part='^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$';//email正则
$tel_part="^13[0-9]{9}|15[0-9]{8}$";//手机号码正则
if($u_pwd==$u_pwd_check)
{
if($u_yzm <> $_SESSION['code'])
{
echo ("<script type='text/javascript'>alert('验证码错误');history.back();</script>");
exit();
}
else
{

if(@eregi($part,$e_mail))
{
if(@eregi($tel_part,$u_phone) )
{
$sql="insert into user values";
$sql.="(null,'$u_name',md5('$u_pwd'),'$e_mail','$u_phone','$u_add',now())";
$admindb->execSQL($sql, $conn);
$sql='select * from user';
$users=$admindb->execSQL($sql, $conn);
$tpl->assign('users',$users);
$tpl->display('file:F:/wamp/www/shop/templates/index.tpl');
$a=2;

}
else
{

echo ("<script type='text/javascript'>alert('手机号码格式错误');history.back();</script>");
exit();
}
}
else
{
echo ("<script type='text/javascript'>alert('邮箱错误');history.back();</script>");
exit();
}
}
}
else 
{
echo ("<script type='text/javascript'>alert('两次输入的密码必须相同');history.back();</script>");
exit();
}每次刷新都会执行一次sql语句,请问各位如何解决这个问题