Cashier Queuing System with Live Monitor and Voice Notification in PHP and SQLite Free Source Code

Language

This is a Cashier Queuing System with a Live Monitor and Voice Notification. This web-application project manage the flow of the business cashier's clients queue. This can help to ease the queuing process of the said business operation. This project has 4 modules which are the Admin, Cashier, Customer/Client, and Live Monitor for Queued Clients or Customer. The project has a simple a small scope but I think can be helpful for businesses to do an effective workflow. This project has a simple user interface and user-friendly functionalities.

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
  • Ajax
  • Bootstrap
  • Sockets
  • SpeechSynthesisUtterance
  • and more...

About the Cashier Queuing System with Live Monitor and Voice Notification

As I have mentioned above, this project has 4 modules. The Admin Module is the side of the system where the management can manage the list of cashiers and manage the video to display on the monitor it could be an Ad or something about the business that will loop in the monitor. The Cashier Module is the side of the system that will be managed by the Cashiers. The cashier can get the next queued number and notify which triggers the monitor to announce the queued number to proceed to the certain counter. The Customer Module is the side of the system where the clients/customers generate their queue number.

Project Features

Admin Side

  • Secure Login/Logout
  • Home Page
  • Upload Video
  • Manage Cashier List (CRUD)
  • Manage Admin User List (CRUD)
  • Manage Account Credentials

Cashier-Side

  • Secure Login/Logout
  • Display Serving Number
  • Get Next Queued Client
  • Notify Serving Client
  • Manage Account Credentials

Customer

  • Generate Queue Number
  • Print Queue Number

Live Monitoring

  • Display Serving Number for each Cashier Counter
  • Loop Display of uploaded video

Some of the System Snapshots

Live Monitor

Cashier Queuing System with Live Monitor and Voice Notification

Cashier Page

Cashier Queuing System with Live Monitor and Voice Notification

Customer Queue Registration

Cashier Queuing System with Live Monitor and Voice Notification

Customer Generated Queue

Cashier Queuing System with Live Monitor and Voice Notification

Admin Cashier List

Cashier Queuing System with Live Monitor and Voice Notification

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 sockets. Then, 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. Open your Command Prompt and redirect the current directory to your Source Code Path.
  6. Run this command "php php-sockets.php".
  7. Browse the Cashier Queuing System with Live Monitor and Voice Notification in a browser. i.e. http://localhost/queuing/.

Default Admin Access

Username: admin
Password: admin123

DEMO VIDEO

That's it! You can now explore the features and functionalities of this Cashier Queuing System with Live Monitor and Voice Notification project in PHP and SQLite Database. I hope this will help you with what you are looking for and you'll find something useful for your future PHP 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.

Comments

This is a really good project for the classroom, thank you for sharing!

Monitoring part doesn't work. I follow all the steps at demo. Please help.

This is a really good project but the Live monitoring part doesn't work. Please advise

Hi, this is the error I am getting when I run the 'php php-sockets.php' command in cmd, Please kindly help rectify this. PHP Fatal error: Uncaught Error: Call to undefined function socket_create() in C:\xampp\htdocs\queuing\php-sockets.php:92 Stack trace: #0 {main} thrown in C:\xampp\htdocs\queuing\php-sockets.php on line 92

Nice project

Hi, this is the error I am getting when I run the 'php php-sockets.php' command in cmd, Please kindly help rectify this. PHP Warning: socket_bind(): Host lookup failed [11001]: No such host is known in C:\xampp\htdocs\tugas-akhir\nomor-antrian\php-sockets.php on line 94 Warning: socket_bind(): Host lookup failed [11001]: No such host is known in C:\xampp\htdocs\tugas-akhir\nomor-antrian\php-sockets.php on line 94 PHP Warning: socket_listen(): unable to listen on socket [10022]: An invalid argument was supplied in C:\xampp\htdocs\tugas-akhir\nomor-antrian\php-sockets.php on line 95 Warning: socket_listen(): unable to listen on socket [10022]: An invalid argument was supplied in C:\xampp\htdocs\tugas-akhir\nomor-antrian\php-sockets.php on line 95

this is really nice work but, after i get que numbers and logged in trying the different cashiers number, it says that there is no que number after after clicking the button NEXT, but i tried many samples to get que numbers

C:\xampp\htdocs\queuing>php php-socket.php 'php' is not recognized as an internal or external command, operable program or batch file.

"php" is not an internal or external command executable by an open or batch file.

"php" is not an internal or external command executable by an open or batch file.

