I help with a MMA event. Fighters interested in competing in our event can register online. What we would like is to have fighters register online and have their info (name, weight, team, picture, etc etc) be saved in the database upon completing the form. The information they submit is used to match them with an opponent. We would like to have all of their info stored in to a database so in the future if we need a certain weight fighter we can search and find them. We would like to be able to go in to a admin control panel where we can search through the fighters that registered (search by name or sort the fighters by name/weight/location/etc). The admin control panel we would also like to use to delete fighters from the database if necessary or edit their information (update their fight record, add or change their pictures, etc) and add notes on that particular fighter. Ultimately we would like to have it so one of us/an admin can view a list of the basic info (name, weight) and when you click that fighters name, it would open up a profile page on that fighter using the info the fighter submitted to the database using the registration form.

What I want to create would look similar to this:
This would be where they register: http://www.vegasfighter.com/fighter-form.php

There info saved in a database

This would be the list of registered fighters: http://www.vegasfighter.com/fighter-...php#tab-promen

This would be their profile that displays all of the info they entered on the registration form: http://www.vegasfighter.com/profile-fighter.php?ID=61


Can anyone help me with something like this or point me in the right direction?

Are you looking to code it yourself or hire somebody to do it for you? Either way, you're in the right place!

If you're looking to code it yourself, you'd need a simple MySQL database and use simple PHP MySQL Insert statements to save all the data from the form. It's just basic form processing. Your schema (database layout) would be pretty big (since there's so much info, and compared to the databases I've done in my own experience), but that won't be a problem if you know how to set up MySQL tables (link to data types, scroll down to MySQL).

Or you could hire somebody

Originally Posted by Physicsguy

Are you looking to code it yourself or hire somebody to do it for you? Either way, you're in the right place!

If you're looking to code it yourself, you'd need a simple MySQL database and use simple PHP MySQL Insert statements to save all the data from the form. It's just basic form processing. Your schema (database layout) would be pretty big (since there's so much info, and compared to the databases I've done in my own experience), but that won't be a problem if you know how to set up MySQL tables (link to data types, scroll down to MySQL).

Or you could hire somebody

Thank you for the info! I would LIKE to be able to do this myself for a learning experience. I can create a form that adds info to a database. That is the part I know how to do but what I am not good with is creating pages that pull certain info from the database and format it to look nice.

I know enough where if somebody were to set up something like this, I would be able to look at it and learn from it.

You could also get ideas from this site. w3schools.com cheers