Puducherry Tourism Statistical Report and Information System

Synopsis:

Puducherry statistical analysis and information center is a website designed for Puducherry tourism Department. In this web site people who all over the world can know the details about Puducherry. One can find its location, specialty and can find their place to stay in Puducherry. As an information center, peoples can get all the important details about Puducherry like the Hotels, Restaurants and its location. They can also find the available travel services and packages in Puducherry are. Help Desk allows one to know the important contacts in Puducherry.

This project contains various modules like User, Admin, and Hotel.  The whole project has been developed by using PHP, HTML, CSS, and MYSQL as a back-end tool.

The User module is a complete Web site for the peoples to see. Peoples can enter into the Web Site freely can collect information’s, know its location and can see photos of Puducherry. The whole website will be User-Friendly and attractive.

Admin module concerns with maintaining the tourist information of Puducherry. They have to collect this information from the hotels located in Puducherry and have to send the details to Indian Government. This manual work is now changed as a computerized work. The department can collect the information from the hotels through the website and can print the details in the given proforma.

Hotel module concerns with updating hotel data’s to the admin database online. The person who is managing the details of the customers who is coming to a particular hotel has to update the database with a unique username and password. They can change the password to their sufficiency. The hotel management updates the database to the Tourism department through the website.

Both the Admin and Hotel module are designed with high security with username and password.

PROJECT GOALS

To develop a better website for Puducherry tourism department
To increase Security for information’s
To update the information using internet facility
To reduce manual work in a simple way.
To reduce the Paper works

PROBLEM DEFINITION

The organization is undergoing major work through human interventions.
Maintaining Tourist information
Maintaining Hotels in Puducherry
Sending Details to the Government
Maintaining the Proforma of every month

PROPOSED SYSTEM

The proposed system reduces the manual activities in the existing system.
It helps in maintaining the information of tourist and hotels in Puducherry in a database which replaces the paper.
Writing the details in the paper is replaced by printing the information in the paper.
The proforma will be printed whenever necessary so no need to maintain it the information in the paper.

MERITS OF THE PROPOSED SYSTEM

Database files are maintained instead of papers, which contains all the necessary details about the hotels and tourist.
The proposed system provides faster access.
The system provides effective report generators.
The organization’s cost and time effectively reduced by the automated system.

MODULES

1) User

This module is a complete website which is designed for the Department of tourism.
People can collect information about Puducherry with this site.
As the concept of AJAX is implemented with this Web site people find it easier to load the pages.

USER MODULE DESIGN

2) Admin

This module concerns with maintaining the tourist information of Puducherry.
The information’s collected from the hotels can be saved in the database and can be used to print proforma.
They can add a new hotel and view the information of a particular hotel.
This module was designed with a secured login hence the user has to log in with the password.

ADMIN MODULE DESIGN

3) Hotel

Hotel module concerns with updating hotel data’s to the admin database in using internet facility.
The person who is managing the details of the customers coming to a particular hotel has to update the database.
The updating of the database was carried out with a unique username and password by using the Pondicherry Tourism Web site.

HOTEL MODULE DESIGN

TABLE DESIGN (user_admin)

TABLE DESIGN (hotel details)

FUTURE ENHANCEMENTS

  • A search system can be incorporated to search for a particular place in Puducherry.
  • Facility of booking of tickets and rooms can be done through the internet.
  • May enhance the payment scheme for ticket booking through internet.
  • Calendar events of Puducherry can be added.

TOOLS:

  • HTML
  • CSS
  • API

SCRIPTING LANGUAGE:

  • PHP (for server-side scripting)
  • JAVASCRIPT (for client-side scripting)

BACK END:

  • MySQL

TECHNIQUES:

  • AJAX

Output Results:

Home Page


How to reach


Weather


History
Admin


View Hotel


Printing Proforma

  1. Install XAMPP
  2. How to connect the DB
    • Go to the URL http://localhost.
    • U will be navigated to another screen
    • In that click on PHPMyAdmin on the left side panel
    • On the new screen in the create new database text box type” tourism_pdy” and click on create.
    • In the new screen comes up you can find the option to create a new table for the existing DB. There look for Import option in the upper navigation.
    • Now click on import and import the text file “tourism_pdy” which I gave with the project and click on go
    • Now it will show “Import has been successfully finished, 29 queries executed.”
    • Database part is completed
  3. How to run the project
    • Copy the source code and paste it here in the path “C:\xampp\htdocs”. Means that the project source code should be inside the htdocs folder of the XAMPP. (This is very important)
    • Now open the browser and give the URL like “http://localhost/project_folder_name/index.php”
    • If the source code is copied as such it should be http://localhost/pondi/index.php
    • Now you will be able to see the project

