Point of Sale System (POS) using PHP and MySQL

March 29, 2021
PHP
point of sale system in php

Project: Point of Sale System (POS) using PHP and MySQL with Source Code

About Point of Sale System (POS) using PHP MySQL Project Free Download

The Point of Sale (POS) System using PHP MySQL with Source Code is a PHP project that manages the sale transaction of a certain store. The project was developed for a certain store which is for the medical store or Pharmacy. This system stores all the products that the store or pharmacy is selling, then the system user will encode the sale transaction on the sales page when the data saved or submitted the transaction will be stored in the database for reporting purposes.

The features of this Point of Sale System are the following:

  • Add, Edit, and Delete Products
  • The table row will highlight if the product is below the quantity of 10
  • Search products
  • Add, Edit, and Delete Customers
  • Add, Edit, and Delete Suppliers
  • Generate Daily, Monthly, and Yearly Reports
  • Can Print Transaction
  • And More…

Point of Sale System (POS) Project

  • Name of Project:     Point of Sale System (POS) Project
  • Language:                  PHP
  • Databases used:      MySQL
  • Design used:            HTML JavaScript, Ajax, JQuery, Bootstrap
  • Browser used:          IE8, Google Chrome, Opera Mozilla
  • Software used:         WAMP/ XAMPP/ LAMP/MAMP

Screenshots

point of sale system using php

point of sale system using php mysql

point of sale system using php mysql

How To Run??

Above all, to run this project you must have installed a virtual server i.e XAMPP on your PC. Point of Sale System (POS) Project in PHP and MySQL with source code is free to download, Use for educational purposes only!

Follow the following steps after Starting Apache and MySQL in XAMPP:

1st Step: Firstly, Extract the file
2nd Step: After that, Copy the main project folder
3rd Step: So, you need to Paste in xampp/htdocs/

Further, Now Connecting Database

4th Step: So, for now, Open a browser and go to URL “http://localhost/phpmyadmin/”
5th Step: After that, Click on the databases tab
6th Step: So, Create a database naming “sales” and then click on the import tab
7th Step: Certainly, Click on browse file and select “sales.sql” file which is inside the “db” folder
8th Step: Meanwhile, click on Go button.

After Creating Database,

9th Step: Moreover, Open a browser and go to URL “http://localhost/pos”

Admin Access

Username: admin

Password: admin

DEMO


Related Projects: Complete Ultimate POS with Inventory Software, Sales and Inventory Management System using PHP CodeIgniter and MySQL, Computer Sales and Inventory System in PHP MySQL, Grocery Sales and Inventory System in PHP MySQL, Complete Sales and Inventory System with Credit Management using PHP, Simple POS and Inventory Management System in PHP/MySQL

