微信小程序实现获取用户信息并存入数据库操作示例
微信小程序获取用户信息简单，但是在存入自己服务器数据库的过程中研究了一天多的时间，并且网上搜索不到该资源，故发出来供大家参考。
index.js
SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。 ?| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 | Page({ data: { nickName: "微信账号登录" , avatarUrl: "./user-unlogin.png" , }, onLoad: function () { var that = this ; var nickName = that.data.nickName ; var avatarUrl = that.data.avatarUrl; var db= "no" ; wx.getUserInfo({ success: function (res) { that.data.nickName = res.userInfo.nickName, that.data.avatarUrl = res.userInfo.avatarUrl, that.setData({ nickName: that.data.nickName, avatarUrl: that.data.avatarUrl, }), that.setData({ db: "ok" // 设置变量db，只有成功获取用户信息后才写入数据库 }) if (db = "ok" ) { var name, url; wx.request({ url: 'https://.../getuserinfo.php' ,//写自己的服务器 header: { "Content-Type" : "application/x-www-form-urlencoded" }, method: "POST" , data: { name: res.userInfo.nickName, url: res.userInfo.avatarUrl, }, success: function () { console.log( "success" ) }, fail: function () { console.log( "fail" ) } }) } }, fail: function (res) { that.data.nickName = "未授权无法获取用户信息" , that.setData({ nickName: that.data.nickName }) } }) }, onShow: function () { } }) |
getuserinfo.php
?| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | <?php $name = $_POST [ 'name' ]; $url = $_POST [ 'url' ]; $servername = "localhost" ; $username = "root" ; $password = "" ; //服务器中连接数据库的密码 $dbname = "mydb" ; //使用的数据库名 // 创建连接 $conn = new mysqli( $servername , $username , $password , $dbname ); // 检测连接 if ( $conn ->connect_error) { die ( "connect server fail: " . $conn ->connect_error); } $sql = "INSERT INTO userinfo VALUES ( '$name' , '$url' )"; if ( $conn ->query( $sql ) === TRUE) { echo "insert success" ; } else { echo "Error: " . $sql . "<br>" . $conn ->error; } $conn ->close(); ?> |
测试通过，在服务器中查询有用户信息
更多精彩
