I am trying to build a? Sumer sports team selection web interface.
Basically, a coach would have a mysql database. He will enter? potential team member? names into? the? table for “team members?? using a web interface like the example “AJAX-ed Todo List With PHP, MySQL & jQuery?? found here: <[url removed, login to view]>. This interface will permit a coach to add, edit, delete and sort team members without leaving or refreshing the web page. This example works great for this purpose but needs more bells and whistles while keeping the same look, feel and functionality. We definitely want to be able to double click on the member’s name and edit that name just like the demo.
I need to take this a step further by also allowing the coach to have more than one list for team names in which to sort the team members. The coach will need to be able to add, edit or delete team names on the fly as well. For instance; the coach may add the teams Colts, Chargers and Braves as his teams. He may find that later he has too many players for just three teams and needs to add another team such as Bears or he may also find that he has too many teams and not enough team members signing up. It may also be necessary to rename the team. These functions need to be just as easy as the functions used to create, manage and remove team members. The demo shown above does not provide but for one list and has no naming capability.
We must have the functionality of the web site listed above:? ? <[url removed, login to view]>.
While this example does not provide for multiple editable lists as teams, we need to be able to add teams, edit the name of the team, or delete the team in the same fashion as the players lists are created. We need to be able to change the color of the team with easily editable style sheets or include parameters into the database that will automatically populate the lists with the right colors.
The team names and possibly the colors for team should be stored in the mysql database table just like the players are stored.
Player names must be addable, editable, deletable, sortable beween lists as well as up and down in the same lists. A double click on the players name should allow for editing just like the demo. The color of the players box should change depending on the list it is added to.
The team names should be just as easy to edit, delete
? The web page should auto populate the team lists with players in similar fashion as the example above using jquery, mysql, php and ajax.
? The top of the web page should have an easily editable header to include the county athletic department contact information and logo.