
Build a robust blog application with PHP (OOP) and MySQL, featuring slug-based post URLs, tag filtering, keyword search, authentication for creating, editing, and deleting posts, and comment moderation.
Install the jam server and the pivot text editor to begin the blog project. Run server software on your OS and start a local host, coding with Sublime Text.
Set up a block project inside the setup folder, configure a local MySQL database connection, and bootstrap header, security, and index files.
SOURCE CODE IS AVAILABLE HERE AND AT PAGINATION SECTION FOR DOWNLOAD
Learn to insert dynamic form data into a MySQL database using a PHP OOP approach, validating title and description, sanitizing input with strip_tags, and displaying success or error messages.
Add image upload to the blog app by handling multipart forms, validating extensions, saving images to a server folder, and storing image data in MySQL via a PHP function.
Extend the blog database by adding an image field and a created_at timestamp, ensure image permissions, and prepare for slug creation discussed in the next video.
Generate a slug for each post by converting the title into a URL-friendly string, replacing spaces with hyphens, and store it in the database for use in post URLs.
Create a tags table and fetch tags from the database to enable browsing posts by tag, linking tags to posts and displaying tag lists on the home page.
Learn to browse posts by tag using a SQL join across posts, tags, and the post-tag relationship, filtering results by dynamic tag names like PSP.
Do you want to know how real world application are made?
Do you want to write clean code?
Do you want to be expert in PHP?
This course take you form scratch from designing of web pages to designing database structure to writing reusable code with object oriented programming approach. I have seen many courses made in php and mysql in udemy were very basic which definitely not helpful for students to be a market ready after completing those courses. Therefore i thought to make a robust web application where i can teach my students not only writing code and storing data in database but better approach to do the task. Therefore i came with a blog application to make my students easy to understand about the project requirements.
PHP is one of the high demanded programming languages in the world. Around 80% of websites and web applications are made with PHP.
Therefore, you can take the advantages of this language to be a better programmer/engineer in software companies with a good salary.
so what’s the course about?
I will personally guide you, step by step, in creating your own robust blog application:
creating unique slug for each posts. slug are more SEO friendly than ID
inserting data to database with multiple parameters and conditions
storing tags for each post. one post may associated with multiple tags. Think about stackoverflow where users can browse all posts associated with that tag.
We make pivot table and you will learn how to query that
we will implement the search engine feature for our blog application.
we will add most popular posts feature in our application. How we do that??
we will add comments system as most of the websites in the world allows users to leave their opinion about the article. This should be approved by admin before they come live. we will handle this as well.
we will add authentication system and you will see how session are used to protect routes.