Build a Digital Agency Service CMS using PHP & MySQL

Download the Jamf installer, run the exe, and install on Windows; then start Apache and MySQL to run PHP files locally and access PSP and myadmin via localhost.

Learn to switch php versions in Laragon on Windows by installing php 7.4, placing it in bin/php, and stopping and restarting all services to toggle between 7.4 and 8.1.10.

install xampp on mac os to run a local server with apache and mysql, access phpmyadmin, and set up a test php project using localhost.

Install composer on Windows to manage PHP dependencies and install packages with simple commands. Include vendor/autoload.php in your project to load stripe and PayPal packages.

Learn how to download and install composer on macOS using Homebrew, verify the installation, and confirm composer commands work.

Compare popular PHP code editors, with emphasis on Visual Studio Code. Learn how to install VS Code and extensions and why it's lightweight and powerful for PHP development.

Create a .php file in a local server folder, run it on localhost, and use PHP blocks and echo to output html or text to the browser.

Discover how echo and print produce browser output in PHP, compare return values, single versus multiple parameters, and the use of parentheses.

Explore PHP data types—string, integer, float, boolean, array, object, null, and resource—through brief descriptions, echo usage, and isint checks.

Explore PHP type casting by converting a variable between integer, float, and string, and use var_dump to reveal type, value, and length. Casting may lose precision.

Explore PHP strings: declare strings with single or double quotes, handle embedded quotes with escaping, and print outputs using echo while avoiding syntax errors.

Explore PHP string functions and basics of declaring and calling functions with parameters. Learn common operations like strlen, str2upper, str2lower, substr, trim, str_replace, and chunk_split.

Explore PHP string functions such as count cares, sprintf, strRepeat, strWordCount, strRev, strPause, and stripTags to manipulate text, format output, and secure input in web apps.

Explore PSP math functions, including pi, min, max, abs, sqrt, round, rand, seal, and floor. See practical examples showing how numbers are manipulated and rounded, plus random values generated.

Learn what a constant is in PHP: an unchangeable value defined with define, globally scoped, with no dollar sign in its name, and using constant arrays like cities.

Explore how PHP operators perform arithmetic, assignment, and comparison on variables and values, illustrated with expressions, operands, and practical examples of echoing results.

Learn how to use PHP increment and decrement operators (pre and post), explore logical operators (and, or, xor, not), and apply string concatenation and concatenation assignment with dot.

Explore the PHP conditional statement by using if, else if, and else, with braces or colon syntax, and learn to execute code based on true conditions.

Explore PHP loops from while, do-while, for, to the for-ish variant, with initialization, condition, and increments. Learn breaking loops, and iterating arrays with for each, keys, and values.

Learn how loops in PHP execute code blocks: while, do-while, for, and foreach, with break and continue to control iterations, and apply modulus to print even and odd numbers.

This lecture demonstrates working with associative arrays in PHP, assigning meaningful keys (full name, country, age), accessing elements by key, and iterating with foreach to display key and value.

Explore multidimensional arrays, including indexed and associative forms, and learn to access nested data and iterate with nested loops to display all elements.

Explore essential PHP array functions, including count, in_array, max, min, array_unique, array_values, explode, implode, and various sorting helpers, with practical debugging and formatting techniques.

Explore how to create and use PHP functions, including built-in vs user-defined functions, parameters, default values, return values, and practical examples like a reusable pyramid generator.

Explore building and processing HTML forms with PHP using get, post, and request, sending data to same or different pages, and displaying results with isset and header redirects.

Learn to implement cookies in PHP with practical examples, including a voting system and a login flow, covering setting, retrieving, and persisting data via form submissions.

learn how to use php sessions to store user data, manage sessions with ob_start and session_start, create a login system with welcome and logout pages, and securely destroy sessions.

Learn core file IO in PHP by reading, writing, and appending text files, listing directory contents with scandir, and using fopen, fgets, and file_get_contents to process file data.

