Joke Collection Website - Public benefit messages - SMS verification code in php

SMS verification code in php

Self-growing id

mobile phone number

Code verification code

Add_time generation time

Status Usage Status: 1 means used, 0 means unused, and the default value is 0.

The above is the simplest structure, and it should be enough not to be complicated. Add_time can be used to determine whether it has expired, and status can be used to determine whether it has been used. If you resend the verification code, the previous record will be deleted. If the verification code is used for multiple functions, get a type field to distinguish these functions.