Covid-19
The website was a class project that was made to implement the use of PHP, MySQL, JQuery and Ajax and the consumption of an external database to show the statistics of covid-19 in the world.
Task
Author: Sebastian Marmol
This project is a website that has the purpose of putting into practice the use of PHP, MySQL, JQuery and Ajax and the consumption of external database to show the covid-19 statistics in the world through graphs and percentage values.
PHP: language used to make dynamic websites
MySQL: database management system
Ajax: it was used to make asynchronous requests to the database.
The main objective was to make a dynamic website with PHP and make asynchronous queries (not reload the page every time there is a new query to the server).
Data from the repository was used. GitHub : pomber/covid19: JSON time-series of coronavirus cases.
was used PHP for parts of login, registration and dashboard in which all the information is shown, as well as the query functions, connection to the database and everything that the server side entails.
On the other hand, to make it a website that is not constantly reloaded, it was used Ajax, asynchronous query methods and the data it received from the server was used to display the graphs and whatever is required.
An example of a query for load cases with an Ajax query:
The result of the project was as follows and I show a brief review of its operation. To be able to use it you can create your own user or enter with the user admin and password 1234.
Note. The data is outdated according to the last record of the used repository.
The development of the website focused mainly on consuming the external database and displaying the data dynamically without the need for constant page reloads.
project experience, mainly, with wordpress and use of maps, booking, informative and corporate.
