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