
Explore how to build a complete news portal from scratch using PHP and MySQL, covering front end, admin panel, authentication, categories, tags, comments, and subscriber management.
Install xampp on Windows, run the installer, then start Apache and MySQL from the control panel and access phpMyAdmin via localhost to manage databases.
Switch php versions in xampp on windows by swapping apache and php folders for different versions, then restart and verify with a phpinfo page.
Learn to install and configure Laragon on Windows, start Apache and MySQL, verify PHP 8.1 with phpinfo, and set up phpMyAdmin for local database management.
Shift between PHP versions in Laragon on Windows, switching from PHP 8.1.10 to PHP 7.4 by downloading the version, placing it in Laragon's bin/php, and restarting services.
Install a local macOS development stack with xampp, start apache and mysql, verify phpMyAdmin, and test a php file via localhost by creating a project in VSCode.
Install and configure MAMP on macOS to run Apache and PHP locally, manage ports for Apache and MySQL, and access phpMyAdmin for database setup.
shift between php versions in mamp on mac os by prefixing unused php folders with an underscore, enable 8.1 and 8.2, restart, and verify with a phpinfo file.
Learn how to download and install composer on windows, manage php dependencies, install packages like stripe and PayPal, and autoload via vendor/autoload.php to integrate with your project.
Install composer on macOS via homebrew by installing homebrew in the terminal, running brew install composer, and verifying the installation by running composer to show its commands.
Compare popular PHP code editors, focusing on Visual Studio Code, its extensions, and lightweight performance, while noting alternatives like Notepad++, Atom, Sublime Text, Brackets, PhpStorm, and NetBeans.
Describe the admin panel html layout, including login, dashboard, settings, color picker, date picker, time picker, a rich text editor, and a front end button to switch to the website.
Convert a static admin panel into modular php templates by creating header.php, footer.php, login.php, and dashboard.php, and use includes to share header, nav, and sidebar.
Configure a config file, establish a database connection via phpMyAdmin, set base URL, and enable mailtrap smtp with host, port, username, and password for testing emails.
Reorganize the php news portal by moving admin assets to a dedicated admin folder, separate front-end from admin, and implement a layouts-based templating system with top.php.
Create a secure login and logout system by building a users table, implementing session checks, and redirecting to login for the admin dashboard, with password hashing and verification.
Learn to implement a forget password workflow in a PHP admin panel, including fixing the link, configuring email sending with PHP mailer, and a reset password flow with a token.
Learn how to implement a reset password workflow in a PHP, MySQL news portal, including token generation and storage in the users table and URL-based verification.
Learn to build an admin profile editor in PHP: add a photo field, show session-based user info, handle multipart forms, and update name and email with validation.
Explore how to implement a complete profile update flow in php and mysql, including updating name, email, password with validation, and secure photo uploads with mime checks and session updates.
learn how to build and integrate admin pages for a news portal using php and mysql, including setting, form, table, and invoice pages, with dynamic sidebar navigation highlighting.
Explore building a dynamic news portal front end with an HTML template, featuring a multi-category menu, sports subcategories, hero and latest news, sidebars, ads, search, and post detail layouts.
Master the template mastery for a PHP news portal by reorganizing admin and front end assets, configuring database name and base URL, and integrating header, footer, and navigation.
Master implementing a base URL system in a PHP MySQL news portal. Convert HTML pages to PHP and unify navigation with header and footer includes.
Admin users can create and manage authors in the news portal, assign roles, and handle name, email, photo, and password, and set active status (excluding the admin).
Admin users learn to view, edit, and delete authors in a PHP, MySQL news portal, manage author photos, and securely update names, emails, passwords, and statuses.
Admin creates a new author and sends an account creation email with login URL and credentials via PHP mailer, enabling the author to log in and update their profile.
Implement author authentication for a php and mysql news portal by building a login form, validating credentials, managing sessions, and protecting the author dashboard with logout and profile access.
Learn to build an edit profile feature for a news portal, updating name, email, password, and photo via a session-based author profile with validation and upload handling.
Implement forget and reset password flows in a php mysql news portal by creating forget password and reset password pages, email token delivery, and password update with validation.
Learn to implement toastr and toaster messages for success and error feedback in a PHP, MySQL news portal, with header and footer scripts and session-based messaging.
Develop and manage the top, above footer, and sidebar advertisements for a news portal by creating an ads table, configuring sections, and integrating front-end display.
Configure the home hero section in the admin panel, create the advertisement home hero page, upload hero images, and toggle activation to display on index.php.
Implement the sidebar top and bottom in a PHP MySQL news portal by duplicating the home footer layout, adding ad slots with conditional photo display, and testing uploads.
Implement the sidebar bottom section by duplicating the top widget, replacing top with bottom across the layout, uploading an advertisement image, and testing updates with refresh.
Create and manage the news categories table, including main categories and subcategories, with fields id, name, slug, show on menu, and show on home; implement duplicate checks.
Explore editing, updating, and deleting categories in a PHP, MySQL news portal, including category view, category edit page, slug validation, and duplicate checks.
Demonstrates building dynamic category menus and front-end displays on the home page and navigation powered by the categories table in PHP and MySQL. It explains ordering categories by name, applying a where condition to show a single menu, and repeating the news of category section for categories such as eco, health, lifestyle, national, sports, technology, and travel on the home page.
Build a news portal with php and mysql, managing categories and subcategories in an admin area, including subcategory create, edit, view, and delete, and display category- and subcategory-wise news.
Edit and update subcategories by copying category edits, selecting the correct category, and updating data in the subcategories table; enforce that categories with subcategories cannot be deleted.
Show dynamic categories and subcategories in the front end via navigation, using queries like select all from subcategories and order by name ascending for a given category.
Develop a PHP MySQL news portal post system with a detailed post table and fields, plus AJAX-driven category/subcategory loading and full post create, view, edit, and delete functionality.
Learn to build a post creation workflow in a PHP, MySQL news portal, including title, slug, description, featured photo, category and subcategory selects, and tag handling in the admin panel.
Master post management in a PHP and MySQL news portal by editing, creating, and deleting posts, managing categories, slugs, featured photos, and tags with ajax-driven subcategory loading.
Learn how to reassign a subcategory to a different category and propagate the category id updates to posts, while enforcing rules that prevent deleting categories or subcategories with linked posts.
Develop author-specific post management in a PHP and MySQL news portal by building an author dashboard, posting creation and viewing own posts, while admins access all posts.
Explore the author post edit workflow in a PHP/MySQL news portal, including updating titles, slugs, categories, tags, and photos while ensuring author ownership.
In this course, I have taught the students the most popular programming language PHP and MySQL from scratch. I have tried to show the most important things of any programming language like authentication system, email verification, template mastering etc. I have developed a complete news portal application with the latest version of PHP and that is currently PHP 8.4 when I am recording the videos.
The persons who are very beginner in php or have little knowledge in PHP, they will be benefitted the most from this course. But the advanced persons will also get help from this course, because I have tried to show all the real life features of a news portal website with advanced features.
Admin Panel Features:
Admin can create, edit and delete Authors.
Admin can change the website footer information
Admin can change logo, favicon etc.
Admin can change top bar information.
Admin can control the home page information.
Admin can create, edit and delete news categories and subcategories.
Admin can create, edit and delete news posts.
Admin can create, edit and delete FAQs.
Admin can create, edit and delete Online Polls.
Admin can create, edit and delete Live Channel items.
Admin can create, edit and delete photos for the photo gallery.
Admin can create, edit and delete photos for the video gallery.
Admin can control the advertisement section.
Admin can delete subscribers and export the list as CSV.
Admin can approve the comment of post and can reply to a comment
Admin can approve the replies of user comments.
Admin can change his own photo, information and password.
Author Features
1. Author can change his own photo, information and password.
2. Author can create, edit and delete news posts.