微信小程序wx.request（7）——登录注册

 我们假定云服务器为http://180.200.24.1:8080，接口为userinfo.php来实现登录功能，接口为adduser.php来实现注册功能,使用腾讯云数据库，内网地址为：172.15.0.2:3306，数据库结构如下：

    

       数据库的名字为testinfo，数据表为datatest

 

首先，我们来实现登录功能：

     userinfo.php

$username = $_GET["username"];
$password = $_GET["password"];
$conn = mysqli_connect("172.15.0.2", "root","********","testinfo");//连接MYSQL数据库
if(!$conn)
{
    die('Could not connect:' .mysql_error());
}
$sql1 = "SELECT password FROM datatest WHERE username='{$username}'";
$result1 = mysqli_query($conn, $sql1);
if($result1 == $password){
    echo "success";
}
else {
    echo "fail";
}

小程序端：

   index.js

   

wx.request({
   url:'http://180.200.24.1:8080/userinfo.php'
   data:{
      username:'zhangsan',
      password:'123'
   },
   header:{
          'content-type':'application/json'
   },
   method:'get',
   success:function(res){
        if(res.data == 'success'){
            console.log('login success')
            wx.navigateTo({
                url:'pages/index/index'
            })
        }
        else{
          console.log('login fail')
         }
   }
})

之后我们来进行注册功能：

       adduser.php

$id = $_GET["id"];
$username = $_GET["username"];
$password = $_GET["password"];
$conn = mysqli_connect("172.15.0.2", "root","*******","testinfo");//连接MYSQL数据库
if(!$conn)
{
    die('Could not connect:' .mysqli_error());
}
$sql1 = "SELECT password FROM datatest WHERE username='{$username}'";
$result1 = mysqli_query($conn, $sql1);
if($result1 != NULL){
    echo "registered";
}
else {
    $sql2 = "INSERT INTO userinfo (id,username,password) VALUES('{$id}','{$username}','{$password}')";
    $result2 = mysqli_query($conn, $sql2);
    echo "success";
}

小程序端：

   index.js

wx.request({
   url:'http://180.200.24.1:8080/adduser.php'
   data:{
      id:1,
      username:'kkkss',
      password:'123ds'
   },
   header:{
          'content-type':'application/json'
   },
   method:'get',
   success:function(res){
        if(res.data == 'success'){
            console.log('register success')
        }
        else{
          console.log('register fail')
         }
   }
})