MySQL Forums
Forum List  »  PHP

Where to start for a new beginner
Posted by: Gwynn Zambello
Date: July 26, 2016 02:58PM

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

Options: ReplyQuote


Subject
Written By
Posted
Where to start for a new beginner
July 26, 2016 02:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.