How PHP avoids duplicate redemption codes in a lottery

How PHP handles duplicate redemption codes in a lottery
To do a lottery, design the table:
Prize table option:
OID Prize ID
Name Prize name

Redemption Code Table code:
OID Prize ID
Code Redemption Code
Status is used 0: unused 1: Used

Now you can add a duplicate redemption code, and the Redemption code will be wrapped in a text box.


How to deal with the status of the Code table when editing prizes and prizes, and if you have the same code, you cannot update the code set Status=1 where Code= ' {$code} ' directly.

Share to:

------Solution--------------------
If $code is a multi-line redemption code
Then you can
$code = Join (', ', Preg_split ("/[\r\n]+/", $code));
Processed into a comma-delimited string of redemption codes
When used
where code in ($code)
Can