Learn to send email in PHP using the PHP mailer library, configure SMTP with mail trap for testing, and send emails with attachments across PHP 7.4 to 8.2.

MySQL is a free, open-source relational database management system that stores data in tables and uses queries to insert, update, delete, and retrieve records; explore phpMyAdmin on a local server.

Learn to connect PHP with MySQL using MySQLi and PDO, avoid the deprecated MySQL extension, compare procedural and object-oriented styles, and use prepared statements to prevent SQL injection.

Insert data into a MySQL database with PHP and PDO, building single and multiple row inserts, using transactions with begin transaction and commit, and retrieving the last inserted id.

Use prepared statements with PDO in PHP to securely insert data into MySQL, protecting against SQL injection. Employ named parameters or unnamed placeholders, bind values and execute for performance.

Select data from a MySQL database using PHP with PDO, covering basic selects, fetch modes, and prepared statements. Explore grouping, distinct, and aggregate functions like count, sum, and average.

Learn to update database data with SQL: use update queries, set column values, and apply where conditions to modify one or more fields for specific rows.

Learn how to use the order by clause to sort query results in PHP and MySQL, specifying ASC or DESC, and combining it with where conditions.

Explore how the union and union all clauses combine multiple select results into a single set, requiring matching column counts and data types, with examples from students and teachers.

Learn how to use alter table to add, drop, rename, and modify columns in a MySQL table, with practical PHP PDO examples on a students table.

Learn how to group rows with group by, filter grouped results with having, and apply aggregate functions such as sum and avg, including joins across tables.

Explore PHP folder content protection to prevent directory listing in uploads and students folders, using empty index.php files or .htaccess with Options -Indexes.

Apply the least privilege principle to secure a login system by implementing role-based access control with admin and editor user types, session management, and page-level authorization.

Learn how to implement pagination in a PHP and MySQL based CMS for a digital agency service, enabling efficient navigation and data management.

Set up the config file and mailtrap for a PHP and MySQL admin panel, establishing database connections, base URL handling, and SMTP credentials.

Shows moving all admin files into a dedicated admin folder, creating a dist admin bundle, and building a templating system with layouts, header, and top for consistent links.

Set up and fix the forget password flow in the admin panel, linking forgetpassword.php to login and reset password pages, and implement email prompts using php mailer.

Implement a secure reset password flow by saving tokens in the users table, validating email and token from the url, hashing the new password, and clearing the token.

edit profile in the admin panel with profile.php, show logged-in admin name from session, display default or uploaded photo, and update name, email, and password with validation via multipart form-data.

Explains editing a user profile in a php and mysql cms: validate and update passwords, update name and email, and upload a valid profile photo with type checks.

Create four admin pages: setting.php, form.php, table.php, and invoice.php, and integrate them into the sidebar. Implement a current page check to highlight the active link and verify rendering.

Convert html files to PHP by renaming extensions, update all links and assets to the dist front path, and separate header and footer for a clean site structure.

Create a common header across all pages and link the main pages (home, about, services, blog, contact) while configuring asset paths with dist front for reliable image loading.

Apply and centralize the base URL across frontend and admin code by configuring the base URL in config, updating dist paths, header, footer, and admin pages.

Learn to implement a jquery toastr notification system in the admin panel. Wire front-end and back-end messages using css and js files and PHP sessions for success alerts and errors.

Learn to manage a back end slider using PHP and MySQL by creating a sliders table, uploading photos, and adding and displaying slider items in an admin panel.

Edit, add, and update slider items in the back end using modals with dynamic IDs, and manage current photos, uploads, and data fields via PHP and MySQL.

Fetch all slides with PHP from the sliders table and render each on the front end, showing the photo (from uploads), subheading, heading, and an optional button with a link.

Show how to render dynamic about data on the front end with PHP and MySQL, updating year, headings, photos, and button text across home and about pages using conditional display.