Hi this is a nice project . how can i change the "cashier" with "counter" in monitoring window


C:\xampp\htdocs\queuing>php php-sockets.php
PHP Warning:  socket_bind(): Host lookup failed [11001]: No such host is known in C:\xampp\htdocs\queuing\php-sockets.php on line 94

Warning: socket_bind(): Host lookup failed [11001]: No such host is known in C:\xampp\htdocs\queuing\php-sockets.php on line 94
PHP Warning:  socket_listen(): unable to listen on socket [10022]: An invalid argument was supplied in C:\xampp\htdocs\queuing\php-sockets.php on line 95

Warning: socket_listen(): unable to listen on socket [10022]: An invalid argument was supplied in C:\xampp\htdocs\queuing\php-sockets.php on line 95

C:\xampp\htdocs\queuing>php php-sockets.php PHP Warning: socket_bind(): Host lookup failed [11001]: No such host is known in C:\xampp\htdocs\queuing\php-sockets.php on line 94 Warning: socket_bind(): Host lookup failed [11001]: No such host is known in C:\xampp\htdocs\queuing\php-sockets.php on line 94 PHP Warning: socket_listen(): unable to listen on socket [10022]: An invalid argument was supplied in C:\xampp\htdocs\queuing\php-sockets.php on line 95 Warning: socket_listen(): unable to listen on socket [10022]: An invalid argument was supplied in C:\xampp\htdocs\queuing\php-sockets.php on line 95

Please am getting an error Fatal error: Class 'SQLite3' not found in C:\wamp\www\queuing\DBConnection.php on line 11

In reply to by Wisdom Ovie (not verified)

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

" 'php' is not recognized as an internal or external command, operable program or batch file." not appear upon calling the qued number, please help thanks

and amazing project, but im getting this error and idk why, im using the xampp (localhost), how can i solve this PLEEEEASEEEE PHP Warning: socket_bind(): Host lookup failed [11001]: No such host is known in C:\xampp\htdocs\monitor\php-sockets.php on line 94 Warning: socket_bind(): Host lookup failed [11001]: Host desconocido in C:\xampp\htdocs\monitor\php-sockets.php on line 94 PHP Warning: socket_listen(): unable to listen on socket [10022]: An invalid argument was supplied in C:\xampp\htdocs\monitor\php-sockets.php on line 95 Warning: socket_listen(): unable to listen on socket [10022]: An invalid argument was supplied in C:\xampp\htdocs\queuing\php-sockets.php on line 95

In reply to by jbs (not verified)

my whatsapp number +88016731647032

thanks, Its working good, relay very useful for learning

Good Day! IS there a version for Mysql for this? Tnx in advance, by the way great work!

Hi, I am receiving the following when opening the link 'Warning: mkdir(): Permission denied in C:\xampp\htdocs\queuing\DBConnection.php on line 3 Fatal error: Uncaught Exception: Unable to expand filepath in C:\xampp\htdocs\queuing\DBConnection.php:14 Stack trace: #0 C:\xampp\htdocs\queuing\DBConnection.php(14): SQLite3->open('C:\\xampp\\htdocs...') #1 C:\xampp\htdocs\queuing\DBConnection.php(69): DBConnection->__construct() #2 C:\xampp\htdocs\queuing\login.php(7): require_once('C:\\xampp\\htdocs...') #3 {main} thrown in C:\xampp\htdocs\queuing\DBConnection.php on line 14'

there is a problem with your cashier side, when you not logout and close the browser you cannot login anymore it says cashier in use how to solve this problem?

'php' error

i get an error importing the database it says #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SQLite format 3' at line 1

I have a question, can this system runs offline? And please can you answer it immediately because tomorrow will be our defense

PLEASE REPLY

Warning: mkdir(): Permission denied in C:\xampp\htdocs\queuing\DBConnection.php on line 3 Fatal error: Uncaught Exception: Unable to expand filepath in C:\xampp\htdocs\queuing\DBConnection.php:14 Stack trace: #0 C:\xampp\htdocs\queuing\DBConnection.php(14): SQLite3->open('C:\\xampp\\htdocs...') #1 C:\xampp\htdocs\queuing\DBConnection.php(69): DBConnection->__construct() #2 C:\xampp\htdocs\queuing\login.php(7): require_once('C:\\xampp\\htdocs...') #3 {main} thrown in C:\xampp\htdocs\queuing\DBConnection.php on line 14

Hi, may i know how to edit the date? and the monitoring mode? thank a lot

how to chage the date and reset in number 1

Add new comment