Category: MySQL Projects

MySQL is the backend database system, We have developed projects with MySQL DB. Students and Projects Lovers can Download Projects with MySQL Database and enjoy executing.

Posted on

Customer Sentiment based Sales Approach

In a corporate world where boundaries are dissolving and communication is taking every form we can imagine, it becomes imperative to obtain access to a faster, less costly way to communicate with customers. Today’s competitive markets demand optimization of the processes and resources leading to improved bottom lines, creating new possibilities and identifying opportunities all along the way.

This concept helps us in robust marketing and promotional customer and businessman communication requirements. It is web-based tool to create an efficient platform for the communication between Service Providers and Customers. The current Customer Sentiment based Sales Approach project allows Service provider to register and select a SMS plan and send messages about their business to the customers.

The New User can also register and see the different providers which are present in the website in category wise. He can select the provider and get the SMS send by it. If the User doesn’t want any SMS then he can unsubscribe also.

Existing System:

In the Existing system different service providers have different websites. If the user wants to search for the information about the different service providers he has to search in different websites. It is somewhat difficult and time consuming.

Proposed System:

In the proposed Customer Sentiment based Sales Approach system the user can search the information about the different service providers and select them by category wise so that they can enable getting sms from a desired service provides. Here we have a module to control all service providers and users.  The service providers can send SMS to the users according to category wise.

Functionalities:

  1. Service Provider Module:
  • Registration and Login:
  • Uploading Module (single user and multi user(through Excel)):
  • Add Categories
  • SMS Service
  • View Bills
  • View Plan
  • View Registered Users
  1. Admin Module:
  • Provider Approver module
  • View Reports
  • Add Plans
  • Control service providers and users
  1. User
  • New User(direct registration) and Service Provider Uploaded User/login
  • Search providers (Category wise)
  • Message Opinion module

Technical Environment:

Technology: Java 2 Standard Edition, JDBC and AJAX

Web Server: Apache Tomcat.

Server Side Technologies:  Servlets, JSP

Database Server: MySQL

Operating System: Microsoft Windows

Posted on

IPL Game Application Java Project

Description:

It is a social networking application and fun game application. This application is based on the IPL (Indian premier league). It just like playing cricket match, but we won’t play directly. Here we will get cricket match updates based on the updates we will get the score. As we know different teams are participating in IPL under different franchises. In this IPL Game Application Java Project each user is a franchise and he will select the players from list and he will create his own team. And he can invite his friends to site also.
Then he will create a group

Once IPL matches’ started he will get the score based on the player score, scored on a particular match. If player hits 1 run then user will get 1 point, if payer hit 4 runs he will get bonus points etc.
Finally one user will win among his friends group.

Existing System:

We have different social networking sites but there is no site which provides games playing among the friends. Now days we have different site which are providing game but that those are game who can play alone. Here user playing along with his friends.

Proposed System:

In this Java Project we are overcoming the problems in the existing system. Here user can send the messages and user can play game.

Modules & Functionalities in this Java Project:

1. Admin :

  • Adding players: Here admin will add the player to site. He will add player profile, strength.
  • Adding Team : Create Cricket teams as per IPL.
  • Add Score : Update the live score details of the players to view by team players

2. User :

  • Selecting players: Here user will select the payers from the list.
  • Choose Players: User will select the players from the list of players from each team.
  • Invite Friends : Here user will invite his or her friends to participate in IPL.
  • View Score : User can view the live score updated by the admin.
  • Updating profile: User will update his profile.

Technologies Used:

Language : Java ,Servlets, jsp, Ajax, css
IDE : Eclipse
Server : Tomcat 5.5
Database : Mysql

Posted on

Web Chat PHP Project

Abstract

Web Chat project enables users to chat to each other through web .This system is written in PHP language. It requires Internet connection. All the chat is supervised by server admin.

This is WEB chatting system software it’s a Web project for college students.  It’s a Server client software application developed in PHP. Here the user can chat with other user through WEB connection. Need of internet connection. This software can be used in all office which is helpful to communicate with office staff. This software is error free. Anyone can use this software

Existing System

  1. Chat only online
  2. No Data Security

Proposed System

1) Chat In Local System connection so it is cheap.

2) Better Communication.

3) Secure and safe system.

