This is learning repository for using php with mysql.
use the following links:
https://www.tutorialspoint.com/php/php_and_mysql.htm
https://www.w3schools.com/php/php_mysql_create.asp
use the below link to work with chart via php:
https://phppot.com/php/creating-dynamic-data-graph-using-php-and-chart-js/
queries:
https://www.sqltutorial.org/sql-rollup/
chartjs sql:
https://phppot.com/php/creating-dynamic-data-graph-using-php-and-chart-js/
Steps: 1)connection and create db by php
2)select a database and create table in it
3)import sql file for running many queries
4)drop table or the complete db
5)front-end inserting-record
6)back-end inserting-record