Create a blog using php mysql and javascript

Watch a project demo detailing how to build a blog with PHP, MySQL, and JavaScript.

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.

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.

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.

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.

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.

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.