Final Documentation

Website for Strike RGP Resort with Online Inquiry and Reservation System
A Project
Presented to
the Faculty of STI College Dasmariñas
In Partial Fulfillment
of the Requirements for the Degree of
Bachelor of Science in Information Technology
By:
Adriano, Aaron Paul
Bagnol, Catherine
Galez, Christine
Pantoja, Alfred E.
Annielyn Gerodias, MIT
Project Adviser
November 2019
Adviser’s Recommendation Sheet
This Project entitled
By:
Adriano, Aaron Paul
Bagnol, Catherine
Galez, Christine
Pantoja, Alfred E.
Submitted in partial fulfillment of the requirements of the Bachelor of Science in Information

Technology degree has been examined and is hereby recommended for acceptance and approval
_______________________
Annielyn Gerodias, MIT

Project Adviser
November 2019
Project Coordinator and Dean’s Acceptance Sheet
After having been recommended and approved is hereby accepted
by the Information Technology Department
of STI College Dasmariñas
______________________________
Felecisimo M. Buensuceso Jr., MIT
Project Coordinator
______________________________
Anna Lissa I. Abello, MIT
Dean
November 2019
PANEL’S APPROVAL SHEET
Developed by:
Adriano, Aaron Paul

Bagnol, Catherine
Galez, Christine
Pantoja, Alfred E.
after having been presented is hereby approved by the following members of the panel
____________________________ ________________________________
Anna Lissa I. Abello, MIT Felecisimo M. Buensuceso Jr., MIT
Panelist 1 Panelist 2
______________________________
Dr. Brandon G. Sibbaluca
Lead Panelist
November 2019
Table of Contents
Title Page ........................................................................................................................................ i
Adviser’s Recommendation Sheet ............................................................................................... ii
Project Coordinator and Dean’s Acceptance Sheet .................................................................. iii
Panel’s Approval Sheet ............................................................................................................... iv
Table of Contents ……………………………………………………………………………….v
Abstract ......................................................................................................................................... vi
Preface .......................................................................................................................................... vii
Chapter I: INTRODUCTION
1.1 Statement of the Problem ........................................................................................... 1-2
1.1.1 General Problem ......................................................................................... 1-2
1.1.2 Specific Problem ......................................................................................... 1-2
1.2 Current State of Technology ...................................................................................... 1-4
1.3 Objectives .................................................................................................................. 1-5
1.3.1 General Objectives ...................................................................................... 1-5
1.3.2 Specific Objectives ..................................................................................... 1-5
1.3.2 Scopes and Limitations ............................................................................... 1-7

Chapter 2: THEORETICAL FRAMEWORK
2.1 Introduction
2.2 Information Technology Theories
2.2.1 Methodology …………………………………………………………… 2
2.2.2 Database Management System ………………………………………… 2-5
2.2.3 MySQL……………………………………………………………………2.5
2.2.4 Hypertext Markup Language(HTML).....………………………………....2-6
2.2.5 Cascading Style Sheet(CSS)………………………………………………2-6
2.2.6 Hypertext Processor(PHP)...………………………………………………2-7
2.2.7 XAMPP……………………………………………………………………2-7
2.3 Multimedia Devices Theory
2.3.1 Adobe Photoshop CS6………...………………………………………….2-8
2.3.2 Adobe Flash ……..……………………………………………………….2-8
2.4 Hosting Theory……………………………………………………………………2-9
2.5 Non-Information Technology Theories
2.5.1Advertisement………………………………………………… ………....2-10
2.5 Summary…………………………………………………………………...2-10
Chapter 3: Website For Strike RGP Resort with Online Inquiry and Reservation System
3.1 Introduction
3.2 System Design Specification
3.2.1 Data Flow Diagram (Diagram 0)…………………………………………………3-1

