0% found this document useful (0 votes)

43 views220 pages

777

Uploaded by

pebbilijayanthnikhil

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

43 views220 pages

777

Uploaded by

pebbilijayanthnikhil

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 220

NEXT-GEN MALWARE LINK DETECTION AND

ANALYSIS PLATFORM
AMini-project Report submitted
in partial fulfilment for the award of the Degree of

Bachelor of Technology in
Computer Science and Engineering

PEBBILI JAYANTH NIKHIL U21CN088

PUTTA SAI SWAROOP U21CN118

PENDLI AJAY KUMAR U21CN093

RAGHUNATHAPUR PRIYANKA U21CN125

Under the guidanceof

Dr.S.Maruthuperumal

DEPARTMENT OFCOMPUTER SCIENCEAND ENGINEERING

SCHOOLOF COMPUTING

BHARATHINSTITUTE OF HIGHER EDUCATIONAND RESEARCH

(Deemed to be University Estd u/s 3 of UGC Act, 1956)

CHENNAI 600 073,TAMILNADU, INDIA

November/ December, 2024
BatchNo. B12

DEPARTMENT OFCOMPUTER SCIENCE & ENGINEERING

BONAFIDE CERTIFICATE
This is to Certify that this Mini-Project Report Titled “NEXT-GEN
MALWARE LINK DETECTION AND ANALYSIS PLATFORM” is the
Bonafide Work of PEBBILI JAYANTH NIKHIL(U21CN088),PUTTA SAI
SWAROOP(U21CN118),PENDLI AJAY KUMAR(U21CN093), RAGHUNATHAPUR
PRIYANKA (U21CN125) who carried out the mini project work under my
supervision. Certified further, that to the best of my knowledge the work
reported here in does not form part of any other project report or dissertation
on basis of which a degree or award conferred on an earlier occasion by any
other candidate.

PROJECT GUIDE HEAD OF THE DEPARTMENT

Dr. S.Maruthuperumal Dr. S. Maruthuperumal

Professor Professor
Department of CSE Department of CSE
BIHER BIHER

Submitted for Semester Mini-Project viva-voce examination held on

INTERNALEXAMINER EXTERNALEXAMINER
DECLARATION

We declare that this Mini-project report titled”NEXT-GEN MALWARE LINK

DEETECTION AND ANALYSIS PLATFORM” submitted in partial fulfillment of
the degree of B. Tech in (Computer Science and Engineering) is a record of
original work carried out by us under the supervision of Dr. S.Maruthuperumal,
and has not formed the basis for the award of any other degree or diploma, in
this or any other Institution or University. In keeping with the ethical practice
in reporting scientific information, due acknowledgements have been made
wherever the findings of others have been cited.

PEBBILI JAYANTH NIKHIL

(U21CN088)

PUTTA SAI SWAROOP

(U21CN118)

PENDLI AJAY KUMAR

(U21CN093)

RAGHUNATHAPUR PRIYAKA
(U21CN125)

Chennai
15-11-2024
ACKNOWLEDMENTS

We express our heartfelt gratitude to our esteemed Chairman, Dr.S. Jagathrakshakan,

M.P., for his unwavering support and continuous encouragement in all our academic
endeavors.
We express our deepest gratitude to our beloved President Dr. J. Sundeep Aanand
President, and Managing Director Dr. E. Swetha Sundeep Aanand Managing Director for
providing us the necessary facilities to complete our project.
We take great pleasure in expressing sincere thanks to Dr. K. VijayaBaskar Raju
ProChancellor, Dr. M. Sundararajan Vice Chancellor (i/c), Dr. S. Bhuminathan Registrar
and Dr. R. Hariprakash Additional Registrar, Dr. M. Sundararaj Dean Academics for
moldings our thoughts to complete our project.
We thank our Dr. S. Neduncheliyan Dean, School of Computing for his encouragement
and the valuable guidance.
We record indebtedness to our Head, Dr. S. Maruthuperumal, Department of
Computer Science and Engineering for his immense care and encouragement towardsus
throughout the course of this project.
We also take this opportunity to express a deep sense of gratitude to our Supervisor Dr.
S.Maruthuperumal and our Project Co-Ordinator Mr. K. Sivaraman for their cordial
support, valuable information, and guidance, they helped us in completing this project
throughvarious stages.
We thank our department faculty, supporting staff and friends for their help and guidance
to complete this project

PEBBILI JAYANTH NIKHIL U21CN088

PUTTA SAI SWAROOP U21CN118

PENDLI AJAY KUMAR U21CN093

RAGHUNATHAAPUR PRIYANKA U21CN125

The increasing sophistication of modern malware presents significant challenges for tradition
a next-generation malware link detection system designed to identify and block malicious
improves upon traditional rule-based and signature-based approaches.

The system integrates multiple detection layers, including URL reputation analysis, domain a
adapt to evolving threats by training models on diverse, up-to-date datasets of known malwa

The experimental results demonstrate a significant improvement in the detection rate and red
protection, offering real-time alerts and automated mitigation strategies. The findings indi
exploitation.
TABLEOFCONTENTS

CHAPTER – 1 INTRODUCTION……………………………...1
CHAPTER – 2 ANALYSIS……………………………………...5
1. Existing System…………………………………………………………..6
2. Need For The New System……………………………………………....6
3. Main Objective Of The New System………………………………….....6
CHAPTER – 3 SYSTEM REQUIREMENT STUDY
1. Hardware Requirements……………………………………………….…9
2. Software Requirements……………………………………………….…..9
3. PHP Language……………………………………………………….……9
4. Common Uses Of PHP…………………………………………….…….10
5. Characteristics Of PHP…………………………………………….…….10
CHAPTER – 4 FUNCTIONAL SPECIFICATIONS
1. Modules………………………………………………………….……….12
2. Module Specifications……………………………………………....…12
CHAPTER – 5 SYSTEM DESIGN
1. FeasibilityStudy………………………………………………………….16
2. Economic Feasibility…………………………………………………..16
3. Operational Feasibility…………………………………………………17
4. BehaviouralFesibility…………………………………………………….17
5. Technical Feasibility…………………………………………….……..17
6. System Design Process……………………………………………..…..18
7. 7. Design Tools……………………………………………………..….18

CHAPTER – 6 DATAFLOW DIAGRAM………………………19

1. Data Flow Chart…………………………………………………..….20
1. Data Flow Diagram……………………………………………….….20

CHAPTER – 7 ER DIAGRAM………………………………21
1. ER Diagram…………………………………………………..………22

CHAPTER – 8 USECASE DIAGRAM ……………………..24

1. Usecase Diagram
2. Usecase Diagram For Admin
3. Usecase Diagram For User
4. Activity Diagram ForAdmin
5. Activity Diagram For User

CHAPTER – 9 TESTING……………………………………...30
1. Types Of Testing………………………………………………………30
1. Acceptance Testing ……………………………………...……...31

2. System Testing………………………………………..…………31

3. IntegrationTesting……………………………………...………..31
4. Unit Testing…………………………………………...…………32
2. Methods Of Software Testing…………………………………..………32
3. Testing Principles………………………………………………...……..33
4. Error Handling…………………………………………………………..33

CHAPTER – 10 SYSTEM VALIDATION AND VERIFICATION…34

CHAPTER – 11 DATABASE DESIGN………………………….37

CHAPTER – 12 SCREENSHOTS ……………………………….43

1. Admin Modules…………………………………………………………..44
1. Admin Login
2. Dashboard
3. Change Password
4. Manage Brands
5. Post A vehicle
6. ManageVehicles
7. Manage Bookings
8. Registered Users
2. User Modules……………………………………………………..…48
1. Sign Up
2. Login
3. Home Page
4. Profile
5. Update Password
6. My Booking
7. My Testimonial
8. Vehicles Details
9. List Of Vehicles
10. About Us

CHAPTER – 13 CODING……………………………………..53
CHAPTER – 14 FUTURE ENHANCEMENT……………….96
CHAPTER – 15 CONCLUSION……………………………...98
BIBLIOGRAPHY…………………….…….100
CHAPTER – 1
INTRODUCTION
ABREVIATIONS/ NOTATIONS/ NOMENCLATURE

HTML:- HTML is the standard markup language for creating Web

pages. HTML describes the structure of a Web page.

CSS :- Cascading Style Sheets is a style sheet language used for

specifying the presentation and styling of a document written in a
markup language such as HTML

JS :- JS stands for JavaScript. It is a text-based, lightweight,

crossplatform, and interpreted scripting programming language

Enthusiastic:- A person who is interested in a particular item.

E-Commerce :- E-commerce (electronic commerce) is the buying and

selling goods and services, or the transmitting of funds or data.

Website :- A website is a collection of files accessed through a web

address, covering a particular theme or subject, and managed by a
particular person or organization.

DEPARTMENT OF COMPUTER SCIENCE 1

CHAPTER 1
INTRODUCTION
1.1 About the project
Malware links, short for malicious URLs, are a significant threat in the
digital age, designed to redirect users to harmful websites that compromise
security by deploying malicious software or stealing sensitive data. With
the increasing reliance on the internet for communication, transactions,
and data sharing, detecting and neutralizing such links has become a
critical aspect of cybersecurity.

Attackers use advanced evasion techniques such as URL obfuscation,

shorteners, and dynamic content generation to bypass traditional defenses,
making malware detection both challenging and essential. Current systems
face issues like high false positive and false negative rates, which impact
their reliability and efficiency. Moreover, the exponential growth of online
traffic demands scalable solutions capable of handling real-time detection
without compromising performance.

Modern malware link detection platforms leverage Artificial Intelligence

and Machine Learning to address these challenges. By analyzing the
structure, content, and behavior of URLs, these platforms distinguish
malicious links from benign ones with high accuracy. They incorporate
real-time threat intelligence and adaptive learning to counter both known
and emerging threats effectively.

This advancement in cybersecurity ensures the protection of personal and

organizational data, preventing financial and reputational damage caused
by cyberattacks. As cyber threats evolve, robust and proactive systems for
malware link detection are indispensable for maintaining digital safety.

DEPARTMENT OF COMPUTER SCIENCE

2 DEPARTMENT OF COMPUTER SCIENCE

DEPARTMENT OF COMPUTER SCIENCE

