Jump to content

Help me please!!


parino_esquilado

Recommended Posts

Ok, so my name is James, and I am creating a MySQL database for my ICT project. I started learning php last week, and have no clue where to go with MySQL, I do have phpMyAdmin however.

 

I am obviously new to using MySQL and php, and would appreciate if I could have some help along the way. I am not here to ask people to do anything for me, cause I know how rude that is, and it is for school, so I do need to do it for myself.

 

For my school project I need to create a website for a fitness center. The website will be used by a receptionist and they will register users, staff and add fitness classes via this website. I will be using WAMP in order to create this.

 

There need to be three tables: 'Members', 'Trainers' and 'Classes'. For the 'Members' table I need the following fields to be present:

 

'memberid', 'forename', 'middlename', 'dob', 'gender', 'address1', 'address2', 'citytown', 'postcode', 'telno', 'email' and finally 'class'. The 'class' field will need to be linked to the 'Classes' table obviously.

 

The 'Trainers' table will require the same fields as the 'Members' table, with the exception of 'memberid' becoming 'trainerid'.

 

And now the 'Classes' table will require the following:

 

'classid', 'classtype', 'classday', 'classstarttime', 'classendtime', 'classcost'.

 

 

The relationship between the tables will need to be as follows:

 

Trainers ---> Classes <--- Members (both 'Trainers' and 'Members' need to link.

 

Please, I don't have a clue where to begin! Help?! I am trying to get this done by the end of the week. Could someone help me please?

 

Thanks, James

 

Link to comment
https://forums.phpfreaks.com/topic/185908-help-me-please/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.