1. PHP
  2. Simple Cashiering System (POS) in PHP and SQLite Source Code Free Download

Simple Cashiering System (POS) in PHP and SQLite Source Code Free Download

Submitted by oretnom23 on Tuesday, September 14, 2021 - 11:32.
Language
PHP

Introduction

This is a Simple Cashiering System in PHP. This simple project is a web-based application that can help businesses to manage their day-to-day transactions. This can help to ease the work of the management or cashier of the business to do transactions with their clients. It also helps to store the transaction details and retrieve the transaction records without hassle.

About the Simple Cashiering System

This project was developed using PHP and SQLite Database. It has 2 types of system users which are the Admin and Cashier. The admin is in charge of managing the list of users and product lists. He/She also has access to manage all the features and functionalities that this project has. The Cashier user role/type is only allowed to manage the POS Side of this simple project. Talking about the POS feature. the system user can easily add an Item by simply entering the product code and the system will provide an autocomplete widget for the item list according to entered code. The user can also automatically add the item quantity while selecting the item. To do this, the user must include the item quantity before the product code is separated by the "*". The POS system has also a feature that the user can manage a discount for their customer in each transaction process.

I developed this project using the following:

  • XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7
  • PHP Language
  • SQLite Database
  • HTML
  • CSS
  • JavaScript
  • jQuery
  • jQuery-UI
  • Ajax
  • Bootstrap

Features

Admin Panel

  • Secure Login/Logout
  • Manage Product Lis
  • Manage User Lis
  • Create Transaction
  • View Transaction Details
  • Delete Transaction
  • Manage Account Details

Staff Side

  • Secure Login/Logout
  • Create Transaction
  • Manage Account Details

System Snapshots of some Features

POS

Simple Cashiering System

Payment Tender Amount Modal

Simple Cashiering System

Transaction Details Modal

Simple Cashiering System

The Simple Cashiering System Project's Source Code is free to download on this website. Feel free to modify it the way you desire.

How to Run ??

Requirements

  • Download and Install any local web server such as XAMPP/WAMP.
  • Download the provided source code zip file. (download button is located below)

Installation/Setup

  1. Open your XAMPP/WAMP's php.ini file and uncomment the sqlite3 and save the file.
  2. Open your XAMPP/WAMP's Control Panel and start Apache.
  3. Extract the downloaded source code zip file.
  4. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
  5. Browse the Simple Cashiering System in a browser. i.e. http://localhost/cashiering/

Default Admin Access Information

Username: admin
Password: admin123

DEMO

That's it. You can now explore the features and functionalities of this Simple Cashiering System in PHP. I hope this project will help you with what you are looking for and you'll find something useful for your future projects.

Explore more on this website for more Free Source Codes and Tutorials.

Enjoy :)

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 SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

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.

Tags
php
SQLite Database
POS in PHP
point of sale
Sales Transaction processing System
PHP Project for Beginners
PHP Project for students
PHP and SQLite3 Integration
SQLite3
Bootstrap
jquery ajax
jQuery-UI

Comments

Submitted by oleteacher on Wed, 09/15/2021 - 03:32

Thank you for sharing! Use a lot of sqlite projects in the classroom since nearly impossible to run mysql on server.

Submitted by jigz (not verified) on Wed, 09/22/2021 - 10:10

Sir I would like to ask why when time is importing to Xampp the DB encounter an error hope can u help I'm new here. Thank you more power and sharing

Hello, you don't have to import the database since I used SQLite as the database in the project. See the Demo video, it includes where and how you can uncomment the SQLite library on your XAMPP. Thaks

Submitted by Anonymous (not verified) on Sat, 11/05/2022 - 07:25

Fatal error: Uncaught Error: Class "SQLite3" not found in C:\xampp\htdocs\cashiering\DBConnection.php:9 Stack trace: #0 C:\xampp\htdocs\cashiering\login.php(7): require_once() #1 {main} thrown in C:\xampp\htdocs\cashiering\DBConnection.php on line 9

Submitted by Anonymous (not verified) on Thu, 11/10/2022 - 18:41

Fatal error: Uncaught TypeError: number_format(): Argument #1 ($num) must be of type float, string given in C:\xampp\htdocs\cashiering\products.php:35 Stack trace: #0 C:\xampp\htdocs\cashiering\products.php(35): number_format('', 2) #1 C:\xampp\htdocs\cashiering\index.php(134): include('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\cashiering\products.php on line 35

Add new comment

About text formats