DEPARTMENT OF COMPUTER SCIENCE
2. Problem Statement
The rapidly evolving digital landscape, malware links have become a pervasive threat
to cybersecurity. These malicious URLs are crafted to redirect users to harmful websites
or initiate the download of malicious software, often serving as the primary vectors for
phishing attacks and cyber intrusions. Following some

1.Sophisticated Evasion Techniques

2.Detection Accuracy Issues

3.Scalability and Performance Constraints

4.Inability to Adapt to Emerging Threats

5. High False Positive and False Negative Rates

2.Previous work

In the field of malware link detection has evolved significantly, with various research
and systems developed to tackle the challenges posed by malicious URLs. Previous
works have primarily focused on traditional detection mechanisms, evolving to
incorporate advanced machine learning and AI-based approaches.

3.Objectives

The primary objective of a malware link detection system is to proactively identify

and mitigate threats posed by malicious URLs, ensuring the security and integrity of
users' digital environments. This involves:

1. Detecting and classifying URLs that are potentially harmful by analyzing various
features such as structure, content, and behavior.

2. Minimizing false positives and false negatives to ensure accurate threat for the
identification while avoiding unnecessary disruptions to users.

3. Adapting to evolving threats by incorporating machine learning models and

heuristic approaches that can identify both known and emerging malware.

DEPARTMENT OF COMPUTER SCIENCE

DEPARTMENT OF COMPUTER SCIENCE
1.5 Specific Project Goals
In The primary aim of the Next-Gen Malware Link Detection project is to develop a
robust, accurate, and scalable system for detecting malicious URLs

1. Proactively Identify Malicious Links

Goal: To develop a system capable of accurately identifying potentially harmful URLs

that lead to phishing sites, malware downloads, or other types of cyber threats.

Implementation:

Utilize machine learning algorithms to analyze URL features and classify them as either
benign or malicious.Leverage advanced techniques like domain reputation analysis,
behavioral analysis, and deep learning to improve detection accuracy.

2. Enhance Detection Accuracy :

Goal: To reduce the false positive and false negative rates, ensuring the system identifies
only malicious URLs without blocking legitimate sites.

Implementation:

Apply supervised machine learning techniques to train the system with high-quality,
labeled datasets to improve classification.Fine-tune models to achieve a balance
between precision (reducing false positives) and recall (reducing false negatives).

3. Leverage Advanced AI and Machine Learning Models:

Goal: To utilize state-of-the-art AI techniques, such as deep learning, to analyze and

detect malware links with high accuracy.
Implementation:
Deploy models such as Convolutional Neural Networks (CNNs) for URL pattern
recognition and Recurrent Neural Networks (RNNs) for detecting sequential behaviors
in URLs.Experiment with Natural Language Processing (NLP) techniques to understand
the semantic structure of URLs.

DEPARTMENT OF COMPUTER SCIENCE

1.6 Scope of the Project
The The scope of the Next-Gen Malware Link Detection project encompasses the
development of a robust, efficient, and adaptive system for identifying and analyzing
malicious URLs in real time. This system will be capable of protecting users,
organizations, and networks from various types of cyber threats facilitated through
harmful links.
1.Malicious Link Detection:

Identify and analyze harmful URLs like phishing or malware distribution for the
links.Machine Learning for Accurate Detection.Use AI and machine learning models
(e.g., Random Forest, CNN, RNN) to classify URLs as safe or malicious.

2.Real-Time Detection:
Ensure the system detects harmful links in real-time to protect users immediately.
Scalability ,Build the system to handle large amounts of web traffic and URLs without
slowing down adapt to New Threats.

1.7 Project Overview Statement

The Next-Gen Malware Link Detection project focuses on developing an

advanced platform designed to detect and analyze malicious URLs that pose
cybersecurity risks, such as phishing sites, malware downloads, and other harmful web
activities. This system will leverage cutting-edge technologies like machine learning,
artificial intelligence (AI), and real-time threat intelligence to provide highly accurate,
scalable, and adaptive solutions for identifying malicious links.

DEPARTMENT OF COMPUTER SCIENCE

DEPARTMENT OF COMPUTER SCIENCE
4DEPARTMENT OF COMPUTER SCIENCE
5
6
CHAPTER – 2
ANALYSIS

7
8
CHAPTER 2
ANALYSIS
➢ Existing System
• Blacklisting and Whitelisting:
Tools like Google Safe Browsing and Microsoft SmartScreen
detect and filter malicious URLs based on predefined lists.
Limitation: They may struggle to detect new or evolving threats.
• Real-Time Threat Intelligence Platforms:
Examples: Cisco Talos and Recorded Future use automated analysis
and human expertise to identify threats.
Limitation: These platforms often rely heavily on vast computational resources.
• Heuristic and Signature-Based Detection:
Examples: Symantec Endpoint Protection and Kaspersky Anti-Virus.
Limitation: High false-positive rates and inefficiency in detecting emerging
threats due to reliance on pre-existing signatures.
➢ Need for the New System
➢ Address Limitations: Current systems struggle with emerging threats,
evasion techniques, and maintaining accuracy. A system is needed to
minimize false positives and negatives.
➢ Adaptability: The system must evolve with threats using machine
learning models and heuristic approaches.
➢ Real-Time Detection: To ensure quick identification and mitigation of
threats, supporting high scalability and performance is vital.
➢ Enhanced Cybersecurity: Protecting users from phishing, data theft,
and system breaches through proactive malware link detection is critical
➢ Main objective of the new system
The goal is to develop an Advanced Malware Link Detection and Analysis
Platform. Key objectives include:
➢ Accurate Detection: Utilize machine learning algorithms to detect and
classify malicious URLs by analyzing URL characteristics, domain age,
and content.
➢ Minimize Errors:Reduce false positives and negatives for reliable
results.

9
➢ Adaptation to Evolving Threats: Incorporate AI techniques to adapt to
new malware tactics.
➢ Scalable and Real-Time Operations: Implement efficient algorithms to
handle high data traffic and deliver real-time threat detection.
➢ User-Friendly Design: Offer a user interface for analysts to review
alerts, investigate incidents, and manage reports.

10
11
12
13
CHAPTER – 3

SYSTEM REQUIREMENT STUDY

14
15
CHAPTER 3
System Requirement Study
1. Hardware Requirements
RAM : 8GB

Hard disk : 20GB

Processor :AMD Ryzen 5 3250U

Graphics : Radeon Graphics 2.60 GHz

Quality : 64 Bit Screen

Resolution : 1366X768

Mouse : Standard Optical

2. Software Requirements
Web Server : APACHE

Language : PHP

Database : MYSQL

Web Browser : Google Chrome or any compatible browser

Operating System : Windows or any equivalent OS

3. Server or Cloud Deployment Requirements :

Cloud Instances: AWS, Azure, or Google Cloud with scalable compute and storage
options.

Virtual Machine Specs: 16 vCPUs, 32 GB RAM, 1 TB SSD.

On-Premise Servers: High-performance server-grade processors (e.g., Intel Xeon or

AMD EPYC).Redundant power supply for reliability.RAID-enabled storage for data
redundancy and protection.

DEPARTMENT OF COMPUTER SCIENCE

16
17
18DEPARTMENT OF COMPUTER SCIENCE
4. Specialized Hardware for Advanced Features
➢ Real-Time Processing:
Multi-core GPUs (e.g., NVIDIA RTX 3000 series or Tensor Processing
Units) for deep learning and rapid analysis.
➢ Data Storage:
NAS (Network Attached Storage) or SAN (Storage Area Network)
for handling large-scale data efficiently.
➢ Security Enhancements:
Hardware-based encryption tools or Trusted Platform Modules
(TPMs) for safeguarding sensitive data.These requirements are designed to
ensure that the platform can operate efficiently in both development and
production environments while accommodating future scalability needs.

19
20DEPARTMENT OF COMPUTER SCIENCE
CHAPTER – 4
FUNCTIONAL SPECIFICATIONS

21
22DEPARTMENT OF COMPUTER SCIENCE
CHAPTER 4
Functional Specification
1. Modules

• Admin
• User
1. Admin:
Admin can Update the web page , manage identify and verify and also view

feedback and enquiry.

2. User:
User can view information of available BIKE, booking BIKE, easily get the
BIKE on rent and also give feedback and can enquiry

1. Data Ingestion Module

Tools and Libraries:

▪ Python Libraries: requests, BeautifulSoup (for web scraping).
▪ APIs: Integration with open-source threat feeds like VirusTotal,
Google Safe Browsing API.
▪ Streaming Platforms: Apache Kafka, RabbitMQ (for real-time data
streams).
Techniques:
▪ Data cleaning and deduplication.
▪ Fetching URLs from malware databases, phishing sites, or live traffic
logs.

2. Feature Extraction Module

Tools and Libraries:

▪ URL Analysis Tools: TLDExtract (for domain-level analysis), Python
string manipulation libraries.
▪ Network Libraries: socket, whois (for host-based feature extraction).
▪ Automation: Selenium (for dynamic behavior analysis).

23
24DEPARTMENT OF COMPUTER SCIENCE
Techniques:

▪ Lexical analysis: Extracting URL length, character patterns, and

entropy.
▪ Host-based analysis: DNS lookup, IP geolocation, and SSL certificate
verification.
▪ Behavioral analysis: Tracking URL redirects or hidden iframe
activities.

3. Malware Detection Module

Tools and Libraries:

▪ Machine Learning Frameworks: Scikit-learn, TensorFlow, PyTorch

(for model building).
▪ Algorithms: Random Forest, Gradient Boosting, SVM, and deep
learning models (e.g., CNNs, RNNs for sequential data).

Techniques:

▪ Supervised learning for binary classification (malicious vs. benign).

▪ Ensemble learning methods to improve accuracy.
▪ Continuous model retraining with new threat data.

4. Reporting and Visualization Module

Tools and Libraries:

▪ Visualization Tools: Matplotlib, Seaborn, Plotly, Tableau (for

creating dashboards and charts).
▪ Reporting Libraries: Pandas, LaTeX (for generating detailed
reports).

Techniques:

▪ Generating performance metrics like accuracy, precision, recall, and

F1-score.

25
▪ Displaying trend analysis and threat insights in interactive
dashboards.
▪ Maintaining historical logs for audits and future reference.

