I set up localhost on mac so I can locally test my php files:
I set up a user database for my registration/login
When users register to my site, their details are added to the user database. I have set the training difficulty field type to enum, so Beginner = 1, Intermediate = 2 and Advanced = 3. I have also added a sign up date field of type=timestamp. So when users log in, it pulls in their sign up date to determine what week they are currently on. All the training plans start on a Monday so if the users sign up date is not a Monday then the guide commences from the following Monday. The database also stores users access token from Strava’s API; when the user connects with Strava through the OAuth protocol, their token gets added to the database. This then allows me to pull in their personal Strava data in order to see if they have done enough miles to progress to the next week.
FEEDBACK: Originally, I was using MySQL statements to connect, select and update the databases. However, from feedback it was suggesting to look into Propel, an orm library. I installed propel using terminal and have used Propels Basic C.R.U.D operations.