Where to start for a new beginner
I have built a page and now have to use a database to store information input from various users. My page is a scheduling tool where each user has a calendar of days where meetings can be scheduled (any range of days the user wants, and each day contains two sets of 48 segments of 15 minutes for AM/PM). So the 'type' for a 15 minute 'segment' can either be empty, pending, or meeting.
I have created 3 tables:
User Table with: user_id, user_name, email
Day Table with: user_id, date, day, segment, am/pm, meeting_id, meeting_type
Meeting Table with: meeting_id, user_id, date, segment, am/pm, invited, responded
How am I supposed to use php to store data here when a user chooses to schedule or attend a meeting, and retrieve data from here when a user opens the page and wishes to view their schedule? Generic Examples that I can translate to my context are great, or links to good places to start. Thank you