Call Us011-4166-8088, 90155-96280, 9313565406

Send Sms'PROJHELP' to 93135-65406

Mail Usinfo@projecthelpline.in

 SIKKIM MANIPAL UNIVERSITY  PROJECT REPORT AT projecthelpline.in

 

 Project Report

On

QUICKSERVICES.COM

UNDER SUPERVISION OF

SUBMITTED BY

NAME : …………………………

ROLLNO.  NO. : ___________

Submitted in partial fulfillment of the requirements for qualifying

Master of Computer Application

MCA

December, 2016

QuickServices.com

Under Supervision of           :                            

              Submitted By:

                 Name                            :           ……………………

                Course                             :           MCA

                   Roll No.                          :  

BONAFIDE CERTIFICATE

Certified that this project report titled “QuickServices.comis the bonafide work of “………………………..………. < NAME OF THE CANDIDATE with REG.NO>.…………” who carried out the project work under my supervision.

SIGNATURE

 

 

ABSTRACT

The Internet is here to stay, and many businesses have made their first leap to the Internet with a web site, and many are now moving forwards using the Internet, not only as an advertising and promotion platform, but as an active business platform. QuickServices.com is fast becoming the latest rage in the services world, and if anybody wants to home repair service like plumber, carpenter. Big companies that can deliver are now accepting booking online through their web sites and even serviceman are getting work in on this method.  It can allow customers to select virtually anything service, from the type of home repair services and maintenance. Aims of QuickServices.com to bring professionalism, good service and trust to the home repair service and maintenance business. This project provides customers with home repair service experience that delights them and become their best-handy-friend. Spread Services constantly provides experienced servicemen that suit required work of their consumers This web project is useful for customers to get quick servicemen in less time to manage their home, customers information, production data and more.

Faster way to book services- It’s a common thing that new customers will visit the website for directions, a phone number to check the menu or for other information. When they show up on the site and see the “Book Now” button.

 

DECLARATION

I hereby declare that this project work titled “QuickServices.com” is my original work and no part of it has been submitted for any other degree purpose or published in any other from till date.

 

 

 

 

TABLE OF CONTENTS

 

 

CONTENTS                                                                           Page No.

 

 
 
1.       INTRODUCTION
1.1.    Overview of the System                                                                                                                                           
1.2.    Objectives and Organization of the report                                                                                          
1.3.   Project Category                                                                                           
 
2.     REQUIREMENT SPECIFICATION
      2.1   Software & Hardware Requirements                                                         
      2.2   Data Flow Diagram                                                                                     

      2.3  CONTEXT LEVEL DFD  Diagrams                                                           

      2.4  E-R Diagram                                                                                                  

 
3.  SYSTEM DESIGN
 
       3.1  Data Modeling                                                                                                
       3.2   Modules                                                                                                          30
       3.3   Scheduling                                                                                                              
4. IMPLEMENTATION                                                                                             

5. RESULTS                                                                                                    

       5.1 Source Code                                                                                                     

 6.  Limitations and future application of the project                                    
 
 7.  Conclusion                                                                                                              
 8.  Bibliography                                                                                                           

 

CHAPTER 1 INTRODUCTION

1.1 OVERVIEW OF THE SYSTEM

 

 

 

1.2 OBJECTIVES AND ORGANIZATION OF THE REPORT

 

QuickServices.com  objectives includes:

 

  1. Faster way to book services

 

  1. Share the news-

 

  1. Free email marketing

 

  1. Online bookings can often be bigger

 

  1. Cost-cutting method

 

  1. Know Delivery Time

 

  1. Reduce Paper Work

 

  1. Improves Efficiency

These are just some of the benefits of booking service online

 

TECHNICAL OBJECTIVES

 

Sales [Product sales, and delivery charges]

 

Purchase [Purchase of raw material]

 

UOM [Unit of measurement of goods]

 

Vouchers [Sale, Purchase, Payment, Receipt, Voucher]

 

Inventory  [Inventory management system]

 

Payroll [Employee management system, regarding to their salary, overtime, attendance, and other data maintenance]

Search Bill [Searching process within bill (payment and receipt bill)]

 

Easy to use [Friendliness environment]

 

Secure and server database [SQL database using as server database PHP front end and Oracle as  Backend]

 

Delivery [Stored all information related to about delivery]

 

1.3 PROJECT CATEGORY

 

 

ADVANTAGES

I have designed the given proposed system in the PHP & MY SQL to QUICKSERVICES.COM.

The following steps that give the detailed information of the need of proposed system are:

Performance:

During past several decades, the records are supposed to be manually handled for all activities. The manual handling of the record is time consuming and highly prone to error. To improve the performance of the Company   system, the computerized system is to be undertaken. The computerized project is fully computerized and user friendly even that any of the members can see the report and status of the company.

Efficiency:

The basic need of this project is efficiency. The project should be efficient so that whenever a new user submit his/her details the project is updated automatically. This record will be useful for other users instantly.

Control:

The complete control of the project is under the hands of authorized person who has the password to access this project and illegal access is not supposed to deal with. All the control is under the administrator and the other members have the rights to just see the records not to change any transaction or entry.

Security:

Security is the main criteria for the proposed system. Since illegal access may corrupt the database. So security has to be given in this project.

Business Intelligence

Gain deeper insight into your business with integrated, comprehensive analysis and reporting for enhanced decision making.

High Availability

Ensure business continuity with the highest levels of system availability through technologies that protect your data against costly human errors and minimize disaster recovery downtime.

Performance and Scalability

Deliver an infrastructure that can grow with your business and has a proven record in handling today’s large amounts of data and most critical enterprise workloads.

Security

Provide a secure environment to address privacy and compliance requirements with built-in features that protect your data against unauthorized access.

Manageability

Manage your infrastructure with automated diagnostics, tuning, and configuration to reduce operational costs while reducing maintenance and easily managing very large amounts of data.

Developer Productivity

Build and deploy critical business-ready applications more quickly by improving developer productivity and reducing project life cycle times.

 

 

DRAWBACKS OF CURRENT MANUAL- SYSTEM

  • The current manual system has a lot of paper work and it does not deal with old exact Details.
  • To maintain the records of candidates and companies manually, is a Time-consuming job.
  • With the increase in database, it will become a massive job to maintain the database.
  • Requires large quantities of file cabinets, which are huge and require quite a bit of space in the office which can be used for storing records of previous claims.
  • Lack of security for the records, anyone disarrange the records of your system.

 

THE NEED OF NEW SYSTEM

  1. Problem of Reliability:
  1. Problem of Accuracy:
  1. Problem of timeliness:
  1. Problem of Validity:
  1. Problem of Economy:
  1. Problem of Capacity:

CHAPTER 2 REQUIREMENT SPECIFICATION

 

2.1 SOFTWARE & HARDWARE REQUIREMENTS

 

 

HARDWARE:

Processor                     :           Pentium 2.4 GHz or above

Memory                       :           256 MB RAM or above

Cache Memory            :           128 KB or above

Printer                         :           Laser Printer

Pen Drive                    :           5 GB

 

SOFTWARE:

Operating System       :       Windows XP (Professional), WAMP Server.

Font-End Too l           :        PHP, Java Script

Back-End                    :       My SQL (phpmyadmin)

 

PHP

PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. PHP, or PHP: Hypertext Preprocessor, is a widely used, general-purpose scripting language that was originally designed for web development, to produce dynamic web pages. It can be embedded into HTML and generally runs on a web server, which needs to be configured to process PHP code and create web page content from it. It can be deployed on most web servers and on almost every operating system and platform free of charge. PHP is installed on over 20 million websites and 1 million web servers. PHP has evolved to include a command line interface capability and can also be used in standalone graphical applications.