5. Real-Time Monitoring Module

Tools and Libraries:

▪ Stream Processing: Apache Kafka, Apache Spark Streaming.

▪ Database Systems: MongoDB, Elasticsearch (for storing and
querying detection results).

Techniques:

▪ Real-time URL scanning and threat evaluation.

▪ Automated blocking of detected threats via API integration.
▪ Alerts and notifications through email, SMS, or dashboard updates.

26DEPARTMENT OF COMPUTER SCIENCE

DEPARTMENT OF COMPUTER SCIENCE

27
28DEPARTMENT OF COMPUTER SCIENCE
29
30DEPARTMENT OF COMPUTER SCIENCE
CHAPTER – 5
SYSTEM DESIGN

31
32DEPARTMENT OF COMPUTER SCIENCE
CHAPTER 5

System Design

1. Technical Feasibility
Availability of Technology:
▪ Python's robust libraries and frameworks (e.g., scikit-learn, requests,
Beautiful Soup) provide a strong foundation for data processing and
machine learning.
▪ Integration with existing tools like threat intelligence feeds and APIs
is achievable with widely available technologies.
Implementation Challenges:
▪ Handling evasion techniques (e.g., URL obfuscation, domain
generation algorithms) requires advanced AI/ML capabilities.
▪ Real-time detection demands scalable computational resources, but
these can be addressed using cloud platforms (e.g., AWS, Google
Cloud).

2.Economic Feasibility
Development Costs:
▪ Initial costs include software development (coding, training models,
testing) and acquiring datasets.
▪ Open-source tools like Python libraries minimize licensing costs.
Operational Costs:
▪ Real-time processing might increase cloud or server costs, but these can
be optimized with scalable solutions.
Return on Investment (ROI):
▪ Proactive detection reduces losses from malware attacks, which can
offset initial and operational costs.
▪ The system has long-term cost benefits through improved cybersecurity.

33
34DEPARTMENT OF COMPUTER SCIENCE
35DEPARTMENT OF COMPUTER SCIENCE
3. Operational Feasibility
User Adoption:

The system’s focus on accuracy, reduced false positives/negatives, and a user-friendly

interface ensures it is practical for cybersecurity teams.Integrating existing systems and
providing real-time alerts can significantly improve user engagement.

Maintenance:

Regular updates to machine learning models and databases for emerging threats are
manageable with automation.

4.Behavioral Feasibility

It Behavioral feasibility refers to how well the system will be accepted and utilized by
its intended users, and whether it will effectively influence the behaviors of those
interacting with it. In the case of the Advanced Malware Link Detection and Analysis
Platform, behavioral feasibility can be evaluated based on the following factors:

1. User Acceptance

2. User Training

3. Behavioral Impact on Users

4. Impact on End-Users

5. Organizational Behavior

4. Legal Feasibility

Compliance with Regulations:Must adhere to data protection laws like GDPR,

especially when analyzing user-generated or sensitive data.Ensure ethical practices in
web scraping and threat intelligence gathering

36DEPARTMENT OF COMPUTER SCIENCE

37
6. System design process
A computer procedure is a series of operations designed to manipulate data
to produce outputs from a computer system. The procedure may be a single
program or a series of programs. The detail design of the computer
procedure follows acceptance by management of an outline design
proposal. The aim now is to design procedures at lower levels of detail,
which will define the detailed steps to be taken to produce the specified
computer output. When complete, these procedure definitions together with
data specifications are organized for programmers from which the required
programs can be written.

7. Design Tools
The design tools for the Advanced Malware Link Detection and Analysis
Platform would involve various software and frameworks to support
different phases of development—from planning and architecture to coding,
testing, and deployment. Here’s a breakdown of key design tools that would
be used:

1. System Design Tools

These tools help in defining the architecture, components, and workflows

of the system.

2.Development Tools:These tools support the actual coding and software

development process.

3. Database Design Tools:

For designing and managing the databases that store collected data,
processed features, and analysis results.

4.Machine Learning and Data Analysis Tools:

These tools are used to develop, train, and evaluate machine learning
models.

5. Testing and Debugging Tools:

These tools help to ensure the reliability and performance of the system.

38DEPARTMENT OF COMPUTER SCIENCE

39
CHAPTER – 6
DATAFLOW DIAGRAMS

40DEPARTMENT OF COMPUTER SCIENCE

CHAPTER 6
Data Flow Diagram
6.1 Data Flow Chart
A Dataflow diagram also known as “Bubble Chart” is used to clarify system
requirements and identifying major transformations that all become programs in system
design.

Symbols:

Data Source/Destination

Data Storage

Flow of data

Relationship

41
6.2 Data flow Diagram

DEPARTMENT OF COMPUTER SCIENCE 42DEPARTMENT OF COMPUTER SCIENCE

43
CHAPTER – 7
ER DIAGRAM

44DEPARTMENT OF COMPUTER SCIENCE

45
CHAPTER 7
ER Diagram
The Entity-Relationship (ER) model was originally proposed by Peter in 1976 [Chen76]
as a way to unify the network and relational database views Simply stated the ER model
is a conceptual data model that views the real world as entities and relationships. A basic
component of the model is the Entity-Relationship diagram which is used to visually
represent data objects. Since Chen wrote his paper the mode has been extended and
today it is commonly used for database design for the database designer, the utility of
the ER model is:

• It maps well to the relational model. The constructs used in the ER model can
easily be transformed into relational tables.
• It is simple and easy to understand with a minimum of training. Therefore, the
model can be used by the database designer to communicate the design to the end
user.
• In addition, the model can be used as a design plan by the database developer to
implement a data model in specific database management software.

All notational styles represent entities as rectangular boxes and relationships as lines
connecting boxes. Each style uses a special set of symbols to represent the BIKEdinality
of a connection. The notation used in this document is from Martin. The symbols used
for the basic ER constructs are:

• Entities are represented by labelled rectangles. The label is the name of the entity.
Entity names should be singular nouns
• Relationships are represented by a solid line connecting two entities. The name
of the relationship is written above the line. Relationship names should be verbs

DEPARTMENT OF COMPUTER SCIENCE

46DEPARTMENT OF COMPUTER SCIENCE
ONLINE BIKERENTAL SYSTEM

Attributes, when included, are listed inside the entity rectangle. Attributes which
are identifiers are underlined. Attribute names should be singular nouns.
BIKEdinality of many is represented by a line ending in a crow's foot. If the
crow's foot is omitted, the BIKEdinality is one.

Existence is represented by placing a circle or a perpendicular bar on the line.

Mandatory existence is shown by the bar (looks like a 1) next to the entity for an instance
is required. Optional existence is shown by placing a circle next to the entity that is
optional.

7.1 ER Diagram

47
48DEPARTMENT OF COMPUTER SCIENCE
CHAPTER – 8
USECASE DIAGRAM

49
CHAPTER 8

UseCase Diagram

1. UseCase Diagram:
A Use case is a description of set of sequence of actions. Graphically it is rendered as
an ellipse with solid line including only its name. Use case diagram is a behavioural
diagram that shows a set of use cases and actors and their relationship. It is an
association between the use cases and actors. An actor represents a real-world object
Primary Actor-Sender, Secondary Actor Receiver.

2. Use Case diagram for admin

Manage
booking

View
Enquriy

Check
Rent

Add bike
details

Logout

50DEPARTMENT OF COMPUTER SCIENCE

51DEPARTMENT OF COMPUTER SCIENCE
8.4 Activity diagram For Admin:

52DEPARTMENT OF COMPUTER SCIENCE

53DEPARTMENT OF COMPUTER SCIENCE
54
CHAPTER – 9
TESTING

55DEPARTMENT OF COMPUTER SCIENCE

56DEPARTMENT OF COMPUTER SCIENCE
CHAPTER 9
Testing
Software Testing is evaluation of the software against requirements gathered from users
and system specifications. Testing is conducted at the phase level in software
development life cycle or at module level in program code. Software testing comprises
of validation and verification.

1. Types of Testing

1. Acceptance Testing:
It is a formal testing according to user needs, requirements and business processes
conducted to determine whether a system satisfies the acceptance criteria or not and to
enable the users, customers or other authorized entities to determine whether to accept
the system or not.

2. System Testing:
System Testing is a type of software testing that is performed on a complete integrated
system to evaluate the compliance of the system with the corresponding requirements.
In system testing, integration testing passed components are taken as input.

3. Integration Testing:
Integration testing (sometimes called integration and testing, abbreviated 1&T) is the
phase in software testing in which individual software modules are combined and tested
as a group Integration testing is conducted to evaluate the compliance of a system or
component with specified functional requirements.

57DEPARTMENT OF COMPUTER SCIENCE

58DEPARTMENT OF COMPUTER SCIENCE
9.1.4 Unit Testing:
Unit testing is a software development process in which the smallest testable parts of an
application, called units, are individually and independently scrutinized for proper
operation. This testing methodology is done during the development process by the
software developers and sometimes QAstaff.

9.2 Methods for Software Testing

There are mainly two widely used methods for software testing, one is White box
testing which uses internal coding to design test cases and another is black box testing
which uses GUI or user perspective to develop test cases.

• White box testing

• Black box testing
System testing falls under Black box testing as it includes testing of the external
working of the software Testing follows user's perspective to identify minor defects.

System Testing includes the following steps:

• Verification of input functions of the application to test whether it is producing

the expected output or not.
• Testing of integrated software by including external peripherals to check the
interaction of various components with each other.
• Testing of the whole system for End-to-End testing.
• Behaviour testing of the application via a user's experience.

59DEPARTMENT OF COMPUTER SCIENCE

60DEPARTMENT OF COMPUTER SCIENCE
9.3 Testing Principles
All tests should be traceable to customer requirements.

Test should be planned long before testing begins.

The testing should begin in the small and progress towards testing "in the large”.

Exhaustive testing is not possible.

To be most effective, testing should be conducted by an independent third party.

• Characteristics of a Good Test

• A good test has a high probability of finding an error.
• A good test is not redundant
• A good test should be best of breed.
• A good test should be neither too simple nor too complex.
This section deals with the details of the classes of tests which must be conducted
to validate the functions, performance, and the constraints. This is achieved
basically by the means of testing which plays a vital role in the development of
the software.

9.4 Error Handling

