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.

Online Verification System Project Synopsis

Online Verification System

Verification process in other words background verification is very important nowadays for a lot of companies. It actually allows companies to validate the info provided by their employees are true and correct without any discrepancies.   

User Types: Admin, user, verifier

Admin will basically approve verifier login. Admin will also validate all data has been posted to the portal via a user and gives final approval for a submitted proof and details once a verifier validates the data. This portal will have 2 step validation process making it a secure and accurate verification system. Admin will upload content related to rules for different sort of documents which need to be uploaded by a logged in user and also set up rules which will be considered while verifying data provided by a user for a logged in verifier.  

The verifier will log in and validate the details and attachments that have been uploaded by a logged in users as per criteria and rules for documents that are needed. Once verifier validates the details provided and verifies the attachments uploaded by the user, he or she will update verification status for a particular user. This will be then sent to admin for final validation approval or verification approval.

The user will register and once registered they will have a dashboard which will show them rules related to various points under scrutiny. Once registered they will have different modules where they will save the details whichever required.

Modules:

  • Personal Details
  • Educational details
  • Professional details
  • Documents
  • Login / Logout
  • Dashboard
  • Admin

Personal Details: This module will ask the user to save details like First name, Middle name, Last name, DOB, Marital status, Residential Address, Father’s Name, Mother’s Name, Spouse Name if married,  Email, Phone Number, Alternate Number, City, State, Country.

Education Details: User has to save all details related to 10th, 12th Graduation and post.Information related to certifications.

Professional details: User will save all details related to job exp and companies wherein he or she worked previously. Date of joining in the current organization.

Documents: User will upload related documents to verify the professional details saved in the portal.

Admin: Will have a grid to approve and validate data related to a user for final approval. Admin will also have a grid to approve verifier login. Reports will also be provided to see how any users submitted data, how many validated by the verifier, how many users have been validated completely. Different type of reports can be added depending on the requirement.

Future Enhancements:

  • We can come up with SMS / email alerts for registration messages, validation complete messages etc.
  • We can provide reports module with the different type of reports for admin login related to sales, order and customer reports.
  • We can introduce plans like getting contracts from different organizations and managing users on the basis of organizations.
  • We can add payment related module for online renewals related to licenses concept related to organizations.

Technology to Use

Design and Markup

– HTML5, CSS3, JavaScript & jQuery

– Bootstrap / Angular JS

Server side

– PHP OR .Net with framework

Database 

– MySQL

– SQL Server

Hardware Requirements:
Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above

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.

ABC Courier Management System PHP Project

ABC Courier Management System

ABSTRACT

Courier management application will be a comprehensive and complete application wherein ABC systems will be able to manage all its operations and also the franchise/dealer related registration, manage their employees and dealer employees, manage delivery info all registered consignments or packages, manage customer related information and provide necessary info to  the same as notifications when he or she logs in to check the status of booked package or consignment.

It will allow the addition of ABC systems necessary information through the admin panel. Will also allow registration of employees working in ABC systems directly. Also, manage various departments in ABC systems. Will also allow adding a different type of packages or consignments that ABC systems deal with. Will also have necessary reports to check monthly wise packages delivered and amount earned by the company in a month. ABC systems can also register their own customers from their branches.

It will also allow registration of dealers who register themselves as franchises to ABC systems. Once registered dealers will be able to book packages or consignments which ABC systems deal with. Dealers can also log in and manage their employees who work for maintaining the courier process whichever are all involved. It will have the option to manage the packages that have been booked by dealers and also allow them to update the delivery status. Dealers can also register customers and manage their bookings.

Both dealers and ABC systems will have modules specifically to manage the packages that are booked, update the information related to the delivery of booked and confirmed packages, also have the option to cancel any packages or consignments. Once delivered registered delivery employees will be able to update the status of package delivery or it can be managed by respective admins.  

User Types: Super Admin, Admin, Employee, Customer, Executive

Modules:

ABC Admin module: It is accessible only to Super admin. This Module will have the option to first save data related to ABC systems and then add departments in the company and the additional locations and then add branch as per location. Roles will also be added by super admin. Once departments are saved super admin will be registering the employees working in ABC system and assign them to related departments and also assign to location. Super admin will also add the service types in the sense different type of packages that they deal with.

In the registration process super admin will create the logins too for the employees who can thereafter login to the application. This module will also have a reporting module. In reporting they will have a different type of reports like Package report, employees report, dealer report. This will application will basically automate the whole process of managing employees, package handling, handling branches and locations.

There will be no need to write down and maintain all documents in the form of files and papers. It will also have the option to book packages for customers and can also cancel any packages. While booking packages necessary info will be saved like the cost of the package, a number of packages, location, customer details, delivery address, customer delivery details, phone number, email id etc.

Booked packages can also be canceled within 2 hours of time. Super admin will also approve dealer registration and assign dealer manager who will manage all related operations of a dealer whichever assigned to him.

UML Diagrams:

Use Case Diagram:

Sequence Diagram:

Activity Diagram:

Class Diagram:

Submodules will basically be the one listed below:

  • ABC Info
  • Add Department
  • Add Location
  • Add Branches
  • Add Roles
  • Add Service Types and their cost
  • Manage Service Types and their cost
  • Add Employees
  • Manage Dealers
  •  Add Customer
  • Manage Customers
  • Manage Customer Packages
  • Book Packages
  • Manage Delivery
  • Reporting
  • Login / Logout

Dealers Module:

Dealers will register and in this process will create their login too. Once their registration is approved by Super admin they can log in. Registered dealers will have the option to register customer first and once they add that info they can book the packages which need to be delivered for a customer.