INTRODUCTION TO PHP

“Client-Server approach with XML / PHP, MY SQL”

The need of today’s software development is competence in a GUI based front-end tool, which can connect to Relational Database engines. This gives the programmer the opportunity to develop client server based commercial applications.

 

FRONT END

PHP, MY SQL programming tools are complete programming environments. It allows programmers to build a GUI program using the various on-screen controls such as buttons, text, menus, boxes etc. These controls are placed on a form and then the processing details related with each control are filled in.

 

In the business world, competitive strategies have become the Booking of the day to improve quality, cut costs and provide a high response customer service base. Most organizations today need to be market driven and do a lot of value addition to their products and services. This naturally calls for rational decision making, which requires information. Information Technology or IT provides that effective channel to support and implement this strategy. Client/Server is the technology that empowers the desktop, thus setting a trend for the way successful organizations will use technology in the next decade.

 INTRODUCTION TO PHP, MY SQL

 

INTRODUCTION OF PHP

DATA TYPE

TEXT TYPES

CHAR( ) A fixed section from 0 to 255 characters long.
VARCHAR( ) A variable section from 0 to 255 characters long.
TINYTEXT A string with a maximum length of 255 characters.
TEXT A string with a maximum length of 65535 characters.
BLOB A string with a maximum length of 65535 characters.
MEDIUMTEXT A string with a maximum length of 16777215 characters.
MEDIUMBLOB A string with a maximum length of 16777215 characters.
LONGTEXT A string with a maximum length of 4294967295 characters.
LONGBLOB A string with a maximum length of 4294967295 characters.

NUMBER TYPES

TINYINT( ) -128 to 127 normal
0 to 255 UNSIGNED.
SMALLINT( ) -32768 to 32767 normal
0 to 65535 UNSIGNED.
MEDIUMINT( ) -8388608 to 8388607 normal
0 to 16777215 UNSIGNED.
INT( ) -2147483648 to 2147483647 normal
0 to 4294967295 UNSIGNED.
BIGINT( ) -9223372036854775808 to 9223372036854775807 normal
0 to 18446744073709551615 UNSIGNED.
FLOAT A small number with a floating decimal point.
DOUBLE( , ) A large number with a floating decimal point.
DECIMAL( , ) A DOUBLE stored as a string , allowing for a fixed decimal point.

The integer types have an extra option called UNSIGNED. Normally, the integer goes from an negative to positive value. Using an UNSIGNED command will move that range up so it starts at zero instead of a negative number.

DATE TYPES

DATE YYYY-MM-DD.
DATETIME YYYY-MM-DD HH:MM:SS.
TIMESTAMP YYYYMMDDHHMMSS.
TIME HH:MM:SS.

MISC TYPES

ENUM ( ) Short for ENUMERATION which means that each column may have one of a specified possible values.
SET Similar to ENUM except each column may have more than one of the specified possible values.

 

ENVIRONMENT / OPERATING SYSTEM

 

 

2.2 DATA FLOW DIAGRAM

 

 

DFDs are constructed using four major components:

  • External entities

for example – passenger is the usual receiver of information and supplier of data during form filling.

  • Data stores
  • Processes

 

Process names are generally unambiguous and convey as much meaning as possible without being too long. Example: verify data, acquired time schedule etc.

Data flows – represents the movement of data between other components.

Data flow diagrams are used to describe how the system transforms information.  They define how information is processed and stored and identify how the information flows through the processes.

  1. Bubbles: –

A circle or bubble represents that transform data from once form to another by performing some tasks with the data.

  1. Data store:-

A data store is place where data is held temporarily from one transaction to next or is stored permanently.

  • External Entity:-

 

 

2.3 DATA FLOW DIAGRAMS

CONTEXT LEVEL DFD FOR

 QUICKSERVICES.COM

 

 

 

Ist Level DFD for QUICKSERVICES.COM

 

 

 

 

II nd LEVEL DFD FOR ADMIN

 

 

 

 

III nd LEVEL DFD FOR THE CUSTOMER

 

 

2.4 ER-DIAGRAM

 


CHAPTER 3 SYSTEM DESIGN

 

 

3.1 DATA TABLE

 

Admin Table-1

 

Field Name Type Constraint
Admin_ID Int(11) Primary Key
Name Varchar (100) Not Null
Email Varchar (100) Not Null
Password Varchar (100) Not Null
Mobile Varchar (100) Not Null
Role Varchar (100) Not Null
Status Varchar (100) Not Null

 

Assign Table-2

Field Name Type Constraint
ID Int(11) Primary Key
Bid Varchar (100) Not Null
empid Varchar (100) Not Null
eName Varchar (100) Not Null
uid Varchar (100) Not Null


Booking Table-3

Field Name Type Constraint
ID Int(11) Primary Key
Fname Varchar (100) Not Null
Iname Varchar (100) Not Null
Email Varchar (100) Not Null
Phone Varchar (100) Not Null
Address Varchar (100) Not Null
Sid Varchar (100) Not Null
Sname Varchar (100) Not Null
Sevid Varchar (100) Not Null
servName Varchar (100) Not Null
Area Varchar (100) Not Null
Time Varchar (100) Not Null
Date Varchar (100) Not Null
Price Varchar (100) Not Null
Uid Varchar (100) Not Null
Status Varchar (100) Not Null


Category Table-4

Field Name Type Constraint
ID Int(11) Primary Key
Cname Varchar (200) Not Null
Desc Text Not Null
Img Varchar (200) Not Null
Path Varchar (200) Not Null

 

Customer Table-5

Field Name Type Constraint
ID Int(11) Primary Key
Fname Varchar (20) Not Null
iname Varchar (20) Not Null
Email Varchar (20) Not Null
Pass Varchar (20) Not Null
Cpass Varchar (20) Not Null
Phn Varchar (20) Not Null
Address Varchar (300) Not Null
City Varchar (20) Not Null
State Varchar (20) Not Null
Country Varchar (20) Not Null
Pin Varchar (20) Not Null


Employee Table-6

Field Name Type Constraint
ID Int(11) Primary Key
name Varchar (20) Not Null
Phn Varchar (20) Not Null
Email Varchar (100) Not Null
Address Varchar (20) Not Null
Area Varchar (20) Not Null
Exp Varchar (300) Not Null
Age Varchar (100) Not Null
Cat Varchar (100) Not Null
Cid Varchar (100) Not Null
Imag Varchar (500) Not Null
path Varchar (200) Not Null
desc Varchar (1000) Not Null
charges Varchar (100) Not Null

Feedback Table-7

Field Name Type Constraint
Name Varchar (20) Not Null
Email Varchar (20) Not Null
Comments Varchar (20) Not Null

 

Service Table-8

Field Name Type Constraint
Id Int(11) Primary Key
cid Varchar (100) Not Null
Cname Varchar (100) Not Null
Sid Varchar (100) Not Null
Sname Varchar (100) Not Null
servName Text Not Null
Rate Varchar (100) Not Null

 

Subcategory Table-9

Field Name Type Constraint
Id Int(11) Primary Key
cid Varchar (200) Not Null
Name Varchar (500) Not Null

 

3.2 MODULES

 

Number of modules and their description to provide an estimation of the student’s effort on the project.

Login/Sign Up

When a customer visits the QuickServices.com system of any service, he will be asked to login or sign up with them for better experience. The customer has to create a unique username and a password.Then he /she need to enter details like Name, phone number, address. After these steps account of that customer will be created.

Menu
The system will provide customers a menu in which all the category and services will be shown with their service charges. The service in the menu are created by the professional and well experienced.
The service charges in this catgeory can be changed according to the customer’s selected  service. The customer can select any category from the booking page or check ratecard  of every category and services.Each category will be shown with their description and price.

