大家来帮我看看这个短信注册接口是那里有问题?
<?php
/**
* 短信注册文件
*
* @
*/
error_reporting(0);
include("config.php");
$con=mysql_connect($host_ip,$host_name,$host_pw);
mysql_select_db($host_table,$con);
$data=mysql_fetch_array(mysql_query("SELECT * FROM baqi_config_data WHERE action='smsmm'"));
define('SMS_KEY',$data['value']); //接口钥匙
$sql=mysql_connect($host_ip,$host_name,$host_pw);
mysql_select_db($host_table, $sql);
mysql_query("set names 'utf8'");
date_default_timezone_set("PRC");
$date = date("Y-m-d H:i:s ");
$smskey = isset($_REQUEST['smskey'])?$_REQUEST['smskey']:null;
$phone = isset($_REQUEST['phone'])?$_REQUEST['phone']:null;
$content = isset($_REQUEST['message'])?$_REQUEST['message']:null;
$smskey==SMS_KEY or die('2');
$pass=substr($phone,-6);
if(stripos($content,'#')){
$content = explode('#',$content);
$pass = $content[1];
}
$name = 'new'.substr($phone,-4);
$user_sql=mysql_query("SELECT * FROM baqi_user_data WHERE tel='".$phone."'");
$row=mysql_fetch_assoc($user_sql);
if($row['user']==$phone){
$sql="UPDATE baqi_user_data SET pw='".$pass."' WHERE user='".$phone."'";
if(mysql_query($sql)){
die("11");
}else{
die("22");
}}else{
$sql="SELECT * FROM baqi_config_data WHERE action='sgb'";
$sgb=mysql_fetch_array(mysql_query($sql));
$sql="insert into baqi_user_data(userid,user,pw,sid,name,money,mtime,ltime,tel,vip,vtime,qdtime,qdcount,tjcount,ggcount,ggtime,mail,weather,hmd) values('0','".$name."','".$pass."','','".$name."','".$sgb['value']."','','".$date."','".$phone."','0','0','0','0','0','0','".$date."','','','0')";
if(mysql_query($sql)){
die("1");
}else{
die("22");
}}
?>
@命运,
$row=mysql_fetch_assoc($user_sql);
改为:
$row=mysql_fetch_array($user_sql);