3 pages queue managing php web app (insert/view position/list records + ajax update)

Job ID: 35137074

Budget: $30 – $250 USD

I need a php web app to manage queues with 3 pages:

Page 1: /index.php

The page is a simple form, with a few validations, so the user can get in the queue:

Name: (DBColumn NOME, VARCHAR)
E-mail: (DBColumn EMAIL, VARCHAR, E-mail validation)
Cel Phone: (DBColumn CELULAR, VARCHAR, Phone validation with mask (##)-####-####)
Company: (DBColumn EMPRESA, VARCHAR, Optional)
Participation: (DBColumn TIPO, INT (but should rendered as 2 option boxes 1=Expositor, 2=Visitante)

After the user submit this form:
Make a Get request using some form values in the querystring like "https://exampleurl/send?number=CELULAR"
Insert the record into the MySQL DB table FILA and show page 2, with inserted id (Autonumber DBColumn = ID) at the querystring.

---------------------

Page 2: /fila/index.php?id={record_id}

A very simple page that shows a text:

Your Position is:
(Result of DB Query
SELECT COUNT(*) FROM FILA
WHERE TIPO=(SELECT TIPO FROM FILA WHERE ID = {id})
AND CHAMADO IS NULL
AND ATENDIDO IS NULL
AND CRIADO < (SELECT CRIADO FROM FILA WHERE ID = {id}
)

The page should be auto refreshed every 5 min.

-----------------------

Page 3: /fila_admin.php

For administrators... There is no need to login, authentication, etc.

A grid showing records of DB Table FILA. Columns:
Name: (DBColumn NOME)
Created: (DBColumn CRIADO)
Called: (DBColumn CHAMADO)
Call: Ajax Action Button -> Update record set CHAMADO = Now()
Confirm: Action Button -> Update record set ATENDIDO = Now()

The Call Ajax Action will also make a Get request using some form values in the querystring like "https://exampleurl/send?number=CELULAR"

Grid DB Query:
SELECT ID, NOME, CELULAR, CRIADO, CHAMADO
FROM FILA
WHERE ATENDIDO IS NULL
Related categories: PHP AJAX MySQL jQuery / Prototype React.js