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:
- Login System
- Manage Sales, Reports
- CRUD products
- CRUD Suppliers
- User Management
- 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
[quads id=1]
after giving admin admin .. its showing wrong login details
have you inserted the database file?
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
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!!
I login with admin user and password it shows error that unable to select database
I tested this project on wamp server, experienced several issues with login.. With multiple errors linking database
My user login is not working
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
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
the dashboard.html file is missing….kindly please provide the file
Unable to select database
unable to select database
http://localhost/pisp/login.php
unable to connect database
please help me
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
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
no there’s no such redirection from the project file. that might be from your system
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
Does anyone made it work on v7? Please share if you had.
hi
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…
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
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
How to add discount and VAT in this?
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
username missing
password missing
this is showing when i try to log in
please help me
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
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
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..
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.
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
how we cane create sales edit?
Helo, How can i Get this Point of Sales and Inventory Management System full package with Cashier panel?
I can’t login this. Error showing in Login.php line 12
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
change mysql_connect() to mysqli_connect()
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
may be you have no connection with database in that line,
please, try to google it and check for the solution
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
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
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”);
}
Unable to generate sales report
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
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
-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
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/