Looking to allow users to build a database for a Sports site

Reply

Join Date: May 2009
Posts: 2
Reputation: powermxpx is an unknown quantity at this point 
Solved Threads: 0
powermxpx powermxpx is offline Offline
Newbie Poster

Looking to allow users to build a database for a Sports site

 
0
  #1
May 21st, 2009
Hi. Please forgive me if this is posted in the wrong section.

I'm starting a sports website and I'm hoping to have a section with each sports team that will display the team roster in a table format. Each player will have a line for their name, position, height, weight, and jersey number.

Here's the catch: Since sports teams are always changing, I am searching for an extension or script that will let my site visitors submit details about each player. Does anyone know of an extension or script that will work for this?

I am hoping to find something that will allow users to submit new records for sports teams. I want there to be a button they can click on, type the players name, height, weight, jersey number, and position, then hit submit and have it appear in an organized table format. It would be nice if before the post is made, the extension allow me to approve each record.

Thank you in advance for any help. Please let me know if I can be more clear.

Thanks!
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 952
Reputation: Airshow will become famous soon enough Airshow will become famous soon enough 
Solved Threads: 135
Airshow's Avatar
Airshow Airshow is offline Offline
Posting Shark

Re: Looking to allow users to build a database for a Sports site

 
0
  #2
May 21st, 2009
Powermxpx,

You will undoubtedly find snippets here and there to help, and if you're lucky you may find a tutoral with a worked example doing something similar. However, I expect you will pretty well have to build the application yourself from the ground up. And remember, you will need to develop the user interface, database, and the controlling logic (View, Model and Controller).

A word of warning before you start. Sports organisation guard facts and figures, possibly including those you mention, very jealously. At one time, I worked for a major sports web site, where just about every new idea passed through the legal department on its way from concept to realisation. Many seemingly good ideas were filtered out. Many classes of sports information that you (and I) may believe to be 100% public domain can prove not to be. Like it or not (like you I don't), commercial protection of information is big business in its own right, and sometimes ruthlessly enforced. Try republishing a football roster and see what happens! As I understand it, the extent to which these constraints apply to your venture may depend on which country the information originates (and to a lesser extent on the country you are in).

I'm a programmer, not a lawyer so I'm passing on what I know in general terms. I can't be more specific because I'm no expert. You may be OK but personally, I would seek legal advice before ebmbarking on cutting code.

Sorry to be negative.

Airshow
Reply With Quote Quick reply to this message  
Join Date: May 2009
Posts: 2
Reputation: powermxpx is an unknown quantity at this point 
Solved Threads: 0
powermxpx powermxpx is offline Offline
Newbie Poster

Re: Looking to allow users to build a database for a Sports site

 
0
  #3
May 21st, 2009
Airshow,

Thanks for the thorough reply. Also, thanks for your advice on the legal side of statistics--I hadn't even considered that. However, the type of site I'm looking to make should be fine as I'm not looking for stats from any of the major sports leagues.

If you happen to come across any type of PHP script or extension that I can install, I'd be grateful!

Thanks again for your kindness,

powermxpx

Originally Posted by Airshow View Post
Powermxpx,

You will undoubtedly find snippets here and there to help, and if you're lucky you may find a tutoral with a worked example doing something similar. However, I expect you will pretty well have to build the application yourself from the ground up. And remember, you will need to develop the user interface, database, and the controlling logic (View, Model and Controller).

A word of warning before you start. Sports organisation guard facts and figures, possibly including those you mention, very jealously. At one time, I worked for a major sports web site, where just about every new idea passed through the legal department on its way from concept to realisation. Many seemingly good ideas were filtered out. Many classes of sports information that you (and I) may believe to be 100% public domain can prove not to be. Like it or not (like you I don't), commercial protection of information is big business in its own right, and sometimes ruthlessly enforced. Try republishing a football roster and see what happens! As I understand it, the extent to which these constraints apply to your venture may depend on which country the information originates (and to a lesser extent on the country you are in).

I'm a programmer, not a lawyer so I'm passing on what I know in general terms. I can't be more specific because I'm no expert. You may be OK but personally, I would seek legal advice before ebmbarking on cutting code.

Sorry to be negative.

Airshow
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 952
Reputation: Airshow will become famous soon enough Airshow will become famous soon enough 
Solved Threads: 135
Airshow's Avatar
Airshow Airshow is offline Offline
Posting Shark

Re: Looking to allow users to build a database for a Sports site

 
0
  #4
May 21st, 2009
Cool, powermxpx.

I was attacked on amnother site once for giving similar advice. People just didn't want to believe they couldn't do just what they wanted with other people's data.

Airshow
Last edited by Airshow; May 21st, 2009 at 11:01 pm.
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 340
Reputation: SKANK!!!!! is an unknown quantity at this point 
Solved Threads: 3
SKANK!!!!!'s Avatar
SKANK!!!!! SKANK!!!!! is offline Offline
Posting Whiz

Re: Looking to allow users to build a database for a Sports site

 
0
  #5
May 24th, 2009
just make a form with out all the feields reqired and use the UPDATE mysql function or whatever its called or if u want to store more than one se of records for each team make multiple tables or databases and still use the UPDATE thing. its really easy to use.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:




Views: 588 | Replies: 4
Thread Tools Search this Thread



Tag cloud for Database Design
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2010 DaniWeb® LLC