I gang

Mini PHP and MYSQL Project

PART 1 MYSQL: o A limousine or limousines may be hired by an individual customer or by a company for a minimum of one day.

o There are a few different models of limousine owned by the company. They have different daily hire charges.

o The cost of hiring a limousine is calculated by adding the daily charge to an amount for the number of miles travelled.

o A customer must specify the starting location for the hire and an approximate distance to be travelled.

o A customer may pay for the hire by means of a recognisable and valid credit/debit cards. The customer may only use a single method of payment for a particular hire (that is, a customer may not pay part of the hire price by, say, Visa and part by, say, Master Card).

o Although hiring a vehicle may be done at a distance (e.g. by telephone), for the hiring to be complete the customer, or the customer's representative, must sign appropriate documents at the company’s premises.

o A customer may hire more than one vehicle at a time provided each vehicle is required for the same hire period. The system to be built should identify a single hire as being a contract between the company and the customer concerning one or more vehicles.

o Each hired vehicle will have a driver employed by "Northampton Wedding Cars".

Part 2 PHP:

Scenario: The XYZ Car Rental Company requires an online database to record the availability of their car stock for rental. When a new car is released and bought by the company it, and the number bought, is added to the database. A count is kept of the cars, which are rented out. When a car is rented out, the count is decremented from the total in stock and when the car is returned the count is incremented. From time to time a car maybe damaged/sold and needs to be deleted from the stock. Finally, after a period of time, a car record may be totally deleted from the stock.

1. Using the command prompt create a table which has the following fields:

ID A number(unique identifier)with a specific format (e.g. BMW10-03)

CARNAME A string – Car Name

FUELTYPE A string - Diesel/Petrol/GAS/Hybrid/Other

TRANSMISSION A string - Manuel/Automatic/Semi-Auto

ENGINESIZE A number – (e.g. 1/1.2/1.4/1.6/1.8…)

DOORS A number – (e.g. 2/3/4/5)

TOTAL A number – Total number of a car in stock

AVAILABLE A number – Total number available to rent

DATEADDED A date – The date when the car was added

2. Create a PHP script [url removed, login to view] to allow you to enter a new car (car name, Fuel type, number, Transmission type, Engine Size, number of doors, date added) to the stock.

3. Create a PHP script [url removed, login to view] to lists the whole cars in the company (car name, fuel type, total in stock and number on rent).

4. Create a PHP script [url removed, login to view] to allow for the deletion of a car record from the car list.

5. Create a PHP script [url removed, login to view] to decrement the number of available cars for rent.

6. Create a PHP script [url removed, login to view] to increment the number of available cars for rent.

7. Create a PHP script, called [url removed, login to view], to allow for adding or deleting a quantity of a certain car.

8. Create a PHP script, called [url removed, login to view], which merges all of the PHP scripts into a single script, which acts as web application to the car rental system. Extra marks will be given for additional features to this script and the database, which enhances the car rental system. For example, recording to whom and when a car was rented and when it was returned

Færdigheder: Database Administration, MySQL, PHP, Projekt Ledelse, Rapport Skrivning

Se mere: mini php project list, which car rental, wedding car hire, visa php payment, vehicles rental, vehicles for hire, vehicle rental company, vehicle on rent, vehicle for rental, using debit card as credit online, use debit card as credit card online, to rent cars, to rent a car, the gas company, the car rental, rent vehicles, rent vehicle, rent to cars, rent the car, rent s car, rent rental car, rent on car, rent of cars, rent of car, rent it car

Om arbejdsgiveren:
( 3 bedømmelser ) india, United Kingdom

Projekt-ID: #4073978

Tildelt til:

gopalvora

ready to start Thanks

£140 GBP in 8 dage
(130 bedømmelser)
6.7

4 freelancere byder i gennemsnit £203 for dette job

traudong

Hello mate, we are very experienced web developers. We would love to work for you. Please have a look at our profile and consider us. Cheers.

£250 GBP in 5 dage
(16 bedømmelser)
5.8
phpmysqlrocks

Ready to start. Thanks

£150 GBP in 10 dage
(11 bedømmelser)
4.2
apiece

Sir, we are ready to work in your project. Plz check private message for details. Thanks

£200 GBP in 14 dage
(3 bedømmelser)
3.7
westtrip

Hello, I am interested and ready to work for you in this project. Please have a look at the Private Message Board for my detailed proposal. Thanks, Animesh

£220 GBP in 20 dage
(0 bedømmelser)
0.0