
Introduction to a PHP and MySQL book author website with e-commerce, showcasing books, author profile, events, galleries, and a full admin panel for orders, coupons, and payments.
Install xampp on Windows by downloading the executable, running the installer, and using the xampp control panel to start Apache and MySQL, then access phpMyAdmin at localhost.
Learn to shift PHP versions in XAMPP on Windows by stopping the Apache server, swapping the Apache and PHP folders, and verifying via PHP info.
Install and configure laragon on Windows, start Apache and MySQL, verify PHP 8.1, and set up phpMyAdmin for local development with root access.
Switch between php versions in Laragon on Windows by installing PHP 7.4, updating the bin folder, and restarting services to toggle between 7.4 and 8.1.10.
Install PSP 8.2 in Laragon on Windows, update the bin folder, restart Apache and MySQL, and verify with a PSP info test.php showing 8.2.1.
Install XAMPP on Mac OS, start Apache and MySQL, and access phpMyAdmin. Create a project folder, write a test index.php, and run it on localhost.
download and install the free mamp on macos, configure ports to run apache and mysql, and use phpmyadmin to manage databases while creating php files in htdocs.
Learn to shift between PSP versions in MAMP on Mac OS by renaming folder versions to activate or deactivate, restarting the service, and verifying with a php info test.
Install and use composer on Windows to manage PHP dependencies, install packages with composer require, and wire autoload into your PHP project via the vendor/autoload.php.
Install composer on Mac OS by installing homebrew via the terminal, pasting the command and entering your password, then running brew install composer and verifying the installation.
Explore popular PHP code editors, with Visual Studio Code highlighted as the most powerful for its extensions and lightweight design. Learn how to install Visual Studio Code and its extensions.
Describe the admin panel template html layout, including login, dashboard, settings, forms with color, date, and time pickers, data table, and icons for details, edit, and delete.
Separate the admin dashboard and login by modularizing with header.php and footer.php, and include nav.php and sidebar.php for a clean, reusable PHP admin interface.
Set up a PHP admin panel with a config.php for database connection and base URL, include it in headers, and configure Mailtrap SMTP (host, port, username, password) for testing emails.
Learn how to move all admin files into a dedicated admin folder, restructure dist assets, and set up a config and templating system with layouts, top.php, and safe base urls.
Learn to create a robust users table and implement a PHP and MySQL login/logout system with session management, role handling, and secure password hashing.
Explore implementing a forget password flow in a PHP admin panel, including creating forget password and reset password pages, configuring PHPMailer SMTP, and sending reset links with tokens.
Explain the reset password workflow: save a token in the users table, email a token link, verify email and token from the url, and update the password with hashing.
Create an editable profile in a PHP admin panel by adding a photo field. Display logged-in user with session data and update name, email, and photo via a multipart form.
Edit profile: update password with validation, update name and email, and upload a photo with image validation and timestamped filenames, syncing to the database and session.
Learn to extend a personal book author site by creating admin pages for settings, form, table, and invoice in PHP, wiring the sidebar links, and activating the current page.
Explore a complete HTML template for a personal book author site front end. Featuring slides, author bio, book search with price filters, cart and PayPal checkout, events, blogs, and galleries.
Duplicate and reorganize the project folder, copying dist front and admin assets (css, js, fonts, uploads) into the proper structure, then configure the database and base URL for local login.
Learn to convert all html pages to php, adjust asset paths to the dist/front folder for css and js, and implement a common header and footer in a PHP application.
Create reusable header.php and footer.php files and include them across all pages to standardize navigation and convert HTML pages to PHP, ensuring CSS and links work.
Apply a base URL across all site links by configuring a central base URL, updating header, footer, and content pages, and performing a global replacement to fix images and navigation.
Rename the admin table from users to admins in a php and mysql project, update references across login, profile, and nav, and set the collation to unicode_ci.
Build a PHP and MySQL user registration flow from sign up to account creation, validating name, email and password, storing data, generating a token, and emailing a verification link.
Implement a PHP registration verify that reads email and token from the URL, validates them against the users table, clears the token, sets status to one, and redirects to login.
Build a PHP login system with form posting, email and password validation, and session handling that redirects to a user dashboard with a sidebar, profile info, and logout functionality.
Create and update user profile information using a PHP and MySQL form, with live validation, duplicate email checks, and session data refresh after update.
Create and test a user edit password page in PHP by copying profile edit logic, including password and confirm password fields, non-empty and match validation, and updating the hashed password.
Explore building a secure forget and reset password flow in PHP and MySQL, including email verification, token generation, reset links, and password hashing.
Configure the header menu to show login and signup for guests, display a user dashboard when logged in, and prevent access to login and password pages for authenticated users.
Learn to secure the admin panel with index.html guards and implement session-based success and error messages across login, forget password, and profile updates, including redirects and proper admin layout integration.
Build an admin panel slider feature by designing a sliders table with id, title, content, photo, and button details, then create, view, edit, and delete sliders.
Edit and delete sliders in the admin panel by updating data, optionally changing the photo, validating title and content, and unlinking old photos on deletion.
Display dynamic slider data on the front end by querying the sliders table in PHP and rendering items in index.php with title, content, and optional button text and link.
Manage the about section data in the admin panel by creating an about items table with photo, video, title, subtitle, content, and button text or url, and update data.
Demonstrate managing the about section data for home and about pages by using a show/hide status, editing fields, and conditional front-end rendering of text, video, and photos.
Manage the home page counter section via the admin panel by creating and editing a counters table with four items, including number and text, and a show or hide status.
Learn to display the counter section data on the home and about pages by querying counter items, checking status, and updating data after edits to keep it consistent across pages.
Create and manage testimonials in the admin panel by building a testimonials table with id, photo, name, designation, and comment, and enable show/hide plus create, view, edit, and delete workflows.
Learn how to manage testimonials in a PHP and MySQL admin panel by editing name, designation, comment, and photo, validating input, and deleting records from the testimonials table.
Display dynamic testimonials on the home page by querying the testimonials table, looping through items, and rendering each item's photo, name, designation, and comment.
Learn to build an admin panel to manage FAQs in a php and mysql site, including creating, editing, and deleting questions and answers.
Master the admin panel workflow to edit, update, and delete FAQs, handling question and answer fields, removing unnecessary photo sections, and applying id-based updates to the FAQ view.
Show faq data on the front end by querying the facts table, using a for loop to iterate results, and dynamically rendering questions and answers on the faq page.
In this course, I am going to teach students how to build a Personal Book Author Website with E-Commerce from scratch using PHP and MySQL. The course will cover all the core aspects of web application development, including authentication systems, email verification, template mastering etc.
I will develop a real-world personal book author website with E-Commerce where book author can show his portfolios, education, experience, awards, photos, videos, events, posts etc. and users can buy his books giving orders online. This project will be built using the latest version of PHP at the time of recording, ensuring students learn modern and up-to-date practices.
This course is designed especially for beginners who have little or no experience with PHP, but even advanced learners will find it useful as I implemented here real-life ecommerce features with cart, checkout, coupon, delivery charge, payment options etc.
Admin Panel Features:
1. Admin can create, edit and delete users.
2. Admin can change logo, favicon, banner etc.
3. Admin can manage sliders
4. Admin can manage testimonials.
5. Admin can manage terms and privacy pages.
6. Admin can manage about page items.
7. Admin can manage photo gallery.
8. Admin can manage video gallery.
9. Admin can manage FAQ page items.
10. Admin can manage events.
11. Admin can manage blog post.
12. Admin can view and delete subscribers.
13. Admin can export subscriber list as CSV.
14. Admin can change his own photo, information and password.
15. Admin can manage his education, experience and award sections.
16. Admin can manage counter
17. Admin can manage book category
18. Admin can manage book publisher
19. Admin can manage book language
20. Admin can manage book items
21. Admin can manage delivery charge options
22. Admin can manage coupons
23. Admin can see all the book orders
24. Admin can see order invoices
25. Admin can change the order status to paid, processing, shipped or cancelled
User Features
1. User can create account in this system for free.
2. User can reset password if needed.
3. User can change his profile information and password.
4. User can pay using paypal, stripe and order for books.
5. User can see orders and invoices.
6. User can print or download the invoice as CSV.
7. User will get email from admin when order status will be changed.