Build Complete CMS Blog in PHP MySQL Bootstrap & PDO

Install Xampp on a virtual machine by downloading from Apache Friends, selecting a recent version, and installing PHP, MySQL, and phpMyAdmin; launch the control panel and start Apache and MySQL.

Install Visual Studio Code by downloading for Windows and installing to start coding; the video notes that other editors like Sublime or text plus can also be used.

Explore the design of a clean blog interface with home and create pages, user login and registration, post creation with images, and a secure PHP and MySQL backend using PDO.

Create a config folder and config.php to hold host, database name, user, and password, then connect with PDO inside a try-catch and set the error mode to exception.

Learn to build a register page in a PHP MySQL app by creating reusable header and includes, validating input, and inserting hashed passwords into a users table with PDO.

Fix the error caused by missing two equals signs for the password, which led to database value errors on the register page.

Learn to build a PHP login page with PDO: validate inputs, query users by email, verify the password hash with password_verify, and redirect to the index.

Learn to start a PHP session at the top of each page, store the username in a session variable, and redirect to the index after login, wiring header and assets.

Demonstrates logging out and destroying the PHP session, updating the header to show profile and log out links via a Bootstrap dropdown, and redirecting to index.

Learn how to log out, destroy the session, and prevent access to login or register pages when a user is already signed in, ensuring redirects to the index page.

Create posts in a PHP MySQL blog by building the create page, validating inputs, handling image uploads to an images folder, and inserting into the posts table with prepared statements.

Learn how to display blog posts on the index page using php, mysql, bootstrap, and pdo, including showing the post author username and executing queries.

Show how to view a single post by reading the post id from the get superglobal, query by id, and render title, subtitle, body, user name, date, and image.

Learn to implement a delete button for posts in a PHP MySQL CMS by passing the post id via GET, executing a prepared delete, and redirecting to index.

Create an update page in PHP that uses two queries to fetch post data by ID and update the title, subtitle, body, and image via a form.

Delete posts and automatically remove their images using a select query to fetch the image name, and update images by replacing the file and unlinking the old one.

Enforce post ownership by comparing the session user id with each post's user id, hiding edit and delete buttons for others and blocking direct access to update or delete pages.

Create a categories table in PHP MySQL, insert dummy rows, and display category names on the index with Bootstrap alerts and links to category.php within the categories folder.

Learn to add a category id to posts, populate a bootstrap select with categories, and fetch posts by category to build a complete php mysql bootstrap blog.

Show posts by category by joining categories and posts tables with inner join, filter by category id, and display title, subtitle, user name, and created date on the category page.

Build a profile page in PHP MySQL that lets users update their username and email via a simple form while ensuring they can only access their own profile with session.

Refine the user side of a PHP MySQL Bootstrap PDO blog by validating login and registration, handling email and password errors, and implementing alerts, sessions, redirects to index and categories.

Refine the user side by implementing robust validation for get requests, secure links, and 404 redirects using bootstrap designs, while finishing profile and category flows and limiting posts.

Designs and builds the admin panel for a CMS blog, enabling login, admin creation, and management of categories and posts with Bootstrap and PHP.

Learn to build an admin login page by creating an admins table and a PHP login form that authenticates against the database and prepares session handling in the admin panel.

Set up and manage sessions to control admin access, implement login and logout with session variables, and conditionally display or hide navigation while redirecting unauthenticated users.

Display dashboard metrics by counting admins, categories, and posts using PHP PDO queries, fetch results, and echo the numbers on the CMS index for a clean, informative admin panel.

Display and manage admins in a PHP CMS by loading a header and config, running a query to fetch admins, and rendering results while preparing for an admin creation page.

Create an admin registration page in PHP and MySQL, with a form for admin name, email, and password, hashing the password, inserting into admins, and enabling admin login and session.

Learn to display and manage categories in the admin panel, update and delete categories, and render them dynamically with for each loops.

Create categories using a simple form that posts the name and inserts it into the categories table, updating the admin panel's category list.

Delete categories in the admin panel by selecting a category id from show categories, executing a delete query with PDO in PHP, and verifying the result in the CMS blog.

Update categories by editing the category name field, binding the category ID, and using a prepared update query, then return to the categories list to verify.