Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 带第三方登录的用户表如何设计

带第三方登录的用户表如何设计

WBOY
Release： 2016-06-06 20:29:21
Original
1985 people have browsed it

带第三方登录的用户表怎么设计比较合理？比如使用QQ登录，可以获得QQ的昵称，随后用户还可以修改昵称等，这样的用户表怎么设计比较合理？

回复内容：

带第三方登录的用户表怎么设计比较合理？比如使用QQ登录，可以获得QQ的昵称，随后用户还可以修改昵称等，这样的用户表怎么设计比较合理？

用户表多添加一个openID字段，附上图一张。第三方登陆流程
带第三方登录的用户表如何设计

用户建个表,存id，昵称啥的
第三方id建个表，拿用户id做映射

第一次登入的时候提供昵称修改以及头像默认设置
而且获取了用户token后自然而然的就可以随时通过token来获取QQ用户那里的相关，所以在用户表加个token，openid和时间记录获取token生成时间来判断是否需要重新获取就行了吧

把openid直接存用户表就可以，多个第三方登陆都存用户表就可以，只是用户绑定第三方的一个属性而已

Related labels：
php
source：php.cn
Previous article：如何正确的设计类和应用类？ Next article：sublime text 3 目录怎么不显示文件夹 图标?
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template