微信小程序 将获取的用户数据存数据库

微信开发端的js文件:

const APP_ID = 'wx0843bxxxxxxxf6fc'; //输入小程序appid  
const APP_SECRET = '637e11bf3dxxxxxxxxx9f9b1ef5221'; //输入小程序app_secret  
var OPEN_ID = '' //储存获取到openid  
var SESSION_KEY = '' //储存获取到session_key 
Page({
  getOpenIdTap: function() {
    var that = this;
    wx.login({
      success: function(data) {
        console.log(data);
        wx.request({
          //获取openid接口
          url: 'https://api.weixin.qq.com/sns/jscode2session?appid=' + APP_ID + '&secret=' + APP_SECRET + '&js_code=' + data.code + '&grant_type=authorization_code',
          data: {},
          method: 'GET',
          success: function(res) {
            console.log(res.data)
            OPEN_ID = res.data.openid; //获取到的openid  
            SESSION_KEY = res.data.session_key; //获取到session_key  
            that.setData({
              openid: OPEN_ID,
              session_key: SESSION_KEY
            });
            wx.request({
              url: 'https://127.0.0.1/wx_test/test.php',//访问的接口地址
              data: {  //传的数据
                openid: OPEN_ID,
                session_key: SESSION_KEY
              },
              success: function() {

              }
            })
          }
        })
      }
    })
  }
})

php文件:

<?php
$openid = $_REQUEST['openid'];
$session_key = $_REQUEST['session_key'];

$db = new mysqli("localhost","root","","test");
!mysqli_connect_error() or die("数据库连接错误");
$date = date("Y-h-d H-i-s");
$sql = "insert into user (phone,openid,session_key,date) values('175****1175','$openid','$session_key','$date')";
$db->query($sql);

 

点击button后获取到的openid和session_key就可以存到数据库中了:

 

posted @ 2018-12-20 11:58  微笑范特西  阅读(7048)  评论(2编辑  收藏  举报