Car Rental System Project Report

A MAJOR PROJECT REPORT ON
CAR RENATL SYSTEM
Submitted in partial fulfillment of the requirements

for the award of the degree of
BACHELOR OF COMPUTER APPLICATIONS

to
Guru Gobind Singh Indraprastha University, Delhi
Submitted to: Submitted by:

Ms. Shweta Sharama Viraj Bhalla
02920602021
BCA VI-Sem (1st Shift)
Session 2021-2024
TRINITY INSTITUTE OF PROFESSIONAL

STUDIES
(Affiliated to Guru Gobind Singh Indraprastha University, Delhi)
Ranked “A+” Institution by SFRC, Govt. of NCT of India
Recognized under section 2(f) of the UGC Act, 1956
NAACAccredited “B++” Grade Institution
1
TABLE OF CONTENT
S NO. TITLE PAGE NO.

• CERTIFICATE OF THE PROJECT GUIDE 3
• ACKNOWLEDGEMENT 4
• LIST OF FIGURES 5
• LIST OF ACRONYMS AND ABBREVIATIONS 6
1. ONLINE CAR RENTAL SYSTEM 7-8
1. Introduction
2. Reason for the Project
3. Problem Statement
4. Aims & Objectives
5. Scope
2. PROJECT DESCRIPTION 9
1. Existing System
2. Benefits
3. FUNCTIONAL AND NON-FUNCTIONAL 10-11
REQUIREMENTS
1. Functional Requirements
2. Non-Functional Requirements
4. DESIGN 12-29
1. Data Flow Diagram
2. Use Case Diagram
3. Activity Diagram
4. Sequence Diagram
5. Class Diagram
5. INTRODUCTION OF TECHNOLOGIES USED PROJECT 30-35
6. SOURCE CODE 36-59
7. OUTPUT SCREEN SHOT 60-61
8. CONCLUSION 62
2
To Whom It May Concern
I, Viraj Bhalla, Enrolment No.02920602021 from BCA-VI Sem of the Trinity Institute of
Professional Studies, Delhi hereby declare that the Minor Project Report entitled Car
Rental System at Trinity Institute of Professional Studies is an original work and the
same has not been submitted to any other Institute for the award of any other degree.
Date: Signature of the Student
Certified that the Project Report submitted in partial fulfilment of Bachelor of Computer
Applications (BCA) to be awarded by G.G.S.I.P. University, Delhi by Viraj Bhalla,
Enrolment No. 02920602021 has been completed under my guidance and is Satisfactory.
Date:
Signature of the Guide:
Name of the Guide: Ms. Shweta Sharama
3
ACKNOWLEDGMENT
I would like to express my special thanks of gratitude to my Project supervisor Ms. Shweta
Sharma who devotes her precious time to interact, guide and give me the golden
opportunity to do this wonderful project on the topic Car Rental System, which also
helped me in doing a lot of Research and I came to know about so many new things.
I am really thankful to her.
Secondly, I would also like to thank my parents and friends who helped me a lot in finishing
this project within the limited time. I made this project not only for marks but to also
increase my knowledge.
Viraj Bhalla
02920602021
BCA VI-Sem (1st Shift)
4
LIST OF FIGURES
S NO. FIGURES PAGE NO.
1. Data Flow Diagram 12-13
2. Use Case Diagram 14-17
3. Activity Diagram 18-24
4. Sequence Diagram 25-28
5. Class Diagram 29
5
LIST OF ACRONYMS AND ABBREVIATIONS
1. OS - OPERATING SYSTEMS
2. DBMS - DATABASE MANAGEMENT SYSTEM
3. ML - MACHINE LEARNING
4. SQL - STRUCTURED QUERY LANGUAGE
5. HTML - HYPER TEXT MARKUP LANGUAGE
6. CSS - CASCADING STYLE SHEETS
6
ONLINE CAR RENTAL SYSTEM
1.1 Introduction
This project is designed so as to be used by Car Rental Company specializing in renting

cars to customers. It is an online system through which customers can view available cars,
register, view profile and book car.
1.2 Reason for the Project
The advancement in Information Technology and internet penetration has greatly enhanced
various business processes and communication between companies (services provider) and
their customers of which car rental industry is not left out. This E-Car Rental System is
developed to provide the following services:
• Enhance Business Processes: To be able to use internet technology to project the rental
company to the global world instead of limiting their services to their local domain
alone, thus increase their return on investment (ROI).
• Online Vehicle Reservation: A tools through which customers can reserve available
cars online prior to their expected pick-up date or time.
• Customer’s registration: A registration portal to hold customer’s details, monitor their
transaction and used same to offer better and improve services to them.
• Group bookings: Allows the customer to book space for a group in the case of weddings
or corporate meetings (Event management).
1.3 Problem Statement
A car rental is a vehicle that can be used temporarily for a fee during a specified period.
Getting a rental car helps people get around despite the fact they do not have access to their
own personal vehicle or don't own a vehicle at all. The individual who needs a car must
contact a rental car company and contract out for a vehicle. This system increases customer
retention and simplify vehicle and staff management.
7
1.4 Aims & Objectives
• To produce a web-based system that allow customer to register and reserve car online
and for the company to effectively manage their car rental business.
• To ease customer’s task whenever they need to rent a car.
1.5 Scope
This project traverses a lot of areas ranging from business concept to computing field, and
required to perform several researches to be able to achieve the project objectives. The area
covers include:
• Car rental industry: This includes study on how the car rental business is being done,
process involved and opportunity that exist for improvement.
• PHP Technology used for the development of the application.
• General customers as well as the company’s staff will be able to use the system
effectively.
• Web-platform means that the system will be available for access 24/7 except when
there is a temporary server issue which is expected to be minimal.
8
PROJECT DESCRIPTION
2.1 How Existing System Work
A car rental is a vehicle that can be used temporarily for a period of time with a fee. Renting
a car assists people to get around even when they do not have access to their own personal
vehicle or don't own a vehicle at all. The individual who want to rent a car must first contact
the car rental company for the desire vehicle. This can be done online. At this point, this
person has to supply some information such as; dates of rental, and type of car. After these
details are worked out, the individual renting the car must present a valid Identification
Card.
Most companies throughout the industry make a profit based of the type of cars that are
rented. The rental cars are categorized into economy, compact, compact premium,
premium and luxury. And customers are free to choose any car of their choice based on
their purse and availability of such car at the time of reservation.
2.2 Benefits of Online Car Rental Services
• This online car rental solution is fully functional and flexible.

• It is very easy to use.
• This online car rental system helps in back office administration by streamlining and
standardizing the procedures.
• It saves a lot of time, money and labour.
• Eco-friendly: The monitoring of the vehicle activity and the overall business becomes
easy and includes the least of paper work.
• The software acts as an office that is open 24/7.
• It increases the efficiency of the management at offering quality services to the
customers.
• It provides custom features development and support with the software.
9
FUNCTIONAL AND NON-FUNCTIONAL
REQUIREMENTS
3.1 Functional Requirements
Requirement analysis is a software engineering technique that is composed of the various

