Access to OpenID and user information

How to Share

Access to user information through the interface is mainly divided into the following steps:

A. Obtaining the access_token of the public number

B. Get all users by querying all user OpenID interfaces.

String url = "https://api.weixin.qq.com/cgi-bin/user/get?access_token=" + access_token;

C, by acquiring user OpenID, and then using OpenID to obtain user data

D. Add user information to the database.

1. Parameterized queries and adding user information to database methods

Press CTRL + C to copy the codepublic void Addtodatabase (Userjson userInfo) {using (SqlConnection conn = new SqlConnection (connstrings ) {Conn. Open (); OpenID, subscribe, nickname, sex, language, city, province, country, Headimgurl, Subscribetime, remark= ""; String cmdtext = @ "INSERT into UserInfo values (@openid, @subscribe, @nickname, @sex, @language, @city, @prov Ince, @country, @headimgurl, @subscribetime, @remark) "; SqlCommand cmd = new SqlCommand (CMDTEXT, conn); Cmd. Parameters.addwithvalue ("@openid", Userinfo.openid); Cmd. Parameters.addwithvalue ("@subscribe", userinfo.subscribe); Cmd. Parameters.addwithvalue ("@nickname", userinfo.nickname); Cmd. Parameters.addwithvalue ("@sex", userinfo.sex); Cmd. Parameters.addwithvalue ("@language", userinfo.language); Cmd. Parameters.addwithvalue ("@city", userinfo.city); Cmd. ParameteRs. AddWithValue ("@province", userinfo.province); Cmd. Parameters.addwithvalue ("@country", userinfo.country); Cmd. Parameters.addwithvalue ("@headimgurl", Userinfo.headimgurl); Cmd. Parameters.addwithvalue ("@subscribetime", userinfo.subscribe_time); Cmd. Parameters.addwithvalue ("@remark", Userinfo.remark); int res = cmd. ExecuteNonQuery (); } }Press CTRL + C to copy the code

2. Get user data via OpenID call interface

 Publicvoid GetUserInfo (StringOpenID) {String url ="https://api.weixin.qq.com/cgi-bin/user/info?access_token= " " &lang=zh_cnstring result = HttpGet (URL, ); // JSON deserialized to object JavaScriptSerializer serializer = new JavaScriptSerializer (); Userjson UserInfo = serializer. Deserialize<userjson> 

3. Get all OpenID

  String url ="https://api.weixin.qq.com/cgi-bin/user/get?access_token=                 "+ Access_token; string openidlist = HttpGet (URL, ); List<string> list = new List<string> (); JavaScriptSerializer serializer = new JavaScriptSerializer (); Userlistjsonresult result = serializer. Deserialize<userlistjsonresult>// Userlistjsonresult result = Jsonhelper.getobjfromjson<userlistjsonresult> ( openidlist)               

Access to OpenID and user information