In Progress

Booking Script

This project is for a car rental bookings site by travel agencies.

The script will be integrated into an existing page php page. It uses a MySQL website.

Following are the specifications for the script:

The user must be able to input “Date of Rental”, “Time of Rental”, “Date of Return”, “Time of Return”, “Rate Code”, “Car Class”

“Date of Rental”, “Time of Rental”, “Date of Return”, “Time of Return” must be used to calculate the number of days based on a 24 hour period. Anything over the 24 hours will counted as an extra day. That value is then multiplied by the value on the “Rate Code”/“Car Class” row in a MySQL database.

Of course, additional fields like first name, last name, pickup city, dropoff city will be in the same page, but don’t really need to be part of the page.

Process of the booking:

1. User enters the information above.

2. User submits the information

3. Response page will show, “Date of Rental”, “Time of Rental”, “Date of Return”, “Time of Return”, “Rate Code”, “Car Class” and the “Price of the Rental”. Along with the other information on that was entered on the previous web page.

Payment is made after completion.

Clarification calculating the cost of the rental:

The cost of the rental is calclated by looking up the weekly and daily value associated with the chosen car class and rate code. The row on the table contains the columns: rate code, car class, daily rate, weekly rate.

The daily rate applies when there is 1, 2, or 3 days. Weekly rates applies to 4, 5, 6, 7 days.
The maximum number of days per rental is 28 days.

The chart below shows how to calculate the pricing of the rental base on more the a 7 day week.

1 = 1 day
2 = 2 day
3 = 3 day
4 = 1 week
5 = 1 week
6 = 1 week
7 = 1 week
8 = 1 week + 1 day
9 = 1 week + 2 days
10 = 1 week + 3 days
11 = 2 weeks
12 = 2 weeks
13 = 2 weeks
14 = 2 weeks
15 = 2 weeks + 1 day
16 = 2 weeks + 2 days
17 = 2 weeks + 3 days
18 = 3 weeks
19 = 3 weeks
20 = 3 weeks
21 = 3 weeks
22 = 3 weeks + 1 day
23 = 3 weeks + 2 days
24 = 3 weeks + 3 days
25 = 4 weeks
26 = 4 weeks
27 = 4 weeks
28 = 4 weeks

Here is the MYSql Table:
CREATE TABLE `tbl_ratesFL` (
`IDratesFL` tinyint(2) NOT NULL auto_increment,
`cartype` varchar(12) default NULL,
`ONE_D` int(6) default NULL,
`ONE_W` int(6) default NULL,
`TWO_D` int(6) default NULL,
`TWO_W` int(6) default NULL,
`THREE_D` int(6) default NULL,
`THREE_W` int(6) default NULL,
`FOUR_D` int(6) default NULL,
`FOUR_W` int(6) default NULL,
`FIVE_D` int(6) default NULL,
`FIVE_W` int(6) default NULL,
PRIMARY KEY (`IDratesFL`,`IDratesFL`)
) TYPE=MyISAM AUTO_INCREMENT=33 ;

Skills: PHP

See more: booking script nulled, rent car script nulled, reservation script nulled, booking nulled script, booking nulled, null booking script, travel agency booking script nulled, value city, the rental car, the car rental, rental of car, rental car rate, rental car price, rental booking, rate car rental, rate a car, price rental car, price for rental car, car rental web site, car rental web, car rental rate, car rental on, car rental it, car rental in, car rental booking site

About the Employer:
( 0 reviews ) West Palm Beach, United States

Project ID: #20793

Awarded to:

EzzatHelal

I am ready for this simple task.

$30 USD in 2 days
(10 Reviews)
4.4

18 freelancers are bidding on average $73 for this job

siddhartha1

dear sir, pls check pmb,thanx

$100 USD in 25 days
(35 Reviews)
7.6
infoway

view PMB for detail.

$100 USD in 4 days
(41 Reviews)
7.1
pentium10

I am confident and capable to do your booking script. I work fast and accurate. Pentium10

$50 USD in 1 day
(212 Reviews)
6.8
PinkCrow

I can do that for you!

$30 USD in 1 day
(137 Reviews)
6.6
viaden

Dear Sirs! Thank you for considering our bid. We've gone through your description and are ready to create the Booking Script you require. Our company has been in the sphere of web development and programming for 10 yea More

$100 USD in 4 days
(3 Reviews)
6.2
nadiralishah

Hello! Kindly check PMB for details

$100 USD in 10 days
(17 Reviews)
5.8
nidle

Dear Sir/ Madam, We have examined your request and would be glad to develop the required script for you. More than 7 years of experience in the field of web technologies and programming help us achieve outstanding More

$100 USD in 7 days
(2 Reviews)
4.9
campbeld

You will probably find it worthwhile to read my upcoming private message.

$50 USD in 5 days
(10 Reviews)
4.7
ebusiness2

Our bid is for really very high quality work for your Booking Script that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our bid includes six week fre More

$100 USD in 10 days
(3 Reviews)
3.4
shockx

Hi, can do this for you in no time. Sample is available just hit me up here. Thanks.

$30 USD in 1 day
(2 Reviews)
3.3
bearcoder

I can do it

$51 USD in 2 days
(3 Reviews)
3.2
tanuj99

pl see pmb for details

$100 USD in 8 days
(1 Review)
3.2
nrsemba

I have been developing sites for a few years now. I believe I can give you the support that you need. I have completed a wide range of sites and systems. A few of them are: [url removed, login to view] [url removed, login to view] www. More

$50 USD in 10 days
(0 Reviews)
0.0
aargem

Hello Sir, I go through very well your specification that you have been specified over here. We grab your idea and surely give you the script as per your needs. Please open PMB for further discussions and there I can d More

$45 USD in 1 day
(0 Reviews)
0.0
stumblefoot

I can do this project for you with ease. I have five years experience with MySQL, PHP, Linux, HTML/CSS/Javascript. This is a simple project and will be no problem at all.

$70 USD in 2 days
(0 Reviews)
2.0
Lithium

Hi, Im interested. I will do it for u. Thanks

$100 USD in 2 days
(0 Reviews)
0.0
buddy4life

I have been working for 5 years on PHP and ASP sites. I offer dependable and fast solutions with complete support. Now I dont promise a cheap solution nor do I promise a fast delivery schedule but i do promise a so More

$100 USD in 10 days
(0 Reviews)
2.0