Question Locked

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

0 helpful
12 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

I want users to be able to add a record into a table from a web form. Here's how I'm hoping it will look: I want users to visit a team's page, then see a web form where they can enter in specific details for players. Once they complete the form, they will be able to hit the submit button, then it will be displayed in a table format.

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

Thanks!

12 replies

by cg it

Wiki site sounds like it would fit your needs.

by evan

Thanks for the suggestion, but do Wiki sites let users complete empty fields and submit them, then add them to a table? From what I've seen, I don't think Wiki sites can do this--but maybe I'm wrong.

Do you know?

Thanks again! :-)

by thumbsup2

WIKI allows users to submit stuff in form fields... you can OK the submission and allow the data to be stored in the database. It's the way you build your web pages that creates the table to be displayed using data retrieved from the database. So, you're going to have to design the database so there's an 'active' key somewhere and only pull the records for the players who are indeed still active.

Let me guess though... you're starting a web site and have no actual web design experience.... right? If you did have experience, you would have already known what I just explained above.

by evan

ThumbsUp2,

Thanks for your reply, there's certainly wisdom in what you have said, but the last part of your post comes across as being extremely arrogant.

I'm sorry if my question sounded ignorant to you. I do have web design experience, but the average website does not need the function I'm asking for. Also, there are sometimes extensions or plug-ins for the same thing that I'm trying to do (especially for CMS driven websites, like Joomla). The follow-up question I asked was related to Wiki type sites, which I'm not familiar with.

With that aside, thank you for your information, I truly appreciate it.

Thanks,

powermxpx

by cg it

who are going to submit data. Fans often are the best source of sports trivia so you want participation. People participate if they can see their participation means something [see it in print]

Wiki allows this but also allows you some control over what gets included and what doesn't so that you don't get tons of duplicates or get gibberish or unrelated content.

by evan

Yes, I really want the fans to participant and add the entries by themselves. I'm on board with you: if the fans can see that their contributions are making a difference, they are more likely to be involved and continue to submit data. It also makes it so much easy than having myself and a few people in charge of adding stats to a database.

I'm going to have to check out Wiki and do more research with it. Thanks for saving me a ton of time by letting me know that wiki can do this stuff--I've been searching for a solution for about a week now.

by thumbsup2

You asked.... "do Wiki sites let users complete empty fields and submit them, [b]then add them to a table?[/b]"

The way I understood that to mean was that you wanted the users to [b]add them to a table[/b] themselves, after being submitted, and since a designer would already know that's not how it works, it didn't appear to me as if you had that experience.

So, if I've misunderstood the question, forgive me.

To answer your question, yes WIKI's let users complete empty fields and submit it for approval. That's what they're designed for. You can set them so you need to approve the submittal before that data can be retrieved from the database. If not approved, the data can be deleted and never reach the retrieval process to be displayed in the table, so nobody ever sees it until you approve it.

by evan

Sorry for any misunderstanding, I should have been more clear in asking the question.

You are right on, I'm looking for users to just submit the data and the site will build the table. From your response, it sounds like Wiki's can do that. That's great!

I'll check this out. Thanks again for your help and kindness.

by tony hopkinson

You want to add a record into a table from a web form.

Google that and you'll see millions of answers.

by evan

Thanks for the feedback...I edited the post so it is more clear.

by tony hopkinson

using.
e.g. IIS, Apache, PHP, ASP, Sql Server Mysql etc.

There's loads of examples about. What's worrying is you having a go at this without being aware of something this basic.

I suggest you start here and at the beginning.

http://www.w3cschools.com/

Happy learning.

This discussion is closed to new replies.