PHP with MySQL: Build 7 PHP and MySQL Projects

Learn to install the exam and VTS code for PHP and MySQL projects, and use video speed controls to match your learning pace.

Install the xampp server on your virtual machine by downloading from Apache Friends, choosing a version (7.4.1). Start the control panel and enable apache and mysql to use phpmyadmin.

Learn to install Visual Studio Code on Windows, create a desktop icon, and open the editor to start coding for PHP and MySQL projects; any text editor will work.

Create a PHP and MySQL project by configuring config.php for database connection, handling errors with try/catch, and creating the short URLs database in phpMyAdmin, then include config in index.

Learn to build a PHP with MySQL URL shortener: insert URLs via a post form using PDO, store in a URLs table, display original and short URLs, and track clicks.

Create and display a short URL using PHP and MySQL, storing the short link with an ID and redirecting users to the original URL when clicked.

Increment link clicks by one with a PHP MySQL update query, using a data object to fetch the current value and update the row by its id.

Use jQuery to increment clicks by binding a click event to an element id and refreshing the index.php page every five seconds with setInterval.

Watch as the instructor uploads the final version of the project code to the resources section, giving students access to the full PHP and MySQL project for review and validation.

Learn how to send emails from a PHP app using the PHP Mailer library with Gmail SMTP, including setup, configuration, and debugging.

Learn to build and process a PHP form to send emails from a chosen address, using HTML inputs and Bootstrap styling.

Follow along as we create an authentication system using PHP and MySQL, with bootstrap tips to get you started.

Check the video resources to access the bootstrap code and HTML files designed for this course, and use these files to start building the PHP and MySQL projects.

Set up a reusable config.php to connect PHP to MySQL using PDO, defining host, database name, user, and password, and test the connection before building the registration pages.

Create a PHP registration page that processes a POST form, validates inputs, inserts a new user into a MySQL users table with prepared statements, and hashes the password for security.

Implement login logic using PHP with PDO, validating email and password, querying users, fetching row data, and verifying the hash with password_verify; redirects to the index page on success.

Start a PHP session, set and echo the username on the index page, and toggle login, register, and home links in the navbar based on session state.

Build a simple blog post system with comments on top of the authentication system, using Ajax and jQuery for form submissions, turning it into a basic CMS.

Build a post creation form with title, body, and a hidden user name from the session; submit to create a post stored with timestamp and viewable on the index page.

Display posts on the index page using Bootstrap cards and a simple query from posts. Preview the title and body, and link to a show page by ID.

Display each post on a dedicated page by retrieving its id via the query string, render the full post body, and enforce login by restricting create page access.

build a forum comments feature using ajax and jquery in a php with mysql project, sending username, post id, and comment to a php endpoint and updating without page reload.

Display comments for a post in real time via ajax and set interval, showing username and comment while clearing inputs and presenting a success alert after insertion without page refresh.

Delete a comment with Ajax and jQuery by sending the comment id to a delete comments endpoint. Implement a button that passes the id and shows a success message.

Fixes a bug that showed the delete button for comments to other users by comparing the session username to the comment author and displaying the delete option for the creator.

Fix a PHP session bug by adding an isset check for the username to prevent undefined index when the session is missing, then verify the login flow works.

Get hands-on with a jQuery ajax rating system by downloading and integrating a rating plugin into your blog post, including the script, styles, and markup to render stars.

Insert post ratings into a MySQL database using PHP and Ajax, storing post_id and rating in a ratings table with a timestamp via a jQuery form submission.

Display and update post ratings by fetching the initial rating from the database, defaulting to zero when missing, and showing the rating for each post on page load.

Fixes a bug by deleting the previous rating for a post before inserting a new one, preventing stale data. Uses a prepared delete query on post_id to update the rating.

Fix rating data in this PHP with MySQL project by tying ratings to both post id and user id via sessions, ensuring per-user ratings update correctly.

Build a live search feature in a PHP and MySQL project using ajax. Use a header search form and a footer script for real-time results with like and wildcards.

Finish the live search feature in a PHP and MySQL app by implementing search filtering, hiding non-matching posts with AJAX, and styling results across the header.

Understand what an API is as a middleman handling requests and responses, and why developers use public, device, and enterprise APIs for affordable access to logins, payments, and maps.

Build a weather app in php by submitting a city to fetch weather from the open weather api, decode json, convert kelvin to celsius, and display the description and temperature.