Error handling refers to the anticipation, detection, and resolution of
programming, application, and comications errors Specialized programs, called
error handlers, are available for some applications. The best programs of this type
forestall errors, if possible recover from them when they occur without
terminating the application, or if alleles fail) gracefully terminate an affected
application and save the error information to a log file.

61DEPARTMENT OF COMPUTER SCIENCE

62DEPARTMENT OF COMPUTER SCIENCE
63
CHAPTER – 10
SYSTEM VALIDATION AND
VERIFICATION

64DEPARTMENT OF COMPUTER SCIENCE

65DEPARTMENT OF COMPUTER SCIENCE
CHAPTER 10
System Validation and Verification
System Validation and Verification is an important aspect of software
engineering. Verification refers to the set of activity that ensures that software
correctly implemented a specific function. Validation refers to a different set of
activity that ensures that the software that has been built is traceable to customer
requirement.

• Verification "Are we building the project, right?"

• Validation "Are we building the right product?"
The definition of validation and verification encompasses many of the activity
that we have referred to as software quality assurance (SQA).

Verification and validation encompass a wide array of SQA activity that include
formal technical review, quality and configuration audit, performance monitoring
simulation, feasibility study, documentation review, algorithm analysis,
development testing, qualification testing and installation test.

System Verification and Validation Defined

Once the design is baselined, the design is transformed, via build, code, buy, or
reuse, into the system of interest. Similar to the discussion for the design process,
most organizations have a set of guidelines or "golden rules" that guide the build
(manufacture or code) process. These include workmanship and quality control
requirements for the organization.

After the system has been built or coded, there will be a gate review where the
system is both verified and validated. At this stage of the system lifecycle, the

66DEPARTMENT OF COMPUTER SCIENCE

67DEPARTMENT OF COMPUTER SCIENCE
concepts of system verification and system validation take on a more formal
meaning. Thus, the Systems Engineering (SE) lifecycle processes include the
processes of System Verification and System Validation. Each process represents a
set of activities (test, demonstration, inspection, analysis) that cumulate with one or
more gate reviews associated with the acceptance of the system by the customer.
System Verification: a process done after design and build or coding, making sure
the designed and built or coded system meets its requirements. The focus is on the
built or coded system and how well it meets the agreed-to requirement set that drove
the design and fabrication. Methods used for system verification include test,
demonstration, inspection, or analysis "Did we build the thing right?" Also included
in system verification is a determination that the team responsible for building or
coding the system of interests followed the organization's rules. guidelines, and best
practices associated with manufacturing and coding. The focus is on the
manufacturing or coding processes. "Did we follow our
organizations guidelines for manufacturing or coding correctly?"

System Validation: a process that occurs after system verification that makes sure
the designed, built, and verified system meets its intended purpose in its operational
environment The focus is on the completed system and how well it meets
stakeholder expectations (needs) that were defined during the scope definition phase
that should have occurred at the beginning of the project "Did we build the right
thing?”

System verification and system validation processes are directly related to the
contractual obligation concept for a requirement statement and set of requirements.
It is through these process activities that we prove we have met both the agreed-to
needs of entities who are the source of our own them.

68DEPARTMENT OF COMPUTER SCIENCE

69DEPARTMENT OF COMPUTER SCIENCE
70
CHAPTER – 11
DATABASE DESIGN

71DEPARTMENT
7 OF COMPUTER SCIENCE
CHAPTER 11
Database Design

The data in the system has to be stored and retrieved from database. Designing the database is
part of system design. Data elements and data structures to be stored have been identified at
analysis stage. They are structured and put together to design the data storage and retrieval
system.

A database is a collection of interrelated data stored with minimum redundancy to serve many
users quickly and efficiently. The general objective is to make database access easy, quick,
inexpensive and flexible for the user. Relationships are established between the data items and
unnecessary data items are removed. Normalization is done to get an internal consistency of
data and to have minimum redundancy and maximum stability. This ensures minimizing data
storage required, minimizing chances of data inconsistencies and optimizing for updates.
The MSAccess database has been chosen for developing the relevant databases.

Admin:
Table Name Admin
Description This table is store information about
Admin
Primary Key id
Foreign Key -

72DEPARTMENT OF COMPUTER SCIENCE

73DEPARTMENT OF COMPUTER SCIENCE

Sl.No. Field Name Data Type(Size) Constraints
1. Id (Primary) int (11) Primary key
2. UserName Varchar (100) Not Null
3. Password Varchar (100) Not Null
4. UpdationDate timestamp Not Null
User Registration:
Table Name tblusers
Description This table is providing the information
about user regisration
Primary Key Id
Foreign Key -
Sl.No Field Name Data type(Size) Constraints
1. Id(Primary) int(11) Primary Key
2. FullName varchar(120) Null
3. EmailId varchar(100) Null
4. Password varchar(100) Null
5. ContactNo char(11) Null
6. DOB varchar(100) Null
7. Address varchar(255) Null
8. City varchar(100) Null
9. RegDate Timestamp Current_timestrap
10. UpdationDate Timestamp Null

74DEPARTMENT OF COMPUTER SCIENCE

75DEPARTMENT OF COMPUTER SCIENCE
Brands Table:
Table Name tblbrands
Description This table is providing the
information about Bike
brands
Primary Key Id
Foreign Key -
Sl.No. Field Name Data Constraints
Type(Size)
1. Id (Primary) int (11) Primary key
2. BrandName Varchar (120) Not Null
3. CreationDate timestamp Current_
4. UpdationDate timestamp Not Null
Contact Us Details Table:
Table Name tblcontctusinfo
Description This table is provide the
contact information at
website.
Primary Key Id
Foreign Key -
Sl.No. Field Name Data Type(Size) Constraints
1. Id int Primary key
2. Address Tinytext Null
3. EmailId Varchar(255) Null
4. ContactNo Char(11) Null

76DEPARTMENT OF COMPUTER SCIENCE

77DEPARTMENT OF COMPUTER SCIENCE
Vehicles Info Table:
Table Name tblvehicles
Description This table is provide the information
about Bikes.
Primary Key Id
Foreign Key -
Sl.No Field Name Data type(Size) Constraints
1. id(primary) int(11) Primary Key
2. VehiclesTitle varchar(150) Null
3. VehiclesBrand int(11) Null
4. VehiclesOverview Longtext Null
5. PricePerDay int(11) Null
6. FuelType varchar(100) Null
7. ModelYear int(6) Null
8. SeatingCapacity int(11) Null
9. Vimage1 varchar(120) Null
10. Vimage2 varchar(120) Null
11. Vimage3 varchar(120) Null
12. Vimage4 varchar(120) Null
13. BrakeAssist int(11) Null
14. LeatherSeats int(11) Null
15. RegDate Timestamp Null
16. UpdationDate timestamp Null

78DEPARTMENT OF COMPUTER SCIENCE

79DEPARTMENT OF COMPUTER SCIENCE
Booking Table:
Table Name tblbooking
Description This table is provide the information
about booking.
Primary Key Id
Foreign Key -
Sl.No Field Name Data type(Size) Constraints
1. id(primary) int(11) Primary Key
2. BookingNumber bigint(12) Null
3. UserEmail varchar(100) Null
4. VehicleId int(11) Null
5. FromDate varchar(20) Null
6. ToDate varchar(20) Null
7. Message varchar(255) Null
8. Status int(11) Null
9. PostingDate timestamp Null

80DEPARTMENT OF COMPUTER SCIENCE

81DEPARTMENT OF COMPUTER SCIENCE
82
CHAPTER – 12
SCREENSHOTS

83DEPARTMENT OF COMPUTER SCIENCE

CHAPTER 12 SCREENSHOTS
1. Admin Modules

1. Admin Login

12.1.2 Dashboard

84DEPARTMENT OF COMPUTER SCIENCE

12.1.3 Change Password

12.1.4 Manage Brands

85DEPARTMENT OF COMPUTER SCIENCE

12.1.5 Post a Vehicle

12.1.6 Manage Vehicles

86DEPARTMENT OF COMPUTER SCIENCE

12.1.7 Manage Bookings

12.1.8 Registered Users

87DEPARTMENT OF COMPUTER SCIENCE

2. User Modules

1. Sign Up

12.2.2 Login

88DEPARTMENT OF COMPUTER SCIENCE

12.2.3 Home Page

12.2.4 Profile

89DEPARTMENT OF COMPUTER SCIENCE

12.2.5 Update Password

12.2.6 My Booking

90DEPARTMENT OF COMPUTER SCIENCE

12.2.7 My Testimonial

12.2.8 Vehicles Details

91DEPARTMENT OF COMPUTER SCIENCE

12.2.9 List Of Vehicles

12.2.10 About Us

92DEPARTMENT OF COMPUTER SCIENCE

93
CHAPTER – 13
CODING

94DEPARTMENT OF COMPUTER SCIENCE

95DEPARTMENT OF COMPUTER SCIENCE
CHAPTER 13
CODING
Index Page
<?php
session_start();
include('includes/config.php');
error_reporting(0);

<!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>Bike Rental Portal</title>

<link rel="stylesheet" href="assets/css/bootstrap.min.css" type="text/css">
<link rel="stylesheet" href="assets/css/styles.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" />

96DEPARTMENT OF COMPUTER SCIENCE

97DEPARTMENT OF COMPUTER SCIENCE
<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">
<link rel="apple-touch-icon-precomposed" sizes="114x114"
href="assets/images/favicon-icon/apple-touch-icon-114-precomposed.html">
<link rel="apple-touch-icon-precomposed" sizes="72x72"
href="assets/images/favicon-icon/apple-touch-icon-72-precomposed.png">
<link rel="apple-touch-icon-precomposed" href="assets/images/favicon-
icon/appletouch-icon-57-precomposed.png">
<link rel="shortcut icon" href="assets/images/favicon-icon/24x24.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');?> <!-
- /Header -->

<section id="banner" class="banner-section">
<div class="container">
<div class="div_zindex">
<div class="row">
<div class="col-md-5 col-md-push-7">
<div class="banner_content">
<h1>Online Bike Rental Management</h1>
<p>We have more than a thousand bikes for you to choose. </p>
<a href="#" class="btn">Read More <span class="angle_arrow"><i class="fa
fa-angle-right" aria-hidden="true"></i></span></a> </div> </div>
</div>
</div>
</div>

