Build 13 Projects with PHP MySQL Bootstrap and PDO

Install XAMPP to set up a local development server with Apache, MySQL, PHP, and phpMyAdmin; configure components, start the control panel, and verify localhost with index.php.

Learn how to install Visual Studio Code on Windows, download from the official site, install, and set up a coding environment with alternatives like PhpStorm, Sublime Text, or Notepad++.

Download the included project files from the resources section and start building this PayPal payment project, gaining hands-on understanding of how PayPal payments work within the setup.

Create a PHP config file to connect to a MySQL database using PDO, defining host, db name, user, and password, and test the connection.

Fetch and display products from the database on the index page using the config file, PDO queries, and a foreach loop to render image, title, price, and description.

Set up a PayPal checkout button with sandbox accounts and a client ID, and test the flow in index.php and pay.php via the PayPal orders API for a $100 purchase.

Implement dynamic PayPal payments in PHP by passing a product id, fetching the price with a PDO query from the products table, and completing the purchase.

Locate the HTML and CSS form files in resources, then create a config.php for the database and test locally with phpMyAdmin to start the project.

Create an includes folder with header.php and footer.php to reduce duplicate code across index, post, and single pages, using PHP require to include them.

Create post form with title, author, category, and body; validate inputs with PHP, alert on empty fields, and execute a prepared insert into posts, then display on the index page.

Insert and display replies for posts by wiring a reply form in single.php, linking reply to its post_id with author_name and reply fields, and creating a replies table with created_at.

Learn to fetch all replies for a specific post using PHP and MySQL, querying replies by post_id, iterating results to access author name and created date.

Pull posts from database using the config, render them on index page by querying posts table and fetching all records, displaying each post's title, date created, author, and category.

Master a single join query to display posts with their reply counts using left join, group by, and aliases in a PHP MySQL app.

Build dynamic post pages by fetching single post data from a MySQL database with PHP, displaying title, body, date, author, and category, and show latest posts ordered by created_at.

Create and manage a categories table with auto-increment id, name, and timestamp, seed with sample data, and display the number of categories along with dynamic, data-driven category options in forms.

Finish the project by displaying post and reply counts, removing the member display, updating footer and queries, and fixing a fatal PHP error while refining the PHP code.

Set up a PHP PDO connection to MySQL, configure host, db name, user, and password, enable exception handling, and create tasks table with id, task name, and date default current_timestamp.

Create a PHP form on index.php, post data to the server, and insert a task into the todos table using a prepared statement after including connection.php.

Learn to handle form submissions and insert data with a prepare statement, create insert.php, and redirect to the index. Then loop through all tasks and display them in a table.

Learn to implement a delete feature in a PHP MySQL app by creating a delete page, passing the record id, and executing a prepared delete query.

Master update flow in PHP and MySQL: build an update page, fetch the record by ID, display it in a form, and execute an update query on the tasks table.

Master a PHP MySQL setup by configuring config.php, establishing a database connection with try-catch, and wiring index.php to use the short URLs database for insertion and retrieval.

Learn how to build a php mysql bootstrap page that inserts user submitted urls into a database and displays short urls with click counts.

Explore building a simple URL shortening feature using PHP and MySQL, displaying a short URL and its ID, then routing to the original link via the ID.

Increment each link's click count by retrieving a data instance of clicks and executing a prepared update query that adds one to the clicks field for the specific id.

Use jQuery document.ready to refresh the page every five seconds after clicking an element with a specific id, triggering a click count increment on index.php.

Learn to send emails from PHP using PHPMailer over Gmail SMTP, configure credentials, and test with a local project setup.

Learn to build and process a Bootstrap-styled email form in PHP, sending emails from index.php via POST and handling name, email, subject, and message inputs with dynamic sender details.

Build an authentication system by following along as you learn to use MySQL and PDO, with Bootstrap, HTML, and CSS in this intro project.

Access the video resources to obtain the HTML files and Bootstrap course materials, designed by the instructor, and start building the PHP MySQL PDO projects.

Create a config.php to connect to your local MySQL database using PDO, define the host, database name, username, and password, and verify the connection before building login and register pages.

Create and process a php registration page by validating post inputs, inserting into the users table with prepared statements, and hashing passwords for security.

Learn to implement a PHP login flow with PDO: validate inputs, query the users table by email, fetch the user, verify the password with password_verify, and handle login outcomes.

Start a PHP session at the top of pages, display the username on index.php when logged in, hide login and register links, and log out by destroying the session.

Build a comment system within a prior authentication-based blog posting setup, creating a simple CMS that supports posts and comments, using Ajax and jQuery for posting and data display.

Create posts using a PHP MySQL setup: build a form with title, body, and hidden username, store in a posts table with created_at, and connect via create.php and index.php.

Display posts on the index page with bootstrap cards, fetch all posts via SQL select, loop through results to show title and truncated body, and link each to show.php?id=

Show a single post on its own page by retrieving the post id and displaying the full post body with bootstrap styling, while enforcing login for creating posts.

Build a comments feature for a post using ajax and jquery, capturing username and post id, and inserting comments into a comments table via insert_comments.php.

Learn to display and insert comments for a post using ajax, reset inputs, and show a success alert, while fetching and rendering comments in real time for the selected post.

Learn how to delete user comments with ajax and jquery, sending the comment id to a PHP delete_comments.php endpoint, and update the page without reload with a success alert.

Fix the bug by checking the session username against the comment author in PHP, displaying the delete button only to the creator.

Fixes a bug by adding an isset session check for the username to prevent undefined index username, ensuring login works again in the PHP MySQL Bootstrap and PDO project.

Set up a blog post rating system using Ajax and jQuery by integrating a jQuery rating plugin, including css and markup, and previewing live star ratings in your project.

Insert the rating for each post via a form and Ajax, then store it in a ratings table with post_id and rating in PHP and MySQL.

Fetch and display ratings for each post in a PHP MySQL Bootstrap project, loading the initial rating on page load and defaulting missing ratings to zero.

Learn to fix bugs in a PHP and MySQL app by deleting old rating records for a post ID before inserting a new rating, ensuring accurate post ratings.

Fixes bugs in the ratings feature by tying ratings to both post id and user id via session data, ensuring per-user accuracy and safe inserts with prepared statements.