Create a CRUD appointment book using php and MySql.
Budget: $30 – $250 USD
We will send to you a part of the app that we are developing. Your job will be to make the appointment schedule on the apps-calendar.html page.
The apps-calendar.html page contains an example of what it should look like when done. Use this page to make any necessary modifications. Of course the .html extension of the page should be changed to .php
The assets folder includes the files with which our app works. Please do not modify any files in this folder except the assets / js / pages / demo.calendar.js file. You can make all the necessary modifications in this file or if you need it you can create more files inside the assets / js / pages / folder but not in any other folder.
The modal window that the user will see must include the fields that you will find in the sql file that we attach, the title of these fields in the modal window will be the following:
FIELD | TITLE IN MODAL WINDOW (if aplicable)
-----------------------------------------------------------------
idcita | Hidden from user (AUTO_INCREMENT)
horacita | automatic when dragging
diacita | automatic when dragging
asuntocita | Asunto
pacCita | Paciente
telCita | Teléfono
username | Hidden from the user (This is a $ _SESSION variable)
group_id | Hidden from user (This is a $ _SESSION variable)
This work should be done using:
Bootstrap 4.4.1, HTML5, CSS3, jQuery (Already included in the app)
PHP 8 MySQLi (object-oriented, don't use procedures)
MySQL Server version: 5.6.51-cll-lve
Fullcalendar (Already included in the app, see https://fullcalendar.io/)
One last matter, the calendar must be configured in Spanish (locale - es)
Thanks in advance
The apps-calendar.html page contains an example of what it should look like when done. Use this page to make any necessary modifications. Of course the .html extension of the page should be changed to .php
The assets folder includes the files with which our app works. Please do not modify any files in this folder except the assets / js / pages / demo.calendar.js file. You can make all the necessary modifications in this file or if you need it you can create more files inside the assets / js / pages / folder but not in any other folder.
The modal window that the user will see must include the fields that you will find in the sql file that we attach, the title of these fields in the modal window will be the following:
FIELD | TITLE IN MODAL WINDOW (if aplicable)
-----------------------------------------------------------------
idcita | Hidden from user (AUTO_INCREMENT)
horacita | automatic when dragging
diacita | automatic when dragging
asuntocita | Asunto
pacCita | Paciente
telCita | Teléfono
username | Hidden from the user (This is a $ _SESSION variable)
group_id | Hidden from user (This is a $ _SESSION variable)
This work should be done using:
Bootstrap 4.4.1, HTML5, CSS3, jQuery (Already included in the app)
PHP 8 MySQLi (object-oriented, don't use procedures)
MySQL Server version: 5.6.51-cll-lve
Fullcalendar (Already included in the app, see https://fullcalendar.io/)
One last matter, the calendar must be configured in Spanish (locale - es)
Thanks in advance