Booking

The first use case is booking. To book, a potential customer must first know what he can choose from (“What’s on the category?”). For booking serviceman a customer

will have to know the category he can choose from and how choosing services will influence the total charges. Customers pick category for their house maintenance. When a customer is choosing his service, he may want to check several services of the same configuration. A customer may also want to book can check all service charges in ratecard menu. Also the customer will have to provide his name, address and telephone number. A customer can also pick another delivery date and time if they wish for the booking to be completed on a later date and time. Customers can book up to two weeks in advance.

Booking Processing

When a booking has been confirmed by a customer booking processing begins.

Throughout the booking processing the booking status will be updated and the customer will be notified. New booking will show up in a list for the employees in the administrator panel. They need to state which services are booked and which area are chosen for the custom booking. The administrator has to look at the booking and decide if they can delivered their service on same area or not. When the decision is made, the booking status will change and the customer will be notified. After assigning the booking service to serviceman who is employee of Spread, the booking status will be updated by administrator and the delivery employees will take over. They will look up the name and address, and reach the booking area. The customer will also be notified when the booking is confirmed and assigned to be serviceman. When service work has been completed or canceled, the booking status will be changed once more. 

 

Administration

 

Security

Data have to very secure and reliable in every manner, must have covered with user id and password, which are only allowed to staff, every staff have their unique id with password.

Assign Booking

When customer will book the service, a list of booking can be seen by administrator. Now administrator will assign the booking work to employees according to customer’s requirements.

 

Track your Booking

This is another interesting feature which helps customers to keep a track of his booking. The customer is notified at every step of their booking process completion. After making payment the customer is shown the time by which his Booking will be delivered to his doorstep

 

3.3 SCHEDULING

 

 

CHAPTER 4 IMPLEMENTATION

COST ESTIMATION OF THE PROJECT

Cost in a project is due to the requirements for software, hardware, and human resources. Hardware resources are computer time, terminal time and memory required for the project. Software resources include the tools and compilers needed during development. The bulk of cost of software development is due to human resources needed. Cost estimates are determined in terms of person-months (PM).

 

Total No. Of Persons Involved In This Project:

  1. Administrator
  1. Senior Programmer
  1. Junior Programmers
  1. On line Users.

 

Since this Project will complete in 4 months

COST ESTIMATE: (Salary of Project Manager + Salary of Senior Programmer + 2 * Salary of  Junior Programmer) * 2

GANTT & PERT CHART

Gant Chart

A Gantt chart is a graphical representation of the duration of tasks against the progression of time. A Gantt chart is a useful tool for planning and scheduling projects

Gantt chart is a project scheduling technique. Progress can be represented easily in a Gantt chart, by coloring each milestone when completed. The project will start in the month of October and end after 4 months at the end of January

 

 

Steps in the PERT Planning Process

PERT planning involves the following steps:

  1. Identify the specific activities and milestones.
  2. Determine the proper sequence of the activities.
  3. Construct a network diagram.
  4. Estimate the time required for each activity.
  5. Determine the critical path.
  6. Update the PERT chart as the project progresses.

 

PERT charts are a more sophisticated form of activity chart. In activity diagrams only the estimated task durations are represented. Since the actual durations might vary from the estimated durations, the utility of the activity diagrams is limited.


 

CHAPTER 5 RESULTS

5.1 SOURCE CODE

Index.php

<?php

session_start();

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

 

</head>

<body>

 

 

<?php include(“header.php”); ?>

<div style=”width:1200px”>

 

 

<?php

include(‘config.php’);

$result=mysql_query(“SELECT * FROM category”);

 

while($row=mysql_fetch_array($result))

{

if($row[‘path’]==””)

{

$pa=”images/tool.png”;

}

else

{

$pa=$row[‘path’];

 

}

?>

<div class=”rounded”><table>

<tr>

<td align=”center”><span style=”color:#FFCC00; font-size:22px”><?php echo $row[‘cname’];?></span></td>

<td><img src=”<?php echo $pa;?>” height=”50px” width=”50px” style=””></td>

</tr>

 

<tr>

<td colspan=”2″>

<p class=”myp”><?php echo $row[‘desc’];?> </p>

</td>

</tr>

<tr>

 

<td colspan=”2″ id=”cl”>

 

<h4 class=”myh4″>

 

<?php if(isset($_SESSION[‘login_name’]))

{

?>

<a href=”book.php?id=<?php echo $row[‘id’];?>” style=”text-decoration:none;”>Book Now</a>

<?php

} else

{

?>

<a href=”cust_log.php?error=Please Login First to Book Your Service !!” style=”text-decoration:none;”>Book Now</a>

<?php

 

} ?>

 

</h4>

 

</td>

</tr>

</table>

</div>

 

<?php

}

?>

 

 

 

 

 

 

 

 

 

 

 

</div>

 

 

<div style=”width:1240px; margin-top:280px; border:#999999 2px solid; margin-left:5px;background-color:#D6D6D6″>

 

<p>

 

<center><h3>Why Choose Us </h3></center>

 

<table align=”center”>

<tr>

<td align=”center”>

<table width=”300px” border=”0″ style=”padding:10px”>

<tr>

<td align=”center”><img src=”images/b1.png” width=”53″ height=”53″></td>

</tr>

<tr>

<td align=”center”>

<p style=”padding-left:10px”><h4>Verfied Serviceman</h4>

QuickService.com  are trained professionals, whose background details are thoroughly checked to ensure your safety and security.</p>

 

 

</td>

</tr>

</table>

 

</td>

 

<td width=”100px”></td>

 

<td align=”center”>

<table width=”300px” border=”0″ style=”padding:10px”>

<tr>

<td align=”center”><img src=”images/b2.png” width=”53″ height=”53″></td>

</tr>

<tr>

<td align=”center”>

<p style=”padding-left:10px”><h4>Faithful & Apparent</h4>

QuickService.com are continuously focused on providing crystal clear services to its customers and ensure customer satisfaction as a guarantee.</p>

 

 

</td>

</tr>

</table>

 

</td>

 

<td width=”100px”></td>

 

<td align=”center”><table width=”300px” border=”0″ style=”padding:10px”>

<tr>

<td align=”center”><img src=”images/b3.png” width=”53″ height=”53″></td>

</tr>

<tr>

<td align=”center”>

<p style=”padding-left:10px”><h4>Service On Time</h4>

Time is very precious and we guarantee of timely services to our customers.QuickService.com always give services on time.</p>

 

 

</td>

</tr>

</table></td>

 

 

</tr>

</table>

 

</p>

 

 

 

 

 

 

 

</div>

 

 

 

<?php include(“footer.php”); ?>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

 

 

</body>

</html>

 

AboutUs.php

 

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

 

</head>

<body>

 

 

<?php include(“header.php”); ?>

<div style=”width:1200px”>

 

</div>

 

<br>

<div style=”width:1240px;  border:#999999 2px solid; margin-left:5px;background-color:#D6D6D6″>

 

<p>

 

<center><h3>About Us </h3></center>

 

<table align=”center”>

<tr>

<td align=”center”>

 

<p style=”padding-left:10px”><h4>Verfied Serviceman</h4>

QuickService.com  are trained professionals, whose background details are thoroughly checked to ensure your safety and security.

QuickService.com is our commitment to bring professionalism, good service and trust to the home repair service and maintenance business. We take immense pride in sending some of the most professional handymen to your homes to fix things that aren’t working.

We have fixed over 5,50,000 houses in our little over 5 years of existence so far.</p>

 

