Skip to main content

Point of Sale (POS) using PHP/MySQL


In this program you will know on how to create a complete online Point of Sale(POS) using PHP/MySQL.The system also help you on how to create an Online Point of Sale that cater both cash, check, and credit.

The system can generate different report such as:

Individual sales report
Inventory report
Daily/weekly/monthly/yearly sales report
Collectibles report
Supplier Report
Customer Report

The system can also retrieve OR, generate individual customer ledger and etc. Happy coding and hope this code will help you.

Database name: inventory

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


Submitted byAhmed Fazeel (not verified)on Fri, 03/23/2012 - 03:34

when i run the cords (Undefined variable: name) this error generated in line 511 can u help me to fix this pls soon (


So are you have been searching the accdou8nting software so the industrial standard software we will suggest. the name of this accounting software is Point of Sale Software. This Point of Sale Software is available online to solve your accounting problem Software.

Submitted byfredy (not verified)on Wed, 05/23/2012 - 05:47

the base is not complete because it is reflected on page searchname.php and checking the code calls a table called members which did not see you could put the entire database if not too much trouble ....

Submitted byAmalaBharathi (not verified)on Sat, 05/26/2012 - 22:55

hello sir,
I'm doing MCA degree. I going to do a project in "Hospital patient billing system in php/mysql" on my own. I'm not too good in php. so i need your guideline. Can you please send me some sample coding to do this project. Thank you sir...

Submitted byrfai (not verified)on Sat, 07/07/2012 - 16:12

how to do sales return in pos

Submitted byamanim (not verified)on Sat, 08/11/2012 - 23:29

Hi,i've inserted the administrator word on both,but i couldnt enter the system.there is an error

" Failed to connect to server: Access denied for user 'root'@'localhost' (using password: NO)"
please help me

Submitted byBenard kiplangat (not verified)on Tue, 09/09/2014 - 14:29

In reply to by amanim (not verified)

Check the file config.php and change the password which is empty for this case to your phpmyadmin password...I hope it will help.

Submitted bymika yunusu (not verified)on Tue, 03/01/2016 - 21:42

In reply to by amanim (not verified)

this string " Failed to connect to server: Access denied for user 'root'@'localhost' (using password: NO)" in your comment is showing that udin't use the proper user and password

1)using your PHP My admin create new user named:administrator and password :administrator
2) create your db named " inventory"
3)Import the file with th name :inventory.sql
4) copy all files and folders which are in side the OnlinePOS folder , run the system and Enjoy

Submitted byAnonymous (not verified)on Wed, 12/12/2012 - 15:04

Containg many errors, but giving a good start for creating POS

Submitted byAnonymous (not verified)on Sun, 02/10/2013 - 20:55

every time i run the program the error is this
Notice: Undefined variable: name in C:\wamp\www\aw\onlinePOS\OnlinePOS\auto.php on line 505 how to fix it sir? can u give me some technique or code on how to fix it?

Submitted byAnonymous (not verified)on Mon, 02/18/2013 - 19:34

after i login, the page occured "could not select database" ..
what is it means?

Submitted byAnonymous (not verified)on Sat, 03/02/2013 - 17:55

The selling php file is missing a JavaScript calling itself bleble
on a textbox called amots and an error on line 505 becaue of get id
but it is a good start to see a php pos.

on the whole it SHOULD NOT work because the page has to reload when
code of selling is put. With a little more working and js at product code i guess there is a way.

I cant believe argie, the owner does not see these problems and errors.
otherwise the only free sample code i can get on the internet

Submitted byAnonymous (not verified)on Mon, 03/04/2013 - 04:03

me again webuzy.
3 days straight trying to make this web pos to work and i have done it!!!

1. The code has no js function called bleble and cause err at line 505 - trying to read a cookie. just remove the line and use your own code for authorising your many different pages.

2. You have to work with ajax so as to avoid reloading page.
unfortunately you have to learn what ajax is if you dont know.

3. do not follow the authors route on selling form doing too many things. have separate cash or POS sales and different ones for credit sales. More manageable.

Once again thanks to owner of the code. gave me the bulk of ideas to work with. If you need specific help,on commercial basis, email me webuzy (at) yahoo (dot) com.

