Code Like a Pro: Create a NEWS website with PHP in 2023

Explore retrieving a user's remaining details from the database, including id, profile picture, and role, by querying the users table with the username.

Upload the user profile picture by building a file input form and posting multipart data. Save the image to assets/images/profiles and update the user record to display the new photo.

Add categories to the database by building a post method PHP form linked to the category table, styled with bootstrap, and test with sample categories like trending and international.

Build a PHP driven news site feature by creating an HTML table to display categories, using Bootstrap table classes, and conditionally showing actions based on admin or editor roles.

Write a PHP method to fetch and display categories in ascending order in a table, with admin and user views and delete actions.

Learn how to prepare and update news site categories with PHP. Edit category records, create edit pages, and update names such as finance and international news.

Implement a public PHP method to delete a category by id, execute a delete from category query, and verify the deletion with a success message.

Build a PHP news post form by adding title, content, category, image, status, news type, tags, and a submit button.

Learn to restrict the news title input to 60 characters with a live counter. Display remaining characters and dynamically change the border color to show valid or exceeded input.

Fetch distinct categories from the database, order them by title, and render each as an option in a category select tag for the news site.

Learn to handle image uploads in PHP by validating file extension and size, generating a unique file name, and moving the image to the news_images directory.

Display an admin-only add post link in the news site sidebar, enable posting a new item with category and image, and verify the link appears after administrator login.

Display casual news by querying casual posts, sorting by id desc, limiting to ten, and rendering id, category, image, 200-char content, plus likes and comments.

Learn to fetch and display news posts by category in a PHP news site, using category IDs to filter results and render category pages.

Apply a foreach loop to iterate over article tags, build a tag string, and compose URLs with a tag query parameter, then render styled tag links for navigation.

Fetch related news posts by category in a PHP site, using SQL to select by category, order randomly, and limit to four, then display image, category, and content.

Add and link all news items to the single post pages by pulling links, images, titles, categories, and tags from the database, ensuring consistency and avoiding broken links.

Add users to the administration panel using PHP, validating input, cleaning data, and inserting new users with roles and default profile pictures.

learn to add a get posts count method in the users class that queries the posts table by username to display each user's post count, with an admin link.

Builds a comments table for news posts with id, post_id, name, email, website, body, and status, and adds a PHP method to insert unapproved comments.

Display and manage user comments in an admin table by loading comments, echoing data, and toggling status between unapproved and approved.

Learn to approve and un-approve comments in a PHP news site by updating comment status and displaying only approved comments on the admin and comments pages.