微信小程序如何使用PHP语言获取数据
微信小程序如何使用PHP语言获取数据？在小程序后台配置好相应的后端请求地址，路径是：开发---->开发设置
成都小程序开发如果需要做多个小程序的打通，还需要在微信开放平台绑定到开发者账号下面， 如果不需要union_id请忽略
服务端准备一个用户授权的接口，假设接口链接为http://test.dev.com/user/authorization，此接口接受如下参数
code：微信登陆接口返回的登陆凭证，用户获取session_key
iv：微信小程序登陆接口返回的向量，用于数据解密
encrypted_data : 微信获取用户信息接口的返回的用户加密数据，用于后端的接口解析
signature加密数据
接口返回的数据如下
{
"errcode": 200,
"msg": "SUCCESS",
"data": {
"uid": 34098,
"unionid": "xxx",
}
}
6.建表
1）用户表，其中比较重要的字段是union_id，因为我们是有多个小程序和公众号，因此使用这个来区分唯一的用户编号
DROP TABLE IF EXISTS `jz_wxa_user`;
CREATE TABLE `jz_wxa_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` bigint(18) DEFAULT NULL,
`openid` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT 'openid',
`user_name` varchar(100) CHARACTER SET utf8mb4 DEFAULT '',
`nick_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户昵称',
`sex` enum('0','1') CHARACTER SET utf8 DEFAULT '1' COMMENT '性别',
`avatar` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户头像',
`province` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '省份',
`city` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '城市',
`country` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '国家',
`wx_union_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '公众平台的唯一id',
`from_url` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '来源url',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`from_appid` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT 'wx95fc895bebd3743b' COMMENT '来源appid',
`wx_header` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '微信头像',
`gh_openid` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '微信公众号openid',
`phone` varchar(30) CHARACTER SET utf8 DEFAULT '' COMMENT '手机号码',
PRIMARY KEY (`id`),
KEY `idx_uid_union_id` (`uid`,`wx_union_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
实现步骤
用户授权时序图
关键代码
小程序端
小程序端的获取用户信息流程
1）调用login方法获取code
2）调用getUserInfo方法获取用户的加密数据
3）调用后端的用户授权接口将用户信息保存到服务端
4）保存后端接口返回的uid和unionid到localstorage中，作为全局参数
获取用户的授权信息
getUid:function(cf){
var that = this
wx.login({
success: function (ress) {
var code = ress.code
wx.getUserInfo({
withCredentials: true,
success: function (res) {
that.globalData.userInfo = res.userInfo;
that.authorize(code, res.signature, res.iv, res.rawData, res.encryptedData, cf)
}
})
}
})
},
authorize: function (code, signature, iv, rawData, encryptedData, cf) {
var that =this
var dataobj = {
code: code,
signature: signature,
iv: iv,
raw_data: rawData,
encrypted_data: encryptedData
}
console.log("code:",code)
var param = JSON.stringify(dataobj)
param = that.Encrypt(param)
var url = that.data.API_DOMAIN2 + "/user/authorization?param=" + param
wx.request({
url: url,
method: "GET",
header: {
'content-type': 'application/json'
},
success: function (res) {
if (res.data.errcode == 200) {
wx.hideToast()
wx.setStorage({
key: "uid",
data: res.data.data.uid,
success: function () {
if (cf) {
typeof cf == "function" && cf(res.data.data.uid)
}
}
})
} else {
that.exceptionHandle('uid', url, res.data.errcode, res.data.msg)
}
}
})
},
服务端
入口方法
/**
* api接口开发
* 获取详情的接口
* @param $uid 用户编号
* @param $iv 向量
* @param $encryptedData 微信加密的数据
* @param $rawData 判断是否为今天
* @param $signature 签名
* @return array
*/
public static function authorization($appid,$appsecret,$code,$iv,$encryptedData,$rawData,$signature){
$result = self::decodeWxData($appid,$appsecret,$code,$iv,$encryptedData);
if($result['errcode'] != 200){
return $result;
}
//处理微信授权的逻辑
$wxUserData = $result['data'];
error_log("authorization data=============>");
error_log(json_encode($wxUserData));
$uid = WxaUserService::regWxaUser($wxUserData);
$data['uid'] = $uid['uid'];
$data['unionid'] = $uid['unionid'];
$result['data'] = $data;
return $result;
}
/**
* 解密微信的数据
* @param $code wx.login接口返回的code
* @param $iv wx.getUserInfo接口或者wx.getWeRunData返回的iv
* @param $encryptedData wx.getUserInfo接口或者wx.getWeRunData返回的加密数据
* @return array
*/
public static function decodeWxData($appid,$appsecret,$code,$iv,$encryptedData){
$sessionKeyUrl = sprintf('%s?appid=%s&secret=%s&js_code=%s&grant_type=authorization_code',config('param.wxa_user_info_session_key_url'),$appid,$appsecret,$code);
$rtnJson = curlRequest($sessionKeyUrl);
$data = json_decode($rtnJson,true);
error_log('authorization wx return data========>');
error_log($rtnJson);
if(isset($data['errcode'])){
return $data;
}
$sessionKey = $data['session_key'];
$wxHelper = new WxBizDataHelper($appid,$sessionKey,$encryptedData,$iv);
$data['errcode'] = 200;
$data['data'] = [];
if(!$wxData = $wxHelper->getData()){
$data['errcode'] = -1;
}else{
error_log('current wx return data is =========>'.json_encode($wxData));
$data['data'] = $wxData;
}
return $data;
}
保存用户信息的方法
/**
* 保存用户信息的方法
* @param $wxaUserData
* @param $regFromGh 表示是否从公众号进行注册
*/
public function regWxaUser($wxaUserData,$regFromGh = false)
{
$value = $wxaUserData['unionId'];
$key = getCacheKey('redis_key.cache_key.zset_list.lock') . $value;
$newExpire = RedisHelper::getLock($key);
$data = $this->storeWxaUser($wxaUserData,$regFromGh);
RedisHelper::releaseLock($key, $newExpire);
return $data;
}
/**
* 保存信息
* @param $wxaUserData
* @return mixed
*/
public function storeWxaUser($wxaUserData,$regFromGh = false)
{
$wxUnionId = $wxaUserData['unionId'];
if (!$user = $this->getByWxUnionId($wxUnionId)) {
$getAccountDataStartTime = time();
//这里是因为需要统一账户获取uid，所以这个是用户中心的接口，如果没有这个流程，则直接使用数据
if($accountData = AccountCenterHelper::regWxaUser($wxaUserData)){
$getAccountDataEndTime = time();
$accountRegTime = $getAccountDataEndTime - $getAccountDataStartTime;
error_log("reg user spend time is ===================>" . $accountRegTime);
$user = [
'uid' => $accountData['uid'],
'user_name' => $accountData['user_name'],
'nick_name' => $wxaUserData['nickName'],
'sex' => $accountData['sex'],
'wx_union_id' => $accountData['wx_union_id'],
'avatar' => isset($accountData['avatar'])?$accountData['avatar']:"",
'from_appid' => $accountData['from_appid'],
'province' => $wxaUserData['province'],
'city' => $wxaUserData['city'],
'country' => $wxaUserData['country'],
'openid' => $wxaUserData['openId'],
'wx_header' => isset($wxaUserData['avatarUrl'])?$wxaUserData['avatarUrl']:"",
'gh_openid' => $regFromGh?$wxaUserData['openId']:"",
];
error_log("insert data=============>" . json_encode($user));
$user = $this->store($user);
$regApiUserEndTime = time();
error_log(" reg api user spend time================>" . ($regApiUserEndTime - $getAccountDataEndTime));
error_log(" after insert data=============>" . json_encode($user));
}
}else{
if(!$user['wx_header']){
$updateData = [
'id' => $user['id'],
'uid' => $user['uid'],
'wx_header' => $wxaUserData['avatarUrl'],
];
$this->update($updateData);
}
//同步用户的openid
if($wxaUserData['openId'] != $user['openid']){
$updateData = [
'id' => $user['id'],
'uid' => $user['uid'],
'openid' => $wxaUserData['openId'],
];
$this->update($updateData);
}
}
$data['uid'] = $user['uid'];
$data['unionid'] = $wxUnionId;
return $data;
}
根据unionid获取用户信息
/**
* 根据unionid获取用户信息
*/
public function getByWxUnionId($unionId)
{
$cacheKey = getCacheKey('redis_key.cache_key.wxa_user.info') . $unionId;
$value = $this->remember($cacheKey, function () use ($unionId) {
$userInfo = WxaUser::where('wx_union_id', $unionId)->first();
$userInfo = $this->compactUserInfo($userInfo);
return $userInfo;
});
return $value;
}
WxBizDataHelper工具类
<?php
/**
* Created by PhpStorm.
* User: Auser
* Time: 11:17
*/
namespace App\Http\Base\Wx;
class WxBizDataHelper
{
private $appid;
private $seesionKey ;
private $encryptedData;
private $iv;
public function __construct($appid, $sessionKey,$encryptedData, $iv)
{
$this->appid = $appid;
$this->seesionKey = $sessionKey;
$this->encryptedData = $encryptedData;
$this->iv = $iv;
}
public function getData(){
$pc = new WXBizDataCrypt($this->appid, $this->seesionKey);
$json = '';
$errCode = $pc->decryptData($this->encryptedData, $this->iv, $json);
$data = [];
if ($errCode == 0) {
$data = json_decode($json,true);
}
return $data;
}
}
WXBizDataCrypt工具类
<?php
/**
* Created by PhpStorm.
* User: Auser
* Time: 10:38
*/
namespace App\Http\Base\Wx;
use App\Http\Base\Wx\Prpcrypt;
use App\Http\Base\Wx\ErrorCode;
use App\Http\Base\Wx\PKCS7Encoder;
class WXBizDataCrypt
{
private $appid;
private $sessionKey;
/**
* 构造函数
* @param $sessionKey string 用户在小程序登录后获取的会话密钥
* @param $appid string 小程序的appid
*/
public function __construct( $appid, $sessionKey)
{
$this->sessionKey = $sessionKey;
$this->appid = $appid;
}
/**
* 检验数据的真实性，并且获取解密后的明文.
* @param $encryptedData string 加密的用户数据
* @param $iv string 与用户数据一同返回的初始向量
* @param $data string 解密后的原文
*
* @return int 成功0，失败返回对应的错误码
*/
public function decryptData( $encryptedData, $iv, &$data )
{
if (strlen($this->sessionKey) != 24) {
return ErrorCode::$IllegalAesKey;
}
$aesKey=base64_decode($this->sessionKey);
if (strlen($iv) != 24) {
return ErrorCode::$IllegalIv;
}
$aesIV=base64_decode($iv);
$aesCipher=base64_decode($encryptedData);
$pc = new Prpcrypt($aesKey);
$result = $pc->decrypt($aesCipher,$aesIV);
if ($result[0] != 0) {
return $result[0];
}
$dataObj=json_decode( $result[1] );
if( $dataObj == NULL )
{
return ErrorCode::$IllegalBuffer;
}
if( $dataObj->watermark->appid != $this->appid )
{
return ErrorCode::$IllegalBuffer;
}
$data = $result[1];
return ErrorCode::$OK;
}
}
Prpcrypt工具类
<?php
/**
* Created by PhpStorm.
* User: Auser
* Time: 10:55
*/
namespace App\Http\Base\Wx;
class Prpcrypt
{
public $key;
public function __construct($key)
{
$this->key = $key;
}
/**
* 对密文进行解密
* @param string $aesCipher 需要解密的密文
* @param string $aesIV 解密的初始向量
* @return string 解密得到的明文
*/
public function decrypt($aesCipher, $aesIV)
{
try {
$module = mcrypt_module_open(MCRYPT_RIJNDAEL_128, '', MCRYPT_MODE_CBC, '');
mcrypt_generic_init($module, $this->key, $aesIV);
//解密
$decrypted = mdecrypt_generic($module, $aesCipher);
mcrypt_generic_deinit($module);
mcrypt_module_close($module);
} catch (Exception $e) {
return array(ErrorCode::$IllegalBuffer, null);
}
try {
$result = PKCS7Encoder2::decode($decrypted);
} catch (Exception $e) {
//print $e;
return array(ErrorCode::$IllegalBuffer, null);
}
return array(0, $result);
}
}
ErrorCode状态代码类
<?php
/**
* Created by PhpStorm.
* User: Auser
* Time: 10:33
*/
namespace App\Http\Base\Wx;
class ErrorCode
{
public static $OK = 0;
public static $IllegalAesKey = -41001;
public static $IllegalIv = -41002;
public static $IllegalBuffer = -41003;
public static $DecodeBase64Error = -41004;
}
