//设置页面内容是html编码格式是utf-8
header("Content-Type: application/json;charset=utf-8");
require_once 'mysql.function.php';
//判断如果是get请求,则进行搜索;如果是POST请求,则进行新建
//$_SERVER是一个超全局变量,在一个脚本的全部作用域中都可用,不用使用global关键字
//$_SERVER["REQUEST_METHOD"]返回访问页面使用的请求方法
if ($_POST["check"] == 1) {
search();
} elseif ($_POST["check"] == 2){
create();
}
//搜索密码信息
function search(){
$sqlhelper = new sqlhelper();
//检查是否有密码的参数
//isset检测变量是否设置;empty判断值为否为空
//超全局变量 $_GET 和 $_POST 用于收集表单数据
if (!isset($_POST["number"]) || empty($_POST["number"])) {
//$res = '{"success":false,"msg":"参数错误"}';
$result = array ('success'=>false,'msg'=>"北鼻,填写的暗语不能为空哦~" );
echo json_encode($result);
return;
}
//global 关键词用于访问函数内的全局变量
//获取number参数
$number = $_POST["number"];//获取密码
//寻找密码
$sql1 = "SELECT * FROM `wanan` WHERE `wxPassword` = '$number'";
// $res = mysql_query($sql1);
// $result_type = MYSQL_ASSOC;
//$row=mysql_fetch_array($res,$result_type);
$row = $sqlhelper->fetchone($sql1);//寻找密码对应的数据库的内容
$wxWord = $row['wxWord'];
//输出对应的文字
if($row['wxPassword']!= NULL)
{ //$result = '{"success":true,"msg":"' . $wxWord . '"}';
$result = array ('success'=>true,'msg'=>$wxWord );
}
else{
//$result = '{"success":false,"msg":"北鼻,没有找到文字哦~"}';
$result = array ('success'=>false,'msg'=>"北鼻,没有找到文字哦~" );
}
echo json_encode($result);
}
//创建密码
function create(){
$sqlhelper = new sqlhelper();
//判断信息是否填写完全
if (!isset($_POST["id"]) || empty($_POST["id"])
|| !isset($_POST["password"]) || empty($_POST["password"]))
{
//echo '{"success":false,"msg":"北鼻,暗语信息填写不全哦"}';
$result = array ('success'=>false,'msg'=>"北鼻,暗语信息填写不全哦~" );
echo json_encode($result);
return;
}
if(!isset($_POST["word"]) || empty($_POST["word"]))
{
//echo '{"success":false,"msg":"北鼻,内容不能为空哦~"}';
$result = array ('success'=>false,'msg'=>"北鼻,内容不能为空哦~" );
echo json_encode($result);
return;
}
//TODO: 获取POST表单数据并保存到数据库
//密码重复
$id =$_POST["id"];
$password = $_POST["password"];
$word = $_POST["word"];
$sql = "SELECT * FROM `wanan` WHERE `wxPassword` = '$password'";
/*
$rest = mysql_query($sql);
$result_type = MYSQL_ASSOC;
$row1 = mysql_fetch_array($rest,$result_type);
*/
$row1 = $sqlhelper->fetchone($sql);//寻找密码对应的数据库的内容
$sql1 = "SELECT * FROM wanan WHERE TO_DAYS( wxTime ) = TO_DAYS( NOW( ) ) AND wxId = '$id'";
// $result2 = mysql_query($sql1);
//$a= mysql_num_rows($result2);
$a = $sqlhelper->getResultNum($sql1);
$m = mb_strlen($password,'utf8');//统计字数
$n = mb_strlen($word,'utf8');//统计文本字数
if($m>6){
//echo '{"success":false,"msg":"北鼻,创建的暗语不能超过6位的呢~"}';
$result = array ('success'=>false,'msg'=>"北鼻,创建的暗语不能超过6位的呢~" );
}
else if ( !preg_match("/^[\x{4e00}-\x{9fa5}a-zA-Z0-9_]+$/u",$password))
{
//echo '{"success":false,"msg":"北鼻,创建的暗语存在异常字符呢~"}';
$result = array ('success'=>false,'msg'=>"北鼻,创建的暗语存在异常字符呢~" );
}
else if($n>=101)
{
//echo '{"success":false,"msg":"北鼻,创建的暗语不能超过100个哦~"}';
$result = array ('success'=>false,'msg'=>"北鼻,创建的暗语不能超过100个哦~" );
}
/*
else if($a>=10)
{
//echo '{"success":false,"msg":"北鼻,创建失败,你已超出当天可创建暗语数量哦~"}';
$result = array ('success'=>false,'msg'=>"北鼻,创建失败,你已超出当天可创建暗语数量哦~" );
}
*/
else if($row1)
{
//echo '{"success":false,"msg":"北鼻,暗语被占用了呢~"}';
$result = array ('success'=>false,'msg'=>"北鼻,暗语被占用了呢~" );
}
else{
$sql = "INSERT INTO wanan (`id`, `wxId`, `wxPassword`, `wxWord`) VALUES (NULL, '$id', '$password', '$word')";
$result = mysql_query($sql);
// echo '{"success":true,"msg":"北鼻,暗语:' . $password . ' 信息保存成功了呢!"}';
$result = array ('success'=>true,'msg'=>"信息保存成功了呢!~" );
}
echo json_encode($result);
}
?>
一键复制
编辑
Web IDE
原始数据
按行查看
历史