3.2.2 Entity Relationship Diagram (ERD) .....................................................................3-2
3.2.2 Context Diagram………………………………………………………………….3-3
3.2.3 Hierarchical Diagram Input Process Output Chart (Front-End)…………..3-4
3.2.4 Hierarchical Diagram Input Process Output (Back-End)…………………3-5
3.3 Summary ................................................................................................................................ 3-6
Chapter 4: PERFORMANCE ANALYSIS
4.1 Introduction
4.2 Experimental
`4.3 Results and Analysis……..………………………………………………………………...4-2
4.3.1 Functionality………………….…………………………………………...............4-2
4.3.2 Content……………………………………………………………………………4-2
4.3.3 Aesthetic ................................................................................................................ 4-3
4.3.4 Availability……….……………………………………………………………….4-4
4-7 Summary……………………………………………………………………………4-4
Chapter 5: Conclusion
Bibliography
Acknowledgment
Appendix A
(Transcript of Interview)
Appendix B
(Survey Form)
Appendix C
(Screenshot)
Appendix D
(Codes)
Appendix E
(Endorsement Letter)
Appendix F
(Resource Persons)
Appendix G
(Personal Vitae)
List of Figures
Figure 2.1 Prototype Model …………………………………………………………… 2
Figure 3.1 Data Flow Diagram (Diagram 0)……………………………………………3-1
Figure 3.2 Entity Relationship Diagram (ERD) ..............................................................3-2
Figure3.3 Context Diagram ..............................................................................................3-3
Figure 3.4 Hierarchical Diagram Input Process Output Chart (Front-End) .....................3-4
Figure 3.5 Hierarchical Diagram Input Process Output (Back-End) ..............................3-5

LIST OF TABLES
Chapter 4
Table 1 Functionality Rating 4-2
Table 2 Content Rating 4-2
Table 3 Aesthetic Rating 4-3
Table 4 Availability Rating 4-4
Table 5 Overall Characteristic Rating 4-4

Abstract
The main objective of creating a website for Strike RGP Resort is to provide them the
convenience in handling inquiries and reservation through computer generation. It is designed to
minimize the paper works, the workload and to organize files that are needed and relevant to the
reservation process. This will sustain the necessity of meeting the customer’s demands by means
of hassle-free transaction that can lessen the time and effort. Without the need of visiting the resort
itself, the customer can inquire and reserve online through the usage of this website. They can
obtain information about the resort’s facilities, amenities, rates and other services offered and the
actual view of the resort itself.
Because of the continuous improvement in technology, its already very rare for a business
to be known without the help of technology. This became the medium of business algorithm. Using
a website, it can be a good quality investment for it will not only benefit the owner for its
competitiveness, the customer will also benefit because more and more will be aware of the
business.
Preface
Manual Reservation is a very costly and time-consuming process, not only in time and
money but with effort as well, paper works, workload and file storage, considering the weak and
slow means of endorsement or promotion of the business or resort itself. For some small
companies, it may be enough to settle in manual process of reservation for it doesn’t need to invest
a computerized system. But, not for big business as what Strike RGP resort is.
The purpose why the developers chose to develop a website for the company is to provide
solution by producing a computerized system which can be relied on for convenience of inquiry
and reservation. This can lessen the direct communication or person to person approach because
it can provide details available online and set the transaction ahead of time without the need of
visiting the location. The storage of files will be much more organize compare to the old way of
file storage.
I. INTRODUCTION
A resort is a place used for vacation, relaxation or as a daytime getaway. While this can be a
single structure such as a hotel, it also can be a whole island or a ship at sea. One of the most
looked-for aspects of a resort is that visitors are freed from most daily errands, which are typically
taken care of by the facility’s staff. Numerous activities are usually presented at resorts, as well as
massages, meals, live entertainment and cosmetic treatments. The actual location of the buildings
also can be used to describe some resorts. A beach or ski resort is a case of this even though there
might be many natural or manmade allures in the immediate area, the resort itself is essentially
defined by the destination. (Rotundus, n.d.)
Traditionally, a resort accommodates customers manually wherein they still need to visit or
directly come to the resort itself even its just for a simple inquiry. When it comes to promotion the
management of the resort still needs to advertise their offered services and amenities using leaflets,
pamphlets, tarpaulins, and social media like Facebook. The customer in the other hand needs to
fill-up a reservation form wherein it asks what date does the customer wants to reserved, how many
people will be included and what are the services are they going to avail including possible add-
ons, afterwards the cashier will give them a paper receipt. This type of process best applies to
walk-in customers only since they have the privilege of looking around the rooms and facilities.
The term ‘reservation’ used in the context of a hotel, means the booking or reserving of a
room (accommodation) by a guest. Reservations leads to reserving of a particular type of room for
a particular guest for a given period of time. It also gives the guest the first impression of the hotel.
Reservations involve activities which do not take place in front of the guests. The entire front
office activities start the moment an inquiry or request regarding accommodation is made at
the reservations. (oer.nios.ac.in, n.d.) While an inquiry is a question which you ask in order
to get some information.
Nowadays people intend to find ways that make life easier and with the help of technology it
is now possible, vast problems coming from manual and traditional ways are having an innovative
and advanced solutions, a website in which it is not only used for advertisement is one of the
technological and futuristic solutions for businesses like the resort, by making transactions secure
and accessible anytime and anywhere as long as there is internet connection, websites ensure the
company’s file storage in which the need to manually write the so-called history of transactions is
no longer needed.
Creating solutions that was intended to make the resort’s transaction processes fast and reliable
will create new opportunities that can save their time and money. The possibility of having more
customers is possible through the developed solution. This will greatly be beneficial to the owner
and cashier itself for he no longer needs to worry about the hassle and crowded transactions
especially in inquiry and reservation.
Developing a website with reservation and Inquiry that can satisfy the customers and the
owner’s needs and specifications is beneficial. In a reservation website, the customers can directly
browse the resort through the internet like looking for the available date, room, cottages and other
services and amenities offered and inquire for it without the need of leaving the house and by
directly visiting the resort.
Website for Strike RGP Resort with Online Inquiry and Reservation System 1-1
1.1 Problem Statement
1.1.1 General Problems
How to develop a Website for Strike RGP Resort with Online Inquiry and
Reservation System?
The existing system of reservation is slow, it requires additional
manpower/laborers, and is apt to error. For inquiry, the only way is through walk-in, phone
calls, and through the resort’s Facebook Page.
1.1.2 Specific Problems
• How to help the resort on improving their reservation process?
➢ In the current process the customers still need to visit the resort for
reservation, wherein they are expected to wait when there are long
lines and when the availability of the services, they wanted to avail
is no longer existing the long wait they have done is all wasted.
• How to help the resort on improving their inquiry process?
➢ The only way of inquiring in the current process of the resort is
through walk-in just like the way reservation does the customer
needs to visit the resort in order to ask for certain issues or problems.
This type of inquiry takes time and effort and can be lessened with
an online system.
• How to improve the promotion of the resort’s facilities and amenities?
➢ The old way of advertisement or promotion conducted by the resort
is through the use of giving pamphlets, leaflets and the
advertisement shown through their Facebook Page. Having a
website will boost the promotion of the resort by showing what the
resort really was.
• How to develop a module that can gain information like feedbacks and
suggestions?
➢ Currently the resort only receives feedbacks and suggestions
through their Facebook Page.
• How to develop a Content Management System (CMS) module that will
manage and control content from front end and transactions like history,
archive, etc.?
➢ Traditionally the resort needs to record transactions in a log book,
which is very time consuming, making reports also needs to be
manually recorded.
1.2 Overview of the Current State of the Technology
The current process of the resort in promoting their business is through the use of
leaflets and Social media such as Facebook. Their Facebook page has 5,908 followers and
5,838 likes. The resort receives 10 to 20 inquiries per day and typically replies within an
hour. The problems that can be encountered in giving leaflets is, if it doesn’t catch the
interest of customers it will only add to the reproduction and the distribution of it as an
unwanted or unnecessary expense, like the usage of money and time.
The current process of reservation of the resort is that the customers is required to
visit the resort personally to make a reservation or they still need to make phone calls or
contact them through their Facebook page for further and necessary transactions in order
to reserve or in order to conduct a reservation.
The process of inquiry is through walk-in wherein the customers will directly ask
the cashier for information such as how to reserve and what is the policy or the wearables
intended or allowed inside the resort etc. The cashier will state information’s like how
much is the entrance fee, cottages and room rates. Just like what is mentioned in
“Reservation” through their Facebook page customers can also use it for inquiring but the
resort cannot reply immediately to the customers. The resort management/staffs commonly
and frequently use mobile phone in order to communicate with the customers.
With the help of technology, the current process of the resort is expected to
improved, by making the Inquiry, Reservation and Promotion web-base, it will have a high
impact on the resort’s income or the volume of incoming customers will increase leading
to a much higher income.
1.3 Objectives
1.3.1 General Objectives
To develop a Website for Strike RGP Resort with online Inquiry and Reservation
System.
1.3.2 Specific Objectives
• To develop a module that will help the resort in their reservation process.
➢ The developed system will be error-free, compared to the traditional
and old way of reservation which is through pen and paper.
• To develop a module that will help the resort in their inquiry process.
➢ The developers develop an online inquiry system that will serve as
an alternative and addition to the traditional walk-in, phone call and
Facebook messages used by the resort.
• To develop a module that will promote the resorts facilities and amenities.
➢ The traditional way of advertisement done by the resort will be
improve through the developed system.
• To develop a module that can gain information like feedbacks and
suggestions.
➢ The developers will develop a website that have module which the
customer can send message about the customers suggestions and
inquiries.
• To develop a Content Management System (CMS) module that will manage
and control content from front end and transactions like history, archive,
etc.
➢ The admin account provided by the system will give the owner
administrator privileges, in order to manage and control the content
that can be seen in the website.
1.3.3 Scope and Limitations
• Scope
➢ Front End
➢ Home – Shows the basic information about the website.
It includes the company name, links to other pages, and a
log-in button. It also has a slider images that shows some of
the resort’s facilities, amenities and a brief overview of the
services offered.
o News/What’s New? - this includes announcements
by the resort.
➢ About us - this includes the business statement like what is
the resort was all about. In this module the visitors can see
brief information about the resort, its history, staff, mission
and vision, with accompanying pictures about who the
owner is.
➢ Account Module/ Client Account- It contains the actions
that the user can perform.
o Sign Up – Before entering in the reservation process
a customer needs to create his/her account. It
contains a registration form wherein one needs to fill-
up what will be his/her username, password, the
customers first name, last name, middle name, email
address, and contact number. Username, email
address, and contact number will be unique per user.
o Log in - After creating an account the customers are
expected to log-in before continuing to the
reservation process. It includes a form showing a to
fill-up the user’s username and password with the
proper validation by checking if the entered
username or email are valid or existing, as well as if
the password that matches an account registered
under those names are valid as well. Only registered
users can proceed to reservation.
o Reschedule - The customer can move reservation to
a different date.
o Cancellation – This will cancel the reservation upon
the user’s request.
➢ Reservation Module – this includes the reservation form
wherein the customer can choose their desired type of
accommodation and select what date will be reserved, with
options for different services/amenities that the resort offers.
The customer will be notified through e-mail and SMS after
a successful reservation.
➢ Virtual Tour- the developed type of viewing the resorts
amenities like rooms, pool, cottage etc.
➢ Facilities and Rates - Contains images of the resort’s
premises, facilities, rooms, amenities and other important
sections. This also shows rates offered by the resort.
➢ Testimonials - In this module, visitors of the website will
see testimonies given by past account holders. Each
testimonial shows the name of the customer. Only registered
users with reservation records can send a testimonial, and all
testimonial submissions are subject to the administrator’s
approval.
➢ Contact us - this includes the inquiry wherein everyone can
use it to ask for suggestions and recommendations.
o 2D Map – This will show the exact location of the
resort.
➢ Back End
➢ Dashboard- this shows the new transactions held in front
end, and certain information like notifications and the admin
and user logs.
o Expected Customers- shows how many customers
are expected to arrive in a day.
o Approved- It shows how many reservations are
approved.
o Pending- it shows how many reservations needs to
be approved.
o Cancelled- it shows how many reservations are
cancelled.
o Reschedule- it shows how many reservations are
rescheduled.
o Messages- shows how many messages are received.
➢ CMS (Content Management System) – in here the admin
Will be able to add, delete and update the content of the
website’s front end.
▪ Home – it includes editing of the slider images and the
other text content to be seen in the front end.
▪ What’s New? - it includes editing announcements and
the other text content to be seen in the front end.
▪ About us- it includes editing of the images and the other
text content to be seen in the front ends about us page.
▪ Terms and Condition- it includes editing of the terms and
condition content of the website wherein the customer is
expected to agree before proceeding to payment.
▪ Reminder- this includes editing of reminders to be shown
and given to the customer of the resort wherein it
contains the proper values and attire inside the resort etc.
▪ Billing Information- it includes editing of the bank
information of the owner such as bank account number
and name.
Website for Strike RGP Resort with Online Inquiry and Reservation System 1 - 10
▪ File management
o Entrance Fee- this includes the editing of fee’s
required to be payed by the customers upon their
arrival on the resort.
o Cottages – in here the admin can add new cottages,
and update the details of it such as images, price etc.
o Rooms- in here the admin can add new rooms, and
update the details of it such as images, price (for day
and night) etc.
o Accounts- this includes user and admin settings
wherein the admin can view, add, delete and block
specific users.
o Archive- this shows blocked admins/users and
removed items like room, cottages, etc. In here you
can retrieve and unblocked those.
o Testimonials- in here the filtered words (e.g. foul
words, offensive and vulgar words etc.) that are not
allowed to be seen can be viewed and added.
➢ Reservations- under this module the transactions held
within the front end like the reservations can be viewed,
updated and approved.
o Pending – this shows pending transactions; the
administrator can approve pending reservations in
here. Payment can also be viewed through here.
o Approved- the administrator can view the approved
transactions; the administrator can also reschedule
the reservation upon the request of the user/customer.
After the administrator approved a reservation an
SMS confirmation and email will be sent to the
customer.
o Cancelled- this shows cancelled transactions or
transactions that are no longer progressed to
reservation.
o Finished- this shows finished transactions.
o Reschedule- this shows rescheduled transactions.
o Rejected- this shows the list of rejected transactions.
o Disabled- this shows the list of disabled transactions
in which it contains the list of accounts that are
forbidden to make a reservation due to three
consecutive cancellation of their reservation.
➢ Inquiry – this contains the messages receive as inquiry, in
here the administrator can view messages and reply to it.
➢ Testimonials- This includes the list of testimonials made by
the customers, the admin can turn the viewing of it on/off.
➢ Reports - Consists of printable reports in terms of
reservation transactions. Reports can be filtered by Pending,
approved, cancelled and finished reservations including the
payment done by the users. Files are generated as PDF.
➢ Blocked Dates- it contains the blocking of a specific date
wherein the resort might not be available, in case there are
existing reservation for the blocked date the system will send
an email message showing to choose whether to cancel their
reservation or reschedule it.
➢ Backup- this download a local copy of the systems database
coming from the online host.
• Limitations
➢ Payment through debit and credit card is not supported.
➢ Full payment of cash is only allowed, computation of down payment
is not supported.
II. Theoretical Framework
2.1 Introduction
Theoretical Framework defines the prototype model that the developers use, as well
as the software’s that is used for creating the website/system. Such as using a transaction
process system (TPS) which defined as a processing system for business transactions
involving the collection, modification, and retrieval of all transaction data. Characteristics
of a TPS include performance, reliability, and consistency. TPS is also known as
transaction processing or real-time processing. In this case, the development of the project
has contained various IT and Non-IT related theories that helped the developers in
development of the website.
2.2 Information Technology Theory
2.2.1 Methodology
Prototype Model
Figure 2.1
A prototyping is a rudimentary working model of a product of information
system. It is usually built for demonstration purposes or as part of the development
process. The proposed system is built, tested and then reworked as necessary until
an acceptable prototype is finally achieved from which the complete system can
now be developed.
The prototype model’s advantages where: it provides the proof of concept
necessary to attract funding, the early visibility of the prototype gives users an idea
of what the final system looks like, it encourages active participation among the users
and producers, it enables a higher output for user, it is very cost effective, it increases
system development speed, it assists in identifying any problems with the efficacy of
earlier design, requirements analysis and coding activities, and it helps in refining the
potential risks associated with the delivery of the system being developed.
• Identify the problems and Creating Solutions
Identifying what the problem and creating solutions is one of the first stages
done in making the proposed system.
The proponents conducted an interview to the secretary/cashier in order to
identify what specific problems they might experience
With the help of the Client the proponents identified and devised a solution for
the specific problem experienced by the resort. The problem experience by the
client is the accommodation of the customers by reservation, according to our
recent observations the customers still needs to come in the location of the resort
for reservation which makes it very inconvenient and time consuming.
Website for Strike RGP Resort with Online Inquiry and Reservation System 2- 1
This study aims to minimize and omit the inconvenience that was experienced
by the customers.
• Develop the prototype
The next step in developing the proposed system is its prototype development.
Developing the prototype means that the major modules of the system was then
started to be develop, the basic functionalities of the system can be observed, and
the systems structure started to be designed.
The development team started to plan, analyze, design the database and do the
major codes in developing the proposed system. The process started in creating the
blueprint and the analyzation of the system wherein the project manager started to
devised the online solutions that are suitable for the clients problem while the
designer started to create a draft design drawn in a piece of paper, the project
manager after devising the solution gives the programmer the queue to start the
coding process. After several analyzation and a development process the designer
started to create the systems architecture. Together with the project manager’s
advice and recommendations the systems prototype was then developed.
• Alpha and Beta Testing, Partial Implementation and the usage of prototype
The testing stages is an important part of system development it covers the
evaluation done by the client and end users, the system can be evaluated as
approved or to be revised. After several testing stages implementation of the system
is the next step it includes the installation and the usage of the system in the real
user environment.
After developing the proposed system’s prototype will be then tested and
evaluated for the purpose of revising and enhancing the systems functionalities and
design. Testing stages includes unit testing where individual modules are then
tested, integration testing where individual modules are compiled and tested as
group, system testing where group modules and programs are then combined to one
running system, and acceptance testing where the proposed system was then tested
to the site for approval.
After several revisions and enhancement the proponent’s system must start to
be partially implemented, hosting the website also started to be implemented at
this stage, but because it was only partial and was also a part of the testing stage
local host was used in order to run the website via a browser, the system was then
run according with the approval of the client, it was used and tried by the client’s
customers itself. But this staged only limits the usage of the client for a short period
of time, the system still needs to be refined and converted in an operational system.
The next staged will discuss the final implementation stage.
• Convert to Operational System
Converting the prototype system into an operational system means that the
system is now then released for final implementation, and its prototype title will
now be then converted to a fully functional and developed system.
After the testing and finishing the partial implementation process started to
convert the system into a fully developed system that was ready to be implemented
online. The system will start to serve customers for the resort,
The problem that was identified must find a suitable solution. An online
solution suits the problem.
• Maintenance, Upgrading and Enhancing the System
Systems Maintenance is the final and an iterative process in system
development, it includes the evaluation of the systems maintainability, the system
will be check-up for a given period of time, and as mentioned it is an iterative
process which makes it very expensive in the systems life cycle development. It
also includes the upgrade and enhancement that the developers might add to it.
It includes Corrective maintenance, wherein changes can be made, Adaptive
maintenance wherein the system must adapt to changing needs of the business,
Perfective maintenance in order to improve the systems efficiency, reliability,
functionality, and maintainability and Preventive maintenance wherein more
changes will be made in order to prevent future system failure. The system will be
then having its upgrades in order to maintain its relativity in the industry.
2.2.2 Database Management Theory
A database management system (DBMS) is a collection of programs that enables
you to store, modify, and extract information from a database. There are many different
types of database management system, ranging from small systems that run on personal
computer huge systems that run on mainframes.
The developers applied database management in the system to store files and data
so that the users can easily retrieve them whenever they needed.
2.2.3 MySQL
MySQL is an Oracle-backed open source relational database management system
(RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all
platforms, including Linux, UNIX and Windows. Although it can be used in a wide range
of applications, MySQL is most often associated with web applications and online
publishing.
MySQL is an important component of an open source enterprise stack
called LAMP. LAMP is a web development platform that uses Linux as the operating
system, Apache as the web server, MySQL as the relational database management system
and PHP as the object-oriented scripting language. (Sometimes Perl or Python is used
instead of PHP.) (searchoracle.techtarget.com, n.d.)
2.2.4 Hypertext Markup Language (HTML)
HTML (Hypertext Markup Language) is a text-based approach to describing how
content contained within an HTML file is structured. This markup tells a web browser how
to display text, images and other forms of multimedia on a webpage.
HTML is a formal recommendation by the World Wide Web Consortium (W3C)
and is generally adhered to by all major web browsers, including both desktop and mobile
web browsers. HTML5 is the latest version of the specification.
Using HTML, a document containing text is further marked up with additional text
describing how the document should be displayed. To keep the markup part separate from
the actual content of the HTML file, there is a special, distinguishing HTML syntax that is
used. These special components are known as HTML tags. The tags can contain name-
value pairs known as attributes, and a piece of content that is enclosed within a tag is
referred to as an HTML element. (theserverside.com, n.d.)
2.2.5 Cascading Style Sheet (CSS)
Stands for "Cascading Style Sheet." Cascading style sheets are used to format the
layout of Web pages. They can be used to define text styles, table sizes, and other aspects
of Web pages that previously could only be defined in a page's HTML.
CSS helps Web developers create a uniform look across several pages of a Web
site. Instead of defining the style of each table and each block of text within a page's HTML,
commonly used styles need to be defined only once in a CSS document. Once the style is
defined in cascading style sheet, it can be used by any page that references the CSS file.
Plus, CSS makes it easy to change styles across several pages at once. For example, a Web
developer may want to increase the default text size from 10pt to 12pt for fifty pages of a
Web site. If the pages all reference the same style sheet, the text size only needs to be
changed on the style sheet and all the pages will show the larger text. (techterms.com, n.d.)
2.2.6 Hypertext Processor (PHP)
Self-referentially short for PHP: Hypertext Preprocessor, an open source, server-
side, HTML embedded scripting language used to create dynamic Web pages.
In an HTML document, PHP script (similar syntax to that of Perl or C ) is enclosed
within special PHP tags. Because PHP is embedded within tags, the author can jump
between HTML and PHP (similar to ASP and Cold Fusion) instead of having to rely on
heavy amounts of code to output HTML. And, because PHP is executed on the server,
the client cannot view the PHP code. (webopedia.com, n.d.)
The developers used PHP as the programming language in developing the
important function of the website
2.2.7 XAMPP
XAMPP ( or ) is a free and open source cross-platform web server solution stack
package developed by Apache Friends, consisting mainly of the Apache HTTP Server,
MariaDB database, and interpreters for scripts written in the PHP and Perl programming
languages. XAMPP stands for Cross-Platform (X), Apache (A), MariaDB (M), PHP (P)
and Perl (P). It is a simple, lightweight Apache distribution that makes it extremely easy
for developers to create a local web server for testing and deployment purposes. Everything
needed to set up a web server – server application (Apache), database (MariaDB), and
scripting language (PHP) – is included in an extractable file. XAMPP is also cross-
platform, which means it works equally well on Linux, Mac and Windows. Since most
actual web server deployments use the same components as XAMPP, it makes transitioning
from a local test server to a live server extremely easy as well. (findwords.info, n.d.)
2.3 Multimedia Devices Theory
2.3.1 Adobe Photoshop CS6
Adobe Photoshop is software that is extensively used for raster image editing,
graphic design and digital art. It makes use of layering to allow for depth and flexibility in
the design and editing process, as well as provide powerful editing tools, that when
combined, are capable of just about anything.
It was created by brothers Thomas and John Knoll in 1988. In 1989, John sold the
program to Adobe Systems, which marketed it as “Photoshop.” Since then, the program
has become the de facto industry standard for raster graphics editing. It is published for
both macOS and Windows, but not Linux. (techopedia.com, n.d.)
The developers use the Photoshop to edit images to be uploaded to the website to
give a more pleasing and attractive picture of interface and also for logo enhancement.
2.3.2 Adobe Flash
Adobe Flash is a proprietary application development platform developed by
Adobe Systems. The primary focus of the Flash platform is the creation of Rich Internet
applications (RIA), which combine graphics, animation, video and sound for an enhanced
Web user experience. (techopedia.com, definition/1991/adobe-flash, n.d.)
The developers use Adobe Flash because it’s very easy and most effective in
creating a presentation.
2.4 Hosting Theory
A web hosting service is a type of internet hosting service that allows individuals and
organization to make their website accessible via the World Wide Web. We host are companies
that provide space on a server owned or leased for use by clients, as well as providing internet
connectivity to the Internet for other servers located in their data center called collocation, also
known as Housing in I Min America or France.
The developers use the World Wide Web to display the website to the internet.
2.5 Non-Information Technology Theories
2.5.1 Advertisement
Paid, non-personal, public communication about causes, good, and services,
ideas, organizations, people and place through mean of direct e-mail, telephone print, radio,
television and internet. An integral part of marketing, advertisements are public notices
designed to motivate. The objective of this is to change the thinking pattern of the recipients
so that he/she persuaded to take the action desired by the advertiser.
2.5.2 Summary
The Website for Strike RGP Resort with Online Inquiry and Reservation System was
developed with the help of these IT and NON-IT THEORIES. This provided a necessary tool that
contains the main resources to build and to make the website feasible. Database Management
theory has helped a lot in increasing tables and providing significant storage for inputted data such
as the use of XAMPP for testing the webpage without the need of the internet and MySQL as a
database HTML tools for creating the website and giving the physical attribute to the layout, CSS
for the design, NIP as a programming language for website development. And also, the Multimedia
devices such as Photoshop CS6 for enhancing logo and images uploaded in the website and the
Adobe Flash for the presentation of the proposed system. Hosting sites is a big help in
implementing this project which made it possible to be accessed online.
3.0 Website for Strike RGP Resort with Online Inquiry and Reservation System
3.1 Introduction
The main objective of the website is to provide a computerized system for Strike RGP
Resort in which it will expand its greater capacity to gain target market and improve the manual
reservation and inquiry by making it online so it will be convenient and benefitable to the both and
customers. Nowadays, the use of improving technology has already been the avenue of business.
It does not only offer a potential strength for the business but also gives the opportunity to provide
a thoughtfully sustainable way for the customer’s demand, and with the development of this
project, the developers aim to create and contribute an output of system development to the
company as well as to the IT industry.
This system will provide users with accurate and efficient modules to manage customer
reservation, to have a new method of inquiring online, to develop a dashboard and reports module
that shows summaries and data regarding customers and transactions, and integrate the system,
combining promotion, publicity, information, reservation, inquiry, and the ability to post
testimonials, giving them an advantage over their competitors.
This chapter contains several diagrams related to the architecture of the system, from the
front-end to the backend. The diagrams that are also included are Entity Relationship Diagrams
(ERD) Data Flow Diagrams (DFD) and Context Diagram.
Figure 3.1 Data Flow Diagram (Diagram 0)
The data flow diagram illustrates how data is processed by the system in terms of input and outputs.
As its name indicates the focus of the flow of information, where does the data comes from, and
goes, then how it is stored.
Figure 3.2 Entity Relationship Diagram
This diagram represents entities involved in the whole process of reservation and inquiry, their
interrelationships, attributes.
Figure 3.3 Context Diagram
This context diagram illustrates how the data is processed by the system in terms of inputs and
output. If the customer will reserve or inquire, they need to register or login an account. Once the
customer sends a message about inquiring or reservation, the admin will notify them.
Figure 3.4 Hierarchical Input Process Output Chart (Front- End)
This HIPO Chart illustrates the hierarchy of modules in the front end. The home module
contains the highlights and brief information about the resort. The reservation module contains the
login/register, reservation form, and receipt. The contact us module contains the exact location and
inquiry form. For the facilities and rates the customer can see entrance fee and amenities. The
about us module contains the background of the resort. Testimonials modules contains the
feedback from the previous customer.
Figure 3.5 Hierarchical Input Process Output Chart (Back-end)
This HIPO Chart represent the hierarchy of modules in the back end. In dashboard, the
admin can see the total reservation, pending, new user accounts, and new message. For the
reservation module, the admin will see the pending and approved reservation. The Content
Management System has file maintenance that can manipulated the home, facilities and Rates,
rooms and contact us. The report module contains the approved and cancelled reports. the inquiry
module contains the message of the customer. For account setting, the admin can access the guest
accounts and other admin accounts, in here the admin can add a new admin.
Chapter 4 Performance Analysis
4.1 Introduction
The study is to develop a website for Strike RGP Resort that can be used for the benefit of
the business, customers, and developers. This will provide an online inquiry and reservation for
customers convenience.
The purpose of testing is to determine if the software is really a bug-free environment and
if the modules really is functioning properly. The developers conducted a survey to gain
information about the client’s satisfaction in using the software. The main objectives or purpose
of the system is to let the client gain information through the website and to give them a hassle-
free online reservation instead of going to the resort personally. Through the information that we
have gathered, the developers will be able to determine the modules that are needed to improve
and to considerate the design as of the result of it there are some suggestions that really help the
developers to make the website more suitable and user friendly to the customer.
4.2 Experimental
The developers conducted a survey through the usage of questionnaires (see appendix B)
to analyze the performance of the website and receive feedback from the users. The survey that
the developers conducted is for the random users that wants to try the resorts offered facilities and
amenities. The survey was rated from excellent to poor, they were asked about the website’s
usability. The feedbacks and comments will help the developers to improve the current website.
The surveys test each module and categories to determine the efficiency and function.
The survey was participated by 80 respondents because it is the number of
customers of the resort per week. To determine the number of respondents that will
participate in the survey, the researchers used Slovin’s Formula. All respondents, at the
very least, had basic knowledge about websites. Most respondents are students from STI
College Dasmarinas. The survey’s purpose is to evaluate the system’s usability,
particularly its functionality and design, if it meets the client’s requirements.
Slovin’s Formula
n = N /(1 + 𝑁𝑒 2 )
Whereas:
n = Number of Samples
N = Total Population
e = Margin of Error
n = 100 / (1 + 100(0.052 ))
n = 80
4.3 Results and Analysis
4.3.1 Functionality
Table 1 Functionality Rating
Characteristics Mean Interpretation
Simplicity of the process of reservation 4.73 Very Effective
Immediate response on inquiries. 4.55 Very Effective
TOTAL 4.64 Very Effective
Legend: 1.0-1.80 Not effective 1.81-2.60 Less effective 2.61-3.40 Moderately effective 3.41
– 4.20 Effective 4.21 – 5.0 Very effective.
The above table shows the extent effectiveness of the developed system to the user in
terms of functionality. It illustrates that all indicators are assessed by respondents as very
effective: (1) item 1 obtained a mean score of 4.73 which means the reservation process of the
website is very simple (2) item 2 obtained a mean score of 4.55 which means the website send
response on inquiries very quickly.
4.3.2 Content
Table 2 Content Rating
Accuracy of information about the 4.97 Very Effective
resort and services offered.
Relevance of the images about the resort 4.5 Effective
and facilities.
terms of Content. It illustrates that indicators are assessed by respondents as very effective and
effective: (1) item 1 obtained a mean score of 4.97 which means the information about the resort
and services offered are all precise. (2) Item 2 obtained a mean score of 4.5 which means the
images about the resort and facilities are appropriate.
4.3.3 Aesthetic
Table 3 Aesthetic Rating
Properly represents the colour of the 4.53 Very Effective
resort.
Visual appeal of the colour used in the 4.31 Very Effective
website.
terms of Aesthetic. It illustrates that all indicators are assessed by respondents as very effective:
(1) item 1 obtained a mean score of 4.53 which means all the colour used in the website properly
represents the resort (2) item obtained a mean score of 4.31 which means the colour used in the
website is visually appealing.
4.3.4 Availabilty
Table 4 Availability Rating
Accessible time of the reservation and 4.51 Very Effective
inquiries for the customer.
Completing all the process without 4.53 Very Effective
interruption.
terms of availability. It illustrates that all indicators are assessed by respondents as very effective:
(1) item 1 obtained a mean score of 4.51 which means the reservation and inquiries are all
available every time for the customer. (2) Item 2 obtained a mean score of 4.53 which means
there is no interruption in completing all the process.
SUMMARY
Table 5 Overall Characteristics Rating
Functionality 4.64 Very Effective
Content 4.73 Very Effective
Aesthetic 4.42 Very Effective
Availability 4.52 Very Effective
Total 4.58 Very Effective
terms of overall characteristics. It illustrates that all indicators are assessed by respondents as
very effective: Functionality earned a mean score of 4.64 which means the overall functionality
is very effective, The content earned a mean score of 4.73 which means the overall content is
very effective, the aesthetic earned a mean score of 4.42 which means the website is very
attractive to the user and the availability earned a mean score of 4.52 which means the
accessibility to the user is very effective.
After the conducted evaluation of the respondents, the proponents have evaluated the
results and analysis according to website’s requirement. In terms of functionality, it obtained a
mean score of 4.64 which means the overall functionality of the website is very effective. In
terms of content, it obtained a mean score of 4.73 which means the content of the website is very
effective. In terms of aesthetic, it obtained a mean score of 4.42 which means the website is very
attractive. In terms of availability, it obtained a mean score of 4.52 which means the website
availability for the customer is very effective.
Chapter 5 Conclusion
This project introduced the developer’s way of innovating the Strike RGP Resort services.
The website will be an advantage in providing important information like announcements, what’s
new, promotions, inquiry and reservation for it evolved into an interactive, effective and easy way
of advertisements. Reservation that are manual before makes it hard to rely on due to inorganized
and inefficient way of responding to customer’s request. Now that technology became an ally of
human interaction, it lessens the workload and it improved the capacity of technology through
helpful machinery such as computer system. Well managed databases are monitored and controlled
at the same time it secures the user’s credentials.
Based from the results of the survey conducted by the developers, it is concluded that the
system is very effective in terms of functionality, content, aesthetic and availability. The
proponents believed that:
1. Strike RGP resort Website with Online Inquiry and Reservation provides easier
way of reservation and inquiry,
2. The website is an effective medium to promote the resort’s facilities and services,
3. and the system provides organized records of transactions which helps the owner
and staff in managing their resort.
Strike RGP Resort will consider the implementation of the project for bigger advantage to
the owner, customers and the management.
Therefore, a website would be better by providing higher security, and more features ad
facts about the resorts itself. The Strike RGP Resort is a beneficial Website to the customers and
staffs.
Bibliography
findwords.info. (n.d.). term/xampp. Retrieved from findwords.info:
https://findwords.info/term/xampp
searchoracle.techtarget.com. (n.d.). definition/MySQL. Retrieved from
searchoracle.techtarget.com: https://searchoracle.techtarget.com/definition/MySQL
techopedia.com. (n.d.). definition/1991/adobe-flash. Retrieved from techopedia.com:
https://www.techopedia.com/definition/1991/adobe-flash
techopedia.com. (n.d.). definition/32364/adobe-photoshop. Retrieved from techopedia.com:
https://www.techopedia.com/definition/32364/adobe-photoshop
techterms.com. (n.d.). definition/css. Retrieved from techterms.com:
https://techterms.com/definition/css
theserverside.com. (n.d.). definition/HTML-Hypertext-Markup-Language. Retrieved from
theserverside.com: https://www.theserverside.com/definition/HTML-Hypertext-Markup-
Language
webopedia.com. (n.d.). TERM/P/PHP.html. Retrieved from webopedia.com:
https://www.webopedia.com/TERM/P/PHP.html
Rotundus. (n.d.). what-is-a-resort-please-explain. Retrieved from rotundus.co.za:
http://www.rotundus.co.za/what-is-a-resort-please-explain/
oer.nios.ac.in. (n.d.) Role_of_Reservations. Retrieved from oer.nios.ac.in:
http://oer.nios.ac.in/wiki/index.php/Role_of_Reservation.
APPENDIX A
(Transcript of Interview)
Transcript of Interview
Proponents: Good Afternoon po Ma’am pwede po sana magtanong kung pumapayag po kayo na
maging client namin for website development, school purposes po, thesis.
Cashier/ Ms. Lorie Ann:Ah ok lang naman kaso si sir lang ang pwedeng mag approved eh. Yung
owner.
Proponents: Ah sige po nasaan po ba sir ngayon?
Cashier/ Ms. Lorie Ann: Lumabas lang saglit si sir pero pabalik na yun.
Proponents: Sige po hintayin na lang po namin siya.
Cashier/ Ms. Lorie Ann: Ay ayan na pala si sir, Sir may mga naghahanap po sa inyo ask lang po
ng approval for thesis project kukunin daw po tayo as client.
Mr. Ricardo Pantoni: Ah sige ok lang naman ano ba need nilang gawin.
Proponents: Need po kasi naming ng client for thesis project po namin, kukinin po sana naming
kayo as client school purposes lang po.
Mr. Ricardo Pantoni: Ah okay lang naman bale need yung kumuha ng mga pics dito?
Proponents: Opo saka ibang data about the resort.
Mr. Ricardo Pantoni: Ah si Lorie na ang sasagot diyan pwede niyo naman I tanong sa kanya
yung mga need ninyo. (Pertaining to the Cashier/ Ms. Lorie Ann) Paki asikaso naman sila.
Cashier/ Ms. Lorie Ann: Ay sige po sir bale ano ba yung mga gusto niyong itanong.
Proponents: Hihingi po sana kami muna po ng brochure or phamplet po kung meron po. Yung
meron pong details na kung ano po yung offered sa resort saka po yung price.
Cashier/ Ms. Lorie Ann: Sige eto meron naman.
Proponents: May mga itatanong lang po kasi kami about kung paano yung accomodations dito
po sa resort. Kagaya po ng Reservation saka inquiry.
Cashier/ Ms. Lorie Ann: Dito kasi kung mag iinquire ka lang yung need mo pumunta dito directly
or pwede namn through phone calls and messenger kasi may Facebook Page naman kami.
Proponents: So same lang po sa reservation?
Cashier/ Ms. Lorie Ann: Oo kapag reservation direct na sila pupunta dito kasabay na yung sa
entrance fee.
Proponents: Sa payment po nun may iba pa po bang way ng pagbayad?
Cashier/ Ms. Lorie Ann: Pwede naman through bank account ni Sir Boy.
Proponents: Bale deposit po?
Cashier/ Ms. Lorie Ann: Oo ganun.
Proponents: Di pa po ninyo nasubukan yung sa pera padala na way ng paymen?
Cashier/ Ms. Lorie Ann: Hindi eh kasi talagang through bank or direct na dito yung bayad nila.
Proponents: Paano po pala yung sa Rescheduling and Cancellation?
Cashier/ Ms. Lorie Ann: Kapag Re-schedule tatawag sila sa amin na mag pa resched sila kaso
before 3 days nung reservation nila dapat nasabi na nila yun.
Proponents: Yung sa cancellation po may refund pa po ba yun in case na nag pa cancel si customer?
Cashier/ Ms. Lorie Ann: Wala na eh No Refund yung policy namin..

Proponents: Ah ganun po.
Cashier/ Ms. Lorie Ann: May mga iba pa kayong itatanong?
Proponents: Sa ngayon po wala na po kasi nandito na po sa brochure yung mga ibang info.
Cashier/ Ms. Lorie Ann: Sige bigay ko yung messenger account ko dun na lang niyo ako
imessage kung meron pa kayong ibang questions.
Proponents: Sige po Salamat po. Babalik na lang po kami ulit for taking ng pictures.
Cashier/ Ms. Lorie Ann: Sige.
______________________________
Signature Over Printed Name
APPENDIX B
(Survey Form)
Name (Optional): Age: Gender:
• The number rating stands for the following:
5 – Excellent 4 – Very Good 3 - Good 2 - Fair 1 – Poor
• Put a check (✔) in the box to rate each questions.
5 4 3 2 1
Functionality
• Simplicity of the process of reservation.
• Immediate response on inquiries.

Content
• Accuracy of information about the resort and
services offered.
•
Relevance of the images about the resort and
facilities.
Aesthetic
• Properly represents the colour of the resort.
• Visual appeal of the colour used in the

website.
Availability
• Accessible time of the reservation and
inquiries for the customer.
• Completing all the process without
interruption.
APPENDIX C
(Screenshots)
Front End
Home Entrance
Cottages Rooms
Testimonials About Us
Contact Us Login
Reservation Step 1 Reservation Step 2
Reservation Step 3 Reservation Step 4

My Reservation My Account
Rescheduling
Backend
Dashboard What’s New(CMS)
Home (CMS) About (CMS)

Terms and Conditions (CMS) Reminder (CMS)
Billing Information (CMS) Entrance (File Management)
Cottages (File Management) Room (File Management)

Walk-In Reservation Pending Reservation
Approved Reservation Cancelled Reservation
Finished Reservation Rescheduled Reservation

Rejected Reservation Disabled Reservation
Inquiry Testimonials
Reports Blocked Dates

APPENDIX D
(Codes)
*Contact Us Front End '".$message."',
<?php '".$dateNow."',
include'backend/conn.php'; '".$timeNow."',
//if (session_status() !== '0'
PHP_SESSION_ACTIVE) {session_start();}
if(session_id() == '' || )
!isset($_SESSION)){session_start();} ");
?> *Inquiry Backend
<?php
<?php if (isset($_GET['id']))
include('backend/conn.php'); {
if (isset($_POST['submit'])) { $query="SELECT * FROM inquire where
id='".$_GET['id']."'";
// Always set content-type when sending HTML $result=mysqli_query($conn,$query);
email while ($result1=mysqli_fetch_array($result))
$headers = "MIME-Version: 1.0" . "\r\n"; {
$headers .= "Content- echo
type:text/html;charset=UTF-8" . "\r\n"; '<div class="two" style="background-color:
rgba(0,0,0,.03);padding:10px;">
// More headers <em style="font-size:18px;"> Subject:
$headers .= 'From:Strikergpresort </em><span style="font-
<strikergpresort.com>' . "\r\n"; size:18px;">    &nbsp
;
$timezone = +8; '.$result1['subject'].'</span><br>
<em style="font-size:13px;">From:</em>
$name = $_POST['name'];       &nb
$email = $_POST['email']; sp;      &
$subject = $_POST['subject']; nbsp;   <span style="font-
$message = $_POST['message']; size:14px;">'.$result1['name'].'</span> <br>
$dateNow = gmdate("F j, Y", time() + <em style="font-size:13px;">Email:</em>
3600*($timezone+date("I"))); <span style="font-size:14px;">
$timeNow = gmdate("g:i a", time() +       &nb
3600*($timezone+date("I"))); sp;      &
$reply = $_POST['reply']; nbsp;     '.$resu
lt1['email'].'</span><br>
<em style="font-size:13px;">Date:</em>
mysqli_query ($conn ,"INSERT INTO inquire <span style="font-size:13px;">
(
name,       &nb
email, sp;      &
subject, nbsp;     &nbsp
message, ; '.$result1['dateNow'].'</span></p>
dateNow, <hr>
timeNow, <em>Message:</em>
reply <div class="mar30-center1"
) style="background-color:white;height:auto;min-
VALUES height:100px;">'.$result1['message'].'</div><br
( >
'".$name."', <p class="r1"><em>Reply:</em></p>
'".$email."',
'".$subject."', <form method="POST">
<input type="hidden" name="email_id" <?php
value="'.$result1['email'].'">
<input type="hidden" include 'backend/conn.php';
name="customer_name"
value="'.$result1['name'].'"> $sql = 'SELECT * FROM customer_reservation
<textarea name="reply" id="area" WHERE status = "pending" AND account_id =
class="reply" style="resize: none;background- "'.$_SESSION['account_id'].'"';
color:white;"> $result = $conn->query($sql);
</textarea><br>
<a>
<button class="btn btn-info" if ($result->num_rows > 0) {
name="submitreply" id="submit" style="margin- // output data of each row
left:20px;background-color:#129470;"><span if($result->fetch_assoc()) {
class="glyphicon "></span> ?>
<span class="f1-1 hideformobile"> <?php
SEND</span></button> }
</a> }else{
</form> $tiss = $_SESSION['account_id'];

</div> $supperss = "";
</div> $sql111 = "SELECT COUNT(id) FROM
</div>'; block_shit WHERE account_id = '$titingss' ";
} $result111 = $conn->query($sql111);
$read="1";
$query1= "UPDATE inquire SET if ($result111->num_rows > 0) {
reply='$read' where id='".$_GET['id']."'"; while($row111 = $result111->fetch_assoc()) {
$x=mysqli_query($conn,$query1); $supperss = $row111['COUNT(id)'];
} }
} else {
//function for reply echo "0 results";
if(isset($_POST['submitreply'])) }
{ ?>
$reply_message=$_POST['reply']; * Reservation Step 2
$c_name=$_POST['customer_name']; <?php
$email=$_POST['email_id'];
require if($_SESSION['check_in'] == "8:00am" ||

'../phpmailer/PHPMailerAutoload.php'; $_SESSION['check_in'] == "6:00pm" ){
require '../phpmailer/class.phpmailer.php'; ?>
$mail = new PHPMailer; <div >
<button class="tablinks"
onclick="openCity(event,
$mail->isSMTP(); 'Tokyo')">Cottage</button>
$mail->Server= relay- </div>
hosting.secureserver.net; <?php
$mail->Host = }else{
'smtpout.asia.secureserver.net'; ?>
$mail->SMTPAuth = true; <?php
$mail->SMTPSecure= false; }
$mail->Port = 80;
*Reservation Step 1 ?>
<?php ?>
$sepcss_date2 = <input type="hidden"
$_SESSION['specific_date']; name="price" id="price" value="<?php echo
$sql = 'SELECT * FROM $row["pricing2"] ?>">
customer_reservation WHERE status = <?php
"Approved" AND date =
"'.$_SESSION['specific_date'].'" OR status = }else{
"Pending" AND date = // something
"'.$_SESSION['specific_date'].'" '; $price =
$result = $conn->query($sql); $row["pricing2"] + $row["pricing"] ;
$total = 0; ?>
if ($result->num_rows > 0) { <input type="hidden"
// output data of each row name="price" id="price" value="<?php echo
while($row = $result- $price ?>">
>fetch_assoc()) { <?php
$total += $row['quantity']; }
}
// echo $total;
}
$sql = "SELECT * FROM room2 $room_name_id = "";

WHERE archive = 0 group by name";
$result = $conn->query($sql); if($_SESSION['check_in'] == "8:00am"){
$sql2 =
if ($result->num_rows > 0) { "SELECT * FROM customer_reservation
// output data of each row WHERE reserve = '$name_shit' AND status =
while($row = $result- 'Approved' AND date = '$sepcss_date2' AND
>fetch_assoc()) { check_in = '8:00am' OR reserve = '$name_shit'
$name_shit = $row['name']; AND status = 'Pending' AND date =
$total_avail = '$sepcss_date2' AND check_in = '8:00am' ";
$row["quantity"] - $total; }else
?> if($_SESSION['check_in'] == "6:00pm"){
<div class="info"> $sql2 =
<input type="hidden" "SELECT * FROM customer_reservation
name="name" id="name" value="<?php echo WHERE reserve = '$name_shit' AND status =
$row["name"] ?>"> 'Approved' AND date = '$sepcss_date2' AND
check_in = '6:00pm' OR reserve = '$name_shit'
<?php AND status = 'Pending' AND date =
'$sepcss_date2' AND check_in = '6:00pm' ";
if($_SESSION['time'] == }else{
'AM'){ $sql2 =
?> "SELECT * FROM customer_reservation
<input type="hidden" WHERE reserve = '$name_shit' AND status =
name="price" id="price" value="<?php echo 'Approved' AND date = '$sepcss_date2' OR
$row["pricing"] ?>"> reserve = '$name_shit' AND status = 'Pending'
AND date = '$sepcss_date2' ";
<?php }
}else if
($_SESSION['time'] == 'PM'){
$result2 = }else{
$conn->query($sql2); ?>
<div id="step3">
$total_shiot = 0; <button class="btn
btn-danger form-control"
$total_shiot_quan = 0; id="room_submit<?php echo $row["id"] ?>"
if ($result- style="margin-top:10px;">BOOK</button>
>num_rows > 0) { </div>
<?php
while($row2 = $result2->fetch_assoc()) { }
?>
$total_shiot += $row2['reserve']; </div>

</div>
$total_shiot_quan += $row2['quantity']; <?php
}
} } else {
echo "0 results";
}else{ }
?>
} </div>
$totalss = <?php
$row["quantity"] - $total_shiot_quan; $sepcss_date =
if($total_shiot $_SESSION['specific_date'];
== $name_shit ){ $sql = 'SELECT * FROM
echo $totalss; customer_reservation WHERE status =
}else{ "Approved" AND date =
echo "'.$_SESSION['specific_date'].'" OR status =
$row["quantity"]; "Pending" AND date =
} "'.$_SESSION['specific_date'].'" ';
?> $result = $conn->query($sql);
</i> $total = 0;
</p> if ($result->num_rows > 0) {
</div> // output data of each row
<div> while($row = $result-
<div id="step2"> >fetch_assoc()) {
<input type="number" $total += $row['quantity'];
name="quantity_room" id="quantity<?php echo
$row["id"] ?>" class="form-control" $cottage_name_id =
style="margin-top: 50px;" value="1"> $row['reserve'];
</div>
<?php }
if($totalss === 0){ // echo $total;
?> }
<div id="step3"> $sql = "SELECT * FROM cottage
<button class="btn WHERE archive = 0 group by name";
btn-secondary form-control" onClick="alert('No $result = $conn->query($sql);
available rooms!');" style="margin- if ($result->num_rows > 0) {
top:10px;">BOOK</button> // output data of each row
</div> while($row = $result-
<?php >fetch_assoc()) {
$name_shit = $row['name'];
?>
<?php
$result2 =
$conn->query($sql2);
$cottage_name_id = "";
// $sql2 = $total_shiot = 0;
"SELECT * FROM customer_reservation
WHERE reserve = '$name_shit' AND status = $total_shiot_quan = 0;
'Approved' AND date = '$sepcss_date' "; if ($result-
>num_rows > 0) {
while($row2 = $result2->fetch_assoc()) {
$cottage_name_id = ""; $total_shiot += $row2['reserve'];
if($_SESSION['check_in'] == "8:00am"){ $total_shiot_quan += $row2['quantity'];

$sql2 =
"SELECT * FROM customer_reservation }
WHERE reserve = '$name_shit' AND status =
'Approved' AND date = '$sepcss_date' AND }else{
check_in = '8:00am' OR reserve = '$name_shit'
AND status = 'Pending' AND date = }
'$sepcss_date' AND check_in = '8:00am' "; $totalss =
}else $row["quantity"] - $total_shiot_quan;
if($_SESSION['check_in'] == "6:00pm"){ if($total_shiot
$sql2 = == $name_shit ){
"SELECT * FROM customer_reservation echo $totalss;
WHERE reserve = '$name_shit' AND status = }else{
'Approved' AND date = '$sepcss_date' AND echo
check_in = '6:00pm' OR reserve = '$name_shit' $row["quantity"];
AND status = 'Pending' AND date = }
'$sepcss_date' AND check_in = '6:00pm' ";
}else{
$sql2 =
"SELECT * FROM customer_reservation ?>
WHERE reserve = '$name_shit' AND status = <?php
'Approved' AND date = '$sepcss_date' OR $days = 0;
reserve = '$name_shit' AND status = 'Pending' if(($_SESSION['check_in'] ===
AND date = '$sepcss_date' "; '8:00am') || ($_SESSION['check_in'] ===
} '6:00pm')){
?>
<b>Date:</b> <?php echo
$_SESSION['specific_date']; ?><br/>
<?php
}else{
?>
<b>Time: </b><?php echo var price = <?php echo json_encode($haseq);
$_SESSION['specific_time']; ?><br/> ?>;
<?php <?php
$diff = }
abs(strtotime($_SESSION['check_in']) - ?>
strtotime($_SESSION['check_out']));
$years = floor($diff / var quantity = $("#quantity<?php echo
(365*60*60*24)); $row["id"] ?>").val();
$months = floor(($diff - $years if((<?php echo $_SESSION['pax']; ?> <=
* 365*60*60*24) / (30*60*60*24)); <?php echo $row["capacity"]; ?>)){
$days = floor(($diff - $years * $.ajax({
365*60*60*24 - $months*30*60*60*24)/ url:'cart.php',
(60*60*24)); method:'POST',
$_SESSION['days'] = $days; data:{
} reserve_name:reserve_name,
?> price:price,
quantity:quantity
<?php },
$sql = "SELECT * FROM room2"; success:function(data){
$result = $conn->query($sql); $.ajax({
type: "GET",
if ($result->num_rows > 0) { url: "cart_record.php",
// output data of each row dataType: "html",
while($row = $result->fetch_assoc()) { success: function(response) {
?> $("#display").html(response);
<script> }
$(document).ready(function(){ });
}
$("#room_submit<?php echo $row["id"]
?>").click(function(){ });
}else{
var reserve_name = <?php echo var pax = <?php echo
json_encode($row["name"]); ?>; $_SESSION['pax']; ?>;
var cap = <?php echo
<?php $row["capacity"]; ?>;
var tot = (pax / quantity);
if($_SESSION['time'] === 'AM'){ if(cap >= tot){
?> $.ajax({
var price = <?php echo url:'cart.php',
json_encode($row["pricing"]); ?>; method:'POST',
<?php data:{
}else if ($_SESSION['time'] === 'PM'){ reserve_name:reserve_name,
?> price:price,
var price = <?php echo quantity:quantity
json_encode($row["pricing2"]); ?>; },
<?php success:function(data){
}else{ $.ajax({
$haseq = $row["pricing"] + $row["pricing2"]; type: "GET",
?> url: "cart_record.php",
dataType: "html",
success: function(response) {
$("#display").html(response); var quantity = $("#quantity<?php echo

} $row["id"] ?>").val();
}); if((<?php echo $_SESSION['pax']; ?> <=
} <?php echo $row["capacity"]; ?>)){
$.ajax({
}); url:'cart.php',
}else{ method:'POST',
alert('You exceed in maximum data:{
capacity of the room'); reserve_name:reserve_name,
} price:price,
quantity:quantity
} },
success:function(data){
}); $.ajax({
}); type: "GET",
</script> url: "cart_record.php",
dataType: "html",
<?php success: function(response) {
}
} $("#display").html(response);
?> }
});
 }
});
<?php }else{
$sql = "SELECT * FROM cottage"; var pax = <?php echo
$result = $conn->query($sql); $_SESSION['pax']; ?>;
var cap = <?php echo
if ($result->num_rows > 0) { $row["capacity"]; ?>;
// output data of each row var tot = (pax / quantity);
while($row = $result->fetch_assoc()) { if(cap >= tot){
?> $.ajax({
<script> url:'cart.php',
$(document).ready(function(){ method:'POST',
data:{
$("#cottage_submit<?php echo $row["id"] reserve_name:reserve_name,
?>").click(function(){ price:price,
var reserve_name = <?php echo quantity:quantity
json_encode($row["name"]); ?>; },
success:function(data){
$.ajax({
type: "GET",
url: "cart_record.php",
var price = <?php echo dataType: "html",
json_encode($row["pricing"]); ?>; success: function(response) {
$("#display").html(response);
}
});
}
}); $id;
}else{
alert('You exceed in maximum if ($result->num_rows > 0) {
capacity of the cottage'); // output data of each row
} while($row = $result-
} >fetch_assoc()) {
$id = $row["id"];
}); $reserve_name =
}); $row["reserve"];
</script> if($_SESSION['time'] ===
'AM'){
<?php
}
} $check_room2 = "";
?> $sql2 = "SELECT * FROM room2 WHERE
*Reservation Step 3 name = '$reserve_name' ";
<?php $result2 = $conn->query($sql2);
require_once 'backend/functions.php'; if ($result2->num_rows > 0) {
include_once"session.php"; while($row2 = $result2->fetch_assoc()) {
$check_room2 = $row2['pricing'];
$sql = 'SELECT * FROM cart WHERE user_id }
= "'.$_SESSION['account_id'].'"'; } else {
$result = $conn->query($sql);
$total = 0;
$sql22 = "SELECT * FROM cottage WHERE
if ($result->num_rows > 0) { name = '$reserve_name' ";
// output data of each row $result22 = $conn->query($sql22);
while($row = $result->fetch_assoc()) { if ($result22->num_rows > 0) {
$total += $row['quantity']; while($row22 = $result22->fetch_assoc()) {
} $check_room2 = $row22['pricing'];
} }
$_SESSION['car_total'] = $total; } else {
if($_SESSION['car_total'] > }
$_SESSION['pax']){ }
$_SESSION['error'] = 'please reserve properly
according to the number of pax';
header("Location: reservation-step-2.php"); ?>
}else if(empty($_SESSION['car_total'])){ <tr>
$_SESSION['error'] = 'The cart is empty'; <td><?php echo
header("Location: reservation-step-2.php"); $row["reserve"] ?></td>
} <td><?php echo
?> $row["quantity"] ?></td>
<?php <td>1</td>
$user_id = <td>
$_SESSION['account_id']; ₱<?php echo
$sql = "SELECT * FROM cart $row["quantity"] * $check_room2 ?>.00
WHERE user_id = '$user_id'"; <a
$result = $conn->query($sql); href="delete.php?id=<?php echo $row["id"] ?>"
id="<?php echo $row["id"] ?>" class="trash" <a
style="text- href="delete.php?id=<?php echo $row["id"] ?>"
decoration:none;float:right"><b>x</b></a> id="<?php echo $row["id"] ?>" class="trash"
</td> style="text-
</tr> decoration:none;float:right"><b>x</b></a>
<?php </td>
}else if($_SESSION['time'] </tr>
=== 'PM'){ <?php
}else{
$check_room23 = ""; $check_room22 = "";

$sql23 = "SELECT * FROM room2 WHERE $check_room23 = "";
name = '$reserve_name' "; $sql23 = "SELECT * FROM room2 WHERE
$result23 = $conn->query($sql23); name = '$reserve_name' ";
if ($result23->num_rows > 0) { $result23 = $conn->query($sql23);
while($row23 = $result23->fetch_assoc()) { if ($result23->num_rows > 0) {
$check_room23 = $row23['pricing2']; while($row23 = $result23->fetch_assoc()) {
} $check_room22 = $row23['pricing'];
} else { $check_room23 = $row23['pricing2'];
}
$sql223 = "SELECT * FROM cottage } else {
WHERE name = '$reserve_name' ";
$result223 = $conn->query($sql223); }
if ($result223->num_rows > 0) {
while($row223 = $result223- $check_room24 = $check_room23 +
>fetch_assoc()) { $check_room22;
$check_room23 = $row223['pricing'];
}
} else {
} ?>
<tr>
<td><?php echo
$row["reserve"] ?></td>
<td><?php echo
?> $row["quantity"] ?></td>
<tr> <td><?php echo
<td><?php echo $_SESSION['days'] ?></td>
$row["reserve"] ?></td> <td>
<td><?php echo
$row["quantity"] ?></td> ₱<?php echo
<td>1</td> ($row["quantity"] * $check_room24) *
<td> $_SESSION['days']; ?>.00
₱<?php echo
$row["quantity"] * $check_room23; ?>.00 <a
href="delete.php?id=<?php echo $row["id"] ?>"
id="<?php echo $row["id"] ?>" class="trash"
style="text-decoration:none;float:right" ><b> $tanginanialfred .= $row['reserve']. ', ';
x </b> $sql = 'INSERT INTO customer_reservation

'.'(account_id,reservation_id,reserve, quantity,
</a> price, check_in, check_out,date, status)
'.'VALUES
</td> ("'.$_SESSION['account_id'].'","'.$_SESSION['r
</tr> eservation_id'].'","'.$row["reserve"].'","'.$row["q
<?php uantity"].'","'.$row['total'].'","'.$_SESSION['chec
} k_in'].'","'.$_SESSION['check_out'].'","'.$_SESS
?> ION['specific_date'].'","Pending")';
if ($conn->query($sql) === TRUE) {
if(count($row) > 0){
<?php }
} }
} else { else
echo "0 results"; {
} echo "failed";
}
?>
*Final Step (Reservation Step 4)
<?php
include 'backend/conn.php'; }
session_start(); } else {
echo "0 results";
function generateRandomString($length = 10) { }
$characters =
'0123456789abcdefghijklmnopqrstuvwxyzABC
DEFGHIJKLMNOPQRSTUVWXYZ';
$charactersLength = strlen($characters); $sql = 'SELECT * FROM user WHERE
$randomString = ''; account_id = "'.$_SESSION['account_id'].'"';
for ($i = 0; $i < $length; $i++) { $result1 = $conn->query($sql);
$randomString .= $characters[rand(0,
$charactersLength - 1)];
} if ($result1->num_rows > 0) {
return $randomString; // output data of each row
}
$_SESSION['reservation_id'] = while($row = $result1->fetch_assoc()) {
generateRandomString();
$sql = 'SELECT * FROM cart WHERE user_id

= "'.$_SESSION['account_id'].'" ';
$tanginanialfred = "";
if ($result->num_rows > 0) { $sql2 = "SELECT * FROM
// output data of each row payment_instruction";
while($row = $result->fetch_assoc()) { $result2 = $conn->query($sql2);
$titis = "0";
}else{
if ($result2->num_rows > 0) { $titis = "1";
// output data of each row $startTimeStamp = strtotime($check_in);
$endTimeStamp = strtotime($check_out);
while($row2 = $result2->fetch_assoc()) {
?> $timeDiff = abs($endTimeStamp -
*Approved reservation $startTimeStamp);
<?php $numberDays = $timeDiff/86400; //

86400 seconds in one day
include 'conn.php';
session_start(); // and you might want to convert to integer
$numberDays = intval($numberDays);
$sql = 'UPDATE customer_reservation SET
status="Approved" WHERE
reservation_id="'.$_GET['id'].'"';
}
if ($conn->query($sql) === TRUE) { $value = $row["quantity"] * $row["price"];

$sum += $value;
$getsi = $_GET['id']; // ITO END
$ghes = "";
$ghes_email = "";
$rid = "";
$tanginanialfred="";
$cin="";
$cout="";
$specdate=""; }
$sum=""; } else {
$sql = "SELECT * FROM customer_reservation echo "0 results";
WHERE reservation_id = '$getsi' "; }
if ($result->num_rows > 0) { // ITO ULIT 2
while($row = $result->fetch_assoc()) { $asdasd = "";
$ghes = $row['account_id']; if($titis == "0"){
$asdasd = $sum;
$rid =$row['reservation_id']; }else{
$tanginanialfred .= $row['reserve']. ', '; $asdasd = $sum * $numberDays;
$cin=$row['check_in'];
$cout=$row['check_out']; }
$specdate=$row['date'];
// ITO STSART 1
$check_in= $row['check_in'];
$check_out= $row['check_out']; $sql = 'SELECT * FROM user WHERE
account_id = "'.$ghes.'"';
if($check_in == "8:00am" || $check_in == $result1 = $conn->query($sql);
"6:00pm" ){
if ($result1->num_rows > 0) {
// output data of each row
while($row = $result1->fetch_assoc()) {
if ($conn->query($sql) === TRUE) {
$contactnum=$row['contact_number'];
$getsi = $_GET['id'];
$ghes = "";
$ghes_email = "";
$rid = "";
$tanginanialfred="";
$cin="";
$sql22 = "SELECT * FROM $cout="";
payment_instruction"; $specdate="";
$result22 = $conn->query($sql22); $sum="";
$sql = "SELECT * FROM customer_reservation
WHERE reservation_id = '$getsi' ";
if ($result->num_rows > 0) { $result = $conn->query($sql);
// output data of each row if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
while($row22 = $result22->fetch_assoc()) { $ghes = $row['account_id'];
$rid =$row['reservation_id'];
$tanginanialfred .= $row['reserve']. ', ';
$cin=$row['check_in'];
$ghes_email = $row['email']; $cout=$row['check_out'];
$specdate=$row['date'];
// header("Location: approved-
reservation.php");
} else {
echo "Error updating record: " . $conn->error; // ITO STSART 1
} $check_in= $row['check_in'];
$check_out= $row['check_out'];
?>
*Reject Reservation if($check_in == "8:00am" || $check_in ==
"6:00pm" ){
<?php
$titis = "0";
include 'conn.php'; }else{
session_start(); $titis = "1";
$startTimeStamp = strtotime($check_in);
$sql = 'UPDATE customer_reservation SET $endTimeStamp = strtotime($check_out);
status="Rejected" WHERE
reservation_id="'.$_GET['id'].'"'; $timeDiff = abs($endTimeStamp -
$startTimeStamp);
$numberDays = $timeDiff/86400; //
86400 seconds in one day
// and you might want to convert to integer

$numberDays = intval($numberDays);
$ghes_email = $row['email'];
} ?>
$value = $row["quantity"] * $row["price"]; *Reschedule More

$sum += $value;
// ITO END <?php
} include_once 'navbar.php';
} else {
echo "0 results";
} include('backend/conn.php');
$id = $_GET['id'];
$ids = $_GET['id'];
// ITO ULIT 2 $check_if_exsiting = "0";
$asdasd = ""; $sql2 = "SELECT * FROM reschedule WHERE
if($titis == "0"){ reservation_id = '$ids' ";
$asdasd = $sum; $result2 = $conn->query($sql2);
}else{ if ($result2->num_rows > 0) {
$asdasd = $sum * $numberDays; while($row2 = $result2->fetch_assoc()) {
}
$check_if_exsiting = "1";
$sql = 'SELECT firstname , email FROM user

WHERE account_id = "'.$ghes.'"'; }
$result1 = $conn->query($sql); } else {
// echo "0 result";
// $check_if_exsiting = 0;
if ($result1->num_rows > 0) { }
// output data of each row
while($row = $result1->fetch_assoc()) {
if(isset($_GET['resched'])){
$sql22 = "SELECT * FROM
payment_instruction"; if($check_if_exsiting == "0"){
$result22 = $conn->query($sql22);
$origDate = $_GET['date3'];
$origDate2 = $_GET['date4'];
if ($result->num_rows > 0) {
// output data of each row $newDate = date("Y-m-d",
strtotime($origDate));
while($row22 = $result22->fetch_assoc()) { $newDate2 = date("Y-m-d",
strtotime($origDate2));
window.location.href = 'reschedule-
more.php?id=$id'; </script>";
$account_id = $_GET['account_id']; }
$reasonngmgatanga = $_GET['reason'];
$check_in = $_GET['check_in'];
$check_out = $_GET['check_out'];
$days_count = $_GET['days_count'];
$date = $_GET['date'];
$change_date = $newDate;
}else{
$startTimeStamp2 = strtotime("$newDate"); }
$endTimeStamp2 = strtotime("$newDate2"); }
$sql = "SELECT * FROM customer_reservation
$timeDiff2 = abs($endTimeStamp2 - WHERE reservation_id = '$ids' ";
$startTimeStamp2); $result = $conn->query($sql);
if ($result->num_rows > 0) {
$numberDays2 = $timeDiff2/86400; // 86400 while($row = $result->fetch_assoc()) {
seconds in one day
// and you might want to convert to integer $dates_check_in = $row['check_in'];

$numberDays2 = intval($numberDays2); $dates_check_out = $row['check_out'];
$dates_date = $row['date'];
$dates_account_id = $row['account_id'];
if($days_count == $numberDays2){
$sql = "INSERT INTO reschedule }

(account_id,reservation_id,check_in, check_out, } else {
date,reason) echo "0 results";
VALUES ('$account_id', '$id', }
'$newDate', '$newDate2', '$check_in', '$reason'
)"; if($dates_check_in == "8:00am" ){
if ($conn->query($sql) === TRUE) { $staus = "Day";

header('location: reschedule-
single.php'); }else{
} else { $staus = "Night";
echo "Error: " . $sql . "<br>" . $conn- }
>error;
}
?>
}else{
<?php
echo "<script> alert('Check in and Check
out it must match to the current date you choose,
Original Day is only $days_count day and you
choose $numberDays2 days');
$check_if_exsiting2 = "0"; <?php
$sql22 = "SELECT * FROM reschedule WHERE
reservation_id = '$ids' "; $startTimeStamp =
$result22 = $conn->query($sql22); strtotime("$dates_check_in");
if ($result22->num_rows > 0) { $endTimeStamp =
while($row22 = $result22->fetch_assoc()) { strtotime("$dates_check_out");
$timeDiff = abs($endTimeStamp -
$check_if_exsiting2 = "1"; $startTimeStamp);
$dates_check_in2 = $row22['check_in']; $numberDays = $timeDiff/86400; // 86400

$dates_check_out2 = $row22['check_out']; seconds in one day
$dates_date2 = $row22['date'];
} // and you might want to convert to integer
} else { $numberDays = intval($numberDays);
// echo "0 result"; echo $numberDays;
// $check_if_exsiting = 0;
} ?>
*Reschedule Single
<?php
include_once 'navbar.php';
if($check_if_exsiting2 == "0"){
include('backend/conn.php');
$id = $_GET['id'];
$ids = $_GET['id'];
?> $check_if_exsiting = "0";
<form method="GET" action="#" $sql2 = "SELECT * FROM reschedule WHERE
novalidate> reservation_id = '$ids' ";
<h4>Re-schedule Details</h4><br> $result2 = $conn->query($sql2);
<input type="hidden" name="id" if ($result2->num_rows > 0) {
value="<?php echo $_GET['id']; ?>" /> while($row2 = $result2->fetch_assoc()) {
<input type="hidden"
name="check_in" value="<?php echo
$dates_check_in; ?>" /> $check_if_exsiting = "1";
<input type="hidden"
name="check_out" value="<?php echo
$dates_check_out; ?>" /> }
<input type="hidden" name="date" } else {
value="<?php echo $dates_date; ?>" /> // echo "0 result";
<input type="hidden" // $check_if_exsiting = 0;
name="account_id" value="<?php echo }
$dates_account_id; ?>" />
<label>
<p><b>From : <?php echo
$dates_check_in; ?></b></p>
<p><b>To : <?php echo
$dates_check_out; ?></b></p>
<p><b>Days:
if(isset($_GET['resched'])){ $dates_date = $row['date'];
$dates_account_id = $row['account_id'];
if($check_if_exsiting == "0"){
$origDate = $_GET['date3'];
$newDate = date("Y-m-d", }
strtotime($origDate)); } else {
echo "0 results";
}
if($dates_check_in == "8:00am" ){
$account_id = $_GET['account_id']; $staus = "Day";

$reason = $_GET['reason'];
$check_in = $_GET['check_in']; }else{
$check_out = $_GET['check_out']; $staus = "Night";
$date = $_GET['date']; }
$change_date = $newDate;
?>
<?php
$sql = "INSERT INTO reschedule

(account_id,reservation_id,check_in, check_out,
date,reason)
VALUES ('$account_id', '$id', '$check_in',
'$check_out', '$change_date', '$reason' )"; $check_if_exsiting2 = "0";
$sql22 = "SELECT * FROM reschedule WHERE
if ($conn->query($sql) === TRUE) { reservation_id = '$ids' ";
header('location: reschedule-single.php'); $result22 = $conn->query($sql22);
} else { if ($result22->num_rows > 0) {
echo "Error: " . $sql . "<br>" . $conn- while($row22 = $result22->fetch_assoc()) {
>error;
}
$check_if_exsiting2 = "1";
}else{
$dates_check_in2 = $row22['check_in'];
} $dates_check_out2 = $row22['check_out'];
} $dates_date2 = $row22['date'];
$sql = "SELECT * FROM customer_reservation }
WHERE reservation_id = '$ids' "; } else {
$result = $conn->query($sql); // echo "0 result";
if ($result->num_rows > 0) { // $check_if_exsiting = 0;
while($row = $result->fetch_assoc()) { }
if($check_if_exsiting2 == "0"){
?>
$dates_check_in = $row['check_in'];
$dates_check_out = $row['check_out'];
APPENDIX E
(Endorsement Letter)
Appendix F
(Resource Persons)
Mr. Ricardo Pantoni
Owner of Strike RGP Resort
Ms. Lorie Ann Pangilinan
Cashier and Secretary at Strike RGP Resort

APPENDIX F
(Personal Vitae)
Aaron Paul C. Adriano
Ph 5 Blk 35 Lot 8 Parklane.
Country Homes San Francisco Cavite
Mobile No.: 0977462519
Email: [email protected]
Objectives
To obtain a position to your company that will enable to use my skills and ability
to work well with other people.
Skills
Computer Literate (MS Word, MS Excel, MS Access, MS Power Point, MS
Visual Basic, Adobe Photoshop, AutoCAD)
Personal Information
Nickname: Aeron
Age: 22
Gender: Male
Height: 5’2
Weight: 90 lbs.
Date of Birth: May 21, 1997
Place of Birth: Pasay
Civil Status: Single
Citizenship: Filipino
Religion: Roman Catholic
Dialects: Filipino, English
Mother’s Name: Catherine Carandang
Occupation: Housewife
Father’s Name: Jojo L Adriano
Occupation: Dicease
Educational Background
Tertiary Education
STI College Dasmarinas

Secondary Education Pasay City West High School

Primary Education Parklane Elementary School
Character Reference
Catherine Bagnol
09354984855
Cj Dimzon
09293494556
I hereby certify that the information above are all true and correct to the best of my
knowledge and beliefs.
Aaron Paul Adriano

Catherine S. Bagnol
Blk6 lot 244 Brgy. Sta Fe
Dasmariñas City, Cavite
Mobile No. 09354984855
Objectives
To obtain a position to your company that will enable to use my skills and ability to work
well with other people.
Nickname: CathCath
Age: 21
Gender: Female
Height: 5’1
Weight: 90 lbs.
Date of Birth: July 5, 1996
Place of Birth: Surigao, Del Sur
Mother’s Name: Ruth S. Bagnol
Father’s Name: Hobert G. Bagnol
Occupation: Taxi driver
Tertiary Education Far East Asia Pacific Institute of Tourism Science
And Technology
Information Technology
Mangubat Ave. Heritage Bldg. Dasmariñas City, Cavite
2012-2014
STI College
N. Guevarra St. Dasmariñas City, Cavite
2016 up to present
Secondary Education Dasmariñas East National High School
Brgy. San Simon Dasmariñas City, Cavite
2008-2012
Primary Education San Nicolas Elementary School

Brgy. San Nicolas Dasmariñas City, Cavite
2002-2008
Certificates and Seminar Attended

March 19, 2012 Computer Literacy Training Program
UNITECH Educational Program Corp.
University of Perpetual Help
Brgy. San Gabriel GMA Cavite
March 5, 2014 Hardware and Servicing NC II

Power Skills Training Center
Dasmariñas City Cavite
On Job Training
April 2013 to Sept. 2013 Universal Robina Corp. Cavite

600 hours
Maintenance Department
6th and 7th Sts. Corner Main Drive FCIE
Langkaan, Dasmariñas City, Cavie
EXPERIENCE
Feb. 13,2015 to Jan. 8, 2016 Ehs Lens Philippine

Lens Inspector
Javalera, Gen. Trias Cavite
Character References
Gerald Kiseo
09099435352
Catherine Guerrero
09090275730
Almera Balca
09368981810
I hereby certify that the information above are all true and correct to the best of my knowledge and
beliefs.
Catherine Sacil Bagnol

Christine B. Galez
Blk 22 L-Lot 12, Brgy.Emmanuel 1
Mobile No. 09099628016
Objectives
To solve problems in a creative and effective manner in a
challenging position.
Nickname: Chris
Age: 21
Gender: Female
Height: 5’4
Weight: 123 lbs.
Date of Birth: December 24,1997
Place of Birth: Pasig City
Mother’s Name: Rowena Galez
Occupation: OFW
Father’s Name: Arnold Laplana
Occupation: Deceased
Tertiary Education STI College
N. Guevarra St. Dasmariñas City, Cavite
2016 up to present
Secondary Education Dasmariñas West National High School

San Antonio de Padua 1,
2011-2014
Primary Education Dasmariñas II Elementary School

Congressional Avenue North,
2006-2011
Certificates
March 28, 2014 Most Trustworthy
Dasmariñas West National High School
San Antonio de Padua 1,
EXPERIENCE
Jan 2015 – present ProdCue Production

Production Staff / Photgrapher
` Las piñas City
Character References
Paulo G.Cabañero
0947 245 4647
Rowena Miranda
0950 100 9080
I hereby certify that the information above are all true and correct to the best of my knowledge and
beliefs.
Christine B . Galez
Alfred E. Pantoja
#34 Acacia Street. Wood Estate Village
San Jose Dasmarinas City Cavite.
Mobile No.: 09486929397
Objectives
To make a real contribution to the day-today operations of any business. Possesses
many transferable skills that can be used in a wide section of settings and industries.
Looking for a suitable intern position with an organization that can offer a uniquely
varied and fascinating working environment.
Skills
MS Office & other
specialist office software
Adobe Photoshop
Basic Desktop/ Laptop Troubleshooting
Computer Languages
Nickname: Fred
Age: 20
Gender: Male
Height: 5’11
Weight: 176.37 lbs.
Date of Birth: January 23, 1999
Place of Birth: Guinobatan Albay
Mother’s Name: Fe E. Pantoja
Father’s Name: Aladin P. Pantoja
Occupation: Technician
Tertiary Education
STI College Dasmarinas

