|
| Budget: |
$ 20-100 |
| Status: |
Closed
for Bidding (selected
user teod)
|
| Project
Creator: |
|
| |
        
5
reviews
|
| Required
Skills: |
,
|
| Attached
Files: |
(None) |
 |
|
|
|
|
|
|
|
|
|
|
Description
i need this done by wed. mourning 10am (EST)
1) Create a mySQL Database (name the database "race####, where #### is your firstinitial and last name) that will contain the following fields: FirstName, LastName, Address, City, State, Zip, Gender (Male or Female), DateOfBirth, TShirtSize, Fee, and Passwd. Place a few test records in the file. (See step 5 for additional requirements for the database).
2b) Create a drop down list that will display the first and last names of the athletes already signed up for the race. Next to the drop down list include a textbox to accept the password. When the user selects the name in the drop down box, enters a password, and clicks a select button. When the button is clicked the information will be retrieved, as explained below.
The PHP application will retrieve the correct record from the database using a SELECT SQL statement. The SQL statement WHERE clause would include both the first name, last name, and the passwd. All three must match for a record to be selected. If the passwd does not match, the program will display "Invalid Password" to the user.
3a) After the information is displayed, a "Update my race information" button should appear. If the user does enter the correct passwd all fields will be displayed in textboxes. The user can then update the information and click the update button. Clicking the update button will cause the PHP application to use the UPDATE SQL statement to update the record in the database. The UPDATE WHERE clause does not have to include the passwd, since the passwd might be the item that is updated. A message "You information has been updated" should be displayed and all textboxes should be cleared after the information has been updated. The "Update my race information" button should no longer be visible.
4) If the athlete is new to the race, they can just enter their information in the textboxes displayed and hit an "Add me to the race" button. The web site should tell them that the cost of the race is $25 and that they should bring cash, check, or credit card to the race to pay for the registration. All information will be saved to the database. A message should also be displayed "Welcome to the race!", after the user has hit the button. All textboxes should be cleared and the drop down list should be updated with the new athlete. The "Remove me from the race" (3b) or the "Update my race information" (3a) button should no longer be visible.
5) SQL file. You MUST include this SQL file
Reminder
You may not start working in this and any project before
your bid is accepted. Any user who violates this policy
may have their account permanently suspended.
|
| Shortlist |
| Decline Bid |
|
|
Dhaka,
BD
location |
US$200
bid amount |

         
(183
reviews)
feedback |

2 day(s)
delivery time |

|
| |
Please check PM
Bid Time: 09-08-2008 13:34
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Chernivtsi,
UA
location |
US$90
bid amount |

         
(53
reviews)
feedback |

1 day(s)
delivery time |

|
| |
Good day dear sir. Please check PMB
Bid Time: 09-08-2008 13:49
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Dhaka,
BD
location |
US$250
bid amount |

         
(18
reviews)
feedback |

3 day(s)
delivery time |

|
| |
Please check PMB.Thanks.
Bid Time: 09-08-2008 15:27
|
|
|
|
|
|
Timisoara,
RO
location |
US$70
bid amount |

         
(8
reviews)
feedback |

2 day(s)
delivery time |

|
| |
Hi,
Please check PMB.
Bid Time: 09-08-2008 14:12
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Kuala Lumpur,
MY
location |
US$70
bid amount |

         
(22
reviews)
feedback |

2 day(s)
delivery time |

|
| |
I can do it. Please PM me and lets discuss more about this project. Regards
Bid Time: 09-08-2008 14:01
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Kingston,
JM
location |
US$100
bid amount |

         
(5
reviews)
feedback |

2 day(s)
delivery time |

|
| |
Please see PM.
Bid Time: 09-08-2008 13:38
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Dhaka,
BD
location |
US$200
bid amount |

         
(5
reviews)
feedback |

1 day(s)
delivery time |

|
| |
Hello Please C PMB. I can provide it very fast.
Bid Time: 09-08-2008 14:21
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Kolkata,
IN
location |
US$70
bid amount |

         
(3
reviews)
feedback |

2 day(s)
delivery time |

|
| |
Please check in pm.
Bid Time: 09-08-2008 14:45
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Dhaka,
BD
location |
US$150
bid amount |

         
(2
reviews)
feedback |

2 day(s)
delivery time |

|
| |
please check PM
Bid Time: 09-08-2008 14:17
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Chennai,
IN
location |
US$1,440
bid amount |

(No Feedback
Yet)
feedback |

45 day(s)
delivery time |

|
| |
Dear client, we can do this for you at affordable cost. Please view PMB!!!
Bid Time: 09-08-2008 13:31
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Islamabad,
PK
location |
US$75
bid amount |

(No Feedback
Yet)
feedback |

2 day(s)
delivery time |

|
| |
Dear sir please accept my bid.
Bid Time: 09-08-2008 16:27
|
|
|
|
|