Simple Php Connect To Sql Databa (PHP, Programming)

Home | My Account | Post Project | Browse Projects | RSS Feeds New!

Simple Php Connect To Sql Databa

Budget:

$ 20-100

Status:

Closed for Bidding (selected user teod)

Project Creator:

5 reviews

Required Skills:

PHP, Programming

Attached Files:

(None)


NEW	SEND	DISCUSS	CONTACT	OPTIONS

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.

Get the Free Step-by-Step Guide on How to Use GetACoder

The act of outsourcing projects has become easy in the past few years thanks to GetACoder. However, our team aims at making the whole process even easier. So, it has now come the time to provide you with a step-by-step guidance on how to use this service and succeed in the outsourcing world totally for FREE.

It doesn’t matter if you are a more experienced user or a novice; using GetACoder will become even simpler with the help of this E-book. There are two major sections: a Buyers section and a Coders section.

Buyers will learn:

How to outsource safely
How to pick the best freelancers
How to manage time and money

Coders will learn:

How to get the best projects
How to secure their payments
How to build a long-lasting relationship with buyers

…and MUCH MORE

Clear examples and pictures illustrating key situations, great tips and real testimonies of some of our best users… all in this Outsourcing Guide. So don’t loose the outstanding opportunity to download GetACoder FREE E-book.

The Outsourcing Revolution: Why It Makes Sense and How to Do It Right

What is GetACoder?

GetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business project, gain access to global talent and manage projects online.

One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a project at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your project. With GetACoder you focus on growing your business and let others do the tedious work. Post your project on GetACoder for free. Find out why people outsource projects with us day after day.

Thousands of Satisfied Customers - Submit/View Quotes

-	simply nice - kuttyanbu
-	Excellent site, fast and easy registration, the best on the Net! - amiroy
-	It’s a wonderful site. I'm really happy to know about this site. - pritesh