PHP Suggestion, need sports web site CMS

[smk17]

I'm wondering if anyone can tell me if this is possible or if I'm just dreaming.

 

I run a website dedicated to Section 4 basketball in New York State. There are 70 teams, divided up into 5 different leagues.

 

I keep their schedules and I also try to enter the scores of their games and enter those on their schedule page. But, with so many games each night of the week (Varisty and JV) I'm finding it close to impossible to keep up. I have to manually enter these scores twice for each game. One on Team A's page, and one on Team B's page.

 

Is there a system I could set up with php that would give me a basic entry page. I enter the schools' names, the date, and the score, and that is automatically entered on their schedule's page with a W or L next to the scores. So I am only entering the scores once for each game, and let php divide that data onto the correct teams schedule page. And making php recognize if that team won or lost.

 

Best case scenario would be to have volunteers from across section 4 be able to enter these scores on a web page for their league or division, even more lessening the load on me.

 

I know there are a few PHP Sports Content Management systems out there, but it seems writing my own would be better.

 

As you have guessed I'm quite new to php. Thanks for any help, I'm not looking for anyone to write this for me, just looking to see if this is possible and maybe a nudge in the right direction.

 

The site is section4hoops.com. There is no php on this site, it's all html.

[gevans]

Well, a system like that is definetly a reachable goal.

 

What I'd recomend is to first have a user management system put in plae, that way you (or someone else) would have to login in to add any information (scores).

 

You'd need to restructure the fixtures (or equivalent page) to run of a database which is where the scores 'could' be kept.

 

When you update the database with new scores the site will pull the details out and update the site.

[.josh]

Yes it is possible.  Don't know if there are any prefab scripts out there though.  How are you storing old data?  Are you just updating your page manually each time, and previous data is just lost?  Or are you like, copy/pasting previous page to a new page, and changing the numbers, so you have like, a million copies of the same page but with different data, as time goes on?

 

If you are absolutely completely new to php then I suggest googling a "hello world" tutorial and working your way through basic syntax, conditions, loops, etc...  If you know the basics, you can start with breaking the habit of making a whole new page on each update.  You will need to learn some basic database handling to do that. 

[smk17]

Yes I'm updating the page manually each time, but not writing over anything, just adding to it. Here's one example:

 

section4hoops.com/pop/iac_schedules_08/candor_s.htm

 

Although, there is a new page for each year. I've been doing this for 3 years.

 

Now I manually type in the score, the W or L, and then the JV score. I have started going through several tutorials and am very interested in it and wish I started many years ago.

 

 

 

[smk17]

Okay, let me make sure I have the basic structure of what will happen here, or what I want to happen.

 

1. User (person who has volunteered to enter game scores) will log on to a web page.

2. The interface he sees will let him enter the scores from the games that he is responsible for. I'm assuming this will be a form that when sent will fill up rows of a database?

3. When people then view the schedule page for that team, those scores from that row will have been automatically placed in the right spot.

 

Would I need to make a separate table for each team in the database? I'm guessing yes.

 

 

[gevans]

What I'd recommend is having a table for the teams...

 

id -> a unique id for every team

team -> the name of the team

 

Then for your scores use another table

 

id -> a unique id for every score

team_id -> the id matching the coresponding team

score -> the score

success - > win or lose (if needed)

 

You can have more of a play with the table structure, that's just my thoughts from what I've seen so far.