
Explore building a blog application with PHP, MySQL, and JavaScript through object oriented programming. Learn how OOP enables maintainable, debug-friendly code and easier hiring, plus a quick project demo.
Watch a project demo detailing how to build a blog with PHP, MySQL, and JavaScript.
Learn to create a blog with php, mysql, and javascript, while focusing on an important read.
Create a PHP database connection script using PDO to connect to a local MySQL blog database, returning the connection instance and handling errors. Test the connection with a simple script.
Define a PHP CRUD class to manage database transactions, using a constructor to initialize the database connection and store it in a private property.
Create a reusable PHP create method with PDO prepared statements to insert data into a given table by passing a data array, building dynamic insert statements with columns and placeholders.
Import blog tables and explain their relationships, then test the create method by inserting a post and a reply to show how the data array maps to columns.
Define and test the read method of a CRUD class by preparing and executing a SQL query, fetching results from the posts table, and validating the output.
Define and test the update method of a PHP MySQL blog CRUD class, using a prepared update query and execute to modify the post content by post id 1.
Implement the delete method in the daily work class using a SQL query and database connection to delete a post, then test and integrate with post, comment, and reply controllers.
Download the project template and integrate it with php and mysql, replacing static data with dynamic content and adding categories, posts, and comments in both backend and frontend templates.
Learn to create a blog using php, mysql, and javascript, and follow the emphasis signaled by the lecture title important please read.
Explore the database structure with separate tables for categories, posts, comments, and replies, linked by foreign keys. Include posts and categories on the dashboard, while users contribute comments and replies.
Learn how to fetch blog posts with their category names using left joins, linking posts to categories via the foreign key posts.category_id = categories.id.
Learn to integrate an HTML template with PHP by replacing static data with database-driven posts, and set up a post controller to handle displaying posts and adding comments.
Build a PHP MySQL driven post display by implementing a post controller, joining categories, and using a CRUD class to read and fetch posts for the front end.
Set up the blog front page by copying index.html from the template, adding the assets, and renaming to a PHP page to enable displaying posts on the front page.
Fetch posts from the database via the post controller, loop through them on the front page, and display the first 60 words with category and title after stripping html tags.
Learn to create an admin add post page by copying a template into admin/posts and connecting it to a page view controller that inserts posts into the database.
Implement the add post method in the post controller to pull form data and insert into the posts table using CRUD create, triggered by the add post button.
Convert the html template to a php file, include and instantiate the post controller, then call add post to create a db entry and display on the front end.
Create an admin dashboard page via index.html under admin/posts to let the admin view, add, update, and delete posts from the database.
Convert the index.html to index.php to embed PHP code, remove static posts, and use a loop to fetch and display all posts from the database in a table.
Create a blog interface in PHP, MySQL, and JavaScript by listing posts and categories, fetching posts via a controller, and displaying truncated content with category names retrieved through left join.
Display the number of comments for each post in a php mysql blog by left joining comments, using count, and grouping by post id on the index page.
Fix the back button on the edit page by linking it to admin/posts/index.php, returning users to the list of posts in the DB.
Create a post images directory, move the uploaded image into that directory, and store the image name in the database linked to the post.
Display a blog post cover image by building the image path from the post id and image name in the database, then render it on the front end.
Display post cover images on the frontend by replacing placeholders with backend images, and build image paths in index.php by appending the post id to the folder name.
Implement the edit post workflow by creating an edit post page from the project template, changing the file extension to PHP, and wiring index.php to editor.php to load post data.
Learn to edit a post by passing the post ID in the URL, retrieving details with get_post in the post controller, and repopulating the edit form fields.
Edit post part 2 demonstrates loading a post's title, content, and category into an edit form, and populating the category select box from the categories table using a CRUD class.
Display a live image preview on the edit post page using php, mysql, and javascript, retrieving the post image from the post images folder by post ID.
Create an update method that updates a post by ID with title, category ID, and content using a named query, then reload the post data to reflect changes after submission.
Update the post cover image by uploading a new file, updating the image name in the database, moving the file to the post images folder, and deleting the old image.
Learn how to implement delete post functionality in a php mysql javascript blog by adding a delete_post method that takes a post_id and executes a delete query.
Learn how to implement marking a post as featured in a PHP MySQL blog by updating the is_featured field, handling URL parameters, and displaying featured posts.
Pull featured posts from the database and display their images, titles, and created dates on the frontend by implementing a get_featured_posts method and joining categories.
In this course we'll be build a real world blog project using php, mysql and javascript. If you're new to web development, the way this course is structured shouldn't scare you. I built the course using object oriented php, and object oriented php is a standard way of coding in the web development industry. If you get a new job as a php developer, you'll be expected to code in object oriented php, not procedural programming.
So the way I'm coding in this course shouldn't scare you way, but instead it should excite you because it's how things are done in the industry. I know object oriented programming can be a bit hard to grasp in the beginning, but you'll enjoy it along the way because it makes your coding life easy as a developer.
This is course is for programmers that are hungry for knowledge, and looking to improve their programming skills. If you constantly seeking to become a better programmer, you've come to the right place...This course is for you. Everytime you sit Infront of a computer as developer, and learn something new, you grow. If you're obsessed with self-betterment. This course is for you. I can guarantee you that you that this course will take your programming career to the next level. It is a combination of things that I've learned over the years, and I simplify all those advanced concepts for you.