Bye all

i have problem with this system....

1. how to create code for replacing js function called bleble and cause err at line 505?

2. can u give URL for learn ajax...?

3. if i separate cash and POS sales...what should i create name file? and how to select customer name if i separate the file?

Submitted byAnonymous (not verified)on Thu, 04/18/2013 - 14:15

hello why is it i cant change the die function to an alert box? any idea?????

Submitted byAnonymous (not verified)on Wed, 05/01/2013 - 14:15

Some one help i ve failed to correct this error e :
( ! ) Notice: Undefined variable: name in C:\wamp\www\onlinePOS\OnlinePOS\auto.php on line 505
Call Stack
# Time Memory Function Location
1 0.0170 433192 {main}( ) ..\auto.php:0
" size="70" style="border:0px;" readonly/> ( ! ) Notice: Undefined variable: id in C:\wamp\www\onlinePOS\OnlinePOS\auto.php on line 506 Call Stack #TimeMemoryFunctionLocation 10.0170433192{main}( )..\auto.php:0 " readonly/> ( ! ) Notice: Undefined variable: prcoede in C:\wamp\www\onlinePOS\OnlinePOS\auto.php on line 507 Call Stack #TimeMemoryFunctionLocation 10.0170433192{main}( )..\auto.php:0 " readonly/>
Date :
Product Price :
( ! ) Notice: Undefined variable: price in C:\wamp\www\onlinePOS\OnlinePOS\auto.php on line 517 Call Stack #TimeMemoryFunctionLocation 10.0170433192{main}( )..\auto.php:0 " style="border:0px;"/>
Quantity :
Available Qty:
( ! ) Notice: Undefined variable: qty_left in C:\wamp\www\onlinePOS\OnlinePOS\auto.php on line 524 Call Stack #TimeMemoryFunctionLocation 10.0170433192{main}( )..\auto.php:0 " size="10" style="border:0px;" readonly="readonly"/>
Reciept Code :

Submitted byanonymouson Fri, 06/07/2013 - 21:43

Newbie here. Unable to import inventory.sql.

What should I do in this case?

Thanks in advance!

This is the report MySQL gives me:

  1. Error
  3. SQL query:
  5. --
  6. -- Database: `inventory`
  7. --
  8. -- --------------------------------------------------------
  9. --
  10. -- Table structure for table `code`
  11. --
  12. CREATE TABLE `code` (
  13. `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
  14. `code` int( 11 ) NOT NULL ,
  15. PRIMARY KEY ( `id` )
  18. MySQL said: Documentation
  19. #1046 - No database selected
Submitted byAnonymous (not verified)on Mon, 07/08/2013 - 19:28

Failed to connect to server: Access denied for user 'root'@'localhost' (using password: NO)

i have installe comes up with a login screen .. i have create database in cpanel but no tables are table from where can i get sample datatabase or structure of a database

Submitted bykiddie (not verified)on Fri, 09/26/2014 - 09:10

too many errors........ i can't figure all it out

Submitted byJessie P. Colipano (not verified)on Sun, 11/30/2014 - 10:18

when i enter the product code searchSuggest2.php is missing error appear. I look into the files there are several searchsuggest files but no searchSuggest2.php... may I ask for a copy...

Many thanks and more power...

Submitted byNetboye (not verified)on Thu, 07/02/2015 - 22:53

Doesn't start properly, after loging in as administrator with same password the said, cant find database. why is that?:

Submitted byJudah (not verified)on Wed, 05/18/2016 - 00:36

In reply to by Netboye (not verified)

maybe you did not create a database connection to the login and the rest.....

Submitted byyeankaon Tue, 06/06/2017 - 21:09

after imputing
username: administrator
Password: administrator

here is the error bellow

Notice: Use of undefined constant inventory - assumed 'inventory' in C:\xampp\htdocs\onlinepos\mainloginexec.php on line 18

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

kindly help

Submitted byTosunPASAon Sat, 09/01/2018 - 20:11

have much a lot of errors
and all pages creating connection... you must cange all pages
if you are using new php / xammp showing mysqli-pdo error.. u must add "error_reporting(0);"

and very tired and cant finish error

realy.. did you use this program ? or why shared ?

Add new comment

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.