4) Flexible system you can edit its source code to make it more attractive or useful.

6) Admin can keep track on whole chatting.

7) We can share files also through this system.

Modules:-

User 1:- Give Mail Id and Get Start the Chat in local System

User 2:- Give Mail id and get Start chatting in local System

Chart: – Send some text messing in user 1 and user 2

System Requirement Specification: 

  • WINDOWS OS (XP service pack 2 /windows 2007 Server)
  • Visual Studio .Net 2010(according requirement)
  • Visual Studio .Net Framework (Minimal for Deployment)
  • SQL Server 2008R2(according requirement) Enterprise Edition
Posted on

School Management Software PHP Project

Every city has hundreds of schools .Schools are character building block for everyone’s life. Schools play very important role in people’s life. Without schools no one can get knowledge.

To get knowledge we have to go to the schools .Schools teaches not only knowledge but also it teaches about the discipline.

The School Management System is the project For Controlling all the Function that happen in school manually up to now but our project is going to all this function by one click only.

Existing System:

1. Things are going manually
2. More Paper Work
3. Need Man Power
4. No Data Base for saving data

Proposed System:

This project enables you to make survey of schools .You can keep track on each activity of schools. If you want to make a school project then this project will surely help you to make it. This is very wonderful project; it consists of all the code and subject which will be need to make it.

Sometime user wants to make project using RDBMS, this is very interesting project. First you download the project and then you have to edit it according to your requirement .This is browser compatible project.

Advantages:

1. Things are going automated
2. No Paper Work
3. Need less Man Power
4. Using Data Base for saving data
5. Data is provide Security

Modules:-

Registration: – By using this Module the Students and give their information and make account in to our application
Login:-This module is for security it will check the user name and password and allow the students to login in to the application
Admin: – He can add all the information about the Schools, Students, and Faculty.
Student: – The school students can view the information that all give uploaded by the admin
Reports: – This will give all the reports about students, Schools and Faculty.

Main Screens:

  1. Main
  2. Student Login
  3. Faculty Login
  4. Admin Login
  5. Add Student Info
  6. Add Faculty Info
Posted on

Express Courier System Java Project

3 Main Modules ( Players / Users ) included in this Express Courier System Java Project.

  1. Administrator
  2. Staff
  3. Customer

Administrator Functionality

1. Login
2. Change Password
3. View / Add / Edit /Delete Staff
4. Add / Edit / Delete New Location ( Location, Route (via points), Price Per Kg)
5. View Bookings By Date
6. Logout

Staff Functionality

1. Login ( using login credentials given by the administrator )
2. Change Password ( after login change password for security reasons)
3. Book parcel
4. Track Parcel By Booking ID
5. Change Location ( location of the parcel, system will trigger an SMS internally to the sender)
6. Enquiries (View and Reply)
7. Upload Promotions/ Delete Promotions
8. Logout

Customer Functionality

1. Tracking Parcel By Booking Id
2. Booking Details By Booking Id
3. View Promotions
4. View Rates Based on Destination and Weight

Technologies For Implementation

Programming Language : JAVA
Database : MySql

Posted on

Pre-Paid Internet Accessing Project Abstract

Abstract:

Prepaid Internet Access takes a couple of minutes to set up and get started. The service can be purchased and renewed online in minutes. Prepaid Internet Access account with preset blocks of time, valid for 1 year + the added benefit of being able to use the service from any place with the same username and password.

A software-based prepaid micro payment scheme is developed. As with existing prepaid micro payment schemes, the profits of the merchants are protected. Furthermore, in this proposed scheme, fairness for the customers is also assured.

More precisely, in this new scheme, the merchant, after receiving prepaid money, can only claim that a customer has already spent a specific amount of money by showing the required cryptographic witness, which can only be received from that customer when making a payment.

Most importantly, in this new scheme, no public key-signature computation is required. Finally, it is shown that, owing to its simplicity and high performance, the proposed scheme can also be employed by small pieces of electronic equipment for general-purpose resource-access control.

This Pre-Paid Internet Accessing software will be of great use to the administrator who controls the internet access, he can implement a systematic way of accessing the internet. A customized browser is provided to act as communicating tool between the prepaid net access application and user. The browser will intimate the user the amount of time he has left out for browsing.

