PHP Project - TennisPlanner [Guidance Request]

[danTheWalker]

Hi Everyone

 

I'm Dan, Ive recently been assigned the task of producing an online app that will allow a collection of tennis players to log in using a single user log-in (this is to simplify it for them) and to select a radio button corresponding to a time, a row of buttons for each player in a table. allowing the users to easily visit the page and see who will be playing at what time.

This will be displayed for the Friday of every week and additional expansion is to include functionality to move between weeks and set status for say every Friday for the entire year and if a players status is still set to null then to send them an email prompting them to update their status plus telling them who is playing when.

 

My problem is I have very little experience programming in PHP and am just scratching the surface.

 

The way in which I have it planned so far is to have:

 

a Tennis Planner db(database)

 

a players table containing each players name, a unique ID (and possibly time var?)

 

In the confusion of my understanding however I'm at a loss as to whether the right way to go would be creating a new table for each date which will then store a value for each players time variable which can be stored and retrieved to display the relative setting for each player or ??just lost here?

 

The way i intend to handle the time setting conundrum is simply set this time variable for each player to an int between 0 and 7, each corresponding to a array of values as follows:

 

Time | Value

 

null = 0

4.30 = 1

4.45 = 2

5.00 = 3

5.15 = 4

5.30 = 5

5.45 = 6

6.00 = 7

 

And using a function to update this page table with the correct radio button settings.

 

Then when a player logs in and changes it they hit submit and the new variable settings for that date are stored.

 

All this is all a bit of a jumble in my mind however and I'm just doing my best for a novice level

 

I'm not a completely novice programmer, i have a stable understanding of OOP concepts, plus I have a deeper understanding of ECMA scripts from AS2 and the foundation seems pretty similar from what I can tell so far however what I would most like is if someone can hit me up on any of the IM's and talked to me a little more fluently about the whole think.

 

Any help, guidance and/or advice is much appreciated

 

Thanks in advance

 

Daniel Walker

[JD*]

If I were designing this, I would have three tables:

 

1 for players, which would have an ID and name

1 for tables/courts, which would have an ID and name/number

1 for registrations, which would hold the playerID(s), tableID(s) and date

 

I'm assuming that someone besides the player will be entering the data, as if everyone is logging in with the same account you won't have an easy way of letting them enter their own data. And that every friday has one available time for each table only?

 

Either way, it would wind up working that when a person enters the site, the database would be queried this way:

 

Query the tables/courts so we can see all of them

For each table, query the schedule so we can see who is playing and when. If empty, display nothing, else display a name above and below a table graphic.

 

On clicking the radio button, enter the player's name into the database for the specific date (another set of information either on the main page, or a sub-page for making the reservation). Then shoot out a confirm email.

 

If you'd like more advise on it, let me know in either this thread or a PM and I'll be more than happy to help