We will be running a badge scanning service at a convention with iPads and barcode scanners. We need to scan the barcode when a user is handed the bag into a field on the screen. Using PHP, the barcode field queries a database. If the record already exists, the background should change to red, and some text shown. If the record does not exist, the background should change to green and change text.
The process will be scan barcode -> query database -> change background & insert barcode into database -> scan new barcode.
This should be all one contained HTML/PHP page with AJAX changing the background and text. The data will be stored in a MySQL DB
The attached PPT file shows the final design.
The important this is that I need this to be finished in the next 4 hours :) so if anyone can help that would be great :)
If you have any questions, please let me know!