For this project that I created, SQL and PHP go hand in hand by the PHP code taking user input and inserting data into the SQL database to save important information from the site. This method of data collection and storage is widely used in many different fields.
https://sphart.soisweb.uwm.edu/infost440/final_project/index.php
This site was created using PHP, HTML, some CSS, and connection to a SQL database to store data about users.
The blog includes a login screen for users and an admin who can create, update, or delete their blog posts and view comments made by regular users. New users can register for an “account,” where a connected SQL database will store their username, name, birthday, and encrypted password for security. Regular users can comment on the admin’s blog posts.
The back-end and front-end code where created by me.