无法实现数据的插入
也没有错误的提示
想问问是哪里错了
<?php
session_start();
if(isset($_POST['ok']))
{
$username = $_POST['username'];
$passwords = $_POST['passwords'];
$repasswords = md5($_POST['repasswords']);
$telephone = $_POST['telephone'];
$email = $_POST['email'];
$address = $_POST['address'];
$coded = $_POST['code'];
$regdate = date('Y-m_d',time());
// $rs = findUserByUserName($username);
//创建连接
$mysqli=new mysqli("localhost","root","","lg_shop");
//设置mysqli编码
mysqli_query($mysqli,"SET NAMES gb2312");
//检查连接是否被创建
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
//创建准备语句
if($stmt=$mysqli->prepare("insert into lg_user (username,password,email,address,telephone,regdate)values(?,?,?,?,?)")){
$stmt->bind_param("sssss",$username,$password,$email,$address,$telephone,$regdate);
$stmt->execute();
$stmt->bind_result($username,$username,$password,$telephone,$address,$email);
if($stmt->fetch()){
echo "<script>alert('用户名已存在,请重新填写!')</script>";
echo "<script>location='regsiter.php'</script>";
}
//写入数据库
else{
//检查验证码
if($_SESSION["identifying"] == $coded)
{
/**
$isok = mysql_query($sql) or die(mysql_error());//这时候可以直观的显示是否是sql语句报错
*/
$sql = addUser($username,$repasswords,$email,$address,$telephone,$regdate);//调用函数,新增用户
if($sql == 1){
echo "<script>alert('注册成功!')</script>";
echo "<script>location='index.php'</script>";
}
else{
echo "<script>alert('注册失败,请重新填写!')</script>";
echo "<script>location='regsiter.php'</script>";
}
}
else{
echo "<script>alert('验证码错误!')</script>";
echo "<script>location='regsiter.php'</script>";
}
}
}
}
//判断用户是否存在
?>
```