Scan barcodes and automatically enter data to sql database. View and search your entries in an easy-to-read table.
Access Scan Mode by clicking the "Scan Mode" Button on the main screen.
Then to enter data simply start scanning. The text field is automatically set onFocus on each page load so there is no need to click the text box every time. If using a scanner to enter data, typically they pass the data with an addition bit of information the automatically "hits" enter or clrf. This allows for each scan to automatically send the data to the database.
With each entry the database automatically records the date and time the entry was submitted and has an auto-incrementing value called id that serves the purpose of a unique entry id.
Access View Mode by clicking the "View Mode" Button on the main screen.
In view mode, users can view all the data in the database with up to date entries. All in an easy to digest table. The table is organized in chronological order. However, in the case that a user may need to find past entries a user has the ability to search any content in the table. Either by id,user,or date/time.
Webapp is written in PHP. PHP requires to live on a server or local server like MAMP in order to function properly.
The Application has Host: Localhost Port: 3308 DBname: scanApp ,and Table: entries harcoded. Meaning if your setting are any different they must be changed in designated area with view.php and scan.php
- Create Database named "scanApp" (ie PHPMyAdmin Database)
- Import entries.sql file located in resources folder
- Visit index.html to use