Comments
  • Fatal error: Uncaught ArgumentCountError: mktime() expects at least 1 argument, 0 given in C:\xampp\htdocs\pos\main\navfixed.php:15 Stack trace: #0 C:\xampp\htdocs\pos\main\navfixed.php(15): mktime() #1 C:\xampp\htdocs\pos\main\index.php(90): include(‘C:\\xampp\\htdocs…’) #2 {main} thrown in C:\xampp\htdocs\pos\main\navfixed.php on line 15

    Shane April 29, 2024 1:41 am Reply
  • now this cant download

    Anonymous January 18, 2024 6:08 pm Reply
  • how to fix this?
    Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it in C:\xampp\htdocs\phplogin\pos\connect.php:10 Stack trace: #0 C:\xampp\htdocs\phplogin\pos\connect.php(10): PDO->__construct(‘mysql:host=loca…’, ‘admin’, Object(SensitiveParameterValue)) #1 C:\xampp\htdocs\phplogin\pos\main\products.php(172): include(‘C:\\xampp\\htdocs…’) #2 {main} thrown in C:\xampp\htdocs\phplogin\pos\connect.php on line 10

    Darol January 14, 2024 10:28 am Reply
  • Where to download the system

    MOsh November 21, 2023 6:30 pm Reply
  • How to solve this error???

    Fatal error: Uncaught mysqli_sql_exception: Unknown database ‘sales’ in D:\xampp\htdocs\pos\login.php:12 Stack trace: #0 D:\xampp\htdocs\pos\login.php(12): mysqli_connect(‘localhost’, ‘root’, Object(SensitiveParameterValue), ‘sales’) #1 {main} thrown in D:\xampp\htdocs\pos\login.php on line 12

    joshua September 22, 2023 12:30 pm Reply
  • thank you

    shin shin June 23, 2023 8:44 pm Reply
  • The product form is missing the field for quantity and the save button

    Roland Ruiz March 19, 2023 1:14 pm Reply
  • Why is the cashier account is no content?

    Anonymous March 19, 2023 7:55 am Reply
  • this line isnt working, the save button will not appear. but if i remove this it will show,

    prepare(“SELECT * FROM supliers”);
    $result->bindParam(‘:userid’, $res);
    $result->execute();
    for($i=0; $row = $result->fetch(); $i++){
    ?>

    jhade March 5, 2023 8:19 pm Reply
    • what file is this from?

      Darol January 14, 2024 6:49 pm Reply
  • save button is not working while adding product info

    jhade March 5, 2023 7:21 pm Reply
  • thank your very much

    Mustafa Malikzad July 21, 2022 4:51 am Reply
  • From where I can download this? There is no link here

    Zeeshan June 14, 2022 4:43 pm Reply
  • Where can I put the discount price?

    Anonymous May 29, 2022 10:59 pm Reply
    • can you tell me where is the download link of this system?

      Zeeshan June 14, 2022 4:45 pm Reply
  • Fatal error: Uncaught ArgumentCountError: mktime() expects at least 1 argument, 0 given in C:\xampp\htdocs\pos\main\navfixed.php:15 Stack trace: #0 C:\xampp\htdocs\pos\main\navfixed.php(15): mktime() #1 C:\xampp\htdocs\pos\main\index.php(90): include(‘C:\\xampp\\htdocs…’) #2 {main} thrown in C:\xampp\htdocs\pos\main\navfixed.php on line 15

    any clue?

    H April 9, 2022 8:46 am Reply
    • until now it’s not fixed

      jc June 19, 2022 4:00 pm Reply
  • after creating the database am searching for localhost/pos but the response is 404 not found

    Denno January 26, 2022 5:13 am Reply
  • where you guys found download link?? I can not see download link for source

    Zubair November 19, 2021 11:09 pm Reply
    • Click the ‘Download Here’ Button below to download the source code.

      admin November 20, 2021 11:25 am Reply
  • Uncaugth ArgumentCountError :mysqli_fetch_array()expect at least 1 argument 0 given C:xamap/htdocs/pos/main/sales.php on 201

    SSB September 6, 2021 2:42 pm Reply
  • i have trouble in Sale Report..

    Notice: Undefined index: d1 in C:\xampp\htdocs\pos\main\salesreport.php on line 165

    how can i fix it?

    CHARLIE MAGNE ORDONIO ALCANTARA August 30, 2021 3:08 pm Reply
  • Fatal error: Uncaught ArgumentCountError: mktime() expects at least 1 argument, 0 given in C:\xampp\htdocs\pos\main\navfixed.php:15 Stack trace: #0 C:\xampp\htdocs\pos\main\navfixed.php(15): mktime() #1 C:\xampp\htdocs\pos\main\index.php(90): include(‘C:\\xampp\\htdocs…’) #2 {main} thrown in C:\xampp\htdocs\pos\main\navfixed.php on line 15

    im getting this error

    Abdullah July 20, 2021 6:05 pm Reply
    • just add “0” next of mktime
      final ver. need to be like mktime (0)

      Almas June 21, 2022 9:55 pm Reply
  • bro please fix it i need it urgent for my shop

    Haris Rahim July 8, 2021 10:10 pm Reply
  • bro sales page are not working and adding product there no save button to save the product please check it

    Haris Rahim July 8, 2021 9:57 pm Reply
    • its not working yet.
      no save button

      domain August 6, 2021 3:02 am Reply
    • Please post the error you are getting so that we can attempt to help.

      Sanele October 4, 2021 12:50 am Reply
    • same im also having the same issue

      rayyan July 15, 2022 12:54 am Reply
  • How change login user name and password

    Haris Rahim July 8, 2021 7:13 pm Reply
  • is there a client version of this?

    Jane Marie S. Estrada July 6, 2021 2:23 pm Reply
  • can you change the name of the pharmacy??

    Anonymous June 28, 2021 5:50 pm Reply
    • You can edit that in the code.

      admin June 28, 2021 9:03 pm Reply
  • Fatal error: Uncaught ArgumentCountError: mktime() expects at least 1 argument, 0 given in C:\xampp\htdocs\pos\main\navfixed.php:15 Stack trace: #0 C:\xampp\htdocs\pos\main\navfixed.php(15): mktime() #1 C:\xampp\htdocs\pos\main\index.php(90): include(‘C:\\xampp\\htdocs…’) #2 {main} thrown in C:\xampp\htdocs\pos\main\navfixed.php on line 15

    Fredrick Omollo June 16, 2021 1:35 pm Reply
    • Please do run in php version 7.3, the stable version.

      admin June 16, 2021 4:24 pm Reply
    • In navfixed.php remove mk for mktime all problem will solved

      Haris Rahim July 8, 2021 7:12 pm Reply
      • it worked bro. thanks a lot

        Anonymous April 17, 2022 8:22 am Reply
      • Valeu Amigo removi toda essa parte e deu certo OBRIGADO PELA AJUDA

        Tirei toda essa parte e de certo -> ,mktime() <-

        Danilo June 18, 2022 10:56 am Reply
      • help me change or remove the “Eric’cs Pharmacy”
        this is just for my school project purposes only

        Ronel Bongcac May 31, 2023 7:21 pm Reply

Leave a Reply

Your email address will not be published. Required fields are marked *