<p style=”padding-left:10px”><h4>Faithful & Apparent</h4>

QuickService.com are continuously focused on providing crystal clear services to its customers and ensure customer satisfaction as a guarantee.Time is very precious and we guarantee of timely services to our customers.QuickService.com always give services on time.</p>

 

</td>

 

</tr>

</table>

 

</p>

 

 

 

</div>

 

<?php include(“footer.php”); ?>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

 

 

</body>

</html>

Contactus.php

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

 

</head>

<body>

 

 

<?php include(“header.php”); ?>

<div style=”width:1200px”></div>

 

<br>

<div style=”width:1240px;  border:#999999 2px solid; margin-left:5px;background-color:#D6D6D6″>

 

<p>

 

<center><h3>Contact Us </h3></center>

<table align=”center”>

<tr>

<td align=”center”>

 

<p style=”padding-left:10px”><h4>Office Address</h4>

 

 

Address: – A-389, Services Builiding, Lodhi Road, Delhi<br>

 

Phone: 9876543121<br>

Email: info@gmail.com

</p>

 

</td>

 

</tr>

</table>

 

</p>

</div>

 

<?php include(“footer.php”); ?>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

 

</body>

</html>

Feed_details.php

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

 

</head>

<body>

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

 

<div class=”adminleft”>

<?php include(‘custLeft.php’); ?>

</div>

 

<div class=”adminright”>

 

<h2 style=” margin-left:90px; margin-right:10px;color:#942423″>Give Your Feedback </h2>

<form action=”feed_action.php” method=”post”>

<table  border=”0″ bordercolor=”black” bgcolor=”#666666″ width=”300″ height=”150″  style=”margin-left:100px; border:#660000 2px solid; padding:10px; color:white”>

<tr>

<td><b>Name</b></td><td><input type=”text” name=”name” placeholder=”Enter Name”/></td>

</tr>

<tr>

<td><b>Email</b></td><td><input type=”text” name=”em” placeholder=”Enter Email” /></td>

</tr>

<tr>

<td><b>Comments</b></td>

<td><textarea name=”com” cols=”” rows=””>&nbsp;</textarea></td>

</tr>

 

<tr>

<td></td><td><input type=”submit” class=”button” value=”Submit”  style=”background-color:#DBB41A; color:#000000; border:#000000; height:30px; border:#660000 1px solid”/></td>

</tr>

</table>

<br>

<span style=”margin-left:100px; padding-top:20px; color:#A71303; font-weight:bold”>

<?php

if(isset($_GET[‘err’]))

{

echo $_GET[‘err’];

}

?>

</span>

</form>

 

</div>

 

</div>

 

<br>

 

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

</body>

</html>

 

 

register.php

 

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

 

</head>

<body>

 

 

<?php include(“header.php”); ?>

<div style=”width:1200px”>

<center>

 

<h2 style=” margin-left:90px; margin-right:10px;color:#942423″>Register Here</h2>

 

 

 

<form action=”register_action.php” method=”post”>

<table  border=”0″ bordercolor=”black” bgcolor=”#666666″ width=”300″ height=”150″  style=”margin-left:100px; border:#660000 2px solid; padding:10px; color:white”>

<tr>

<td><b>Name</b></td>

</tr>

<tr>

<td><input type=”text” name=”fn” placeholder=”Enter First name”/></td>

<td><input type=”text” name=”na” placeholder=”Enter Last name”/></td>

</tr>

<tr>

<tr>

<td><b>Email</b></td>

</tr>

<tr>

<td colspan=”2″><input type=”text” name=”em” placeholder=”Enter email” /style=”width:100%”></td>

</tr>

<tr>

<td><b>Password</b></td>

</tr>

<tr>

<td><input type=”password” name=”ps” placeholder=”Enter password” /></td>

<td><input type=”password” name=”ps” placeholder=”Confirm password” /></td>

</tr>

<tr>

<td><b>Phone number</b></td>

</tr>

<tr>

<td colspan=”2″><input type=”text” name=”ph” placeholder=”Enter Phone no” /style=”width:100%”></td>

</tr>

<tr>

<td><b>Address</b></td>

</tr>

<tr>

<td colspan=”2″><input type=”text” name=”add” placeholder=”Enter street address” /style=”width:100%”></td>

</tr>

<tr>

<td><input type=”text” name=”add” placeholder=”Enter city”/></td>

<td><input type=”text” name=”add” placeholder=”Enter state”/></td>

</tr>

<tr>

<td><select name=”country”>

<option value=”Select”>Select</option>

<option value=”Afghanistan”>Afghanistan</option>

<option value=”Albania”>Albania</option>

 

<option value=”Yemen”>Yemen</option>

<option value=”Zambia”>Zambia</option>

<option value=”Zimbabwe”>Zimbabwe</option>

</select></td>

<td><input type=”text” name=”pin” placeholder=”Enter pin code”/></td>

 

</tr>

<tr>

<td colspan=”2″ align=”center”><input type=”submit” class=”button”  value=”Register” style=”background-color:#DBB41A; color:#000000; border:#000000″/></td>

</tr>

</table>

<br>

<span style=”margin-left:100px; padding-top:20px; color:#A71303; font-weight:bold”>

<?php

if(isset($_GET[‘err’]))

{

echo $_GET[‘err’];

}

?>

</span>

</form>

</center>

 

</div>

 

<br>

 

<?php include(“footer.php”); ?>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

</body>

</html>

 


 

cust_log.php

 

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

 

</head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px”>

 

<center>

 

<h2 style=” margin-left:90px; margin-right:10px;color:#942423″>Customer Login</h2>

 

<form action=”cust_action.php” method=”post”>

<table  border=”0″ bordercolor=”black” bgcolor=”#666666″ width=”300″ height=”150″  style=”margin-left:100px; border:#660000 2px solid; padding:10px; color:white”>

<tr>

<td><b>Username</b></td><td><input name=”username” type=”text” id=”username” placeholder=”Enter Username”/></td>

</tr>

<tr>

<td><b>Password</b></td><td><input name=”password” type=”password” id=”password” placeholder=”Enter password” /></td>

</tr>

<tr>

<td></td><td><input type=”submit” class=”button” value=”Login”  style=”background-color:#DBB41A; color:#000000; border:#000000; height:30px; border:#660000 1px solid”/></td>

 

</tr>

</table>

<br>

<span style=”margin-left:100px; padding-top:20px; color:#A71303; font-weight:bold”>

<?php

if(isset($_GET[“error”]))

{

echo $_GET[“error”];

}

?>

</span>

</form>

</center>

 

</div>

 

<br>

 

<?php include(“footer.php”); ?>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

</body>

</html>

admin.php

 

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

 

</head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px”>

 

<center>

 

<h2 style=” margin-left:90px; margin-right:10px;color:#942423″>Admin Login</h2>

 

<form action=”adm_action.php” method=”post”>

<table  border=”0″ bordercolor=”black” bgcolor=”#666666″ width=”300″ height=”150″  style=”margin-left:100px; border:#660000 2px solid; padding:10px; color:white”>

<tr>

<td><b>Username</b></td><td><input type=”text” name=”usern” placeholder=”Enter Username”/></td>

</tr>

<tr>

<td><b>Password</b></td><td><input type=”password” name=”pass” placeholder=”Enter password” /></td>

</tr>

<tr>

<td></td><td><input type=”submit” class=”button”   value=”Login” style=”background-color:#DBB41A; color:#000000; border:#000000; height:30px; border:#660000 1px solid”/></td>

 

</tr>

</table>

<br>

<span style=”margin-left:100px; padding-top:20px; color:#A71303; font-weight:bold”>

<?php

if(isset($_GET[‘err’]))

