Blogging System: A total Content Management System (C.M.S), also contains an Admin Panel which controls the whole dynamic process of this monolithic project.

What is a Blogging Systems

Are broadcast-style communications systems that enable authors to publish articles, opinions, or product reviews (known as posts), which can be delivered through stand-alone websites, email, feed syndication systems, and social networks. According to https://gartner.com

Blogging refers to writing, photography, and other media that's self-published online

What is a Content Management System (C.M.S)

A content management system is a software application that allows you to create and deliver digital content. A CMS lets you easily edit your digital experiences and then publish that experience to the web and other digital channels. According to https://business.adobe.com

How to setup this Project Database after downloading the XAMPP control Panel:

Start the XAMPP control panel.
Navigate to SQL_FILES folder
Open the content_management_system.sql file using a text editor, preferably, VS code.
Copy the whole content of the file.
On your browser, preferably google chrome, paste this http://localhost/phpmyadmin on the search tab.
Your background should look like the one below.

6. Click on the button SQL, you should see the exact type of image below.

Go back to step 1 and follow through till step 3, then paste the content into the SQL panel, which you just opened.
click Go which is on the bottom-right-corner of the SQL page.

Abbreviations that will be used and their meaning :

DB - Database

CRUD (Create Read Update Delete) system

UI/UX - User Interface / User Experience

How this project Admin Panel Functions

It has a Dashboard that shows the list below

i. It contains a Post Section

ii. It contains a Category Section

iii. It contains also a Comment in Section

iv. It also contains the User Section

Well Under the Dashboard are 4 sub-sections, which I have listed above with their Images.

Post Section.
Comments Section.
Users Section.
Categories Section.

Tools needed to get this Project Up and running are:

Browser, preferably - google chrome

Xampp Control Panel

Text Editor, preferably - Visual studio code

Steps to get the whole process started.

Open the Xampp control panel you downloaded, after installing it on the local machine.

click Apache: Start
click MySQL: Start
Download and install Visual Studio Code
Open or better still, run the visual studio code

clone this repository by running git clone https://github.com/Alpheus-godswill1/blogging_system3.git

Extensions that eased the process using VS code text editor on this project.

Bracket pair Coloriser
Emmet Live
Github themes
Vs Code great icons

Let's Start from the Backend to the Front End i.e from the Admin Panel to the Front display Page.

As I said earlier it contains several sections, which I listed above.
So I am going to explain, how I built each section, and what bugs I encountered, you will get to know the mindset behind each section and how I moved from one line of code to the completion of this amazing project.

Remember We are discussing the Admin Section.

Section 1 (CREATE ACCOUNT/SIGN UP PAGE, WHEN USER DON'T HAVE AN ACCOUNT WITH THIS ORGANISATION)

Before entering any website as a contributor an editor or an admin or whatever role a person plays, firstly, you must have a record, or an account with them so they can know you properly. So note no random user can just publish content on an organization's website, it must go through a process.

There is normally a connection to the database first in any PHP-built section, to ensure data communication is gotten properly. The connection to the DB must be working properly before any checking and validation of the field like the password, username, email, etc, is done using the script below.

Section 2 (LOGIN PAGE, WHEN USER HAVE AN ACCOUNT WITH THIS ORGANISATION):

Here can only be accessed if the user has an account created with the ORGANISATION.

This occurs by a process, data stored in the database is taken and compared to the data inserted into the field by the user to see if the data corresponds, or else an error message is activated by a script.

HTML5 / CSS3 tags below

PHP script that takes data from HTML/CSS page, validates them, and stores them in DB

SECTION 3 :

How DATA is sent and gotten for the POST SECTION in the Admin Panel :

Like I said earlier there is a connection to the DB first before anything is carried out.

Using a CRUD system.

1i. Post is sent to the DB tables (post)

HTML tags and PHP scripts for the image above to send post to DB.

PHP scripts to insert data to DB table (post)

For the HTML header of the Table

For the edit button feature

For the change status feature

SECTION 4 :

This section is for the category of the post displayed on the front page, but this is also stored and displayed in DB and Admin Panel, it all depends on what the user(Admin, editor, copywriter), etc, is trying to do, e.g (Tech, Finance, Health, Food ), etc.

Add new category feature (send new category to DB), below is the PHP script that allows this to occur dynamically with ease.

This is to display the category that the content creator selected :

Delete Feature: this is to delete the category dynamically if the user wishes.

SECTION 5:

Below is the comment section in the Admin Panel.

UI of the comments, arranged in a tabular form, gotten from the DB.

using class(OOP) to build this comment section:

Script to check how many users of the website commented.

Script to instantiate comment class ( that is to call the class created for the comment section)

PHP script to change the status of the comment in DB to either 'unapproved' or 'approved' dynamically with ease.

SECTION 6 :

This section tells us how many users have been registered to each section :

Number of users registered or logged in to the admin panel :

Number of comments by public users from the front-end

Number of categories used by content creators ( publishers, editors, copywriters, sales marketers), etc.

Number of posts on the DB table (post)

SECTION 7 :

This section consists of the profile of the current user logged into the Admin Panel.

HTML tags and PHP scripts that allows user to update their profiles e.g headshot, name, phone numbers, etc.

This section is now where all data (behind the scene work) from the DB is displayed for the public, dynamically with ease.

FRONT END (user interface display ).

SECTION 1

Display blog posts (articles) based on categories.

This feature is so amazing, I always use to wonder how it happened, and I finally built it out myself, it's called single post display ( when you search a keyword on the search tab, normally a post or two appears, when a particular post is clicked it eventually opens up singly ). It was pretty fun building out this feature.