PHP with MySQL: Build 8 PHP and MySQL Projects

Install Exame, a server runner for your PHP and MySQL projects. If you already have Exame and the server software, skip the next two videos and keep learning.

Learn to build an authentication system using PHP and MySQL, with Bootstrap and basic HTML and CSS; follow along to implement the project in this course.

Build a PHP registration page that processes a form with post data, validates inputs, inserts into a users table using prepared statements, and hashes passwords for security.

Implement a login workflow using PHP and MySQL, validating email and password with PDO, querying the users table, fetching results, verifying the password with password_verify, and redirecting to index page.

Display posts on the index page using bootstrap cards, fetch posts from the database with PHP, show title and body previews, and link to a show page by post id.

Grab the initial rating from the database and display it on page load, then fetch and echo ratings for each post, defaulting to zero when missing.

Learn to fix bugs by deleting the old rating before inserting a new one when a user updates a post, using a post-id based delete query.

Build a dynamic CV builder with PHP by creating an HTML form and a CSS CV template, then process submissions with PHP to generate and download a PDF.

Generate dynamic qr codes with php and mysql by submitting a form to a processing script, which saves uniquely named images in a folder and returns to the index.