PHP Projects

Point of Sales And Inventory Management System In PHP With Source Code

Project: Point of Sales and Inventory Management System in PHP with source code

– To download Point of Sales and Inventory Management system project for free (scroll down)

About Project

Point of Sales and Inventory Management System project is developed using PHP, CSS, Bootstrap, and JavaScript. Talking about the project, it has all the essential features required for a POS and Inventory system. This project contains an admin side where Admin can manage sales, products, suppliers, customers and manage users. The Admin plays an important role in the management of the system. In this project, all the main functions are performed from the Admin side.

About System

The Admin has full control of the system, all the functions are to be performed from Admin panel. Here, the admin can manage sales, the user has to enter customer’s name and cash amount. After that, the system provides the sales report which includes item code, name, quantity, price, discount and amount. After a sale of a certain item, the system automatically displays profit amount. The user can CRUD products. For this, he/she has to provide item name, category, arrival, expiry date, selling, original price, supplier and quantity. Each product must be placed under a certain category, the user has to provide a category name to add a category.

The system also allows managing customers. The user should provide the customer’s name, address, customer, product name, total, note, and the expected date. The suppliers also have CRUD features. In order to add a supplier, the user has to provide the supplier’s name, address, contact person, contact number and note. The sales reports can be viewed easily and the last feature of this project is about User Management. The admin can add users according to their positions. Design of this project is so simple so that user won’t find it difficult to understand, use and navigate.

To run this project you must have installed virtual server i.e XAMPP on your PC (for Windows). Point of Sales and Inventory Management System in PHP with source code is free to download, Use for educational purposes only! For the project demo, have a look at the image slider below.

Features:

  1. Login System
  2. Manage Sales, Reports
  3. CRUD products
  4. CRUD Suppliers
  5. User Management
  6. Automatic Profit calculation
How To Run??

After Starting Apache and MySQL in XAMPP, follow the following steps

1st Step: Extract file
2nd Step: Copy the main project folder
3rd Step: Paste in xampp/htdocs/

Now Connecting Database

4th Step: Open a browser and go to URL “http://localhost/phpmyadmin/”
5th Step: Then, click on databases tab
6th Step: Create database naming “posales” and then click on import tab
7th Step: Click on browse file and select “posales.sql” file which is inside “DATABASE” folder
8th Step: Click on go.

After Creating Database,

9th Step: Open a browser and go to URL “http://localhost/PISP/”
Insert the username and password which is provided inside the “Readme.txt” file.

LOGIN DETAILS ARE PROVIDED IN “Readme.txt” FILE INSIDE THE PROJECT FOLDER

DOWNLOAD POINT OF SALES AND INVENTORY MANAGEMENT SYSTEM IN PHP WITH SOURCE CODE: CLICK THE BUTTON BELOW



0 0 votes
Article Rating
Subscribe
Notify of
guest
71 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
ashok shah
ashok shah
4 years ago

after giving admin admin .. its showing wrong login details

Naseeb Bajracharya
4 years ago
Reply to  ashok shah

have you inserted the database file?

Jack
Jack
4 years ago

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:xampphtdocsPISPlogin.php:12 Stack trace: #0 {main} thrown in C:xampphtdocsPISPlogin.php on line 12

Naseeb Bajracharya
4 years ago
Reply to  Jack

You must be using PHP 7. Start using mysqli instead of mysql over entire application. OR simply switch to PHP 5.6.3, it will work out!!

Pratiksha raj
Pratiksha raj
1 year ago

I login with admin user and password it shows error that unable to select database

Edmond
Edmond
2 years ago
Reply to  Jack

I tested this project on wamp server, experienced several issues with login.. With multiple errors linking database

shivani
shivani
4 years ago

My user login is not working

