How to produce or create dynamic a blog PHP and MySQL database
It is a widely known fact that a blog, as we know it, is an application where certain users (Admin users generally) are able to create, edit, update and publish articles with the aim of making them available to the public for reading and maybe commenting on. There is an online catalog of these articles that can be browsed by users and the general public, and they can click on any of them to read more about them or to make a comment on them.
Creating our Database
In order to start creating our tables in our MySQL client, before we begin creating our blog, we should lay out what we want in our blog. There is no doubt that we will need to hold blog posts, and each post should contain a title, a description of what the post is about, an author, and the date when it was posted. In order to accomplish this task, we could simply create a table to hold all of that information, and then we could create a basic blog with just one table. However, with just one table, we will not be able to have as much control over our data as we would like. As an example, we could store the name of the author in the same table as the blog post, but what would happen if we also wanted to store the email address of the author? Yes, of course! It would seem that adding another field to our table would be the obvious solution to our problem.
Creating our Objects in PHP
Creating our files and folders is the first step in writing PHP code. For this tutorial, we will have our index.php in our root folder, followed by an includes folder, which holds our CSS stylesheet, our JavaScript files, includes.php, which contains references to our objects and MySQL connection, and blogpost.php, which contains our BlogPost object.
Once we have our database set up, we need to create the objects in PHP that will handle the data on our behalf so that we can begin to use it. Programming objects are a way to pull together various attributes (such as variables) and methods that all relate to the same thing in order to create a coherent whole. We are also able to organize our programs much better with the help of objects. In order to illustrate what our objects are in a more "real-life" sense and to give us a better idea of what they are, let's first create a simple object so that we can put them in a more "real life" context.
Features:
- User registration system that manages two types of users, Admins and Normal Users, with the management of the two types of users
- There will be a separate admin area and a public area on the blog, which are completely separate from each other
- Admin users will be able to access the admin area of the website only if they are logged in and normal users and members of the public will be able to access the public area
- There are two types of admins that can be found in the admin section:
Admin:
- Any post can be created, viewed, updated, published/unpublished, and deleted at any time.
- In addition, you will be able to create, view, update and delete topics.
- It is only an Admin user (and only an Admin user) who can create another Admin user or Author.
- The ability to view, update, and delete other admin users is available
Authors:
- The user is only able to create, view, update and delete posts that they have created themselves
- It is not possible for them to publish a post. The Admin user is the only one who has the authority to publish posts on the site.
- Posts that have been published will only be displayed in the public area of the website
- There is a particular topic under which each post is created
- Posts and topics have a many-to-many relationship that exists between them.
- Posts are listed on the public page. Each post has a featured image, an author, and a date when it was published.
- When the user clicks on the topic of his choice, he will be able to view the entire list of posts under that topic
- It is possible for a user to view the full post when they click on a post, and they can also leave a comment at the bottom of the post.
- The Disqus commenting system is implemented, which allows users to comment using their social media accounts on platforms such as Facebook, GooglePlus, or Twitter using their Disqus accounts.
Implementation
Let us start coding right now:
You will need to create a folder named complete-blog-php in the directory of your server. Using a text editor of your choice, such as Sublime Text, open this folder in your default text editor. It is recommended that you create the following subfolders within it: admin, includes, and static.
It is expected that the contents of the three folders will be as follows:
- Files for the admin backend area will be stored in this folder. The files included in this folder are concerned with the creation, viewing, updating, and deleting of posts, topics, and users.
- A file containing pieces of code that are to be included into one or more other pages will be stored in the includes folder. E.g. Files that are used to display error messages
- Contains static files such as images, CSS stylesheets, and Javascript.
A static folder is a folder that contains, among other things, the styling for your site, as mentioned earlier. As soon as you create the static folder, you will need to create three subfolders: css, images, and scripts. The css folder you just created should have a file called public_styling.css within it.
Firstly, we will start with a combination of some of the best amplifications of the different databases in order to get the most benefit from them.