98DEPARTMENT OF COMPUTER SCIENCE

99DEPARTMENT OF COMPUTER SCIENCE
<div class="container div_zindex">
<div class="section-header white-text text-center">
<h2>Our Satisfied <span>Customer's Review</span></h2>
</div>
<div class="row">
<div id="testimonial-slider">
<?php
$tid=1;
$sql = "SELECT tbltestimonial.Testimonial,tblusers.FullName from tbltestimonial
join tblusers on tbltestimonial.UserEmail=tblusers.EmailId where
tbltestimonial.status=:tid";
$query = $dbh -> prepare($sql);
$query->bindParam(':tid',$tid, PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{ ?>

<div class="testimonial-m">
<div class="testimonial-img"> <img src="assets/images/cat-profile.png" alt=""
/> </div>
<div class="testimonial-content">
<div class="testimonial-heading">
<h5><?php echo htmlentities($result->FullName);?></h5>
<p><?php echo htmlentities($result->Testimonial);?></p>
</div>
</div>
</div>
<?php }} ?>

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

100DEPARTMENT OF COMPUTER SCIENCE

101DEPARTMENT OF COMPUTER SCIENCE

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

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

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

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

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

</body>

<!-- Mirrored from themes.webmasterdriver.net/carforyou/demo/index.html by

HTTrack Website Copier/3.x [XR&CO'2014], Fri, 16 Jun 2017 07:22:11 GMT -->
</html>

102DEPARTMENT OF COMPUTER SCIENCE

103DEPARTMENT OF COMPUTER SCIENCE
Bike Listing
<?php
session_start();
include('includes/config.php');
error_reporting(0); ?>

104DEPARTMENT OF COMPUTER SCIENCE

105DEPARTMENT OF COMPUTER SCIENCE
<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" />

</div>
<ul class="coustom-breadcrumb">
<li><a href="#">Home</a></li>
<li>Bike Listing</li>
</ul>
</div>
</div>

<div class="dark-overlay"></div>
</section>

<section class="listing-page">
<div class="container">
<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 = $dbh -> prepare($sql);
$query->bindParam(':vhid',$vhid, PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$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";

106DEPARTMENT OF COMPUTER SCIENCE

107DEPARTMENT OF COMPUTER SCIENCE
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{ ?>
<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>
foreach($results as $result)
{ ?>
<option value="<?php echo htmlentities($result->id);?>"><?php
echo htmlentities($result->BrandName);?></option> <?php }} ?>

</select>
</div>
<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 Bike</button>
</div>
</form>
</div>
</div>

<div class="sidebar_widget">
<div class="widget_heading">
<h5><i class="fa fa-motorcycle" aria-hidden="true"></i> Recently Listed
Bikes</h5>

108DEPARTMENT OF COMPUTER SCIENCE

109DEPARTMENT OF COMPUTER SCIENCE
</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 = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1; if($query-
>rowCount() > 0)
{
foreach($results as $result)
{ ?>

</body>
</html>

My Bookings
<?php
session_start();
error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['login'])==0)
{
header('location:index.php');
}
else{

110DEPARTMENT OF COMPUTER SCIENCE

111DEPARTMENT OF COMPUTER SCIENCE
?><!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>BikeForYou - Responsive Bike Dealer HTML5 Template</title> 
<link rel="stylesheet" href="assets/css/bootstrap.min.css" type="text/css">

<link rel="stylesheet" href="assets/css/styles.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">

112DEPARTMENT OF COMPUTER SCIENCE

113DEPARTMENT OF COMPUTER SCIENCE
<link rel="apple-touch-icon-precomposed" sizes="144x144"
href="assets/images/favicon-icon/apple-touch-icon-144-precomposed.png">
<link rel="apple-touch-icon-precomposed" sizes="114x114"
href="assets/images/favicon-icon/apple-touch-icon-114-precomposed.html">
<link rel="apple-touch-icon-precomposed" sizes="72x72"
href="assets/images/favicon-icon/apple-touch-icon-72-precomposed.png">
<link rel="apple-touch-icon-precomposed" href="assets/images/favicon-
icon/appletouch-icon-57-precomposed.png">
<link rel="shortcut icon" href="assets/images/favicon-icon/24x24.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');?>

<h1>My Booking</h1>
</div>
<ul class="coustom-breadcrumb">
<li><a href="#">Home</a></li>
<li>My Booking</li>
</ul>
</div>
</div>

114DEPARTMENT OF COMPUTER SCIENCE

115DEPARTMENT OF COMPUTER SCIENCE
<div class="dark-overlay"></div>
</section>

<?php
$useremail=$_SESSION['login'];
$sql = "SELECT * from tblusers where EmailId=:useremail";
$query = $dbh -> prepare($sql);
$query -> bindParam(':useremail',$useremail, PDO::PARAM_STR); $query-
>execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{ ?>
<section class="user_profile inner_pages">
<div class="container">
<div class="user_profile_info gray-bg padding_4x4_40">
<div class="upload_user_logo"> <img src="assets/images/dealer-logo.jpg"
alt="image">
</div>

<div class="dealer_info">
<h5><?php echo htmlentities($result->FullName);?></h5>
<p><?php echo htmlentities($result->Address);?><br>
<?php echo htmlentities($result->City);?> <?php echo htmlentities($result-
>Country); }}?></p>
</div>
</div>
<div class="row">
<div class="col-md-3 col-sm-3">
<?php include('includes/sidebar.php');?>

<div class="col-md-6 col-sm-8">

<div class="profile_wrap">
<h5 class="uppercase underline">My Bookings </h5>
<div class="my_vehicles_list">
<ul class="vehicle_listing">
<?php
$useremail=$_SESSION['login'];

116DEPARTMENT OF COMPUTER SCIENCE

117DEPARTMENT OF COMPUTER SCIENCE
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{ ?>

<li>
htmlentities($result->Vimage1);?>" alt="image"></a> </div>
<div class="vehicle_title">
<h6><a href="vehical-details.php?vhid=<?php echo htmlentities($result-
>vid);?>""> <?php echo htmlentities($result->BrandName);?> , <?php echo
htmlentities($result->VehiclesTitle);?></a></h6>
<p><b>From Date:</b> <?php echo htmlentities($result>FromDate);?><br
/> <b>To Date:</b> <?php echo htmlentities($result>ToDate);?></p>
</div>
<?php if($result->Status==1)
{ ?>
<div class="vehicle_status"> <a href="#" class="btn outline btn-xs active-
btn">Confirmed</a>
<div class="clearfix"></div>
</div>
</div>
</section>

<?php include('includes/footer.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>
<?php } ?>

118DEPARTMENT OF COMPUTER SCIENCE

119DEPARTMENT OF COMPUTER SCIENCE
My Testimonials
<?php
session_start();
error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['login'])==0)
{
header('location:index.php');
}
else{
?>
<!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>Bike Rental Portal | My Testimonials </title>

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

<link rel="stylesheet" href="assets/css/styles.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">

120DEPARTMENT OF COMPUTER SCIENCE

121DEPARTMENT OF COMPUTER SCIENCE
</section>

<div class="row">
<div class="col-md-3 col-sm-3">
<?php include('includes/sidebar.php');?>
<div class="col-md-8 col-sm-8">
<div class="profile_wrap">
<h5 class="uppercase underline">My Testimonials </h5>
<div class="my_vehicles_list">
<ul class="vehicle_listing">
<?php
$useremail=$_SESSION['login'];
$sql = "SELECT * from tbltestimonial where UserEmail=:useremail";

122DEPARTMENT OF COMPUTER SCIENCE

123DEPARTMENT OF COMPUTER SCIENCE
$query = $dbh -> prepare($sql);
$query -> bindParam(':useremail',$useremail, PDO::PARAM_STR); $query-
>execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);

if($cnt=$query->rowCount() > 0)
{
foreach($results as $result)
{ ?>
<li>
<div>
<p><?php echo htmlentities($result->Testimonial);?> </p>
<p><b>Posting Date:</b><?php echo
htmlentities($result>PostingDate);?> </p>
</div>
<?php if($result->status==1){ ?>
<div class="vehicle_status"> <a class="btn outline btn-xs active-
btn">Active</a>
<div class="clearfix"></div>
</div>
<?php } else {?>
<div class="vehicle_status"> <a href="#" class="btn outline btn-
xs">Waiting for approval</a>
<div class="clearfix"></div>
</ul><
<?php include('includes/footer.php');?>

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

124DEPARTMENT OF COMPUTER SCIENCE

125DEPARTMENT OF COMPUTER SCIENCE
<script src="assets/js/slick.min.js"></script>
<script src="assets/js/owl.carousel.min.js"></script>

</body>
</html>
<?php } ?>

Contact Us
<?php
session_start();
error_reporting(0);
include('includes/config.php');
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)
<!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>BikeForYou - Responsive Bike Dealer HTML5 Template</title>

126DEPARTMENT OF COMPUTER SCIENCE

127DEPARTMENT OF COMPUTER SCIENCE
<link rel="stylesheet" href="assets/css/bootstrap.min.css" type="text/css">

<link rel="stylesheet" href="assets/css/styles.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 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" <link rel="apple-touch-icon-
precomposed" sizes="144x144"
href="assets/images/favicon-icon/apple-touch-icon-144-
precomposed.png"> <link rel="apple-touch-icon-precomposed"
sizes="114x114" <style>
.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>

<

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

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

<section class="page-header contactus_page">
<div class="container">
<div class="page-header_wrap">

128DEPARTMENT OF COMPUTER SCIENCE

129DEPARTMENT OF COMPUTER SCIENCE
<div class="page-heading">
<h1>Contact Us</h1>
</div>
<ul class="coustom-breadcrumb">
<li><a href="#">Home</a></li>
<div class="contact_info_m"><a
href="mailto:codeprojectsorg@gmail.com"><?php echo htmlentities($result>ContactNo);
?></a></div>
</li>
</ul>
<?php }} ?>
</div>


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

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


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


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


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



<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>

130DEPARTMENT OF COMPUTER SCIENCE