tasks that determine the needs or conditions that are to be met for a new or altered product,
taking into consideration the possible conflicting requirements of the various users.
Functional requirements are those requirements that are used to illustrate the internal
working nature of the system, the description of the system, and explanation of each
subsystem. It consists of what task the system should perform, the processes involved,
which data should the system holds and the interfaces with the user. The functional
requirements identified are:
a. Customer’s registration: The system should allow new users to register online and
generate membership card.
b. Online reservation of cars: Customers should be able to use the system to make booking
and online reservation.
c. Automatic update to database once reservation is made or new customer registered:
Whenever there’s new reservation or new registration, the system should be able update
the database without any additional efforts from the admin.
d. Feedbacks to customers: It should provide means for customers to leave feedback.
3.2 Non-Functional Requirements
It describes aspects of the system that are concerned with how the system provides the
functional requirements. They are:
a. Security: The subsystem should provide a high level of security and integrity of the
data held by the system, only authorized personnel of the company can gain access to
the company’s secured page on the system; and only users with valid password and
10
username can login to view user’s page.
b. Performance and Response time: The system should have high performance rate when
executing user’s input and should be able to provide feedback or response within a
short time span usually 50 seconds for highly complicated task and 20 to 25 seconds
for less complicated task.
c. Error handling: Error should be considerably minimized and an appropriate error
message that guides the user to recover from an error should be provided. Validation of
user’s input is highly essential. Also the standard time taken to recover from an error
should be 15 to 20 seconds.
d. Availability: This system should always be available for access at 24 hours, 7 days a
week. Also in the occurrence of any major system malfunctioning, the system should
be available in 1 to 2 working days, so that the business process is not severely affected.
e. Ease of use: Considered the level of knowledge possessed by the users of this system,
a simple but quality user interface should be developed to make it easy to understand
and required less training.
11
DESIGN
DATA FLOW DIAGRAMS
4.1.1 Data Flow Diagram (DFD)
A Data Flow Diagram (DFD) is a graphical representation that depicts the information
flow and the transforms that are applied as data moves from input to output.
EMAIL FOR RESERVED CAR
CAR RESERVED
RESERVE A CAR EMAIL FOR RESERVED CAR
NEW
REGISTRATION ADD
ONLINE CAR CUSTOMER CAR
CUSTOMER RENTAL RENTAL
. SYSTEM COMPANY
LOGIN REQUEST
TRANSACTION
REPORTS
AUTHENTICATION
REGISTRATION CONFIRMATION
Figure 4.1.1 Level 0 DFD of Online Car Rental System
In this diagram, Customer and Car Rental Company are the two entity sets.
Functions of Customer:
• New Registration
• Login Request
12
• Registration Confirmation by the System
• Reserve Car
• Car Issued by the System
• Email received for Reserved Car
Functions of Car Rental Company:
• Add Customer
• Send E-Mails for Reserved Car
• View Transaction reports
RESPONS
RESPONSE TO FEEDBACK E TO
FEEDBACK
CUSTOMER DB
CUSTOMER
DETAILS
FEEDBACK
LOGIN
DETAILS
SIGNED IN STAFF
REGISTER AS
NEW MEMBER
LOGIN SELECT LOGIN DETAILS

DETAILS FOR LOGIN
CAR
RESERVATION
AVAILABLE
CARS STAFF DB
CUSTOMER CUSTOMER DB
REPORT STAFF DB
CHOOSE PROCESS REPORT
CAR RENTAL VIEW
REPORT SIGNED IN
CAR DB REPORT
RETURN MAKE ADD/UPDATE

ADMIN
CAR PAYMENT CAR DETAILS
CAR
RESERVED
FEEDBACK CAR DB
Figure 4.1.2 Level 1 DFD of Online Car Rental System
13
USE-CASE DIAGRAMS
4.2.1 Actor and Use Case Description

Actor and use case description shows the detail description of interaction between the
actors and their use cases. The description enables to have a proper understanding of how
actor interacts with the system through their use cases.
Actor Use Case Use Case Description
This use case describes the activities of the

customer to register online and become a member.
Register as
Customer's details are required as part of the
member
registration. Login detail is automatically sent to
the customer after successful registration.
This use case enable customer to search and make

reservation. Non-register customer will be
Make
directed to register before their reservation can be
Customer reservation
confirmed. Notification is automatically send to
the customer after the task is completed.
This use case describes the event of customer

returning the car borrowed, the use case extends
Return car
"process rental" use case from the staff actor.
Give feedback This use case is used by the customer to provide

feedbacks/comment to the company; a
confirmation notification will be send to the
customer once a feedback has been submitted.
14
This use case is used by the staff to add new car to
the company's fleet database. Staff will need to
Add new car
login to activate this use case.
Update car This use case is used by the staff to edit and modify
details car details whenever there is new renewal
(insurance, road tax). It allows the company to keep
up-to-date record of their fleet.
Reply to This use case describes the event by which staff