INTRODUCTION:

This Pre-Paid Internet Accessing project deals in Internet access on prepaid basis. The following conditions apply for prepaid Internet access.

Prepaid Internet is for general Internet access within the Federated countries and all prepaid email accounts end with @mail.com Internet access on a prepaid basis are charged on a usage sensitive basis. Customers have the flexibility to define the duration of the email account (in monthly increment).

At the expiration of the email account, the customer has 90 days to revalidate the account, otherwise, the account is deleted and all messages purged. A user can utilize existing prepaid cards for new prepaid Internet service.

Prepaid Internet access, Customers will use Timecards’ serial and scratch-off number as username and password to gain Internet access. The balance on the prepaid card will be debited according to megabyte usage for both transmit and receive data (rounded to the nearest Mb) per each Internet session.

To set up a new connection on another computer, you need to make sure it is configured to connect to the internet. Follow the instructions below:

  • To access the Internet with your prepaid card, click on the dialer icon or the shortcut that you have created on your desktop.
  • This window will open. Enter the card number as the username and the scratch number as the password. Click “Dial” or “Connect”.
  • Your prepaid will be accessed.

A business method for providing Internet access to users comprises requesting access to the Internet via the public telephone network or other Internet access infrastructure such as DSL, cable, wireless, or dedicated line, presenting a user name and password and then verifying the user name, password, account activation status and account time balance if the account is for a fixed amount of on line time, or date of expiration if the account is for a fixed elapsed time.

The system acknowledges user access by identifying the account time balance or expiration date. This is followed by allowing access to the Internet and using the Internet access for a session time of not more than the account time balance or up to the terminal date. After that the access time is disconnected.
A new account time balance is calculated if appropriate and the time balance, if any, is communicated to the user.

 

SOFTWARE’S USED:

  • C#.NET(HARD-CODE)
  • MS SQL OR XML

Advantage

  • Using is very simple.
  • Easy installation.
  • It can be carried out to any place by using Laptop.
  • It connects to any kind of Browser.
  • No need to wait in the Cyber Café wasting the time.

Disadvantage

  • Sometime server may be down.
  • Some of the cable equipment is expensive.
  • Consumption of power is more because of PC

Application

This Pre-Paid Internet Accessing software is very much user friendly and provide a secure to the internet, in terms of prepaid access concept, the customized browser provided communicates with the prepaid application and work according as a perfect user interface.

Posted on

Online Book Store PHP Project

Abstract:

Many people’s have problem that they want to learn or read .But due to their busy schedule they could not give time to study even they want to study .So i have realized these peoples problem and added this powerful project.

It will be very suitable for the such peoples who have to work whole days far away from their home. This project just gives a Basic demo of live project .You can make it online by adding some more code or features to enhance it. if you face any help in any step then contact me

Existing System

Things going manually like going to book shop and checking the books and buying the books
No security for data base because all the books information is keep in records and that work is also done by man by using man power so there is chance of doing mistakes

Proposed System

In this project you can view any book very easily online. You can purchase online books by selecting any payment gateway like pay-pall or money wire.

This is controlled by a admin who have full control over all the books. All the books are stored into the Database. so there is fill security of theft of payment etc.

Online bookstore provides a platform where all the books are kept in an arranged way and you can choose your required book by just selecting it from the store .after selecting book and view all the description such as name of book, name of author and price ,user can make payment of it in order to get it.

Modules

Admin: – He will add all the information about the books like cost name year subject all the complete information of the book who have all the rights do on the project

Users: – He can search for the book he is in need if he found the book he can buy that book from his home only

Registration: – For all the new users this module is used

Login: – The entire registered user can access the application by using this module

SOFTWARE SPECIFICATION

• WAMP — Web Application Server
• PHP — Server Side Scripting Language
• MySQL — Database
• XHTML — Extendible Hypertext Markup Language

Posted on

Synopsis for Mobile Ticketing Portal Project

Synopsis: This Mobile Ticketing Portal document covers the overview of one such application – Mobile Ticketing that will be the best app for this very promising platform.

Mobile Ticketing exclusively developed for PVR Cinemas is a utility for its mobile phone users to book tickets.  Also, it gives an opportunity for the PVR Administration staff to update movie information using a web client which can be accessible only by authorized persons.