Siva
Siva
4 years ago

Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000]: General error: 1364 Field ‘discount’ doesn’t have a default value’ in C:wampwwwPOS and Inventory System PHPPISPmainincoming.php:33 Stack trace: #0 C:wampwwwPOS and Inventory System PHPPISPmainincoming.php(33): PDOStatement->execute(Array) #1 {main} thrown in C:wampwwwPOS and Inventory System PHPPISPmainincoming.php on line 33

arthur
arthur
4 years ago

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:xampphtdocsPISPlogin.php:12 Stack trace: #0 {main} thrown in C:xampphtdocsPISPlogin.php on line 12

Biplab Acharjee
Biplab Acharjee
4 years ago

the dashboard.html file is missing….kindly please provide the file

Dhamu
Dhamu
4 years ago

Unable to select database

manjunath
4 years ago

unable to select database

manjunath
4 years ago

http://localhost/pisp/login.php
unable to connect database

please help me

ericko0593
ericko0593
4 years ago

i have the same issue, i created the database “posales” and the same messages appears “unnable to connect the data base”, i think there is a problem in the connect.php file
Im with mysql version 5.5.20
PHP version 5.3.10
apache 2.2.21

samuel Kortimai
samuel Kortimai
3 years ago

Hi, please help me I have uploaded the files in my htdos but the there is too much redirection I am not getting access to the login page

tonyfonseca
tonyfonseca
3 years ago

Hi first of all i want to thanks for sharing yours project codes with us.
i download the ”Point of Sales And Inventory Management System In PHP With Source Code” and its giving me the following errors. Can you please help me? Thanks.
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:xampphtdocsTonyPhpProjectsPOS and Inventory System PHPPISPlogin.php:12 Stack trace: #0 {main} thrown in C:xampphtdocsTonyPhpProjectsPOS and Inventory System PHPPISPlogin.php on line 12

techy
techy
3 years ago

Does anyone made it work on v7? Please share if you had.

divebomb
divebomb
3 years ago

hi

divebomb
divebomb
3 years ago

while using this POS, after a successful save of transaction, the page goes into the “main/preview.php?invoice=”, i think the problem on this page is, while using the USER account, this page should not be visible for the user, it should only be visible for the admin account…

a user can meddle other menus on the POS…

how can I fix that? can the moderator fix it?

Thanks…

alexa
alexa
3 years ago

first use php 6.3.5
second in this area of login.php the default is ‘sales’ change it to ‘posales’
//Select database
$db = mysql_select_db(‘sales’, $link);

then go again to http://localhost/PISP/
then instead of admin, admin try to login using this:
username: codeprojects
password: tobi

alexaGuno
alexaGuno
3 years ago

first use php 6.3.5
second in this area of login.php the default is ‘sales’ change it to ‘posales’
//Select database
$db = mysql_select_db(‘sales’, $link);

then go again to http://localhost/PISP/
then instead of admin, admin try to login using this:
username: codeprojects
password: tobi

Tsumi26
Tsumi26
3 years ago

How to add discount and VAT in this?

ModMod
ModMod
3 years ago

after installation and change to my_sqli I got this error

” Notice: Undefined index: username in D: xampp htdocs PISP login.php on line 33

Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in D: xampp htdocs PISP login.php:29 Stack trace: #0 D: xampp htdocs PISP login.php(33): clean(”) #1 {main} thrown in D:xampphtdocsPISPlogin.php on line 29″

Plz help

Nadim Mahmud
Nadim Mahmud
3 years ago

username missing
password missing
this is showing when i try to log in
please help me

CSection
CSection
3 years ago

I was able to install using PHP 7, so i just wanted to know how can i change colors? because i tried to modify on the bootstrap.css file but its working. thanks

skykode
skykode
3 years ago

Pls how will i tackle this error:
Warning: session_start() [function.session-start]: Cannot send session cache limiter – headers already sent (output started at C:xampphtdocsPOS and Inventory System PHPPISPmainheader.php:19) in C:xampphtdocsPOS and Inventory System PHPPISPmainauth.php on line 3

Rahul
Rahul
3 years ago