131DEPARTMENT OF COMPUTER SCIENCE
Log Out
<?php
session_start();
$_SESSION = array();
if (ini_get("session.use_cookies")) {
$params = session_get_cookie_params(); setcookie(session_name(),
'', time() - 60*60,
$params["path"], $params["domain"],
$params["secure"], $params["httponly"]
);
}
unset($_SESSION['login']);
session_destroy(); // destroy session
header("location:index.php"); ?>

Profile
<?php
session_start(); error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['login'])==0)
{
header('location:index.php');
}
else{
if(isset($_POST['updateprofile']))
{
$name=$_POST['fullname'];
$mobileno=$_POST['mobilenumber'];
$dob=$_POST['dob'];
$adress=$_POST['address'];
$city=$_POST['city'];
$country=$_POST['country'];
$email=$_SESSION['login'];
$sql="update tblusersset
FullName=:name,ContactNo=:mobileno,dob=:dob,Address=:adress,City=:city,Countr
y=:country where EmailId=:email";
$query = $dbh->prepare($sql);
$query->bindParam(':name',$name,PDO::PARAM_STR);

132DEPARTMENT OF COMPUTER SCIENCE

133DEPARTMENT OF COMPUTER SCIENCE
$query->bindParam(':mobileno',$mobileno,PDO::PARAM_STR);
$query->bindParam(':dob',$dob,PDO::PARAM_STR);
$query->bindParam(':adress',$adress,PDO::PARAM_STR);
$query->bindParam(':city',$city,PDO::PARAM_STR);
$query->bindParam(':country',$country,PDO::PARAM_STR);
$query->bindParam(':email',$email,PDO::PARAM_STR);
$query->execute();
$msg="Profile Updated Successfully";
}

?>
<!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>Bike Rental Portal | My Profile</title>


<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">

134DEPARTMENT OF COMPUTER SCIENCE

135DEPARTMENT OF COMPUTER SCIENCE
<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">
<link rel="apple-touch-icon-precomposed" sizes="114x114"
rel="stylesheet">
<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>

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

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


<section class="page-header profile_page">
<div class="container">
<div class="page-header_wrap">
<div class="page-heading">
<h1>Your Profile</h1>
</div>

136DEPARTMENT OF COMPUTER SCIENCE

137DEPARTMENT OF COMPUTER SCIENCE
<?php
$useremail=$_SESSION['login'];
$sql = "SELECT * from tblusers where EmailId=:useremail";
$query = $dbh -> prepare($sql);
$query -> bindParam(':useremail',$useremail, PDO::PARAM_STR); $query-
>execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{ foreach($results as
$result)
{ ?>
<section class="user_profile inner_pages">
<div class="container">
<div class="user_profile_info gray-bg padding_4x4_40">

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

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

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

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

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

138DEPARTMENT OF COMPUTER SCIENCE

139DEPARTMENT OF COMPUTER SCIENCE
<?php
$useremail=$_SESSION['login'];
$sql = "SELECT * from tblusers where EmailId=:useremail";
$query = $dbh -> prepare($sql);
$query -> bindParam(':useremail',$useremail, PDO::PARAM_STR); $query-
>execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{ foreach($results as
$result)
{ ?>
<section class="user_profile inner_pages">
<div class="container">
<div class="user_profile_info gray-bg padding_4x4_40">

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

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

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

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

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

140DEPARTMENT OF COMPUTER SCIENCE

141DEPARTMENT OF COMPUTER SCIENCE
<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>
<?php } ?>

Post Testimonial
<?php
session_start(); error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['login'])==0)
{
header('location:index.php');
}
else{
if(isset($_POST['submit']))
{
$testimonoial=$_POST['testimonial'];
$email=$_SESSION['login'];
$sql="INSERT INTO tbltestimonial(UserEmail,Testimonial)
VALUES(:email,:testimonoial)";
$query = $dbh->prepare($sql);
$query->bindParam(':testimonoial',$testimonoial,PDO::PARAM_STR);
$query->bindParam(':email',$email,PDO::PARAM_STR);

$query->execute();
$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
$msg="Testimonail submitted successfully";
}

142DEPARTMENT OF COMPUTER SCIENCE

143DEPARTMENT OF COMPUTER SCIENCE
else
{
$error="Something went wrong. Please try again";
}
}
?>

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


<section class="page-header profile_page">
<div class="container">
<div class="page-header_wrap">
<li>Post Testimonial</li>
</ul>
</div>
</div>

<div class="dark-overlay"></div>
</section>

<?php
$useremail=$_SESSION['login'];
$sql = "SELECT * from tblusers where EmailId=:useremail";
$query = $dbh -> prepare($sql);
$query -> bindParam(':useremail',$useremail, PDO::PARAM_STR); $query-
>execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1; if($query-
>rowCount() > 0)
{
foreach($results as $result)
{ ?>
<section class="user_profile inner_pages">
<div class="container">
<div class="user_profile_info gray-bg padding_4x4_40">
<div class="upload_user_logo"> <img src="assets/images/dealer-logo.jpg"
alt="image">
</div>

144DEPARTMENT OF COMPUTER SCIENCE

145DEPARTMENT OF COMPUTER SCIENCE
</body>
</html>
<?php } ?>

Update Password
<?php
session_start();
error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['login'])==0)
{
header('location:index.php');
}
else{
if(isset($_POST['update']))
{
$password=md5($_POST['password']);
$newpassword=md5($_POST['newpassword']);
$email=$_SESSION['login'];
$sql ="SELECT Password FROM tblusers WHERE EmailId=:email and
Password=:password";
$query= $dbh -> prepare($sql);
$query-> bindParam(':email', $email, PDO::PARAM_STR);
$query-> bindParam(':password', $password, PDO::PARAM_STR);
$query-> execute();
$results = $query -> fetchAll(PDO::FETCH_OBJ); if($query
-> rowCount() > 0)
{
$con="update tblusers set Password=:newpassword where EmailId=:email";
$chngpwd1 = $dbh->prepare($con);
$chngpwd1-> bindParam(':email', $email, PDO::PARAM_STR);
$chngpwd1-> bindParam(':newpassword', $newpassword,
PDO::PARAM_STR); $chngpwd1->execute();
$msg="Your Password succesfully changed";
}
else
{
$error="Your current password is
wrong"; } }

146DEPARTMENT OF COMPUTER SCIENCE

147DEPARTMENT OF COMPUTER SCIENCE
?>
<!DOCTYPE HTML>
<html lang="en">
<head>
<link rel="stylesheet" href="assets/css/bootstrap.min.css" type="text/css">

<link rel="stylesheet" href="assets/css/styles.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">

148DEPARTMENT OF COMPUTER SCIENCE

149DEPARTMENT OF COMPUTER SCIENCE
<input class="form-control white_bg" id="newpassword" type="password"
name="newpassword" required>
</div>
<div class="form-group">
<label class="control-label">Confirm Password</label>
<input class="form-control white_bg" id="confirmpassword"
type="password" name="confirmpassword" required>
</div>

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

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

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

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

150DEPARTMENT OF COMPUTER SCIENCE

151DEPARTMENT OF COMPUTER SCIENCE
<?php include('includes/forgotpassword.php');?>

</body>
</html>
<?php } ?>

Manage Bookings
<?php
session_start(); error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['alogin'])==0)
{
header('location:index.php');
}
else{
if(isset($_REQUEST['eid']))
{
$eid=intval($_GET['eid']);
$status="2";
$sql = "UPDATE tblbooking SET Status=:status WHERE id=:eid";
$query = $dbh->prepare($sql);
$query -> bindParam(':status',$status, PDO::PARAM_STR);
$query-> bindParam(':eid',$eid, PDO::PARAM_STR);
$query -> execute();

152DEPARTMENT OF COMPUTER SCIENCE

153DEPARTMENT OF COMPUTER SCIENCE

<link rel="stylesheet" href="css/bootstrap-social.css">
<style>

.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);
table table-striped table-bordered table-hover" cellspacing="0"
width="100%">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap-select.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery.dataTables.min.js"></script>
<script src="js/dataTables.bootstrap.min.js"></script>
<script src="js/Chart.min.js"></script>
<script src="js/fileinput.js"></script>
<script src="js/chartData.js"></script>
<script src="js/main.js"></script>
</body>
</html>
<?php } ?>

Reg Users
<?php
session_start();
error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['alogin'])==0)
{
header('location:index.php');
}
else{
if(isset($_GET['del']))
{
$id=$_GET['del'];

154DEPARTMENT OF COMPUTER SCIENCE

155DEPARTMENT OF COMPUTER SCIENCE
$sql = "delete from tblbrands WHERE id=:id";
$query = $dbh->prepare($sql);
$query -> bindParam(':id',$id, PDO::PARAM_STR);
$query -> execute();
$msg="Page data updated successfully";
}
?>
<!doctype html>
<html lang="en" class="no-js">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1,
minimum-scale=1, maximum-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<meta name="theme-color" content="#3e454c">
<title>Bike Rental Portal |Admin Manage testimonials </title>

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 }?>
<table id="zctb" class="display
table table-striped table-bordered table-hover" cellspacing="0" width="100%">
<thead>
<tr>
<th>#</th>
<th>
Name</th>
<th>Email
</th>
<th>Contact
no</th>
<th>DOB</th>
<th>Address</th>
<th>City</th>
<th>Country</th>
<th>Reg Date</th>

156DEPARTMENT OF COMPUTER SCIENCE

157DEPARTMENT OF COMPUTER SCIENCE
$query->execute();
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1,
minimum-scale=1, maximum-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<meta name="theme-color" content="#3e454c">

<title>Bike Rental Portal |Admin Manage Vehicles </title> </style>

</head>
<tbody>
<?php $sql = "SELECT
tblvehicles.VehiclesTitle,tblbrands.BrandName,tblvehicles.PricePerDay,tblvehicles.F
uelType,tblvehicles.ModelYear,tblvehicles.id from tblvehicles join tblbrands on
tblbrands.id=tblvehicles.VehiclesBrand";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{ ?>
<tr>
<td><?php
echo htmlentities($cnt);?></td>
<td><?php
echo htmlentities($result->VehiclesTitle);?></td>
<td><?php
echo htmlentities($result->BrandName);?></td>
<td><?php
echo htmlentities($result->PricePerDay);?></td>
<td><?php echo htmlentities($result->FuelType);?></td>

