How to design an online seat selection system which can change seat information dynamically?

such as
now I want to design an online seat selection system
but when users sign up, they can dynamically edit unreserved seats in the background
how should I design it from the generation of seats to the final registration, seat selection and editing
?
I hope to give you some ideas.
by the way, we will discuss how to access the database.
Thank you!

Mar.07,2021

the seat and state storage of the core can be mapped to the php logic code using redis bitmaps
location

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b320f2-2b148.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b320f2-2b148.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?