Staff customer’s sends reply to customer's earlier feedback. It
feedback depends on `give feedback' use case from the
customer.
Process rental This use case described the event by which staff
updates the system when customer pick up or when
returning car.
Add new staff This use case describes the event by which Admin
add new staff detail to the company's staff database.
Admin It is invoke whenever a new staff join the company.
View report This use case is used by the Admin to view

transaction report.
Table 4.2.1 Actors and Use Case Description
15
4.2.2 Use Case Diagram
Register as member Add new car

Staff
Make reservation Update car details
Customer
Process rental
<<extend>>
Return car
Reply to
customer's
Give feedback/
comments feedback
Admin
View report
Figure 4.2.2: E-Car Rental System [use case]
16
4.2.3 Use-Case Dependency Diagram
Depends on
Register as Add new car Update car details
Member
Pick car
<<extend>> Make reservation
Process rental
<<extend>>
Return car
<<extend>> <<extend>>
Reply to customer's
feedback
Late return Early return Depends on
Give feedback/
comments View cus tomer's
<<include>> patronage
View report
<<include>>
View transaction
report
Figure 4.2.3: Use Case Dependency Diagram
17
ACTIVITY DIAGRAMS
4.3.1 Activity Diagram
Activity diagrams graphically represent the sequential business and operational workflows
of a system. It is a dynamic diagram that shows the activity and the event that causes the
object to be in the particular state. The workflows from activity diagram will serve as guide
for system navigation in the final design phase of the system.
4.3.1.1 Member Registration
Customer E-Car Rental System

Start
Enter details
[Yes]
Enter username and

password
Accept terms & [No]

conditions Username exist?
Confirm and
submit
Display customer's
welcome screen
Send email
confirmation
End
Figure 4.3.1.1: Register as member
18
4.3.1.2 Profile Modification

Start
[No]
Login Valid?
Navigate to Edit [Yes]

Profile
Modify your profile
Confirm and submit
Update database
Send confirmation
notification
Log out
End
Figure 4.3.1.2: Modify profile
19
4.3.1.3 Reservation of Car
Start
Choose pickup
location
Choose pick up date

and time
Choose return
location
Choose return date

and time
Choose vehicle class
Choose from Display available

available car cars
[No]
Member?
Login
Register
[No]
Valid?
[Yes]
merge
Confirm
Redirect to payment
gateway
Send confirmation
End
Figure 4.3.1.3: Make Reservation
20
4.3.1.4 Customer Feedback

Start
Enter your details
Enter your message/remark
Submit feedback
Send notification
End
Figure 4.3.1.4: Give feedback/comment
21
4.3.1.5 Payment of Car Rent
Staff
Start
Provide member id
Check rental detail

[Yes]
Overdue?
[No]
Pay late charges
Merge
Confirm return
Update database
End
Figure 4.3.1.5: Rent a Car
22
4.3.1.6 Adding a New Car
Staff E-Car Rental System
Login
[No]
Login
Valid?
[Yes]
Enter car details
Add to inventory
Update status
End
Figure 4.3.1.6: Add a New Car
23
4.3.1.7 View Report
Admin E-Car Rental System
Start
Login
[No]
Valid?
[Yes]
Specify report to view
Confirm and submit
Retrieve report
End
Figure 4.3.1.7: View report
24
SEQUENCE DIAGRAMS
4.4.1 Sequence Diagram

Sequence diagrams are used to demonstrate the behavior of objects in a use case by
describing the objects and the messages they pass. It provides a graphical representation of
object interactions over time. Sequence diagrams show an actor, the objects and
components they interact with in the execution of a use case. One sequence diagram
represents a single Use Case 'scenario' or events. Sequence diagrams show the flow of
messages from one object to another, and as such correspond to the methods and events
supported by an object.
4.4.1.1 Member Registration
Interface object Control object Entity object Entity object

Customer:Ola Interface:"reg Control:c008 Customer Intelligent
001" Database:"db 01" Agent:"Confirma
Agent"
Enter details
Enter username
Check username
Enter password
Read and accept terms

Confirm and Submit
Validate registration
Update database
Send login parameters as email
Send SMS Confirmation
Figure 4.4.1.1: Register as member Register as member (Sequence)

System Architect
Mon Jan 18, 2010 17:52
Comment
Prepared by:
Mikhail Ola' Adisa
i08000718
25
4.4.1.2 Reservation of Car
Interface object Control object Entity object Entity object Entity object Entity object
Customer:Ola Interface:i002 Control:c008 CarDatabase:"d CustDatabase:" Payment:"VISA Intelligent
b 001" Data 1" card" Agent:Confirmatio
Choose pick up location
Choose pick up date and time
Choose return location
Choose return date and time
Choose vehicle class

Display available cars
Login/register
Pass to control
Check username and password
Show cusotmer info

Confirm and Submit Redirect to payment gateway
Enter payment detail
Process payment
Send confirmation email/SMS
Figure 4.4.1.2: Make reservation

Make reservation (Sequence)
System Architect
Mon Jan 18, 2010 17:19
Comment
Prepared by:
4.4.1.3 Customer Feedback Mikhail Ola' Adisa
Feedback System:"sys 01" Database:"db

Customer:ola page:i001 001"
Enter details
Enter feedback message

Confirm and submit
Accept feedback
Add to database
Send confirmation
Figure 4.4.1.3: Give feedback
26
4.4.1.4 Adding a New Car
New Car page: P001 Control:Admin Database:"db

staff:John Handler 01"
Login
Pass to control
Check validity
provide admin page
Enter new car details
Confirm and submit

Pass to control
Add to database
Log out
Close session
Figure 4.4.1.4: Add new car
4.4.1.5 Feedback Response
Staff:John Interface:i001 Control:Feed Database:"db

Handler
01"
Login
Check validity
Get staff info
Select feedback
Display feedback
Respond to feedback
Log out
End session
Figure 4.4.1.5: Respond to feedback
27
4.4.1.6 Return Car and Check Rental Details
Interface:i001 Database:"db
Customer:ola Staff:john 01"
Provide member id
Check rental details

Confirm if overdue
Process rental
Update database
Figure 4.4.1.6: Return car
4.4.1.7 View Report
Report page: Report Control: Database:"db

P002 c008 01"
Admin:Kabir
Login
Check validity
Specify report
Retrieve report
Log out
End session
Figure 4.4.1.7: View report
28
CLASS DIAGRAM
4.5.1 Class Diagram

The class diagram is the main building block, a number of classes are identified and
grouped together in a class diagram which helps to determine the statically relations
between those objects.
Automation notify
provides 1 alert
Distance chart - name : string 1
1..*
- source : string get () Feedback respond to
- destination : 1 provide () 1..* 1..*
alert () 1
- id : int Staff
get () notify () - custName : string
provide () - custEmail : string
1 - sid : char
notify - sname : string
1..* send () - position : string
respond () - mobile : int
Reservation Customer
gives1..* add 1 addcar ()
- rid : int - userId : string 1..* modifyInfo ()
- pickdate : date makes 1..* - custName : string 1..*
- returndate : date 1..* - cusAddr : string 1 add
- mobile : int 1..*
- pickloc : string
- VehicleClass : string - email : string Car 1
Admin
1..* 1
reserve () register () rent - PlateNo : string
search() login () 1 - CarName : string - Id : string
reservation () - carType : string - name : string
1..* - rent : double
makes makes add ()
add () modify ()
1..* modify () view ()
Return reserve ()
1..* 1
Payment
- id : int
- retdate : date process View
- id : int
- amount : double 1..*
- custName : string update () Report
pay () - id : int
confirm () - date : date
Early return - title : string
Late return
1..*
- lateCharge : double generate ()
confirm () print ()
save ()
pay ()
confirm ()
Figure 4.5.1 Class Diagram of Online Car Rental System
29
INTRODUCTION OF TECHNOLOGIES USED IN
PROJECT
5.1 About PHP
PHP: Hypertext Pre-processor is a widely used, general-purpose scripting language that

was originally designed for web development to produce dynamic web pages. For this
purpose, PHP code is embedded into the HTML source document and interpreted by a web
server with a PHP processor module, which generates the web page document.
As a general-purpose programming language, PHP code is processed by an interpreter

application in command-line mode performing desired operating system operations and
producing program output on its standard output channel. It may also function as a
graphical application. PHP is available as a processor for most modern web servers and as
standalone interpreter on most operating systems and computing platforms.
PHP was originally created by Rasmus Lerdorf in 1995 and has been in continuous
development ever since. The main implementation of PHP is now produced by the PHP
Group and serves as the de facto standard for PHP as there is no formal specification. PHP
is free software released under the PHP License.
PHP is a general-purpose scripting language that is especially suited to server-side web

development where PHP generally runs on a web server. Any PHP code in a requested file
is executed by the PHP runtime, usually to create dynamic web page content. It can also
be used for command-line scripting and client-side GUI applications. PHP can be deployed
on most web servers, many operating systems and platforms, and can be used with many
relational database management systems. It is available free of charge, and the PHP Group
provides the complete source code for users to build, customize and extend for their own
use.
30
Originally designed to create dynamic web pages, PHP now focuses mainly on server-side
scripting, and it is similar to other server-side scripting languages that provide dynamic
content from a web server to a client, such as Microsoft's Active Server Pages, Sun
Microsystems’ Java Server Pages, and mod_perl. PHP has also attracted the development
of many frameworks that provide building blocks and a design structure to promote rapid
application development (RAD). Some of these include CakePHP, Symfony, CodeIgniter
and Zend Framework, offering features similar to other web application frameworks.
5.2 PHP Syntax:
HTML and PHP code is written on the same page, and to distinguish PHP code from
HTML, the PHP code is enclosed within <? php ?> Tags.
For example:
<html>
<head><title>php basics</title></head>
<body>
<h2>HELLO</h1>
<?php
echo "hello";
?>
</body>
</html>
In the above example PHP code is embedded within HTML. In this way PHP and HTML
coding is combined on the same page.
Since PHP is a server side scripting language, the PHP coding cannot be seen by the end
user through view source option, due to this feature PHP is very secure.
31
PHP is a parsed language; therefore PHP environment is necessary at the server for running
PHP scripts.
5.3 Working of PHP:
Figure 5.1 Working of PHP
When a client requests web page containing PHP code from the server, then the requested
PHP pages are parsed under PHP environment and interaction with database is made if
required.
After server side processing, the resulting HTML pages are passed to client and displayed
on the browser.
32
In this way the working of php is complete.
5.4 Connecting PHP Application to MySQL Database
1) Make a connection variable to the database:
$con= mysql_connect ("localhost","servername","password");
Here $con is a connection variable to database.
2) Select a database over that connection variable:
$db=mysql_select_db("databasename",$con);
3) Prepare a sql query to execute:
$qry= Select * from abc;
4) Run the sql query:
$result=mysql_query($qry);
5) Iterate over the result:
while($row = mysql_fetch_array($result))
{
//some logic
}
5.5 Introduction to MySQL:
MySQL is a relational database management system (RDBMS) that runs as a server

providing multi-user access to a number of databases. MySQL is officially pronounced
("My S-Q-L"), but is often pronounced ("My Sequel"). It is named for original developer
Michael Widenius's daughter My.
The MySQL development project has made its source code available under the terms of
the GNU General Public License, as well as under a variety of proprietary agreements.
33
MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL
AB, now owned by Sun Microsystems, a subsidiary of Oracle Corporation.
MySQL code uses C and C++. The SQL parser uses yacc and a home-brewed lexer,
sql_lex.cc.
MySQL works on many different system platforms, including AIX, BSDi, FreeBSD, HP-
UX, i5/OS, Linux, Mac OS X, NetBSD, Novell NetWare, OpenBSD, OpenSolaris,
eComStation, OS/2 Warp, QNX, IRIX, Solaris, Symbian, SunOS, SCO OpenServer, SCO
UnixWare, Sanos, Tru64 and Microsoft Windows. A port of MySQL to OpenVMS also
exists.
All major programming languages with language-specific APIs include Libraries for
accessing MySQL database. In addition, an ODBC interface called MyODBC allows
additional programming languages that support the ODBC interface to communicate with
a MySQL database, such as ASP or ColdFusion. The HTSQL - URL based query method
also ships with MySQL adapter allowing direct interaction with MySQL database from
any web client via structured URLs. The MySQL server and official libraries are mostly
implemented in ANSI C/ANSI C++.
5.6 Introduction to APACHE SERVER:
In this project apache server is used to parse and execute PHP pages, before deploying
websites on the server, the website should be tested at the developer side to get a feel of
how the website will work on actual server.
Therefore apache server is like a local server on the developer side, apache server should
be informed about the environment on which it should work.
In our project apache server is configured to work with PHP, in this way all the PHP pages
are parsed and executed by the server.
When apache is installed on the system, then its services is controlled by apache service
monitor.
34
Figure 5.2 APACHE Service Monitor
35
SOURCE CODE
6.1 Page
<?php
session_start();
error_reporting(0);
include('includes/config.php');
?>
<!DOCTYPE HTML>
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width,initial-scale=1">
<meta name="keywords" content="">
<meta name="description" content="">
<title>Car Rental Portal | Page details</title>

<link rel="stylesheet" href="assets/css/bootstrap.min.css" type="text/css">

<link rel="stylesheet" href="assets/css/style.css" type="text/css">

<link rel="stylesheet" href="assets/css/owl.carousel.css" type="text/css">
<link rel="stylesheet" href="assets/css/owl.transitions.css" type="text/css">

<link href="assets/css/slick.css" rel="stylesheet">

<link href="assets/css/bootstrap-slider.min.css" rel="stylesheet">

<link href="assets/css/font-awesome.min.css" rel="stylesheet">


<link rel="stylesheet" id="switcher-css" type="text/css"
href="assets/switcher/css/switcher.css" media="all" />
<link rel="alternate stylesheet" type="text/css" href="assets/switcher/css/red.css"
title="red" media="all" data-default-color="true" />
<link rel="alternate stylesheet" type="text/css" href="assets/switcher/css/orange.css"
title="orange" media="all" />
<link rel="alternate stylesheet" type="text/css" href="assets/switcher/css/blue.css"
title="blue" media="all" />
<link rel="alternate stylesheet" type="text/css" href="assets/switcher/css/pink.css"
title="pink" media="all" />
<link rel="alternate stylesheet" type="text/css" href="assets/switcher/css/green.css"
title="green" media="all" />
<link rel="alternate stylesheet" type="text/css" href="assets/switcher/css/purple.css"
title="purple" media="all" />


<link rel="apple-touch-icon-precomposed" sizes="144x144" href="assets/images/favicon-icon/apple-
touch-icon-144-precomposed.png">
36
touch-icon-114-precomposed.html">
<link rel="apple-touch-icon-precomposed" href="assets/images/favicon-icon/apple-touch-icon-57-
precomposed.png">
<link rel="shortcut icon" href="assets/images/favicon-icon/favicon.png">
<link href="https://fonts.googleapis.com/css?family=Lato:300,400,700,900" rel="stylesheet">
</head>
<body>
<
<?php include('includes/colorswitcher.php');?>


<?php include('includes/header.php');?>
<?php
$pagetype=$_GET['type'];
$sql = "SELECT type,detail,PageName from tblpages where type=:pagetype";
$query = $dbh -> prepare($sql);
$query->bindParam(':pagetype',$pagetype,PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{ ?>
<section class="page-header aboutus_page">
<div class="container">
<div class="page-header_wrap">
<div class="page-heading">
<h1><?php echo htmlentities($result->PageName); ?></h1>
</div>
<ul class="coustom-breadcrumb">
<li><a href="#">Home</a></li>
<li><?php echo htmlentities($result->PageName); ?></li>
</ul>
</div>
</div>

<div class="dark-overlay"></div>
</section>
<section class="about_us section-padding">
<div class="section-header text-center">
<h2><?php echo htmlentities($result->PageName); ?></h2>

<p><?php echo $result->detail; ?> </p>
</div>
<?php } }?>
</div>
</section>

37
<
<?php include('includes/footer.php');?>


<div id="back-top" class="back-top"> <a href="#top"><i class="fa fa-angle-up" aria-
hidden="true"></i> </a> </div>


<?php include('includes/login.php');?>


<?php include('includes/registration.php');?>


<?php include('includes/forgotpassword.php');?>



<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>
<script src="assets/js/interface.js"></script>

<script src="assets/switcher/js/switcher.js"></script>

<script src="assets/js/bootstrap-slider.min.js"></script>

<script src="assets/js/slick.min.js"></script>
<script src="assets/js/owl.carousel.min.js"></script>
</body>
</html>
38
6.2 Car Listing
<?php
session_start();
error_reporting(0);
?>
<!DOCTYPE HTML>
<html lang="en">
<head>
<title>Car Rental Portal | Car Listing</title>




touch-icon-114-precomposed.html">
39
precomposed.png">
</head>
<body>






<section class="page-header listing_page">
<h1>Car Listing</h1>
</div>
<li>Car Listing</li>
</ul>
</div>
</div>
</section>


<section class="listing-page">
<div class="row">
<div class="col-md-9 col-md-push-3">
<div class="result-sorting-wrapper">
<div class="sorting-count">
<?php
//Query for Listing count
$sql = "SELECT id from tblvehicles";
$query->bindParam(':vhid',$vhid, PDO::PARAM_STR);
$query->execute();
$cnt=$query->rowCount();
?>
<p><span><?php echo htmlentities($cnt);?> Listings</span></p>
</div>
</div>
<?php $sql = "SELECT tblvehicles.*,tblbrands.BrandName,tblbrands.id as bid from tblvehicles join

tblbrands on tblbrands.id=tblvehicles.VehiclesBrand";
40
$query->execute();
$cnt=1;
{
{ ?>
<div class="product-listing-m gray-bg">
<div class="product-listing-img"><img src="admin/img/vehicleimages/<?php echo
htmlentities($result->Vimage1);?>" class="img-responsive" alt="Image" /> </a>
</div>
<div class="product-listing-content">
<h5><a href="vehical-details.php?vhid=<?php echo htmlentities($result->id);?>"><?php echo
htmlentities($result->BrandName);?> , <?php echo htmlentities($result->VehiclesTitle);?></a></h5>
<p class="list-price">$<?php echo htmlentities($result->PricePerDay);?> Per Day</p>
<ul>
<li><i class="fa fa-user" aria-hidden="true"></i><?php echo htmlentities($result-
>SeatingCapacity);?> seats</li>
<li><i class="fa fa-calendar" aria-hidden="true"></i><?php echo htmlentities($result-
>ModelYear);?> model</li>
<li><i class="fa fa-car" aria-hidden="true"></i><?php echo htmlentities($result-
>FuelType);?></li>
</ul>
<a href="vehical-details.php?vhid=<?php echo htmlentities($result->id);?>" class="btn">View
Details <span class="angle_arrow"><i class="fa fa-angle-right" aria-hidden="true"></i></span></a>
</div>
</div>
<?php }} ?>
</div>

<aside class="col-md-3 col-md-pull-9">
<div class="sidebar_widget">
<div class="widget_heading">
<h5><i class="fa fa-filter" aria-hidden="true"></i> Find Your Car </h5>
</div>
<div class="sidebar_filter">
<form action="search-carresult.php" method="post">
<div class="form-group select">
<select class="form-control" name="brand">
<option>Select Brand</option>
<?php $sql = "SELECT * from tblbrands ";

$query->execute();
$cnt=1;
{
{ ?>
<option value="<?php echo htmlentities($result->id);?>"><?php echo htmlentities($result-
>BrandName);?></option>
<?php }} ?>
</select>
</div>
41
<div class="form-group select">
<select class="form-control" name="fueltype">
<option>Select Fuel Type</option>
<option value="Petrol">Petrol</option>
<option value="Diesel">Diesel</option>
<option value="CNG">CNG</option>
</select>
</div>
<div class="form-group">
<button type="submit" class="btn btn-block"><i class="fa fa-search" aria-
hidden="true"></i> Search Car</button>
</div>
</form>
</div>
</div>
<div class="sidebar_widget">
<div class="widget_heading">
<h5><i class="fa fa-car" aria-hidden="true"></i> Recently Listed Cars</h5>
</div>
<div class="recent_addedcars">
<ul>
<?php $sql = "SELECT tblvehicles.*,tblbrands.BrandName,tblbrands.id as bid from tblvehicles join
tblbrands on tblbrands.id=tblvehicles.VehiclesBrand order by id desc limit 4";
$query->execute();
$cnt=1;
{
{ ?>
<li class="gray-bg">
<div class="recent_post_img"> <a href="vehical-details.php?vhid=<?php echo
htmlentities($result->id);?>"><img src="admin/img/vehicleimages/<?php echo htmlentities($result-
>Vimage1);?>" alt="image"></a> </div>
<div class="recent_post_title"> <a href="vehical-details.php?vhid=<?php echo
htmlentities($result->id);?>"><?php echo htmlentities($result->BrandName);?> , <?php echo
htmlentities($result->VehiclesTitle);?></a>
<p class="widget_price">$<?php echo htmlentities($result->PricePerDay);?> Per Day</p>
</div>
</li>
<?php }} ?>
</ul>
</div>
</div>
</aside>

</div>
</div>
</section>


42


<div id="back-top" class="back-top"> <a href="#top"><i class="fa fa-angle-up" aria-
hidden="true"></i> </a> </div>







</body>
</html>
43
6.3 Check Availability
<?php
require_once("includes/config.php");
// code user email availablity
if(!empty($_POST["emailid"])) {
$email= $_POST["emailid"];
if (filter_var($email, FILTER_VALIDATE_EMAIL)===false) {
echo "error : You did not enter a valid email.";

}
else {
$sql ="SELECT EmailId FROM tblusers WHERE EmailId=:email";
$query= $dbh -> prepare($sql);
$query-> bindParam(':email', $email, PDO::PARAM_STR);
$query-> execute();
$results = $query -> fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query -> rowCount() > 0)
{
echo "<span style='color:red'> Email already exists .</span>";
echo "<script>$('#submit').prop('disabled',true);</script>";
} else{
echo "<span style='color:green'> Email available for Registration .</span>";

echo "<script>$('#submit').prop('disabled',false);</script>";
}
}
}
?>
44
6.4 Contact Us
<?php
session_start();
error_reporting(0);
if(isset($_POST['send']))
{
$name=$_POST['fullname'];
$email=$_POST['email'];
$contactno=$_POST['contactno'];
$message=$_POST['message'];
$sql="INSERT INTO tblcontactusquery(name,EmailId,ContactNumber,Message)
VALUES(:name,:email,:contactno,:message)";
$query = $dbh->prepare($sql);
$query->bindParam(':name',$name,PDO::PARAM_STR);
$query->bindParam(':email',$email,PDO::PARAM_STR);
$query->bindParam(':contactno',$contactno,PDO::PARAM_STR);
$query->bindParam(':message',$message,PDO::PARAM_STR);
$query->execute();
$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
$msg="Query Sent. We will contact you shortly";
}
else
{
$error="Something went wrong. Please try again";
}
}
?>
<!DOCTYPE HTML>
<html lang="en">
<head>
<title>CarForYou - Responsive Car Dealer HTML5 Template</title>

45


<link rel="apple-touch-icon-precomposed" sizes="144x144" href="assets/images/favicon-icon/apple-touch-
icon-144-precomposed.png">
icon-114-precomposed.html">
icon-72-precomposed.png">
precomposed.png">
<style>
.errorWrap {
padding: 10px;
margin: 0 0 20px 0;
background: #fff;
border-left: 4px solid #dd3d36;
-webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
}
.succWrap{
padding: 10px;
margin: 0 0 20px 0;
background: #fff;
border-left: 4px solid #5cb85c;
-webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
}
</style>
</head>
<body>
<




46

<section class="page-header contactus_page">
<h1>Contact Us</h1>
</div>
<li>Contact Us</li>
</ul>
</div>
</div>
</section>


<section class="contact_us section-padding">
<div class="row">
<div class="col-md-6">
<h3>Get in touch using the form below</h3>
<?php if($error){?><div class="errorWrap"><strong>ERROR</strong>:<?php echo
htmlentities($error); ?> </div><?php }
else if($msg){?><div class="succWrap"><strong>SUCCESS</strong>:<?php echo
htmlentities($msg); ?> </div><?php }?>
<div class="contact_form gray-bg">
<form method="post">
<label class="control-label">Full Name <span>*</span></label>
<input type="text" name="fullname" class="form-control white_bg" id="fullname" required>
</div>
<label class="control-label">Email Address <span>*</span></label>
<input type="email" name="email" class="form-control white_bg" id="emailaddress" required>
</div>
<label class="control-label">Phone Number <span>*</span></label>
<input type="text" name="contactno" class="form-control white_bg" id="phonenumber" required>
</div>
<label class="control-label">Message <span>*</span></label>
<textarea class="form-control white_bg" name="message" rows="4" required></textarea>
</div>
<button class="btn" type="submit" name="send" type="submit">Send Message <span
class="angle_arrow"><i class="fa fa-angle-right" aria-hidden="true"></i></span></button>
</div>
</form>
</div>
</div>
<div class="col-md-6">
<h3>Contact Info</h3>
<div class="contact_detail">
47
<?php
$pagetype=$_GET['type'];
$sql = "SELECT Address,EmailId,ContactNo from tblcontactusinfo";
$query->bindParam(':pagetype',$pagetype,PDO::PARAM_STR);
$query->execute();
$cnt=1;
{
{ ?>
<ul>
<li>
<div class="icon_wrap"><i class="fa fa-map-marker" aria-hidden="true"></i></div>
<div class="contact_info_m"><?php echo htmlentities($result->Address); ?></div>
</li>
<li>
<div class="icon_wrap"><i class="fa fa-phone" aria-hidden="true"></i></div>
<div class="contact_info_m"><a href="tel:61-1234-567-90"><?php echo htmlentities($result-
>EmailId); ?></a></div>
</li>
<li>
<div class="icon_wrap"><i class="fa fa-envelope-o" aria-hidden="true"></i></div>
<div class="contact_info_m"><a href="mailto:contact@exampleurl.com"><?php echo
htmlentities($result->ContactNo); ?></a></div>
</li>
</ul>
<?php }} ?>
</div>
</div>
</div>
</div>
</section>




<div id="back-top" class="back-top"> <a href="#top"><i class="fa fa-angle-up" aria-hidden="true"></i>
</a> </div>



48





</body>

</html>
49
6.5 Database
-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 06, 2017 at 08:10 PM
-- Server version: 5.6.20
-- PHP Version: 5.5.15
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `carrental`
--
-- --------------------------------------------------------
--
-- Table structure for table àdmin`
--
CREATE TABLE IF NOT EXISTS àdmin` (

ìd` int(11) NOT NULL,
ÙserName` varchar(100) NOT NULL,
`Password` varchar(100) NOT NULL,
ùpdationDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE
CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table àdmin`
--
INSERT INTO àdmin` (ìd`, ÙserName`, `Password`, ùpdationDate`) VALUES

