求推荐较好的数据库编程源码网站
做数据库编程也有半年多了,一直都在按照自己的想法写代码,没有机会接触高水准的代码,现在意识到自己写的东西可能很麻烦或者差劲。所以希望能够多了解一下他人的好一些的代码,但自己是在校学生,平日接触的东西也有限。所以希望大家能够不吝指教,推荐几个关于数据库编程源码的网站,最好是MYSQL的。还有,像QQ等软件的权限管理及用户数据加密是如何实现的呢?求指教!谢谢!
回复讨论(解决方案)
其实我要实现的功能大致就相当于本论坛的功能,如何高效地管理这么大量的数据呢?请求大神指点 一个较好的案例供参考
等回复啊等回复
对了,咱天朝也有个很火的 discuz论坛 ,也是php的。
“像QQ等软件的权限管理及用户数据加密是如何实现的呢?”
mysql自己带了 md5,password等加密方式。moodle这个平台用的就是MD5。而QQ这种,肯定有很多个加密方式共同组成,甚至有自己开发的加密算法,sa证书(完全个人瞎猜)
权限,最简单的不就是数据库里的一个值嘛。0代表什么,1代表什么.
查看mysql本身的user表:
| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv |
看到各种权限,Y就是有这个权限,N就是没有。
对了,咱天朝也有个很火的 discuz论坛 ,也是php的。
“像QQ等软件的权限管理及用户数据加密是如何实现的呢?”
mysql自己带了 md5,password等加密方式。moodle这个平台用的就是MD5。而QQ这种,肯定有很多个加密方式共同组成,甚至有自己开发的加密算法,sa证书(完全个人瞎猜)
权限,最简单的不就是数据库里的一个值嘛。0代表什么,1代表什么……
嗯,简单的加密做了一些,但是复杂的用户权限自己做的方法就感觉太麻烦了,想看一下别人的实现。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Alipay PHP...

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

The application of SOLID principle in PHP development includes: 1. Single responsibility principle (SRP): Each class is responsible for only one function. 2. Open and close principle (OCP): Changes are achieved through extension rather than modification. 3. Lisch's Substitution Principle (LSP): Subclasses can replace base classes without affecting program accuracy. 4. Interface isolation principle (ISP): Use fine-grained interfaces to avoid dependencies and unused methods. 5. Dependency inversion principle (DIP): High and low-level modules rely on abstraction and are implemented through dependency injection.

How to automatically set the permissions of unixsocket after the system restarts. Every time the system restarts, we need to execute the following command to modify the permissions of unixsocket: sudo...

How to debug CLI mode in PHPStorm? When developing with PHPStorm, sometimes we need to debug PHP in command line interface (CLI) mode...

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

Sending JSON data using PHP's cURL library In PHP development, it is often necessary to interact with external APIs. One of the common ways is to use cURL library to send POST�...

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.