{

echo $_GET[‘err’];

}

?>

</span>

</form>

</center>

 

</div>

 

<br>

<?php include(“footer.php”); ?>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

</body>

</html>

adm-welcome.php

 

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

 

</head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

 

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

<div class=”adminright”>

 

<h1 style=” margin-left:0px; margin-right:10px;color:#942423″>Welcome <?php

echo $_SESSION[‘admin_name’].”<br>”;

 

?></h1>

 

<p style=”text-align: justify; margin-left:0px; margin-right:70px”>In QuickService.com you are administrator.You can add category,subcategory, modify them upload images of categories.You have access of view booking and you can update customer booking service status.Including these facilities,you can check customer report and feedback report. </p>

 

</div>

 

</div>

 

<br>

 

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

</body>

</html>

add-category.php

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” /></head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

 

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

 

<div class=”adminright”>

 

<h2 style=” margin-left:90px; margin-right:10px;color:#942423″>Add Category</h2>

 

 

 

<form action=”cat_action.php” method=”post” enctype=”multipart/form-data”>

<table  border=”0″ bordercolor=”black” bgcolor=”#666666″ width=”500″ height=”150″  style=”margin-left:100px; border:#660000 2px solid; padding:10px; color:white”>

<tr>

<td><strong>Category Name </strong></td>

<td><input name=”cname” type=”text” id=”cname” placeholder=”Enter Username”/></td>

</tr>

<tr>

<td><strong>Category Description </strong></td>

<td>

 

<textarea name=”desc” id=”desc”></textarea>  </td>

</tr>

<tr>

<td><strong>Category Image Icon </strong></td>

<td><input type=”file” name=”img”></td>

</tr>

 

<tr>

<td></td><td><input type=”submit” class=”button”  style=”background-color:#DBB41A; color:#000000; border:#000000; height:30px; border:#660000 1px solid”/></td>

</tr>

</table>

<br>

<span style=”margin-left:100px; padding-top:20px; color:#A71303; font-weight:bold”>

<?php

if(isset($_GET[‘err’]))

{

echo $_GET[‘err’];

}

?>

</span>

</form>

 

</div>

 

</div>

<br>

 

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

 

 

</body>

</html>

 

cat_Details.php

 

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

 

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

 

<div class=”adminright”>

 

<h2 style=” margin-right:10px;color:#942423″> Category Report</h2>

 

<br>

<table class=”bordered” style=”font-size:16px;width: 80%; color:white;” bgcolor=”#666666″ align=”left”>

<thead>

 

<tr>

<th>#</th>

<th>Category Name</th>

<th>Description</th>

<th>Category Icon </th>

 

<th></th><th> </th>

 

</tr>

</thead>

<?php

 

$result=mysql_query(“SELECT * FROM category”);

 

while($row=mysql_fetch_array($result))

{

?>

<tr>

<td><?php echo $row[‘id’];?></td>

<td><?php echo $row[‘cname’];?> </td>

<td><?php echo $row[‘desc’];?> </td>

<td><img src=”<?php echo $row[‘path’];?>” width=”35″ height=”35″> </td>

 

<td><a href=”edit-cat.php?id=<?php echo $row[‘id’];?>” style=”color:orange”><b>Edit</b></a> </td>

 

<td><a href=”delete_cat.php?id=<?php echo $row[‘id’];?>” style=”color:orange”><strong>Delete</strong></a>  </td>

</tr>

<?php

}

?>

 

</table>

</div>

</div><br><!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–></body>

</html>

 

add-sub.php

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” /></head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

 

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

<div class=”adminright”>

<h2 style=” margin-left:90px; margin-right:10px;color:#942423″>Add Subcategory </h2>

<form action=”sub_action.php” method=”post” enctype=”multipart/form-data”>

<table  border=”0″ bordercolor=”black” bgcolor=”#666666″ width=”500″ height=”150″  style=”margin-left:100px; border:#660000 2px solid; padding:10px; color:white”>

 

<tr>

<td><strong>Select Service Category</strong></td>

<td>

<select name=”cat”>

<?php

 

$result=mysql_query(“SELECT * FROM category”);

while($row=mysql_fetch_array($result))

{

?>

<option value=”<?php echo $row[‘id’];?>”><?php echo $row[‘cname’];?></option>

<?php

}

?>

</select> </td>

</tr>

 

<tr>

<td><strong>Subcategory Name </strong></td>

<td><input name=”name” type=”text” id=”name” placeholder=”Enter Name”/></td>

</tr>

 

 

<tr>

<td></td><td><input type=”submit” class=”button” value=”Submit” style=”background-color:#DBB41A; color:#000000; border:#000000; height:30px; border:#660000 1px solid”/></td>

</tr>

</table>

<br>

<span style=”margin-left:100px; padding-top:20px; color:#A71303; font-weight:bold”>

<?php

if(isset($_GET[‘err’]))

{

echo $_GET[‘err’];

}

?>

</span>

</form>

</div>

 

</div>

 

<br>

 

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

</body>

</html>

 

sub_Details.php

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

 

<div class=”adminright” style=”width:900px”>

 

<h2 style=” margin-right:10px;color:#942423″> Subcategory Report</h2>

 

<br>

<table class=”bordered” style=”font-size:16px;width: 60%; color:white;” bgcolor=”#666666″ align=”left”>

<thead>

 

 

<tr>

<th>#</th>

<th> Category Id</th>

<th>Subcategory Name</th>

 

<th></th><th> </th>

 

</tr>

</thead>

<?php

 

$result=mysql_query(“SELECT * FROM subcategory”);

while($row=mysql_fetch_array($result))

{

?>

<tr>

<td><?php echo $row[‘id’];?></td>

<td><?php echo $row[‘cid’];?> </td>

<td><?php echo $row[‘name’];?> </td>

 

 

<td><a href=”edit-sub.php?id=<?php echo $row[‘id’];?>” style=”color:orange”><b>Edit</b></a> </td>

 

<td><a href=”delete_sub.php?id=<?php echo $row[‘id’];?>” style=”color:orange”><strong>Delete</strong></a>  </td>

</tr>

<?php

}

?>

</table>

</div>

 

</div>

 

<br>

 

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

</body>

</html>

add_serv.php

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

 

</head>

<body>

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

<div class=”adminright”>

<h2 style=” margin-left:90px; margin-right:10px;color:#942423″>Add Service </h2>

<form action=”serv_action.php” method=”post” enctype=”multipart/form-data”>

<table  border=”0″ bordercolor=”black” bgcolor=”#666666″ width=”500″ height=”150″  style=”margin-left:100px; border:#660000 2px solid; padding:10px; color:white”>

 

 

<tr>

<td><strong>Select Service Category</strong></td>

<td>

<select name=”cat” onChange=”getResult(this.value);”>

<option value=”Select Category”>Select Category</option>

<?php

 

$result=mysql_query(“SELECT * FROM category”);

while($row=mysql_fetch_array($result))

{

?>

<option value=”<?php echo $row[‘id’];?>-<?php echo $row[‘cname’];?>”><?php echo $row[‘cname’];?></option>

<?php

}

?>

</select> </td>

</tr>

<tr>

<td><strong>Select Service Subcategory</strong></td>

<td id=”sh”>

<select name=”subcat”>

<option>Select Subcategory</option>

 

</select> </td>

</tr>

<tr>

<td><strong>Service Name </strong></td>

<td><textarea name=”name”></textarea></td>

</tr>

 

<tr>

<td><strong>Price </strong></td>

<td><input name=”price” type=”text” id=”price” placeholder=”Enter Price”/></td>

</tr>

 

<tr>

