Content Management System in PHP & MySQL

Set up a blog cms project by configuring html structure, repositories, and local hosting, then build admin panels, categories, articles, and media management in a php and mysql workflow.

Convert existing pages into reusable PHP template files by migrating header, navigation, and footer into includes, updating pages to pull in these blocks for a simple back-end CMS.

Convert pages into reusable template files on the back end, centralizing navigation with a header navigation block. Apply the same steps across all pages and push updates from staging.

Plan and create a comprehensive database for a PHP and MySQL CMS, outlining tables and columns for users, posts, categories, comments, and pages, with slugs, timestamps, and relationships.

Update and test admin navigation across the CMS, linking the dashboard, categories, articles, comments, widgets, and settings while ensuring login and consistency in PHP and MySQL.

Use PHP and MySQL to implement a secure admin login by reusing existing login code, adding session handling, password hash verification, form validation, and access to the dashboard.

Implement a PHP and MySQL logout flow, manage user sessions, verify login status, and guard the dashboard with a check login mechanism.

Learn to build category management in a PHP and MySQL CMS, including adding, displaying, updating, deleting categories, and handling slug, description, and validation.

Learn to build a PHP and MySQL content management flow: create an article form with validation, insert articles and categories, manage slugs and images, and handle errors.

Learn to view articles in a php and mysql content management system by joining posts, categories, and images, displaying titles, dates, authors, and status with admin edit options.

Learn to implement a reusable delete mechanism for articles and categories in a PHP and MySQL CMS, using a single file, parameter-based table switching, and related record updates.

Update articles in a PHP and MySQL CMS by editing article content and metadata, including slug, status, and categories, with insert and update queries.

Learn to display pages from the pages table in a content management system, update the pages schema with slug, date, and status, and implement edit, delete, and author display logic.

Delete pages with a single delete page, update the dashboard, and manage pages and articles in a PHP and MySQL CMS, while addressing errors and safeguards.

Learn to update content pages in a PHP & MySQL CMS by editing article and editorial pages, using a form to update title, slug, content, status, and page order.

Add users in a content management system using PHP and MySQL by validating form inputs, checking username and email uniqueness, hashing passwords, inserting records, and redirecting to the user list.

View users page displays user data from a PHP and MySQL CMS, including full name, email, and article counts, with login and database connections.

Explore implementing delete operations for widgets in a PHP and MySQL CMS, including delete links, item removal, and updating the widget table.

Update widgets in a php and mysql content management system by editing widget data and displaying updates in forms. Push edits to staging and sync database values.

Create the blog home page in a PHP & MySQL CMS by connecting to the database, fetching posts with a select query, and displaying titles, content, and timestamps.

Explore how to integrate blog categories into navigation using PHP and MySQL, including fetching categories with a select query, displaying category titles, and updating navigation in a CMS workflow.

Learn to display article images in a PHP and MySQL CMS by checking image fields, handling placeholders, uploading images, and retrieving post image data from the database.

Build a blog single article page in PHP and MySQL by connecting to the database, fetching a post, and displaying its title, content, author, date, and image placeholder.

Explore how to build blog widgets in a PHP and MySQL CMS by rendering a sidebar with category-based widgets, dynamic blocks, and index and single page queries.

Create and display a blog page within the content management system, including a single article view, updating page data in the database, and temporarily disabling comments.

Display uploaded images on the view articles page by checking for a non-empty post_pic field and showing the image when present, with a placeholder on pages lacking an image.

Display and manage article images on the edit page by checking database existence, showing the image, and enabling deletion and reupload for admins.

Delete the article image on the edit page by unlinking the file when present, updating the article's image fields and timestamps, and validating image existence in the admin media workflow.

Reuse the article image upload flow to re-upload a picture on the edit article page using multipart form data and validate image input while updating title, content, slug, and category.

Learn to implement image upload on add and edit pages in a PHP MySQL CMS, with multipart form data handling, file validation, and database updates for pages and media.

Display the author name on a PHP and MySQL view page by selecting the username from the users table and linking it to the admin edit screen.

Learn to display article categories by joining the post_categories and categories tables, retrieving category names for each article, and rendering them on the view articles page.

Learn to build a dynamic edit widget page by selecting widget type with radio buttons and generating a 1-10 order value via a loop, pulling existing types from the database.