Secondary Education: Oxford Louise Academy Inc.
Primary Education: Oxford Louise Academy Inc.

Character Reference
Dreena Mae L. Cruz
I hereby certify that the information above are all true and correct to the best of my
knowledge and beliefs.
Alfred E. Pantoja

Final Documentation

Uploaded by

Copyright:

Available Formats

Final Documentation

Uploaded by

Document Information

Original Description:

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

Final Documentation

Uploaded by

Copyright:

Available Formats

Website for Strike RGP Resort with Online Inquiry and Reservation System

the Faculty of STI College Dasmariñas

Adriano, Aaron Paul

Annielyn Gerodias, MIT

This Project entitled

Submitted in partial fulfillment of the requirements of the Bachelor of Science in Information

Annielyn Gerodias, MIT

This Project entitled

After having been recommended and approved is hereby accepted

by the Information Technology Department

of STI College Dasmariñas

Felecisimo M. Buensuceso Jr., MIT

Anna Lissa I. Abello, MIT

This Project entitled

Adriano, Aaron Paul

Anna Lissa I. Abello, MIT Felecisimo M. Buensuceso Jr., MIT

Dr. Brandon G. Sibbaluca

Title Page ........................................................................................................................................ i

Adviser’s Recommendation Sheet ............................................................................................... ii