<td></td><td><input type=”submit” class=”button” value=”Submit” style=”background-color:#DBB41A; color:#000000; border:#000000; height:30px; border:#660000 1px solid”/></td>

</tr>

</table>

<br>

<span style=”margin-left:100px; padding-top:20px; color:#A71303; font-weight:bold”>

<?php

if(isset($_GET[‘err’]))

{

echo $_GET[‘err’];

}

?>

</span>

</form>

</div>

 

</div>

 

<br>

 

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

 

 

</body>

</html>

<script type=”text/javascript” src=”js/jquery-1.11.0.min.js”></script>

 

<script type=”text/javascript”>

 

function getResult(str)

{

$.ajax({

type: “GET”,

url: “serv_result.php”,

data: “cid=” + str,

success: function(data)

{

$(“#sh”).html(data);

},

error: function()

{

$(“#sh”).html(‘loading Result..’);

}

});

}

</script>


 

serv_Details.php

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

 

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

 

 

 

<div class=”adminright” style=”width:820px”>

 

<h2 style=” margin-right:10px;color:#942423″> Service Report</h2>

 

<br>

<table class=”bordered” style=”font-size:16px; color:white;” bgcolor=”#666666″ align=”left” width=”600px”>

<thead>

 

 

<tr>

 

<th>Service Name</th>

<th>Category Name</th>

<th>Subcategory Name</th>

<th>Price</th>

 

<th></th><th> </th>

 

</tr>

</thead>

<?php

 

$result=mysql_query(“SELECT * FROM service”);

while($row=mysql_fetch_array($result))

{

?>

<tr>

 

<td><?php echo $row[‘servName’];?> </td>

<td><?php echo $row[‘cname’];?> </td>

 

<td><?php echo $row[‘sname’];?></td>

<td><?php echo $row[‘rate’];?> </td>

 

 

<td><a href=”edit-serv.php?id=<?php echo $row[‘id’];?>” style=”color:orange”><b>Edit</b></a> </td>

 

<td><a href=”delete_serv.php?id=<?php echo $row[‘id’];?>” style=”color:orange”><strong>Delete</strong></a>  </td>

</tr>

<?php

}

?>

 

</table>

</div></div>

<br>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

</body>

</html>

 

view_book_history.php

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

 

 

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

<div class=”adminright” style=”width:900px”>

<h2 style=” margin-right:10px;color:#942423″> Booking  Report</h2>

<br>

<table class=”bordered” style=”font-size:16px;width: 80%; color:white;” bgcolor=”#666666″ align=”left”>

<thead>

 

<tr>

<tr>

<th>Booking Id</th>

<th>Name</th>

<th>Email</th>

<th>Phone</th>

<th>Address</th>

<th>Subcategory</th>

<th>Service Name</th>

<th>Area</th>

<th>Time</th>

<th>Booking Date</th>

<th>Booking Price</th>

<th>Status</th>

 

</tr>

</thead>

<?php

 

$result=mysql_query(“SELECT * FROM booking”);

while($row=mysql_fetch_array($result))

{

?>

<tr>

<td><?php echo $row[‘id’];?></td>

<td><?php echo $row[‘fname’];?> <?php echo $row[‘lname’];?> </td>

 

<td><?php echo $row[’email’];?> </td>

<td><?php echo $row[‘phn’];?> </td>

<td><?php echo $row[‘address’];?> </td>

<td><?php echo $row[‘sname’];?> </td>

<td><?php echo $row[‘servName’];?> </td>

<td><?php echo $row[‘area’];?> </td>

<td><?php echo $row[‘time’];?> </td>

<td><?php echo $row[‘date’];?> </td>

<td><?php echo $row[‘price’];?> Rs.</td>

<td><?php echo $row[‘status’];?> </td>

 

 

</tr>

<?php

}

?>

 

</table>

</div>

 

</div>

 

<br>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

</body>

</html>

 

assignBooking.php

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” /></head>

<body>

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

<div class=”adminright”>

<h2 style=” margin-left:90px; margin-right:10px;color:#942423″>Add Category</h2>

<form action=”assign_action.php” method=”post” enctype=”multipart/form-data”>

<input type=”hidden” name=”bid” value=”<?php echo $_GET[“bid”]; ?>”>

<input type=”hidden” name=”uid” value=”<?php echo $_GET[“uid”]; ?>”>

 

<table  border=”0″ bordercolor=”black” bgcolor=”#666666″ width=”500″ height=”150″  style=”margin-left:100px; border:#660000 2px solid; padding:10px; color:white”>

 

<tr>

<td><strong>Select Employee</strong></td>

<td>

 

<select name=”emp”>

<option value=”Select Category”>Select Employee</option>

<?php

 

$result=mysql_query(“SELECT * FROM employee”);

while($row=mysql_fetch_array($result))

{

?>

<option value=”<?php echo $row[‘id’];?>-<?php echo $row[‘name’];?>”><?php echo $row[‘name’];?></option>

<?php

}

?>

</select>   </td>

</tr>

 

<tr>

<td></td><td><input type=”submit” class=”button”  style=”background-color:#DBB41A; color:#000000; border:#000000; height:30px; border:#660000 1px solid”/></td>

</tr>

</table>

<br>

<span style=”margin-left:100px; padding-top:20px; color:#A71303; font-weight:bold”>

<?php

if(isset($_GET[‘err’]))

{

echo $_GET[‘err’];

}

?>

</span>

</form>

</div>

</div>

 

<br>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

</body>

</html>


 

Update_Booking.php

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

 

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

 

<div class=”adminright” style=”width:900px”>

<h2 style=” margin-right:10px;color:#942423″> Booking  Report</h2>

 

 

<br>

<table class=”bordered” style=”font-size:16px;width: 80%; color:white;” bgcolor=”#666666″ align=”left”>

<thead>

<tr>

<tr>

<th>Booking Id</th>

<th>Name</th>

<th>Email</th>

<th>Phone</th>

<th>Address</th>

<th>Subcategory</th>

<th>Service Name</th>

<th>Area</th>

<th>Time</th>

<th>Booking Date</th>

<th>Booking Price</th>

<th>Status</th>

 

</tr>

</thead>

<?php

 

$result=mysql_query(“SELECT * FROM booking”);

while($row=mysql_fetch_array($result))

{

?>

<tr>

<td><?php echo $row[‘id’];?></td>

<td><?php echo $row[‘fname’];?> <?php echo $row[‘lname’];?> </td>

 

<td><?php echo $row[’email’];?> </td>

<td><?php echo $row[‘phn’];?> </td>

<td><?php echo $row[‘address’];?> </td>

<td><?php echo $row[‘sname’];?> </td>

<td><?php echo $row[‘servName’];?> </td>

<td><?php echo $row[‘area’];?> </td>

<td><?php echo $row[‘time’];?> </td>

<td><?php echo $row[‘date’];?> </td>

<td><?php echo $row[‘price’];?> Rs.</td>

<td><?php echo $row[‘status’];?> </td>

<td><a href=”updateBooking.php?id=<?php echo $row[‘id’];?>”>UPDATE</a>

 

 

</tr>

<?php

}

?>

 

</table>

</div>

 

</div>

 

<br>

 

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

</body>

</html>

 

Cust_display.php

 

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

 

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

<div class=”adminright”>

 

<h2 style=” margin-right:10px;color:#942423″> Customer Report</h2>

 

 

<br>

<table class=”bordered” style=”font-size:16px;width: 80%; color:white;” bgcolor=”#666666″ align=”left”>

<thead>

 

<tr>

<tr>

<th>#</th>

<th>Name</th>

<th>Email</th>

<th>Password</th>

<th>Phone </th>

 

<th>Address</th>

<th>City</th>

<th>State</th>

 

<th>Country</th>

<th>Pin Code</th>

 

</tr>

</thead>

<?php

$result=mysql_query(“SELECT * FROM customer”);

 

while($row=mysql_fetch_array($result))

{

?>

<tr>

<td><?php echo $row[‘id’];?></td>

<td><?php echo $row[‘fname’];?> <?php echo $row[‘lname’];?> </td>

 

<td><?php echo $row[’email’];?> </td>

<td><?php echo $row[‘pass’];?> </td>

 

<td><?php echo $row[‘phn’];?> </td>

<td><?php echo $row[‘address’];?> </td>

<td><?php echo $row[‘city’];?> </td>

<td><?php echo $row[‘state’];?> </td>

<td><?php echo $row[‘country’];?> </td>

<td><?php echo $row[‘pin’];?> </td>

 

 

</tr>

<?php

}

?>

 

</table>

</div>

</div>

 

<br>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

</body>

</html>

 


 

feedback_details.php

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

 

 

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

<div class=”adminleft”>

<?php include(‘adminleft.php’); ?>

</div>

<div class=”adminright”>

<h2 style=” margin-right:10px;color:#942423″> Category Report</h2>

<br>

<table class=”bordered” style=”font-size:16px;width: 80%; color:white;” bgcolor=”#666666″ align=”left”>

<thead>

 

<tr>

<th> Name</th>

<th>Email</th>

<th>Comments </th>

 

</tr>

</thead>

<?php

 

$result=mysql_query(“SELECT * FROM feedback”);

 

while($row=mysql_fetch_array($result))

{

?>

<tr>

<td><?php echo $row[‘name’];?></td>

<td><?php echo $row[’email’];?> </td>

<td><?php echo $row[‘comments’];?> </td>

 

</tr>

<?php

}

?>

 

</table>

</div>

 

</div>

 

<br>

 

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

</body>

</html

ratecard.php

 

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

<?php include(“header.php”); ?>

<div style=”width:1200px”>

 

<?php

include(‘config.php’);

$result=mysql_query(“SELECT * FROM category”);

 

while($row=mysql_fetch_array($result))

{

if($row[‘path’]==””)

{

$pa=”images/tool.png”;

}

else

{

$pa=$row[‘path’];

 

}

?>

<div class=”rounded”><table>

<tr>

<td align=”center”><span style=”color:#FFCC00; font-size:22px”><?php echo $row[‘cname’];?></span></td>

<td><img src=”<?php echo $pa;?>” height=”50px” width=”50px” style=””></td>

</tr>

 

<tr>

<td colspan=”2″>

<p class=”myp”><?php echo $row[‘desc’];?> </p>

</td>

</tr>

<tr>

 

<td colspan=”2″ id=”cl”>

 

<h4 class=”myh4″><a href=”ratecardMore.php?id=<?php echo $row[‘id’];?>&cname=<?php echo $row[‘cname’];?>” style=”text-decoration:none;”>Check Rate Card</a></h4>

</td>

</tr>

</table>

</div>

 

<?php

}

?>

</div>

<br>

<div style=”width:1240px; margin-top:280px; border:#999999 2px solid; margin-left:5px;background-color:#D6D6D6″>

 

<p>

 

<center><h3>Why Choose Us </h3></center>

 

<table align=”center”>

<tr>

<td align=”center”>

<table width=”300px” border=”0″ style=”padding:10px”>

<tr>

<td align=”center”><img src=”images/b1.png” width=”53″ height=”53″></td>

</tr>

<tr>

<td align=”center”>

<p style=”padding-left:10px”><h4>Verfied Serviceman</h4>

Spreada Service Zone Provider  are trained professionals, whose background details are thoroughly checked to ensure your safety and security.</p>

</td>

</tr>

</table>

</td>

<td width=”100px”></td>

 

<td align=”center”>

<table width=”300px” border=”0″ style=”padding:10px”>

<tr>

<td align=”center”><img src=”images/b2.png” width=”53″ height=”53″></td>

</tr>

<tr>

<td align=”center”>

<p style=”padding-left:10px”><h4>Faithful & Apparent</h4>

Spreada Service Zone Provider are continuously focused on providing crystal clear services to its customers and ensure customer satisfaction as a guarantee.</p>

 

</td>

</tr>

</table>

 

</td>

 

<td width=”100px”></td>

<td align=”center”><table width=”300px” border=”0″ style=”padding:10px”>

<tr>

<td align=”center”><img src=”images/b3.png” width=”53″ height=”53″></td>

</tr>

<tr>

<td align=”center”>

<p style=”padding-left:10px”><h4>Service On Time</h4>

Time is very precious and we guarantee of timely services to our customers.Spreada Service Zone Provider always give services on time.</p>

 

</td>

</tr>

</table></td>

</tr>

</table>

</p>

</div>

<?php include(“footer.php”); ?>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

</body>

</html>

book.php

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

 

<?php include(“header.php”); ?>

<div style=”width:1200px”>

<center>

 

<h2 style=” margin-left:90px; margin-right:10px;color:#942423″>Book Your Service Now</h2>

 

<?php

include(“config.php”);

 

$id=$_SESSION[‘login_id’];

 

$sq=mysql_query(“Select * from customer where id=’$id'”);

while($ro=mysql_fetch_array($sq))

{

?>

<form action=”book_action.php” method=”post”>

<input type=”hidden” name=”uid” placeholder=”Enter First name” value=”<?php echo $id; ?>”/>

<table  border=”0″ bordercolor=”black” bgcolor=”#666666″ width=”300″ height=”150″  style=”margin-left:100px; border:#660000 2px solid; padding:10px; color:white”>

<tr>

<td><b>Name</b></td>

</tr>

<tr>

<td><input type=”text” name=”fn” placeholder=”Enter First name” value=”<?php echo $ro[“fname”]; ?>”/></td>

<td><input type=”text” name=”na” placeholder=”Enter Last name” value=”<?php echo $ro[“lname”]; ?>”/></td>

</tr>

<tr>

<tr>

<td><b>Email</b></td>

</tr>

<tr>

<td colspan=”2″><input type=”text” name=”em” placeholder=”Enter email” value=”<?php echo $ro[“email”]; ?>” style=”width:100%”></td>

</tr>

<tr>

<td><b>Phone number</b></td>

</tr>

<tr>

<td colspan=”2″><input type=”text” name=”ph” placeholder=”Enter Phone no” style=”width:100%” value=”<?php echo $ro[“phn”]; ?>”></td>

</tr>

<tr>

<td><b>Address</b></td>

<td><b>Select Date</b></td>

</tr>

<tr>

<td><input type=”text” name=”add” placeholder=”Enter street address” style=”width:100%” value=”<?php echo $ro[“address”]; ?>”></td>

<td><input type=”date” name=”date” placeholder=”Select Booking Date” style=”width:100%” ></td>

</tr>

<tr>

<td><b>Select Subcategory</b></td>

<td><b>Select Service</b></td>

</tr>

<tr>

<td><select name=”sname” style=”width:150px” onChange=”getResult(this.value);”>

<?php

$cid=$_GET[“id”];

$que=mysql_query(“Select * from subcategory where cid=’$cid'”);

while($rt=mysql_fetch_array($que))

{

?>

<option value=”<?php echo $rt[“id”];?>-<?php echo $rt[“name”];?>”><?php echo $rt[“name”];?></option>

<?php

}

?>

 

</select></td>

<td id=”sh”><select name=”serv” style=”width:150px”>

<option value=”Select Service”>Select Service</option>

</select></td>

</tr>

 

<tr>

<td><b>Select Area</b></td>

<td><b>Select Time</b></td>

</tr>

<tr>

<td><select name=”area” style=”width:150px”>

<?php

$que=mysql_query(“Select * from employee”);

while($rt=mysql_fetch_array($que))

{

?>

<option value=”<?php echo $rt[“Area”];?>”><?php echo $rt[“Area”];?></option>

<?php

}

?>

 

</select></td>

<td><select name=”time” style=”width:150px”>

<option value=”9AM to 12PM”>9AM to 12PM</option>

<option value=”12PM to 3PM”>12PM to 3PM</option>

<option value=”3PM to 6PM”>3PM to 6PM</option>

<option value=”6PM to 9PM”>6PM to 9PM</option>

</select></td>

</tr>

<tr>

<td colspan=”2″ align=”center” id=”sPrice”>

 

</td>

</tr>

<tr>

<td colspan=”2″ align=”center”><input type=”submit” class=”button”  value=”Confirm Booking” style=”background-color:#DBB41A; color:#000000; border:#000000; height:30px”/></td>

</tr>

 

</table>

<br>

<span style=”margin-left:100px; padding-top:20px; color:#A71303; font-weight:bold”>

<?php

if(isset($_GET[‘err’]))

{

echo $_GET[‘err’];

}

?>

</span>

</form>

<?php

}

?>

</center>

 

</div>

 

<br>

 

<?php include(“footer.php”); ?>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

 

</body>

</html>

<script type=”text/javascript” src=”js/jquery-1.11.0.min.js”></script>

<script type=”text/javascript” >

 

</script>

 

Thankyou.php

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

<?php include(“header.php”); ?>

<div style=”width:1200px”>

 

<center>

<img src=”images/thankyou.png” width=”500″ height=”200″ style=”margin-right:100px; margin-top:20px”/>

<p style=”text-align: justify; margin-left:250px; margin-right:70px”><?php echo $_GET[‘msg’]; ?></p>

</center>

</div>

 

<br>

 

<?php include(“footer.php”); ?>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

</body>

</html>

 

track_booking.php

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

<div class=”adminleft”>

<?php include(‘custLeft.php’); ?>

</div>

 

<div class=”adminright”>

<h2 style=”margin-left:0px; margin-right:10px;color:#942423″>Your Booking History</h2>

<div style=”width:900px”>

<table class=”bordered” style=”font-size:16px;width: 96%; color:white;” bgcolor=”#666666″ align=”left”>

<thead>

<tr>

<tr>

<th>Booking Id</th>

 

<th>Address</th>

<th>Subcategory</th>

<th>Service Name</th>

<th>Area</th>

<th>Time</th>

<th>Booking Date</th>

<th>Booking Price</th>

<th>Status</th>

<th>Track</th>

 

</tr>

</thead>

<tr>

<td><?php echo $row[‘id’];?></td>

<td><?php echo $row[‘address’];?> </td>

<td><?php echo $row[‘sname’];?> </td>

<td><?php echo $row[‘servName’];?> </td>

<td><?php echo $row[‘area’];?> </td>

<td><?php echo $row[‘time’];?> </td>

<td><?php echo $row[‘date’];?> </td>

<td><?php echo $row[‘price’];?> Rs.</td>

<td><?php echo $row[‘status’];?> </td>

<td><a href=”serviceman.php?bid=<?php echo $row[‘id’];?>” style=”color:#99FF33″>Check Service Man Details</a></td>

</tr>

<?php

}

?>

</table>

</div>

</div>

</div>

<br>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

</body>

</html>


 

serviceman.php

<?php

session_start();

include(‘adm-lock.php’);

?>

<!DOCTYPE html>

<html>

<head>

<link type=”text/css” rel=”stylesheet” href=”css/style1.css” />

</head>

<body>

<?php include(“header.php”); ?>

<div style=”width:1200px;”>

<div class=”adminleft”>

<?php include(‘custLeft.php’); ?>

</div>

<div class=”adminright”>

<h2 style=”margin-left:0px; margin-right:10px;color:#942423″>Serviceman Details</h2>

<div style=”width:900px”>

<table class=”bordered” style=”font-size:16px;width:60%; color:white; margin-bottom:100px” bgcolor=”#666666″ align=”left”>

<thead>

<tr><td colspan=”2″ align=”center”><center><img src=”<?php echo $row[‘path’];?>” height=”200″ width=”200″></center></td></tr>

<tr>

<th>Serviceman Id</th>

<td><?php echo $row[‘id’];?></td>

</tr><tr>

<th>Name</th>

<td><?php echo $row[‘name’];?> </td>

</tr><tr>

<th>Phone</th>

<td><?php echo $row[‘phn’];?> </td>

</tr><tr>

<th>Experiecne</th>

<td><?php echo $row[‘exp’];?> </td>

</tr><tr>

<th>Age</th>

<td><?php echo $row[‘age’];?> </td>

</tr><tr>

<th>Description</th>

<td><?php echo $row[‘desc’];?> </td>

</tr>

</thead>

</table>

<?php

}

?>

</div>

</div>

</div>

<br>

<!–<div class=”main”  style=”background-color:#333333; color:#FF9933″>

<p>Trending Services</p>

</div>–>

</body>

</html>

 

CODE EFFICIENCY

Reviewing of Code efficiency for a module is carried out after the module is successfully compiled and all the syntax errors eliminated. Code efficiency review is extremely cost-effective strategies for reduction in coding errors in order to produce high quality code. Normally, two types of efficiency are carried out on the code of a module – code optimization and code inspection. The procedure and final objective of these two efficiency techniques are very different as discussed below.

 

OPTIMIZATION OF CODE:-

 


CHAPTER 6 LIMITATIONS AND FUTURE

APPLICATION OF THE PROJECT

SCOPE OF FUTURE APPLICATION

The scope of the system is defined on the basis of various functionalities provided by the system. The scope can be explained as:-

  • Build a web based system.
  • Information handling of all users who travel between the difference routes i.e. new passenger list will be created, data retrieval, updates in the information.
  • Information handling of the booking of tickets of user’s i.e. new records can be created, data retrieval, update and cancellation of the ticket functionality.
  • The scope of the project is to develop customize software package for travel agencies for reducing the manual problems.
  • It should deals with the online ticket reservation as well as cancellation.
  • The Administrator will take decisions on the basis of valuable reports which is generated by the automation system for the maintenance of the vehicle as well as passenger reservation system.
  • This system never decreases the manpower but helps the development of available manpower and optimizes the manpower by which company’s standards and capabilities can be scaled to higher dimension.
  • It is very difficult to maintain huge number of vehicles manually, but in automation system the administration will directly known what the vehicle condition and required maintenance.
  • Simultaneously the above project also keeps track the information of the drivers and the other employee’s record. The Administrator will handle Payroll system of a particular employee based on their performance.

 

FUTURE SCOPE

This system can be further used in the Network to use by all the doctors available in the hospital. Further I want to include following functionalities in the system.

  • Including Image Support
  • Automate mailing / SMS to the patient for their appointment

 

  1. CONCLUSIONS

Overall the project teaches us the essential skills like:

  • Using system analysis and design techniques like data flow diagram in designing the system.
  • Understanding the database handling and query processing.
  1. BIBLIOGRAPHY
  1. Senn James A : Analysis and Design of Information Systems, McGraw Hill, International Ed, 1989.
  2. O’Brien Jamea A : Management Information Systems, Galgotia Publications Pvt Ltd, New Delhi, 1998.
  3. Laudon & Laudon : Management Information Systems, Organisation and Technology, PHI, New Delhi, 1998.
  4. Wetherebe James : Systems Analysis and Design, Galgotia Publications Pvt Ltd, New Delhi, 1990