PHP with MySQL: Build 5 PHP and MySQL Projects

Install and configure XAMPP on a virtual machine by downloading from Apache Friends, selecting PHP, MySQL, and phpMyAdmin, starting the control panel, and verifying ports such as 3306.

Watch two videos showing how to install Sublime and Visual Studio Code, with guidance that either editor works for all projects and there is no difference between them.

Install Visual Studio Code on Windows by downloading and running the installer, then open the editor to start coding. Other text editors also work for PHP projects.

Install and set up the Sublime Text editor on a virtual machine, download from the Sublime Text site, run the installer, and locate the open files panel to begin coding.

Learn to build a PHP with MySQL authentication system by following along, using MySQL, bootstrap, and basic HTML and CSS for styling.

Access the resources to download the HTML files and bootstrap code for this project, then keep going with the PHP with MySQL course.

This lecture shows how to create a config.php to connect to a local MySQL database with PDO, defining host, DB name, user, and password, then testing the connection.

Build a registration page that processes a post form, validates inputs, and inserts a new user into a MySQL table using a prepared statement and password hashing.

Learn how to implement user login with PHP and MySQL by collecting email and password, querying with PDO, verifying the password hash with password_verify, and handling login flow.

Manage PHP user sessions by starting sessions, displaying the username when logged in, hiding login and register links, and logging out by destroying the session and redirecting home.

Set up a PHP and MySQL project by establishing a database connection with PDO, localhost, and a database name. Create a tasks table with id, task name, and current timestamp.

Learn to insert form data into a MySQL database with PHP by creating a post-backed index file, establishing a connection, crafting a prepared insert statement, and displaying results.

Shows inserting data with prepared statements and post-submit checks, building insert.php, redirecting to index, and looping through all records to display them in a table with object fetch.

Learn to delete a MySQL record from a PHP app by passing the record id via a link, validating it, executing delete from posts where id, and returning to index.

Add an update page in a PHP and MySQL project, fetch the target record by ID, pre-fill the form, and execute the update query to save changes.

Configure the PHP project with a config file for the database connection and error handling using try/catch blocks, and use phpMyAdmin to create a local database named short touch URLs.

Insert user-provided URLs into a urls table in a MySQL database using PDO, and display both the original and shortened URLs with a clicks counter for each entry.

Learn to create a simple URL shortener with PHP and MySQL, display a short link, pass an ID, query the database, and redirect users back to the original URL.

Increment a link’s click count by executing an update query in PHP with MySQL, using the link’s id to update the clicks value in the database.

Learn to increment click counts by using a jQuery click handler attached to an element ID, and a setInterval that refreshes the body of index.php every 5 seconds.

The instructor will upload the final version of the project code to the video’s resources section for students to review and validate their work, encouraging continued learning.

Start a photo gallery project with a simple template, featuring an index and a photo detail page, plus a create form with title, description, file input, and authentication.

Set up and integrate an authentication system into a new PHP project by importing login, register, and config files, creating a shared header, and testing login, register, and create pages.

Set up the project configuration and database, create a users table, implement register and login flows, and manage sessions to conditionally display navigation links and protect the create page.

Build an image posting feature by creating an images table, validating inputs, uploading and moving a file, and inserting title, description, image, and username with a prepared statement.

Display gallery images on the home page by querying the database, fetching results as objects, looping through rows, and linking each image to its photo detail page using its id.

Click a gallery image to view its details on a dynamic PHP page that uses the image id to fetch and display the title, image, and description, with date formatting.

Learn to display gallery details in PHP with MySQL by listing images, truncating descriptions with substr, validating forms with bootstrap alerts, and excluding the current image using an id check.

Learn to send emails in php using the php mailer, configure smtp with gmail, set sender and recipient, compose html messages, and handle errors.

Implement a PHP contact form to send emails from a chosen address. Build a bootstrap-styled form with name, email, subject, and message, and process submission on the same page.