after giving admin password it showing wrong login details…and id i login as user its working but not working as admin…please guide me..

msh
msh
3 years ago

your title is misleading. It says the “point of sale” while there is no option to generate a sales receipt. so technically its not a point of sale.

IBRAHIM ADIGUN
IBRAHIM ADIGUN
3 years ago

Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\xampp\htdocs\POFSALES\login.php on line 18
Unable to select database

how do you fix this error

nasie
nasie
3 years ago

how we cane create sales edit?

Moses
Moses
3 years ago

Helo, How can i Get this Point of Sales and Inventory Management System full package with Cashier panel?

Monirul islam
3 years ago

I can’t login this. Error showing in Login.php line 12

vijay wagh
vijay wagh
2 years ago

hello, i have gone true the code and i had try many time to login but after entering the user and the password it shows the below error after i login into the project.

Please help with this error its urgent,
…..
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in E:\college software\XAMPP\htdocs\PISP\login.php:12 Stack trace: #0 {main} thrown in E:\college software\XAMPP\htdocs\PISP\login.php on line 12

codeprojects
Editor
2 years ago
Reply to  vijay wagh

change mysql_connect() to mysqli_connect()

vijay wagh
vijay wagh
2 years ago
Reply to  codeprojects

now am getting this error

Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in E:\college software\XAMPP\htdocs\PISP\login.php on line 20
Unable to select database

codeprojects
Editor
2 years ago
Reply to  vijay wagh

may be you have no connection with database in that line,
please, try to google it and check for the solution

Alostora
Alostora
2 years ago

Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in E:\college software\XAMPP\htdocs\PISP\login.php on line 20
Unable to select databas

The wolf
The wolf
2 years ago
Reply to  Alostora

Please show me the solution of this?

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in E:\college software\XAMPP\htdocs\PISP\login.php:12 Stack trace: #0 {main} thrown in E:\college software\XAMPP\htdocs\PISP\login.php on line 12

Richard
Richard
2 years ago
Reply to  Alostora

go to login.php page make a change here instead of this
//Select database
$db = mysql_select_db(‘sales’, $link);
if(!$db) {
die(“Unable to select database”);
}
to this one try it out.
//Select database
$db = mysql_select_db(‘posales’, $link);
if(!$db) {
die(“Unable to select database”);
}

Yinka
Yinka
2 years ago

Unable to generate sales report

Anonymous
Anonymous
2 years ago

0) { //Login Successful session_regenerate_id(); $member = mysql_fetch_assoc($result); $_SESSION[‘SESS_MEMBER_ID’] = $member[‘id’]; $_SESSION[‘SESS_FIRST_NAME’] = $member[‘name’]; $_SESSION[‘SESS_LAST_NAME’] = $member[‘position’]; //$_SESSION[‘SESS_PRO_PIC’] = $member[‘profImage’]; session_write_close(); header(“location: main/index.php”); exit(); }else { //Login failed echo ‘Wrong login details’; } }else { die(“Query failed”); } ?>
 
 
Error on login

madhawaka
2 years ago

Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\xampp\htdocs\POFSALES\login.php on line 18
Unable to select database

how do you fix this error

Alif Shinichi
1 year ago

-first, use php version 5.6
-in login.php line 12 change to
$db = mysql_select_db(‘posales’, $link);
if(!$db) {
die(“Unable to select database”);
}
– it works if using user
username : codeprojects
password : tobi

Problem :

– can’t login using admin account

Alif Shinichi
1 year ago

SOLVED !!!

-first, use php version 5.6
-in login.php line 12 change to
$db = mysql_select_db(‘posales’, $link);
if(!$db) {
die(“Unable to select database”);
}
– it works if using user
username : codeprojects
password : tobi

– if you want to login using admin, use
username : admin
password : admin123

if you have any questions.visit my website https://ternakkoding.com/contact.html and send message via email/facebook

Big Thanks to : https://code-projects.org/

71
0
Would love your thoughts, please comment.x
()
x