(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '2017-07-05 11:02:08');
-- --------------------------------------------------------
--
-- Table structure for table `tblbooking`
--
CREATE TABLE IF NOT EXISTS `tblbooking` (

ùserEmail` varchar(100) DEFAULT NULL,
`VehicleId` int(11) DEFAULT NULL,
50
`FromDate` varchar(20) DEFAULT NULL,
`ToDate` varchar(20) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`Status` int(11) DEFAULT NULL,
`PostingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
--
-- Dumping data for table `tblbooking`
--
INSERT INTO `tblbooking` (ìd`, ùserEmail`, `VehicleId`, `FromDate`, `ToDate`, `message`, `Status`,
`PostingDate`) VALUES
(1, 'test@gmail.com', 2, '22/06/2017', '25/06/2017', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit,
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
exercitation ullamco', 1, '2017-06-19 20:15:43'),
(2, 'test@gmail.com', 3, '30/06/2017', '02/07/2017', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit,
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud
exercitation ullamco', 2, '2017-06-26 20:15:43'),
(3, 'test@gmail.com', 4, '02/07/2017', '07/07/2017', 'Lorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ', 0, '2017-06-26 21:10:06'),
(4, 'test1@gmail.com', 1, '11/07/2017', '12/07/2018', 'ddddddddddd', 0, '2017-06-29 18:20:45'),
(5, 'php@gmail.com', 6, '11/07/2017', '12/07/2017', 'i want to hire this taxi for few hours', 1, '2017-07-05
11:09:18');
-- --------------------------------------------------------
--
-- Table structure for table `tblbrands`
--
CREATE TABLE IF NOT EXISTS `tblbrands` (

`BrandName` varchar(120) NOT NULL,
`CreationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
ÙpdationDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
--
-- Dumping data for table `tblbrands`
--
INSERT INTO `tblbrands` (ìd`, `BrandName`, `CreationDate`, ÙpdationDate`) VALUES

(1, 'Maruti', '2017-06-18 16:24:34', '2017-06-19 06:42:23'),
(2, 'BMW', '2017-06-18 16:24:50', NULL),
(3, 'Audi', '2017-06-18 16:25:03', NULL),
(4, 'Nissan', '2017-06-18 16:25:13', NULL),
(5, 'Toyota', '2017-06-18 16:25:24', NULL),
(7, 'Marutiu', '2017-06-19 06:22:13', NULL),
(8, 'Taxi', '2017-07-05 11:02:29', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `tblcontactusinfo`
--
51
CREATE TABLE IF NOT EXISTS `tblcontactusinfo` (
Àddress` tinytext,
ÈmailId` varchar(255) DEFAULT NULL,
`ContactNo` char(11) DEFAULT NULL
--
-- Dumping data for table `tblcontactusinfo`
--
INSERT INTO `tblcontactusinfo` (ìd`, Àddress`, ÈmailId`, `ContactNo`) VALUES

(1, 'Test Demo test demo
', 'test@test.com', '8585233222');
-- --------------------------------------------------------
--
-- Table structure for table `tblcontactusquery`
--
CREATE TABLE IF NOT EXISTS `tblcontactusquery` (

`name` varchar(100) DEFAULT NULL,
`ContactNumber` char(11) DEFAULT NULL,
`Message` longtext,
`PostingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` int(11) DEFAULT NULL
--
-- Dumping data for table `tblcontactusquery`
--
INSERT INTO `tblcontactusquery` (ìd`, `name`, ÈmailId`, `ContactNumber`, `Message`, `PostingDate`,

`status`) VALUES
(1, 'Anuj Kumar', 'webhostingamigo@gmail.com', '2147483647', 'Lorem Ipsum is simply dummy text of the
printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the
1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has
survived not only five centuries, but also the leap into electronic typesetting, remaining essentially
unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum
passages, and more recently with desktop publishing software like Aldus PageMaker including versions of
Lorem Ipsum', '2017-06-18 10:03:07', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tblpages`
--
CREATE TABLE IF NOT EXISTS `tblpages` (

`PageName` varchar(255) DEFAULT NULL,
52
`type` varchar(255) NOT NULL DEFAULT '',
`detail` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
--
-- Dumping data for table `tblpages`
--
INSERT INTO `tblpages` (ìd`, `PageName`, `type`, `detail`) VALUES

(1, 'Terms and Conditions', 'terms', '<P align=justify><FONT size=2><STRONG><FONT
color=#990000>(1) ACCEPTANCE OF TERMS</FONT><BR><BR></STRONG>Welcome to Yahoo!
India. 1Yahoo Web Services India Private Limited Yahoo", "we" or "us" as the case may be) provides the
Service (defined below) to you, subject to the following Terms of Service ("TOS"), which may be updated
by us from time to time without notice to you. You can review the most current version of the TOS at any
time at: <A href="http://in.docs.yahoo.com/info/terms/">http://in.docs.yahoo.com/info/terms/</A>. In
addition, when using particular Yahoo services or third party services, you and Yahoo shall be subject to any
posted guidelines or rules applicable to such services which may be posted from time to time. All such
guidelines or rules, which maybe subject to change, are hereby incorporated by reference into the TOS. In
most cases the guides and rules are specific to a particular part of the Service and will assist you in applying
the TOS to that part, but to the extent of any inconsistency between the TOS and any guide or rule, the TOS
will prevail. We may also offer other services from time to time that are governed by different Terms of
Services, in which case the TOS do not apply to such other services if and to the extent expressly excluded
by such different Terms of Services. Yahoo also may offer other services from time to time that are governed
by different Terms of Services. These TOS do not apply to such other services that are governed by different
Terms of Service. </FONT></P>\r\n<P align=justify><FONT size=2>Welcome to Yahoo! India. Yahoo
Web Services India Private Limited Yahoo", "we" or "us" as the case may be) provides the Service (defined
below) to you, subject to the following Terms of Service ("TOS"), which may be updated by us from time to
time without notice to you. You can review the most current version of the TOS at any time at: </FONT><A
href="http://in.docs.yahoo.com/info/terms/"><FONT
size=2>http://in.docs.yahoo.com/info/terms/</FONT></A><FONT size=2>. In addition, when using
particular Yahoo services or third party services, you and Yahoo shall be subject to any posted guidelines or
rules applicable to such services which may be posted from time to time. All such guidelines or rules, which
maybe subject to change, are hereby incorporated by reference into the TOS. In most cases the guides and
rules are specific to a particular part of the Service and will assist you in applying the TOS to that part, but
to the extent of any inconsistency between the TOS and any guide or rule, the TOS will prevail. We may also
offer other services from time to time that are governed by different Terms of Services, in which case the
TOS do not apply to such other services if and to the extent expressly excluded by such different Terms of
Services. Yahoo also may offer other services from time to time that are governed by different Terms of
Services. These TOS do not apply to such other services that are governed by different Terms of Service.
</FONT></P>\r\n<P align=justify><FONT size=2>Welcome to Yahoo! India. Yahoo Web Services India
Private Limited Yahoo", "we" or "us" as the case may be) provides the Service (defined below) to you, subject
to the following Terms of Service ("TOS"), which may be updated by us from time to time without notice to
you. You can review the most current version of the TOS at any time at: </FONT><A
href="http://in.docs.yahoo.com/info/terms/"><FONT
size=2>http://in.docs.yahoo.com/info/terms/</FONT></A><FONT size=2>. In addition, when using
particular Yahoo services or third party services, you and Yahoo shall be subject to any posted guidelines or
rules applicable to such services which may be posted from time to time. All such guidelines or rules, which
maybe subject to change, are hereby incorporated by reference into the TOS. In most cases the guides and
rules are specific to a particular part of the Service and will assist you in applying the TOS to that part, but
to the extent of any inconsistency between the TOS and any guide or rule, the TOS will prevail. We may also
offer other services from time to time that are governed by different Terms of Services, in which case the
TOS do not apply to such other services if and to the extent expressly excluded by such different Terms of
Services. Yahoo also may offer other services from time to time that are governed by different Terms of
Services. These TOS do not apply to such other services that are governed by different Terms of Service.
</FONT></P>'),
53
(2, 'Privacy Policy', 'privacy', '<span style="color: rgb(0, 0, 0); font-family: "Open Sans", Arial,
sans-serif; font-size: 14px; text-align: justify;">At vero eos et accusamus et iusto odio dignissimos ducimus
qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint
occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum
et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta
nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis
voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis debitis aut
rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque
earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut
perferendis doloribus asperiores repellat</span>'),
(3, 'About Us ', 'aboutus', '<span style="color: rgb(0, 0, 0); font-family: "Open Sans", Arial, sans-
serif; text-align: justify;">At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis
praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati
cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum
fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est
eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas
assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis debitis aut rerum
necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum
rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis
doloribus asperiores repellat</span>'),
(11, 'FAQs', 'faqs', '
<span style="color: rgb(0, 0, 0);

font-family: "Open Sans", Arial, sans-serif; font-size: 14px; text-align: justify;">Address------
Test dsfdsfds</span>');
-- --------------------------------------------------------
--
-- Table structure for table `tblsubscribers`
--
CREATE TABLE IF NOT EXISTS `tblsubscribers` (

`SubscriberEmail` varchar(120) DEFAULT NULL,
`PostingDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
--
-- Dumping data for table `tblsubscribers`
--
INSERT INTO `tblsubscribers` (ìd`, `SubscriberEmail`, `PostingDate`) VALUES

(1, 'anuj.lpu1@gmail.com', '2017-06-22 16:35:32');
-- --------------------------------------------------------
--
-- Table structure for table `tbltestimonial`
--
CREATE TABLE IF NOT EXISTS `tbltestimonial` (

ÙserEmail` varchar(100) NOT NULL,
`Testimonial` mediumtext NOT NULL,
`PostingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
54
`status` int(11) DEFAULT NULL
--
-- Dumping data for table `tbltestimonial`
--
INSERT INTO `tbltestimonial` (ìd`, ÙserEmail`, `Testimonial`, `PostingDate`, `status`) VALUES

(1, 'test@gmail.com', 'Test Test', '2017-06-18 07:44:31', 1),
(2, 'test@gmail.com', '\nLorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam nibh. Nunc varius
facilis', '2017-06-18 07:46:05', 1),
(3, 'php@gmail.com', 'Wow its Great ', '2017-07-05 11:08:26', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `tblusers`
--
CREATE TABLE IF NOT EXISTS `tblusers` (

`FullName` varchar(120) DEFAULT NULL,
`Password` varchar(100) DEFAULT NULL,
`ContactNo` char(11) DEFAULT NULL,
`dob` varchar(100) DEFAULT NULL,
Àddress` varchar(255) DEFAULT NULL,
`City` varchar(100) DEFAULT NULL,
`Country` varchar(100) DEFAULT NULL,
`RegDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
--
-- Dumping data for table `tblusers`
--
INSERT INTO `tblusers` (ìd`, `FullName`, ÈmailId`, `Password`, `ContactNo`, `dob`, Àddress`, `City`,
`Country`, `RegDate`, ÙpdationDate`) VALUES
(1, 'Anuj Kumar', 'demo@gmail.com', 'f925916e2754e5e03f75dd58a5733251', '2147483647', NULL,
NULL, NULL, NULL, '2017-06-17 19:59:27', '2017-06-26 21:02:58'),
(2, 'AK', 'anuj@gmail.com', 'f925916e2754e5e03f75dd58a5733251', '8285703354', NULL, NULL, NULL,
NULL, '2017-06-17 20:00:49', '2017-06-26 21:03:09'),
(3, 'Anuj Kumar', 'webhostingamigo@gmail.com', 'f09df7868d52e12bba658982dbd79821', '09999857868',
'03/02/1990', 'New Delhi', 'New Delhi', 'New Delhi', '2017-06-17 20:01:43', '2017-06-17 21:07:41'),
(4, 'Anuj Kumar', 'test@gmail.com', '5c428d8875d2948607f3e3fe134d71b4', '9999857868', '', 'New Delhi',
'Delhi', 'Delhi', '2017-06-17 20:03:36', '2017-06-26 19:18:14'),
(5, 'test', 'test1@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', '9015501898', NULL, NULL, NULL,
NULL, '2017-06-29 18:19:08', NULL),
(6, 'php', 'php@gmail.com', '202cb962ac59075b964b07152d234b70', '9015501898', NULL, NULL, NULL,
NULL, '2017-07-05 11:06:55', '2017-07-05 11:08:02');
-- --------------------------------------------------------
--
-- Table structure for table `tblvehicles`
55
--
CREATE TABLE IF NOT EXISTS `tblvehicles` (

`VehiclesTitle` varchar(150) DEFAULT NULL,
`VehiclesBrand` int(11) DEFAULT NULL,
`VehiclesOverview` longtext,
`PricePerDay` int(11) DEFAULT NULL,
`FuelType` varchar(100) DEFAULT NULL,
`ModelYear` int(6) DEFAULT NULL,
`SeatingCapacity` int(11) DEFAULT NULL,
`Vimage1` varchar(120) DEFAULT NULL,
ÀirConditioner` int(11) DEFAULT NULL,
`PowerDoorLocks` int(11) DEFAULT NULL,
ÀntiLockBrakingSystem` int(11) DEFAULT NULL,
`BrakeAssist` int(11) DEFAULT NULL,
`PowerSteering` int(11) DEFAULT NULL,
`DriverAirbag` int(11) DEFAULT NULL,
`PassengerAirbag` int(11) DEFAULT NULL,
`PowerWindows` int(11) DEFAULT NULL,
`CDPlayer` int(11) DEFAULT NULL,
`CentralLocking` int(11) DEFAULT NULL,
`CrashSensor` int(11) DEFAULT NULL,
`LeatherSeats` int(11) DEFAULT NULL,
`RegDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
--
-- Dumping data for table `tblvehicles`
--
INSERT INTO `tblvehicles` (ìd`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`,

`FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`,
ÀirConditioner`, `PowerDoorLocks`, ÀntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`,
`DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`,
`LeatherSeats`, `RegDate`, ÙpdationDate`) VALUES
(1, 'ytb rvtr', 2, 'vtretrvet', 345345, 'Petrol', 3453, 7, 'knowledge_base_bg.jpg', '20170523_145633.jpg',
'phpgurukul-1.png', 'social-icons.png', '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2017-06-19 11:46:23', '2017-06-20
18:38:13'),
(2, 'Test Demoy', 2, 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam nibh. Nunc varius facilisis
eros. Sed erat. In in velit quis arcu ornare laoreet. Curabitur adipiscing luctus massa. Integer ut purus ac augue
commodo commodo. Nunc nec mi eu justo tempor consectetuer. Etiam vitae nisl. In dignissim lacus ut ante.
Cras elit lectus, bibendum a, adipiscing vitae, commodo et, dui. Ut tincidunt tortor. Donec nonummy, enim
in lacinia pulvinar, velit tellus scelerisque augue, ac posuere libero urna eget neque. Cras ipsum. Vestibulum
pretium, lectus nec venenatis volutpat, purus lectus ultrices risus, a condimentum risus mi et quam.
Pellentesque auctor fringilla neque. Duis eu massa ut lorem iaculis vestibulum. Maecenas facilisis elit sed
justo. Quisque volutpat malesuada velit. ', 859, 'CNG', 2015, 4, 'car_755x430.png', 'looking-used-car.png',
'banner-image.jpg', 'about_services_faq_bg.jpg', '', 1, 1, 1, 1, 1, 1, 1, NULL, 1, 1, NULL, NULL, '2017-06-
19 16:16:17', '2017-06-21 16:57:11'),
(3, 'Lorem ipsum', 4, 'Lorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
56
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsum', 563, 'CNG', 2012, 5, 'featured-
img-3.jpg', 'dealer-logo.jpg', 'img_390x390.jpg', 'listing_img3.jpg', '', 1, 1, 1, 1, 1, 1, NULL, 1, 1, NULL,
NULL, NULL, '2017-06-19 16:18:20', '2017-06-20 18:40:11'),
(4, 'Lorem ipsum', 1, 'Lorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem
ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsumLorem ipsum', 5636, 'CNG', 2012, 5, 'featured-
img-3.jpg', 'featured-img-1.jpg', 'featured-img-1.jpg', 'featured-img-1.jpg', '', 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL,
NULL, NULL, '2017-06-19 16:18:43', '2017-06-20 18:44:12'),
(5, 'ytb rvtr', 5, 'vtretrvet', 345345, 'Petrol', 3453, 7, 'car_755x430.png', NULL, NULL, NULL, NULL, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2017-06-20 17:57:09', '2017-06-21 16:56:43'),
(6, 'Waganor Taxi', 8, 'Its Well matintaied', 10, 'Petrol', 2017, 4, 'Koala.jpg', 'Desert.jpg', 'Hydrangeas.jpg',
'Jellyfish.jpg', '', 1, 1, 1, NULL, 1, 1, NULL, 1, 1, 1, NULL, 1, '2017-07-05 11:04:18', NULL);
--
-- Indexes for dumped tables
--
--
-- Indexes for table àdmin`
--
ALTER TABLE àdmin`
ADD PRIMARY KEY (ìd`);
--
-- Indexes for table `tblbooking`
--
ALTER TABLE `tblbooking`
--
-- Indexes for table `tblbrands`
--
ALTER TABLE `tblbrands`
--
-- Indexes for table `tblcontactusinfo`
--
ALTER TABLE `tblcontactusinfo`
--
-- Indexes for table `tblcontactusquery`
--
ALTER TABLE `tblcontactusquery`
--
57
-- Indexes for table `tblpages`
--
ALTER TABLE `tblpages`
--
-- Indexes for table `tblsubscribers`
--
ALTER TABLE `tblsubscribers`
--
-- Indexes for table `tbltestimonial`
--
ALTER TABLE `tbltestimonial`
--
-- Indexes for table `tblusers`
--
ALTER TABLE `tblusers`
--
-- Indexes for table `tblvehicles`
--
ALTER TABLE `tblvehicles`
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table àdmin`
--
ALTER TABLE àdmin`
MODIFY ìd` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tblbooking`
--
ALTER TABLE `tblbooking`
--
-- AUTO_INCREMENT for table `tblbrands`
--
ALTER TABLE `tblbrands`
--
-- AUTO_INCREMENT for table `tblcontactusinfo`
--
ALTER TABLE `tblcontactusinfo`
--
-- AUTO_INCREMENT for table `tblcontactusquery`
--
58
ALTER TABLE `tblcontactusquery`
--
-- AUTO_INCREMENT for table `tblpages`
--
ALTER TABLE `tblpages`
--
-- AUTO_INCREMENT for table `tblsubscribers`
--
ALTER TABLE `tblsubscribers`
--
-- AUTO_INCREMENT for table `tbltestimonial`
--
ALTER TABLE `tbltestimonial`
--
-- AUTO_INCREMENT for table `tblusers`
--
ALTER TABLE `tblusers`
--
-- AUTO_INCREMENT for table `tblvehicles`
--
ALTER TABLE `tblvehicles`
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
59
OUTPUT SCREEN-SHOTS
7.1 Sign Up Page
7.2 Home Page
60
7.3 Subscription Page
7.4 Car Listing Page
61
CONCLUSION
Car rental business has emerged with a new goodies compared to the past experience where
every activity concerning car rental business is limited to a physical location only. Even
though the physical location has not been totally eradicated; the nature of functions and
how these functions are achieved has been reshaped by the power of internet. Nowadays,
customers can reserve cars online, rent car online, and have the car brought to their door
step once the customer is a registered member or go to the office to pick the car.
The web based car rental system has offered an advantage to both customers as well as Car
Rental Company to efficiently and effectively manage the business and satisfies customers’
need at the click of a button.
62

Car Rental System Project Report

Uploaded by

Copyright:

Available Formats

Car Rental System Project Report

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Car Rental System Project Report

Uploaded by

Copyright:

Available Formats

A MAJOR PROJECT REPORT ON

CAR RENATL SYSTEM

Submitted in partial fulfillment of the requirements

BACHELOR OF COMPUTER APPLICATIONS

Submitted to: Submitted by:

TRINITY INSTITUTE OF PROFESSIONAL

S NO. TITLE PAGE NO.

Date: Signature of the Student

I am really thankful to her.

S NO. FIGURES PAGE NO.

1. Data Flow Diagram 12-13

2. Use Case Diagram 14-17

3. Activity Diagram 18-24

4. Sequence Diagram 25-28

This project is designed so as to be used by Car Rental Company specializing in renting

1.2 Reason for the Project

1.3 Problem Statement

2.1 How Existing System Work

2.2 Benefits of Online Car Rental Services

• This online car rental solution is fully functional and flexible.

3.1 Functional Requirements

Requirement analysis is a software engineering technique that is composed of the various

3.2 Non-Functional Requirements

DATA FLOW DIAGRAMS

4.1.1 Data Flow Diagram (DFD)

EMAIL FOR RESERVED CAR

RESERVE A CAR EMAIL FOR RESERVED CAR

Figure 4.1.1 Level 0 DFD of Online Car Rental System

Functions of Car Rental Company:

LOGIN SELECT LOGIN DETAILS

RETURN MAKE ADD/UPDATE

Figure 4.1.2 Level 1 DFD of Online Car Rental System

4.2.1 Actor and Use Case Description

Actor Use Case Use Case Description

This use case describes the activities of the

This use case enable customer to search and make

This use case describes the event of customer

Give feedback This use case is used by the customer to provide

Reply to This use case describes the event by which staff

Admin It is invoke whenever a new staff join the company.

View report This use case is used by the Admin to view

Table 4.2.1 Actors and Use Case Description

Register as member Add new car

Figure 4.2.2: E-Car Rental System [use case]

Figure 4.2.3: Use Case Dependency Diagram

4.3.1 Activity Diagram

4.3.1.1 Member Registration

Customer E-Car Rental System

Enter username and

Accept terms & [No]

Figure 4.3.1.1: Register as member

Customer E-Car Rental System

Navigate to Edit [Yes]

Modify your profile

Confirm and submit

Figure 4.3.1.2: Modify profile

Customer E-Car Rental System

Choose pick up date

Choose return date