My Tube Downloader PHP Project

Existing System:-

  • In the existing system, we have already used YOUTUBE website to upload and view videos but that website is not giving permission for downloading our or others videos.
  • In YOUTUBE for downloading user has to first install youtube downloader for downloading video then only user can download videos.
  • For songs, we are using SONGS website for downloading the mp3 songs but it is not providing the facility of uploading mp3 songs and in this, we can’t listen to it.
  • The above both sides are an individual one for videos and one for songs and it does not provide services to each other at one time.

Need for the New System:-

  • As shown above in the existing system for videos and songs we have to open two different websites.
  • In that, for videos, we used the youtube website and for songs, we used songs website. 
  • For this we have developed new website name “mytube Developer” on this website we are providing the facility of viewing, uploading and downloading videos, wallpapers, and songs on a single website.
  • In this site, we can change the password and we can also update our profile data. so it is easily understood by the users.

The objective of the Project:-

In our website www.mytube devloper.com when any user visits he/she. The user comes with lots of expectations and trust to get what he/she Wants. He has to register to get the benefits of the features and resources of our website and for this purpose, we have a simple and easy to fill 3 steps login form which takes user’s personal details.

Our website provides the facility of videos, songs, and wallpapers which you can view and have fun. Our website provides the facility of videos, songs, and wallpapers which you can download and have fun. We also provide the facility of uploading videos, songs, and wallpapers which you want to share with your friends and community.

We also provided you facilities to update your profile data and changing password for registration. We have tried to fulfill all the user requirements on our website.

Data Dictionary:-

TABLE NAME: Register

DESCRIPTION: Registration of user detail

NO Field Datatype Constrains Description
1 Id int (5) Primary key Unique user id
2 Firstname Varchar (30) Not null Firstname of user
3 Lastname Varchar (30) Not null Lastname of user
4 Gender Varchar (30) Not null Gender of user
5 Birthday Varchar (30) Not null Date of birth
6 Email Varchar (30) Not null Email id of user
7 Country Varchar (30) Not null Country of user
8 Postalcode Int (10) Not null Postalcode of user
9 Username Varchar (50) Not null Name of user
10 Password Varchar (50) Not null Password of user
11 Sec-ques Varchar(250) Not null Sec-ques of user
12 Sec-ans Varchar(250) Not null Sec-answer of user
13 Status Enum(‘0’,’1’) Not null Check the Current status

TABLE NAME: Songs

DESCRIPTION: Details of songs

No Field Datatype Constrains Description
1 Id Int (5) Primary key Unique id of songs
2 Title Varchar (250) Not null Title of songs
3 Url Varchar (250) Not null Url of songs
4 Description Varchar (1000) Not null Description of songs
5 Status Enum(‘0’,’1’) Not null Check the Current status

TABLE NAME: Video

DESCRIPTION: Details of the video

No Field Datatype Constrains Description
1 Id Int (5) Primary key Unique id of video
2 Title Varchar (250) Not null Title of video
3 Url Varchar (250) Not null Url of video
4 Description Varchar (1000) Not null Description of video
5 Status Enum(‘0’,’1’) Not null Check the Current status

TABLE NAME: Wallpapers

DESCRIPTION: Details of wallpapers

No Field Datatype Constrains Description
1 Id Int (5) Primary key Unique id of wallpapers
2 Title Varchar (250) Not null Title of wallpapers
3 Url Varchar (250) Not null Url of wallpaper
4 Description Varchar (1000) Not null Description of wallpapers
5 Status Enum(‘0’,’1’) Not null Check the Current status

UML Diagrams:

Entity Relationship Diagram

Context Level DFD:

0’ Level DFD:

System Development:

Screen Shots of Input Forms:-

  • Home Page
  • Registration Form
  • Login Page
  • Upload Video
  • Upload Wallpaper
  • Upload Music Song
  • User Profile
  • Get New Password

Screen Shots of Output Forms:-

  • User Successfully Registered
  • Welcome User Home Page
  • View Video
  • Upload Video Successfully
  • View Wallpaper
  • Upload Wallpaper Successfully
  • Download Wallpaper
  • View Songs
  • Upload Song Successfully
  • Profile Update Successfully
  • Password Update Successfully

Online Shopping Cart PHP Project Code

