该值未插入到数据库中
问题描述:
我想创建用于注册OTP验证的API。 OTP在移动设备上成功发送。但是用户的价值并没有被插入到数据库中。这是我的注册码。请帮助我我困在这。先谢谢了。该值未插入到数据库中
signup.php
<?php
include('config.php');
if(!empty($_POST['name']) &&
!empty($_POST['mobile']) &&
!empty($_POST['email']) &&
!empty($_POST['password'])
){
$name = $_POST['name'];
$mobile = $_POST['mobile'];
$email = $_POST['email'];
$password = $_POST['password'];
$str = mt_rand(100000, 999999);
$avalible_user_name="";
$avalible_user_email="";
$SQL= mysql_query("SELECT * FROM users WHERE mobile='".$mobile."' ");
while($row=mysql_fetch_array($SQL)){
$avalible_user_name=$row['mobile'];
}
$SQL= mysql_query("SELECT * FROM users WHERE email='".$email."' ");
while($row=mysql_fetch_array($SQL)){
$avalible_user_email=$row['email'];
}
if($avalible_user_name=="" && $avalible_user_email==""){
$SQLQUERY = mysql_query("INSERT INTO users SET
name = '" . $name."',
mobile = '" . $mobile."',
email = '" . $email."',
password = '" . md5($password)."',
otp = '".$str."',
status = 0 ");
$msg = "Your verification code:".$str.".";
$sms_text = str_replace(" ","%20",$msg);
$api_key = '2584909553545C';
$from = 'chkotp';
$api_url = "**My otp url**";
$response = file_get_contents($api_url);
die(json_encode(array("success"=>"true","message"=>"OTP sent to your mobile number please verify.")));
}else{
die(json_encode(array("success"=>"false","message"=>"Mobile or email all ready exits ")));
}
}else{
die(json_encode(array("success"=>"false","message"=>"Empty Parameters..!!")));
}
?>
答
你插入查询语法是错误的,
$new_pass = md5($password);
$SQLQUERY = mysql_query("INSERT INTO users(name, mobile, email, password) values('$name','$mobile','$email','$new_pass')");
我希望它能帮助。
没有支持代码的太多标签和mysqli标签对于这里使用的api有问题。 –
使用mysqli或pdo代替mysql –
是的,你已经添加连接到mysql-query funcion。 – MikeSouto