<td><?php echo htmlentities($result->ModelYear);?></td>

158DEPARTMENT OF COMPUTER SCIENCE

159DEPARTMENT OF COMPUTER SCIENCE

<script src="js/jquery.min.js"></script>
<script src="js/bootstrap-select.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery.dataTables.min.js"></script>
<script src="js/dataTables.bootstrap.min.js"></script>

</body>
</html>
<?php } ?>

Create Brand
<?php
session_start(); error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['alogin'])==0)
{
header('location:index.php');
}
else{
// Code for change password
if(isset($_POST['submit']))
{
$brand=$_POST['brand'];
$sql="INSERT INTO tblbrands(BrandName) VALUES(:brand)";
$query = $dbh->prepare($sql);
$query->bindParam(':brand',$brand,PDO::PARAM_STR);
$query->execute();
$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
$msg="Brand Created successfully";
}
else
{
$error="Something went wrong. Please try again";
}

160DEPARTMENT OF COMPUTER SCIENCE

161DEPARTMENT OF COMPUTER SCIENCE
}
</style>

</head>

<body>
<?php include('includes/header.php');?>
<div class="ts-main-content">
<?php include('includes/leftbar.php');?>
<div class="content-wrapper">
<?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 }?> class="col-sm-8

col-sm-offset-4">

<button class="btn btn-primary" name="submit"

type="submit">Submit</button>

Change Password

162DEPARTMENT OF COMPUTER SCIENCE

163DEPARTMENT OF COMPUTER SCIENCE
<?php
session_start();
error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['alogin'])==0)
{
header('location:index.php');
}
else{
// Code for change
password
if(isset($_POST['submit']))
{
$password=md5($_POST['password']);
$newpassword=md5($_POST['newpassword']);
$username=$_SESSION['alogin'];
$sql ="SELECT Password FROM admin WHERE UserName=:username and
Password=:password";
$query= $dbh -> prepare($sql);
$query-> bindParam(':username', $username, PDO::PARAM_STR);
$query-> bindParam(':password', $password, PDO::PARAM_STR); $query-
> execute();
$results = $query -> fetchAll(PDO::FETCH_OBJ); if($query
-> rowCount() > 0)
{
$con="update admin set Password=:newpassword where
UserName=:username";
$chngpwd1 = $dbh->prepare($con);
$chngpwd1-> bindParam(':username', $username, PDO::PARAM_STR);
$chngpwd1-> bindParam(':newpassword', $newpassword,
PDO::PARAM_STR); $chngpwd1->execute();
$msg="Your Password succesfully changed";
}
else
{
$error="Your current password is not valid.";
}
}
?>

<!doctype html>
<html lang="en" class="no-js">

<head>

164DEPARTMENT OF COMPUTER SCIENCE

165DEPARTMENT OF COMPUTER SCIENCE
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1,
minimum-scale=1, maximum-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<meta name="theme-color" content="#3e454c">

<title>Bike Rental Portal |Admin Change Password</title>

166DEPARTMENT OF COMPUTER SCIENCE

167DEPARTMENT OF COMPUTER SCIENCE
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>
<?php include('includes/header.php');?>
<div class="ts-main-content">
<?php include('includes/leftbar.php');?>
<div class="content-wrapper">
name="chngpwd" class="form-horizontal" onSubmit="return valid();">
<?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="form-group">
<button class="btn btn-primary" name="submit" type="submit">Save
changes</button>

<script src="js/jquery.min.js"></script>
<script src="js/bootstrap-select.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery.dataTables.min.js"></script>

168DEPARTMENT OF COMPUTER SCIENCE

169DEPARTMENT OF COMPUTER SCIENCE
<script src="js/dataTables.bootstrap.min.js"></script>
<script src="js/Chart.min.js"></script>
<script src="js/fileinput.js"></script>
<script src="js/chartData.js"></script>
<script src="js/main.js"></script>

</body>
</html>
<?php } ?>