The archetypical view of this Mobile Ticketing Portal project can be classified into three components with MySQL as the backend.  Namely:

  1. J2ME Client
  2. Web-client (JSP / Servlets)
  3. Server side (JSP / Servlets)

Component Features:

J2ME Client

  1. Update Weekly Movie Schedules – The user on his mobile phone clicks the update button to get the next week’s movie schedules and automatically it will be stored in the RMS.
  2. Book Tickets – The user can book movie tickets from this feature by the details already available on his mobile through the update option.
  3. History – A log of the previous bookings done by the user will be stored on his mobile and can be viewed by this tool.
  4. Movie Reviews – Users can check out Movie reviews by connecting to the server.
  5. F.A.Q – A user manual is kept stored in the mobile phone as online help.

Web-Client

  1. Login – Administrator mode login is available
  2. Add New Film to the list
  3. Add Cinema Info
  4. Add Language Info
  5. Schedule Film Date, Timings, and Ticket Availability Status

Server-side Component 

Along with the request processing being done by the server for its clients, the Server will send an SMS as acknowledgment after booking tickets with ticket numbers reserved for the number of tickets booked. 

Hardware Requirements:

  1. Mobile Phone with GPRS enabled
  2. Pentium II or above with at least 2.0GB Hard disk

Software Requirements:

  1. J2SE
  2. J2ME wireless toolkit
  3. Tomcat
  4. MySQL

Future Enhancements: 

  1. Concentrate on other theaters too.
  2. Movie Reviews with a trailer being played out as an audio or video file.
  3. Download Ring tones and Wallpapers.

Download the complete Project code on Online Movie Ticket Booking System.

Download Online Movie Ticket Booking web-based Java & MySQL Project Source Code & Project Report.

Posted on

Real Estate Portal on Handheld Devices Project Synopsis

This Real Estate Portal on Handheld Devices document covers the design, architecture, tools and development methodology for one such application – Magic Bricks that will be the killer app for this very promising platform.

Magic Bricks exclusively developed for Real Estate Community is a utility for mobile phone users to enquire/search for accommodation/lands available in a locality, as per their requirement ( meaning -Rent or Buy). Also, the web client is equipped with facilities for the Real Estate Administration staff to update property information along with an image (if one exists) on authentication.

A search facility on the home page of this portal allows any user to browse through the current real estate data based on their requirements.

Archetypically, this project can be classified into three components with MySQL as the back-end.

Namely:

1. J2ME Client
2. Web-client (JSP / Servlets)
3. Server side (JSP / Servlets)

Component Features:

  1. J2ME Client
    a. Search for accommodation
  2. Web -Client
    a. Login
    b. Add Property
    c. Add Area/Locality
    d. Add Property Information
  3. Server Side
    a. Processes the requests of the clients

Software Requirements:

1. J2SE
2. J2ME wireless toolkit
3. Tomcat
4. MySQL

Future Enhancements:

1. Add keyword search on the web client.
2. Categorize users like buyers, Agents and Builders.
3. Add online discussion forum for active interaction between users.
4. Add facilities for users to lease, mortgage their property apart from only sale and purchase.

Posted on

Student Project Information Synopsis

The aim of the Student Project Information Java project is to more efficiently submit academic project information. It is a hassle-free platform which helps the students to reduce paper work. The current status of the academic project on which the students are working upon can be viewed and accessed by the admin.

The admin will be able to view and edit the project using their personal credentials and these changes will be known to the users. The Super Admin has the access to view the project list of all the students.

This Student Project Information java based web application can be used by the students to upload their project updates by logging-in using their credentials. During the complete project schedule, various deadlines are set for the students to update their current project details.

This Final Year Project includes 3 modules:

1. Super Admin
2. Admin
3. User

Super Admin: The Super Admin can view the list of the projects of all the students. He has the ability to generate ranks to every project.

Admin: Admin can perform CRUD (Create, Remove, Update, and Display) operations. The changes made by the Admin can be viewed by the students.

User: User is responsible to work and update the project from time to time. They are provided with the deadline during the completion of the project.

This Student Project Information project is developed on a Windows platform using the following requirements

  • Core Technology Used: Java
  • Front-End Languages: HTML, CSS, JavaScript
  • Database: MySQL