For delivery of packages, employee executive will be assigned. Info related to delivery can also be updated in the delivery module. The option will be provided to update info related to the delivery of package as delivered or pending. Booked packages can also be canceled within 2 hours of time. Submodules for Dealers will be as listed below:

  • Add Customer
  • Manage Customers
  • Manage Customer Packages
  • Book Packages
  • Manage Delivery
  • Reporting
  • Login / Logout

Customers Module:

This module is for customers who will register online via the application. The will be asked to provide all the important info at the time of registration. Once registered they can log in and book package.

They will have the option to add their profile info wherein the address, email id, phone number etc can be updated.  The option will be provided to view the status of the packages that are booked online.

  • Registration
  • Book Package
  • View delivery
  • My Profile
  • Logout / Login  

Employees Modules:

This module will be available for Managers and executives. Executives once logged can update the status of delivery. Managers once logged in can view the status of all packages that are being managed by dealers. Managers will have the option to cancel dealer registrations too.

  • Delivery management
  • Manage dealers

Output Screens:

Admin Sign In Page:

Admin Home Page:

Admin Add Dealership Request page:

Admin View Dealership Request page:

Admin Add Branch Address:

Admin View Branch Page:

Add Consignment Details Page:

Add Delivery Page:

Add Receiver Page:

View Receiver Page:

Get Corporate ID Page:

View Consignment List:

Advantages:

The following are the advantages of the proposed system

  1. Easy to track the status of applications at any level at any point in time
  2. Can generate required reports easily
  3. The centralized database helps in avoiding conflicts
  4. Easy to use GUI that does not require specific training.

Future Enhancements:

  • Notifications via email for registration approval, package delivery
  • Online payment for booking packages

Software Requirements:

Technical Aspects:
Database: MySQL
Language: PHP
Front-end: HTML, CSS,

Hardware Requirements:

Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above

Download ABC Courier Management System PHP Project Code, Database and Screens.

Campus Pedia – College Management System PHP Project

Introduction:

Campus Management System is educational network project which aims to completely managing colleges, institutes and universities by providing better interaction between students, faculty, and administration. It will provide seamless interaction between the stakeholders enables small administration and management of various teaching, non-teaching and administrative activities.

Motivation:

To have unique projects and develop our own innovative ideas. To become an original thinker by weighing up differing arguments and draw your own conclusions without copying others work.

The objective of the thesis:  

To produce Campus Management System in the undergraduate projects and create awareness about it.

Proposed Work:

Campus Management System is an advanced network information sharing system. Here we can share the information in an effective manner. We can post our ideas and any information instantly. It is interrelated with the different management systems. It will help full to exchanging and providing the latest information and updates quickly. It will provides seamless interaction between the different users.

Database Design:

Here we have seven modules. They are:

  • Admin
  • HOD
  • Counselor
  • Staff
  • Librarian
  • Student
  • TPO

Admin Module: Admin is the person, who works in the administrative department. In Campus Management System he has the ability to activate new users, who are accessing the application, like STUDENT, HOD, COUNSELOR. He can Track the details of any staff or student from his Account.

HOD Module: Person how Are acting as a head of the Department, they having their own account to control the department activities. Like: Assign Councilor’s, Adding new users like Staff and Student etc.

Councilor Module: Councilor is the person who monitoring particular students, who assigned by the HOD. He/ She can update student profiles based on student`s request.

Staff Module: Staff can see the timetables belong to their Own department. And the can update their own profiles. The can ask quires and they can give their answer for the quires which is sent by others.

Librarian Module: In this module home posts gallery, library, settings. Librarian can handle the student requests. He can update the book’s information.

Student Module: He/She can able to post any ideas can able to reserve books from the library.Can give feedback to their HOD or Councilor or ADMIN. He can see his profile if any modification is there in his profile he can post some message to his counselor as a feedback.

TPO Module: He can post the any latest information about placements. And he can track the student profile based on their academics and backlogs.

System Design:

Class Diagram:

Usecase Diagram:

Sequence Diagram:

Collaboration Diagram:

Activity Diagram:

Software Requirements:

Operating System: Windows Family.

Application Server:    Xampp.

Web designing languages :  HTML5, CSS3.

Scripts :   JavaScScripts:

Server side Script :   PHP.

IDE IDE: beans

Database: MySQL.

Database Connectivity : PhpMyAdmin.

Browsers support: IE9, Firefox, Chrome, and Opera

Hardware Requirements:

Processor Speed: 1.1GHZ

RAM:   512MB RAM & above

Hard Disk:   80GB & above

Keyboard: Standard Windows Keyboard

Mouse:   Two or Three button

Monitor:   VGA

OUTPUT RESULTS:

Fig: 7.1 Login page

Fig: 7.2.Admin Home Page

Fig: 7.3 : HOD Home Page

Fig.7.4: Student Home Page

Fig.7.5: Counselor Home Page

Fig.7.6: TPO Home Page

Fig.7.7: Librarian Home Page

Fig.7.8: TPO track

Fig.7.9: TPO Upload

Fig.7.10: Change password

Fig.7.11: Posts

Fig.7.12: Library reservation

Fig.7.13: Ask queries

Fig.7.14: Student feedback panel

Fig.7.15: Assign counselor

Fig.7.16: Feedbacks

Fig.7.17: Activate new users

Fig.7.18: See timetables

Fig.7.19: Track User

Fig.7.20: Student requests library

Fig.7.21: Upload Books Details:

Fig.7.22: Counselor track

Conclusion:

Campus Management System is an Educational Network Which Will Helpful To Share The Information between the different users Effectively and quickly and also provide good interaction between the different users.

Future Scope:

1. Now in our project, we are using the MySql Database, in future, we would like to implement in Oracle.

2. In future, we would like to provide more services to the users.