Post AVehicle
a<?php
session_start();
error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['alogin'])==0)
{
header('location:index.php');
}
else{

if(isset($_POST['submit']))
{
$vehicletitle=$_POST['vehicletitle'];
$brand=$_POST['brandname'];
$vehicleoverview=$_POST['vehicalorcview'];
$priceperday=$_POST['priceperday'];
$fueltype=$_POST['fueltype'];
$modelyear=$_POST['modelyear'];
$seatingcapacity=$_POST['seatingcapacity'];
$vimage1=$_FILES["img1"]["name"];
$vimage2=$_FILES["img2"]["name"];
$vimage3=$_FILES["img3"]["name"];
$vimage4=$_FILES["img4"]["name"];
$vimage5=$_FILES["img5"]["name"];
$airconditioner=$_POST['airconditioner'];
$powerdoorlocks=$_POST['powerdoorlocks'];
$antilockbrakingsys=$_POST['antilockbrakingsys'];
$brakeassist=$_POST['brakeassist'];
$powersteering=$_POST['powersteering'];

170DEPARTMENT OF COMPUTER SCIENCE

171DEPARTMENT OF COMPUTER SCIENCE
$driverairbag=$_POST['driverairbag'];
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
</style>

</head>

<body>
<?php include('includes/header.php');?>
<div class="form-group">
<label class="col-sm-2 control-label">Vehical Overview<span
style="color:red">*</span></label>
<div class="col-sm-10">
<textarea class="form-control" name="vehicalorcview" rows="3"
required></textarea>
</div>
</div>

<div class="form-group">
<label class="col-sm-2 control-label">Price Per Day(in INR)<span
style="color:red">*</span></label>
<div class="col-sm-4">
<input type="text" name="priceperday" class="form-control" required>
</div>
<label class="col-sm-2 control-label">Select Fuel Type<span
style="color:red">*</span></label>
<div class="col-sm-4">
<select class="selectpicker" name="fueltype" required>
<option value=""> Select </option>

<option value="Petrol">Petrol</option>
<option value="Diesel">Diesel</option>
<option value="CNG">CNG</option>
</select>
</div>
</div>

<div class="form-group">
<label class="col-sm-2 control-label">Model Year<span
style="color:red">*</span></label>

172DEPARTMENT OF COMPUTER SCIENCE

173DEPARTMENT OF COMPUTER SCIENCE
<div class="col-sm-4">
Index
<?php
session_start();
include('includes/config.php');
if(isset($_POST['login']))
{
$email=$_POST['username'];
$password=md5($_POST['password']);
$sql ="SELECT UserName,Password FROM admin WHERE UserName=:email and
Password=:password";
$query= $dbh -> prepare($sql);
$query-> bindParam(':email', $email, PDO::PARAM_STR);
$query-> bindParam(':password', $password, PDO::PARAM_STR);
$query-> execute();
$results=$query->fetchAll(PDO::FETCH_OBJ); if($query-
>rowCount() > 0)
{
$_SESSION['alogin']=$_POST['username']; echo "<script
type='text/javascript'> document.location = 'change-password.php'; </script>";
?>
<!doctype html>
<html lang="en" class="no-js">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Bike Rental Portal |Admin Login</title>
<link rel="stylesheet" href="css/font-awesome.min.css">
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/bootstrap-social.css">
<input type="text"
placeholder="Username" name="username" class="form-control mb">

<script src="js/jquery.min.js"></script>
<script src="js/bootstrap-select.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery.dataTables.min.js"></script>
</body>

174DEPARTMENT OF COMPUTER SCIENCE

175DEPARTMENT OF COMPUTER SCIENCE
</html>
Update Contact Us Info
<?php
session_start(); error_reporting(0);
include('includes/config.php');
if(strlen($_SESSION['alogin'])==0)
{
header('location:index.php');
}
else{
// Code for change password
if(isset($_POST['submit']))
{
$address=$_POST['address'];
$email=$_POST['email'];
$contactno=$_POST['contactno'];
$sql="update tblcontactusinfo set
Address=:address,EmailId=:email,ContactNo=:contactno";
$query = $dbh->prepare($sql);
$query->bindParam(':address',$address,PDO::PARAM_STR);
$query->bindParam(':email',$email,PDO::PARAM_STR);
$query->bindParam(':contactno',$contactno,PDO::PARAM_STR);
$query->execute();
$msg="Info Updateed successfully";
}
?>

<!doctype html>
<html lang="en" class="no-js">

176DEPARTMENT OF COMPUTER SCIENCE

177DEPARTMENT OF COMPUTER SCIENCE
<title>Bike Rental Portal |Admin Create Brand</title>

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

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

<
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap-select.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery.dataTables.min.js"></script>

Log Out
<?php
session_start();
$_SESSION = array();
if (ini_get("session.use_cookies")) {
$params = session_get_cookie_params();
setcookie(session_name(), '', time() - 60*60,
$params["path"], $params["domain"],
$params["secure"], $params["httponly"]
);
}
unset($_SESSION['login']);
session_destroy(); // destroy session
header("location:index.php");
?>

178DEPARTMENT OF COMPUTER SCIENCE

179DEPARTMENT OF COMPUTER SCIENCE
180
CHAPTER – 15
FUTURE ENHANCEMENT

181DEPARTMENT OF COMPUTER SCIENCE

182
CHAPTER 15
Future Enhancement

➢ Add new bike is representing the bike list.

➢ The User payment for the current receiptof the payment.
➢ Add the current project for booking easy.
➢ System that allows users to track the availability of bikes in real-time.
➢ Users can reserve bikes in advance.
➢ Adding a loyalty program to incentivize users to continue renting bikes.

183DEPARTMENT OF COMPUTER SCIENCE

184
CHAPTER – 16
CONCLUSION

185DEPARTMENT OF COMPUTER SCIENCE

186
CHAPTER 16
Conclusion
In comparison to previous experiences, when every activity related to the vehicle rental
business was restricted to a physical place alone, the bike rental industry has emerged
with new delicacies

Even if the physical location has not been completely eliminated, the internet's power
has altered the nature of functions and how these tasks are accomplished Customers may
now book vehicles online, rent automobiles online, and have the bike delivered to their
home if they are a registered member, or they can travel to the office to pick up the bike.
From web based portal, we can say that bike rental portal can be more helpful and saves
lot of time with more some advantages:

• Fully funtional and flexible.

• Can book a bike with/without driver.
• Local booking or outstation booking With insurance or without insurance.
• It saves lot of time money and labour.
• Can operate 24x7.
• Use of least paper work.

187DEPARTMENT OF COMPUTER SCIENCE

188
BIBILOGRAPHY

189DEPARTMENT OF COMPUTER SCIENCE

190
Bibliography

The following books were referred during the analysis and execution phase of the
Project.

Books Referred:

• BEGINNING PHP5 - DAVE MERCER

• BLACK BOOK HTML - -WILEY DREAMTECH
• PHPAND MYSQL WEB DEVELOPMENT-LUKEWELLING LAURA
• MICROSOFT SQL SERVER 2000--RANKIN, PAUL & JENSEN
• SQL SERVER-2000 - DUSAN PETKOVIC
• PHP IN A NUTSHELL -PAUL HUDSON

Websites Referred:

➢ https://www.mysql.com/
➢ https://www.apachefriends.org/download.html
➢ https://www.php.net/
➢ https://www.sitepoint.com/php/
➢ http://www.projectworlds in

191DEPARTMENT OF COMPUTER SCIENCE

192

Final Major Project File
No ratings yet
Final Major Project File
36 pages
Final Report2 8
No ratings yet
Final Report2 8
82 pages
Final Document
No ratings yet
Final Document
61 pages
Trust Wave Monitor For Cyber Threats: Project Report
No ratings yet
Trust Wave Monitor For Cyber Threats: Project Report
84 pages
Golden File 2ND Draft
No ratings yet
Golden File 2ND Draft
45 pages
Python Subdomain Scanner Report
No ratings yet
Python Subdomain Scanner Report
81 pages
Dubber
No ratings yet
Dubber
36 pages
K2 Lumiq
No ratings yet
K2 Lumiq
49 pages
REPORT EDIT 1 Final
No ratings yet
REPORT EDIT 1 Final
53 pages
Vinodhini Project
No ratings yet
Vinodhini Project
66 pages
Wa0017.
No ratings yet
Wa0017.
52 pages
Final Report2 1
No ratings yet
Final Report2 1
83 pages
B2 Salma Fayaz
No ratings yet
B2 Salma Fayaz
56 pages
Sradesh Vac
No ratings yet
Sradesh Vac
19 pages
A Mini Project Report Submitted in The Partial Fulfillment of The Requirements For The Award of The Degree of
No ratings yet
A Mini Project Report Submitted in The Partial Fulfillment of The Requirements For The Award of The Degree of
64 pages
REPORT
No ratings yet
REPORT
14 pages
Prooooject
No ratings yet
Prooooject
56 pages
Project - Report (1) Aaa
No ratings yet
Project - Report (1) Aaa
43 pages
2659 Emmela Venkata Pavan Kalyan Compressed
No ratings yet
2659 Emmela Venkata Pavan Kalyan Compressed
34 pages
Project Document
No ratings yet
Project Document
71 pages
Securemail PDF
No ratings yet
Securemail PDF
111 pages
MINI DOCC LAST (1) - Removed
No ratings yet
MINI DOCC LAST (1) - Removed
52 pages
Network Intrusion Detection System Report
No ratings yet
Network Intrusion Detection System Report
59 pages
Covid19-TMS Report Kings2
No ratings yet
Covid19-TMS Report Kings2
55 pages
Visvesvaraya Technological University: "Machine Learning Based Approach To Detect Phishing Attacks"
No ratings yet
Visvesvaraya Technological University: "Machine Learning Based Approach To Detect Phishing Attacks"
78 pages
Document For Final Project
No ratings yet
Document For Final Project
57 pages
Coa Units
No ratings yet
Coa Units
59 pages
B.Tech Malware Detection Project
No ratings yet
B.Tech Malware Detection Project
54 pages
Malware Detection
No ratings yet
Malware Detection
17 pages
Virtual Assistant Project - REPORT
85% (20)
Virtual Assistant Project - REPORT
37 pages
BCSE497J Project I Report - Sparsh
No ratings yet
BCSE497J Project I Report - Sparsh
67 pages
Report 1 Crim
No ratings yet
Report 1 Crim
73 pages
Netbanking Security With Blockchain Technology
No ratings yet
Netbanking Security With Blockchain Technology
6 pages
Virtual Assistant Project REPORT
No ratings yet
Virtual Assistant Project REPORT
37 pages
DROWSINESS-DET AddPage
No ratings yet
DROWSINESS-DET AddPage
46 pages
Digital Forensics Toolkit Phase 2 Report Final
No ratings yet
Digital Forensics Toolkit Phase 2 Report Final
69 pages
Final Project Report Crime Data
No ratings yet
Final Project Report Crime Data
37 pages
R1 Final
No ratings yet
R1 Final
4 pages
1SJ18CS115 Veera Jaswanth Reddy
No ratings yet
1SJ18CS115 Veera Jaswanth Reddy
28 pages
CB3591 ESSS Manual
No ratings yet
CB3591 ESSS Manual
30 pages
Credit Card Fraud Detection PR222
No ratings yet
Credit Card Fraud Detection PR222
12 pages
Mini Finallworddddff
No ratings yet
Mini Finallworddddff
54 pages
IoT Malware Detection Framework
No ratings yet
IoT Malware Detection Framework
89 pages
Cybersecurity System
No ratings yet
Cybersecurity System
71 pages
Internship 86 - Merged
No ratings yet
Internship 86 - Merged
33 pages
VTU FINAL YEAR PROJECT REPORT Front Pages
100% (1)
VTU FINAL YEAR PROJECT REPORT Front Pages
11 pages
Ilovepdf Merged
No ratings yet
Ilovepdf Merged
158 pages
Digital Forensics Toolkit Report
No ratings yet
Digital Forensics Toolkit Report
46 pages
Plagiarism Report
No ratings yet
Plagiarism Report
46 pages
Project - Report Susan
No ratings yet
Project - Report Susan
54 pages
Internship Report
No ratings yet
Internship Report
42 pages
Enforcing Secure and Privacy Preserving Information Brokering System
No ratings yet
Enforcing Secure and Privacy Preserving Information Brokering System
6 pages
Sample
No ratings yet
Sample
21 pages
Network Attack
No ratings yet
Network Attack
84 pages
Batch6DocumentationFinal 1
No ratings yet
Batch6DocumentationFinal 1
41 pages
RigmaUmesh Finalprojectreport
No ratings yet
RigmaUmesh Finalprojectreport
60 pages
Phishing Detection
No ratings yet
Phishing Detection
101 pages
B12 IIII
No ratings yet
B12 IIII
75 pages
B.Tech Mini-Project: Medi Connect
No ratings yet
B.Tech Mini-Project: Medi Connect
57 pages
Bitcoin BTC: Unit V
No ratings yet
Bitcoin BTC: Unit V
23 pages
1
No ratings yet
1
32 pages
Assignment #3 Compare The Technology Used.: AWS Vs Azure: Compute
No ratings yet
Assignment #3 Compare The Technology Used.: AWS Vs Azure: Compute
1 page
Sparsh Verma SD3
No ratings yet
Sparsh Verma SD3
3 pages
Framework Brief English
No ratings yet
Framework Brief English
2 pages
Hitachi Vantara FY23 Resell Program
No ratings yet
Hitachi Vantara FY23 Resell Program
9 pages
AWS Solutions Architect Course Guide
No ratings yet
AWS Solutions Architect Course Guide
7 pages
Cisco Ndi User Guide Release 622 Aci
No ratings yet
Cisco Ndi User Guide Release 622 Aci
230 pages
Who Is A Service Provider in ITSM and Types
No ratings yet
Who Is A Service Provider in ITSM and Types
4 pages
Sap Sac
No ratings yet
Sap Sac
11 pages
Zscaler Beyond Identity Deployment Guide FINAL
No ratings yet
Zscaler Beyond Identity Deployment Guide FINAL
25 pages
Manish Chopra: Contact
No ratings yet
Manish Chopra: Contact
3 pages
BTEC ICT: Software Installation Plan
50% (2)
BTEC ICT: Software Installation Plan
16 pages
MIS Project Report
No ratings yet
MIS Project Report
15 pages
ИСО МЭК 17789 prznt
No ratings yet
ИСО МЭК 17789 prznt
24 pages
InHand Networks InGateway502 Edge Gateway PRDT Spec V3.3
No ratings yet
InHand Networks InGateway502 Edge Gateway PRDT Spec V3.3
8 pages
Cyber Security
No ratings yet
Cyber Security
72 pages
IBM Watson Sales Foundation Database Level 1-Quiz
No ratings yet
IBM Watson Sales Foundation Database Level 1-Quiz
20 pages
Microsoft Azure
No ratings yet
Microsoft Azure
5 pages
Migracion A Version 12 Cucm
No ratings yet
Migracion A Version 12 Cucm
231 pages
AVE 19.3 Installation and Upgrade Guide
No ratings yet
AVE 19.3 Installation and Upgrade Guide
122 pages
OWASP Cloud Top 10
No ratings yet
OWASP Cloud Top 10
19 pages
Oracle: Exam 1z0-965
No ratings yet
Oracle: Exam 1z0-965
37 pages
India Cybersecurity Industry Services and Product Growth Story
No ratings yet
India Cybersecurity Industry Services and Product Growth Story
66 pages
State of Healthcare Life Sciences GCCs in India PDF
No ratings yet
State of Healthcare Life Sciences GCCs in India PDF
29 pages
Distributed ML with PyTorch & Ray
No ratings yet
Distributed ML with PyTorch & Ray
11 pages
6 Cloud Computing
No ratings yet
6 Cloud Computing
51 pages
ECS Mother Dairy
No ratings yet
ECS Mother Dairy
5 pages
13th International Conference On Information Technology Convergence and Services (ITCS 2024)
No ratings yet
13th International Conference On Information Technology Convergence and Services (ITCS 2024)
2 pages
Zakaria El Gtay - CV
No ratings yet
Zakaria El Gtay - CV
3 pages
Comprehensive Product Manager Guide - Developing Agentic AI Applications For Fintech Research Analysts
No ratings yet
Comprehensive Product Manager Guide - Developing Agentic AI Applications For Fintech Research Analysts
31 pages
Cloud Computing - Unit 7 - Week 4
No ratings yet
Cloud Computing - Unit 7 - Week 4
1 page