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.

Install the xampp server on a virtual machine, enable PHP and MySQL, and use the control panel to run the server in the background and access phpMyAdmin.

Learn how to install Visual Studio Code on Windows, accept the license, create a desktop shortcut, and launch the editor to begin coding PHP and MySQL projects.

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.

Download the bootstrap code I designed and the HTML files from the resources to start building PHP with MySQL projects.

Create a reusable config.php to establish a MySQL database connection in PHP, by setting host, db name, user, and password, and verify the connection with a test.

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.

Start and manage PHP sessions to show the username on the navigation bar after login, hide login and register, and destroy sessions on logout with redirects to the index page.

Create a simple blog post system with comments on top of your authentication system, using Ajax and jQuery for posts and data display.

Create a post form with title and body plus a hidden session username; submit to a create post handler to insert into the posts table with a timestamp.

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.

Show a single post on its own page, validate login for the create page, and fetch by id to display the full post with basic styling.

Build a forum feature by adding comments to each post using Ajax and jQuery, posting without page refresh, and handling post ID, username, and comment data.

Show how to submit comments with ajax, reset inputs, and display a success alert, then dynamically fetch and display all comments for a post in real time every few seconds.

Delete a comment using Ajax and jQuery by sending the comment id to PHP script, performing a delete from comments where id=, and updating the UI with a success message.

Fix the bug so only the comment creator sees the delete button by comparing the logged-in username to the comment's username, and display nothing otherwise.

fix a bug by checking that the session username is set, resolve undefined index username error, and verify the fix by logging in and refreshing.

Develop a simple rating system inside a blog post using Ajax and jQuery, by integrating a rating plugin, including CSS and scripts, and wiring up PHP.

Submit post ratings via ajax to a php mysql backend, inserting post_id and rating into a ratings table with a timestamp for display on refresh.

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.

Fix bugs in a PHP and MySQL project by linking ratings to the user id stored in the session, ensuring per-user, per-post ratings, and updating queries to check both ids.

Learn how an API acts as a middleman between your app and services, delivering data through requests and responses; explore public, SOAP, and private API types with real-world examples.

Build a weather app with PHP and MySQL by submitting a city, fetching data from open weather map, decoding json, and displaying the city's weather and the temperature in celsius.

Access the final version of the PHP with MySQL project code from the video resources section to validate your work and keep learning.

Build a real-world like and dislike system using Ajax and jQuery in a PHP with MySQL project, creating a database-backed posts feed with dynamic like counts and a config.php connection.

Learn to implement a like and dislike toggle using Ajax in a PHP and MySQL project, updating post likes by ID with a post request and dynamic front-end updates.

Learn to implement a PHP and MySQL like/dislike toggle for posts, with jQuery updating the button text and likes count in real time.

Set up a PHP project, install a PHP pdf library with composer, and configure vendor autoload to generate a PDF CV from an HTML form.

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.

Learn to generate QR codes in a PHP project using a composer package, autoloading vendor files, and configuring encoding, image output, and dynamic data for practical authentication use cases.

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.

Learn to implement a live search feature with PHP and MySQL using Ajax and jQuery, and the LIKE operator, including input handling and dynamic results.

Finish the search feature in the PHP and MySQL project by implementing ajax-driven filtering that displays post titles and bodies and hides non-post content across pages.