Lengkap

47107 MySQL/PHP code for event mgt

Need PHP program to do the following: The Insane Century Series 1. User is presented with a description of each course (and the dates for when entries are being accepted for each course. Courses and dates for each stage are stored in the insane_century_series_courses table (needs to be created). Course descriptions are stored in the courses table. 2. Next to the course for which results are currently being accepted (and for which the user has NOT already submitted a result) is a link or button with title "Submit Result". Next to any courses for which results are currently being accepted (and for which the user HAS already submitted a result is a status of "Result Received". Next to any courses that are no longer accepting results and for which the user has NOT submitted a performance is a status of "CLOSED". Next to any courses that are no longer accepting results and for which the user HAS submitted a performance is a link or button with title "View Results". 3a. If the user clicks on the "Submit Result" button, he is presented with two options. One is to manually input result (time and age). The second option is to upload their [url removed, login to view] file and select their time from the appropriate entry. The time, age and stage number is stored in the insane_century_results table (needs to be created). The user is then informed that his result has been received and is returned to the previous page, where this will be reflected by the status label next to the course. 3b. If the user clicks on a "View Results" button, the rider names and times will be displayed for that course in ascending order by time. The user's name and time will be highlighted in bold red for easy identification. The Training Ride Series - This series should be handled in the same fashion as the Insane Century Series. The only difference is that it will need its own tables. Also, in addition to entering (or selecting from uploaded [url removed, login to view]) time and age, the user will also select whether to enter results in Training Ride Series only or both the Training Ride Series AND the Tour de Web (see below). The Tour de Web - This series shares the same courses and submission form as the Training Ride Series and so will not require its own submission form or table for courses and dates. It will, however, needs its own page for course descriptions (as status will be different from the Training Ride Series) and it will need its own results table (unless a column is added to the Training Ride Series Results table to indicate whether "both" or "Training Ride Series only". Also, results will need to be displayed differently. The results will be displayed using a table with the results of each stage displayed in separate columns. All times below the fastest time will be relative to the fastest time (i.e. +00:01:35) and results will also be grouped by All Riders, by age and by racing category. Racing category must be looked up in the rider table. There will also be a general classification by All Riders, by age and by racing category. The general classification is the cumulative time of each rider up to and including each stage. I have code that does most of this that can be modified or just used to illustrate what I am looking for. Course Directory Modifications 1. Modify [url removed, login to view] code so that a user may select favorite courses to include in my_courses.php. A user may select (via a checkbox next to each course) one or more courses and then may press an "Add to My Favorites" button to add all checked courses to the my_courses table (needs to be created and should have 2 columns rider_ID and course_ID). 2. Currently, [url removed, login to view] code displays only courses for which a user has submitted a performance. [url removed, login to view] code must instead display courses which the user has selected as favorite courses via search_courses.php. Also, the [url removed, login to view] code should also display check boxes next to each course as in the search_courses code but with the intention of removing all check courses from the my_courses table.

Kemahiran: Semua Boleh, PHP

Lihat lagi: training program names, php program code, php code for, php checked checked, performance press, fashion names, code that, classification web, century link, all php program, php courses, php code program, php a, ride or, racing series, php training, php code, Mysql php, modify code, illustrate an easy

Tentang Majikan:
( 8 ulasan ) Lexington, United States

ID Projek: #1796390

Dianugerahkan kepada:

$145 USD dalam 5 hari
(67 Ulasan)
5.6