Project Coordinator and Dean’s Acceptance Sheet .................................................................. iii

Panel’s Approval Sheet ............................................................................................................... iv

Table of Contents ……………………………………………………………………………….v

Preface .......................................................................................................................................... vii

1.1 Statement of the Problem ........................................................................................... 1-2

1.1.1 General Problem ......................................................................................... 1-2

1.1.2 Specific Problem ......................................................................................... 1-2

1.2 Current State of Technology ...................................................................................... 1-4

1.3 Objectives .................................................................................................................. 1-5

1.3.1 General Objectives ...................................................................................... 1-5

1.3.2 Specific Objectives ..................................................................................... 1-5

1.3.2 Scopes and Limitations ............................................................................... 1-7

2.2 Information Technology Theories

2.2.1 Methodology …………………………………………………………… 2

2.2.2 Database Management System ………………………………………… 2-5

2.2.4 Hypertext Markup Language(HTML).....………………………………....2-6

2.2.5 Cascading Style Sheet(CSS)………………………………………………2-6

2.2.6 Hypertext Processor(PHP)...………………………………………………2-7

2.3 Multimedia Devices Theory

2.3.1 Adobe Photoshop CS6………...………………………………………….2-8

2.3.2 Adobe Flash ……..……………………………………………………….2-8

2.4 Hosting Theory……………………………………………………………………2-9

2.5 Non-Information Technology Theories

3.2 System Design Specification

3.2.1 Data Flow Diagram (Diagram 0)…………………………………………………3-1

3.2.2 Context Diagram………………………………………………………………….3-3

3.2.3 Hierarchical Diagram Input Process Output Chart (Front-End)…………..3-4

3.2.4 Hierarchical Diagram Input Process Output (Back-End)…………………3-5

3.3 Summary ................................................................................................................................ 3-6

Chapter 4: PERFORMANCE ANALYSIS

`4.3 Results and Analysis……..………………………………………………………………...4-2

4.3.3 Aesthetic ................................................................................................................ 4-3

3.2 System Design Specification

Figure 2.1 Prototype Model …………………………………………………………… 2

Figure 3.1 Data Flow Diagram (Diagram 0)……………………………………………3-1

Figure 3.2 Entity Relationship Diagram (ERD) ..............................................................3-2

Figure3.3 Context Diagram ..............................................................................................3-3

Figure 3.5 Hierarchical Diagram Input Process Output (Back-End) ..............................3-5

Table 1 Functionality Rating 4-2

Table 2 Content Rating 4-2