php - Insert record into mysql with different id (by user ID)
one text
have this problem.
Have small web app. There are 10 users. Every user has own form and he must fill it every day. Inserting into mysql works fine. Problem is every user has his own numbering. YEAR-MONTH-CUSTOM-NUMBER
User 1: 202111121, 202111122, 202111103 etc
User 2: 202111221, 202111222, 202111203 etc
user 3: 202111321, 202111322, 202111303 etc
My question: how can I define inserting records via form for users into mysql? For example today User1 save html form so it'll insert record into mysql with id 202111121.
Today the same user will fill form again and he must insert record with id 202111122
etc. Thank you
Source