The main aim of developing this PHP based online shopping application web project is to provide easy access to buy products online.

This project looks like an online shopping website like Amazon or Flipkart where the user has to register in the website first then they can search products category wise, find product manufacturer, product description.

The below are the database tables created with the necessary columns

Category Table:

  • category id
  • category name
  • sort order
  • date added
  • description

Create Account Table:

  • first name
  • last name
  • email
  • telephone
  • fax
  • company
  • address1
  • city
  • postcode
  • country
  • password
  • password confirm
  • subscribe
  • privacy policy

Customer Table:

  • customer id
  • customer first name
  • customer last name
  • customer email
  • telephone
  • fax
  • password
  • cart
  • newsletter
  • address
  • status
  • customer group id
  • date added

Download Table:

  • download id
  • filename
  • date added
  • name

Information Table:

  • information ID
  • sortorder
  • title
  • description

Login session  Table:

  • user id
  • username
  • email
  • password
  • country

Manufacturer Table:

  • Manufacturer id
  • Manufacturer name
  • sort order

Product Table:

  • product id
  • product name
  • product description
  • product price
  • product quantity
  • manufacturing id
  • category id
  • download id

Download the below attached online shopping cart php project source code and database.

Food Ordering Management System PHP & MySQL Project

Summary of the System: 

There is a lot of scope online food ordering business and we can tap it to the max extent possible as everyone has access to an online ordering facility via the internet. Food business usually will have high demand and hence online business prospect for food ordering should be profitable.  We will provide an easily accessible interface wherein the customer can view and place the order easily.

The customer can register initially with minimum details and will be allowed to check the menu items before ordering them, adding them to cart and submit the order. The system records the details in MySQL database so that it will be easy to retrieve later. The users of the system also include employee/admin who will handle info related to product addition and assigning vehicle for placed orders.

Problem Statement:

The food business in restaurants is being carried out in the same fashion for so many decades. In the restaurants, when the customers visit, they will read the large menu cards which just has the name of the item and price. They have to decide in moments time and place the order just to wait in the queue for getting the ordered items on their table. Sometimes, the waiting time is so huge that the customers will actually lose interest in the item. Moreover, some customers will be in their office or busy to come physically to the restaurant and eat.

To ease the process of ordering the items, giving a description of each item and getting the item on the table the online food ordering system is designed. Some of the common problems are listed below.

The general problems faced while ordering food physically in a restaurant are listed below.

  1. Viewing the complete description of the menu item before ordering.
  2. Placing the order standing in a queue.
  3. Waiting for the customer’s turn to get the food.

These hurdles will be avoided by placing the order online

Users of the System:

The users of the system include the customers and the employees. The employees of the system are responsible for updating the menu items as well as the delivery of the item to a particular address. The customers will visit the website, check for the items available in the menu, order for one or more items in the menu. All the activities such as ordering items online, delivery of the items by employees, the vehicle used to deliver the items etc. will be recorded in the database for all the events.

Users of the database:

The top-level management who owns the food business will be using the database. They can try to infer details like

  1. what is the most demanded item?
  2. Which item is not ordered at all?
  3. What amount of business is made on daily basis?
  4. How the delivery of items is being carried out? etc.

Use Cases:

Use case diagram for Customers

Use case Diagram for Employees

The architecture of the Application 

Entities and its Attributes:

The main entities identified in the system are listed below.

  1. Customer [Attributes -> cid, name, email, pwd, phno, address]
  2. Employee [Attributes -> eid, name, phno, email, password]
  3. Orders [Attributes -> oid, pid, cid, odate, quantity, delivery status, vehicle]
  4. Products [Attributes -> pid, name, description, price, file]
  5. Vehicle [Attributes -> vid, status,vehicle_number]
  6. Cart [Attributes -> id, cid, pid, qty, status] 

Logical Design: 

The identified entities along with the attributes in the system are listed in Section 1. The tables that are designed are given below.

Customer Module:

The customer table consists of below details

  1. cid {primary key} [type : int auto_increment] assigned for each unique customer.
  2. name [type : varchar(30)] represents name of the customer
  3. Email [type : varchar(30)] represents email of the customer
  4. Pwd [type: varchar(30)] used for saving password of the customer
  5. Phnno [type : int(11)] is used for saving phone number of customer
  6. Address [type : text] used for saving the address of the customer

This table is used to get the details of customers

Employee Module:

Employee table is used to save

  1. eid {primary key} [type : int auto_increment] assigned for each unique employee.
  2. name [type : varchar(30)] represents the name of the employee.
  3. Phno [type : int(15)] is for saving phone number of employee
  4. Email [type : varchar(32)] saves the email info of an employee
  5. Password [type : varchar(32)] will save password of employee

Orders Module:

Order table used to save

  1. oid { primary key } [type : int auto_increment] assigned for each order.
  2. pid { foreign key references products: pid } .
  3. Cid [foreign key references customer: cid]
  4. Quantity [type : int (25) ] represents the quantity of the ordered product.
  5. Odate [type : datetime] represents a timeframe of the products ordered by the customer
  6. Quantity [type : int (11)] provides the quantity ordered by the customer
  7. Delivery status [type : tinyint(1)] saves the delivery status whether delivered or pending
  8. Vehicle [type : int(11)] helps in assigning vehicles. foreign key references: vehicles vid

Products Module:

Products tables used to save

  1. pid {primary key} [type : int auto_ioncrement ] assigned for each product.
  2. name [type : varchar(20)] represents the name of the product.
  3. description [type :text] represents the description of the product.
  4. Price [type : double(10,5)] saves the price of the product ordered
  5. File [type : text] saves the image of product ordered

Vehicle Module:

Vehicle table used to save

Vehicle [Attributes -> vid, vehicle number]

  1. vid {primary key} [type : int auto_increment] assigned for each vehicle.
  2. Status [type : int(11)]
  3. Vehicle number [type: varchar(30)] saves the registration number of the vehicle assigned for delivery

Cart Module:

Cart table used to save

Cart [Attributes -> id, cid, pid, qty, status]

  1. Id {primary key} [type : int auto_increment] assigned for each cart
  2. Cid foreign key references customer id from the customer table
  3. Pid foreign key references products table
  4. Qty saves all quantities related to products added in cart
  5. The status will save delivery status

Entity-Relational diagram:

Download Food Ordering Management System PHP & MySQL Project Source Code.

Collaborative Online Tutorial System Java Project

Abstract:

Now a days Tutorial Points are becoming useful to the students who are in the search of quality education. So, this application provides the support for both the tutors and students. The Admin is the head of this application who can view the students and tutors registered into the application. Admin will add the courses. The tutors who need to be registered and login and can select the course he would like teach by providing location and timings.

Students who also need to register and login into the application while registering student will give the location and after logging when he selects the course. The tutors available in that location and the course that tutor can teach both are matched and the request will be sent to admin. Admin will confirm the request therefore student can view the tutor details.

UML Diagrams:

Use case Diagram:

Sequence Diagram:

Activity Diagram:

Class Diagram:

There are 3 Modules present in the application:

  1. Admin
  2. Tutor
  3. Student

Admin:

Admin will login with the default username and password. Admin can view the registered tutors and students. He can also view the requests from tutors. Admin will confirm the requests then the details of tutors are shown to student and the tutor will be assigned to student.

Tutor:

Tutor will login and register into the application by giving the username and password, after logging in tutor will select the course and location and the timings with his availability. If any student requests were there in that locality the tutor will be assigned to student. 

Student:

Student will register and login into the application by giving username and password and student need to select the course and timings and if any tutors available in that area the request will be forwarded to admin, admin will confirm the request the tutor will be assigned to student.

Existing System:

In Existing System, the users need to visit the nearest tutorial point and there after he need to enquire the courses and the availability timings of the tutor. This makes the process lengthy and complicated.

Proposed System:

In Proposed System the tutors and students will registered and based on the student’s locality the tutors will be mapped by the timings selected by the student, this makes the whole process simple and effective.

Output Results:

Home Page:

Admin Login Page:

Admin View Tutor Page:

Admin Add Course page:

All Output Results:

1.Homepage
2.Admin Login
3.Admin Home
4.View Tutor
5.View Students
6.Add Course
7.View Tutors Request
8.Tutor Registration
9.Tutor Login
10.Tutor Home
11.View Profile
12.View and Select Courses
13.View Feedback
14.Student Registration
15.Student Login
16.Student Home:
17.View Profile
18.View and select courses
19.View Tutor
20.Feedback Page

Software Requirements:

Hardware Requirements:

Processor-Intel Core, RAM-2 Gb , Hard disk-500 Gb.

Software Requirements:

Operating System-Windows 7/8/10, Front End-HTML, CSS, JavaScript NetBeans7.4, JDK 1.7, MySQL 5.5, SQLYog, HTML, JavaScript and CSS.