BlackBelt PHP and MySQL Skills for Creating Dynamic Websites

Practice uses assignment, string, arithmetic, and comparison operators through variable creation, string concatenation, numeric calculations, and precedence testing to reinforce PHP operator syntax and outcomes.

Show how a while loop echoes a message while condition is true and increments counter to ten. Initialize a variable to 1, test var <= 10, then echo and increment.

Explore how pre and post increment work in PHP, compare auto increment nuances, and apply plus-equals and string concatenation to manipulate variables and strings in dynamic websites.

Create constants in PHP with define, learn naming rules, and that a constant's value cannot be changed, with default case sensitivity and optional true to make it case insensitive.

Explore how foreach splits arrays, including multi-dimensional arrays, and why echoing an array fails. Build a recursive function to echo all values, using the array function to test for arrays.

Learn essential php array functions, including count, is_array, in_array, array_combine, array_merge, array_shift, and array_pop, and understand loose versus strict comparisons and default values.

Explore how PHP's array_walk applies a user supplied function to every array element, using value as first argument, key as second, and an optional third value, with by-reference updates.

Build a PHP file type detector by exploding the file name and using array_pop to get the last element as the extension.

Use the string replace function to swap zeros with the word zero in a string, using four arguments (last optional) and track replacements with a counter.

Learn to verify email addresses using preg_match with regular expressions, and master pattern design basics, anchors, character classes, quantifiers, and escaping.

Use file exist to check if a file or directory exists. Use file to test a regular file, file size to get the file size, and unlink to delete.

this bluebelt demonstration creates file.txt, writes 1 through 0, and uses file_exists, filesize, and unlink to verify existence, measure size, and delete the file.

Learn how feof() tests the end of a file in PHP, and how separate read and write pointers track progress for safe handling of large files.

Track web page visits by storing a counter in a text file, updating on each visit, handling the first visit when the file doesn't exist, then reading and incrementing.

Open, read, and close a directory to reveal its contents, learning that each read returns a name, not the path, and that dot and dot-dot denote root and parent folders.

BlueBelt shows how to delete directories and files together using a recursive super delete function that traverses a directory, unlinks files, and removes the nation directory once empty.

Discover how to send data with form and input tags using action and method, choose post for passwords and get for others, and read submitted data from the global array.

Learn how to send and receive form data with an HTML form and process.php using post, with username and password inputs, and $_POST in PHP to echo values.

Use the get method to send data with a hyperlink by placing a question mark, then the username and password, with ampersands separating values to the destination process.

Learn to upload a file with a PHP form, using an input named upload, configure max file size, inspect $_FILES for size and tmp_name, then move_uploaded_file to destination.

Upload a photo to a destination folder using a PHP form with a 30 megabyte limit, validate the submit, and move the uploaded file with move_uploaded_file; confirm success.

Learn to secure file uploads by implementing security checks, organizing storage, and renaming files properly to mitigate risks when users upload to your server.

Learn to validate uploaded file types in PHP by using the switch statement on the global upload array, accepting image/jpeg and exiting on illegal types.

Rename uploaded files using time and rand, extract extensions with explode and array_pop, and create year and month directories with mkdir for successful uploads.

Explains how to download a file by using the head function to tell the browser to download, specify the file size and name, and read contents with a while loop.

Display six pictures, convert each into a get method download link, send the picture name via a global array, build its url, and trigger the browser to download.

Identify and fix download program weakness by validating the file path against a whitelist of downloadable files, using safe get data and implementing checks to prevent unauthorized downloads.

Learn why object-oriented programming should come before MySQL in PHP development to store file ownership and retrieval in a database; MySQL is powerful, popular, and free.

learn object oriented programming by understanding objects as data types and how to declare them; compare procedural programming and see how OOP lets you write less and reuse more.

Refactor a file upload program into object oriented modules and classes, covering error and type control and file handling. Learn the one class one independent file rule and naming conventions.

This lecture shows how to create a PHP class, declare properties and methods, set a default value, instantiate the class with require and new, and call methods with arguments.

Explore the MySQL database and the MySQLi class in PHP, understanding databases as warehouses with tables, columns, and rows, and learn to navigate their structure and core concepts.

Learn to operate and manage databases with phpMyAdmin, create databases and tables, set collation to UTF-8 for multilingual sites, and navigate the WAMP-based interface to view table structures.

Explore the 30 MySQL data types across date and time, numeric, and string categories, and learn how storage size, fixed versus variable length, and length attributes affect database design.

Create a new database and a table, set the primary key field with autoincrement, and define engine and transmission fields with appropriate types and lengths, plus storage options and collation.

Demonstrates connecting to a MySQL database in PHP using the construct method (localhost, root, car) and the connect method, checking success, suppressing errors with @, and disconnecting with close.

Learn to retrieve data with SQL select statements, use back quotes for identifiers and capitalization for readability, then execute the query and fetch results with fetch array or fetch row.

Demonstrate retrieving six rows from car info table by connecting to the database, preparing and executing a select query, fetching results with fetch array in a loop, and freeing resources.

Learn to organize retrieved data using SQL limits and conditions, selecting specific rows with start index 0, where clauses, and like patterns with a percent wildcard.

Learn how to update and delete rows in a MySQL database with PHP, using where and limit 1 to protect data, and how the query method returns true or false.

Learn to validate and filter user input with regular expressions, controlling content and length, and escape all special characters before database insertion to prevent sql injection.

Master four database operations and connect using the connect or construct method, handle errors, and use the query method for retrieval, insert, update, or delete with where and limit safeguards.

build a login program that uses post, validates inputs, connects to a MySQL database, encrypts and compares passwords, and authenticates users before granting access.

Learn how to complete a PHP membership system by creating a private home page, redirecting with window.location, and solving login-required access and username display from the database.

Explore how a university balances access control by using ID cards for general entry and fingerprint scanners for sensitive areas, combining cost and safety for robust security.

Explain cookies and sessions as web identity tools: cookies stay on the browser, sessions live on the server, with admins using sessions and ordinary users relying on cookies.

Set two cookies, user id and security, after login and place a cookie scanner on every page to verify the token against an encrypted md5 value retrieved from the database.

Create an id card and a card scanner, implement cookie-based authentication for user id and security, validate the user against the database, and verify the md5 password to grant access.

Learn to securely log out by revoking the id card, expiring cookies with setcookie to time() minus one, and ensuring the correct path, after verifying login state before logout.

Add a new function to the membership system, implement a file upload flow, and verify successful uploads including file types, folders, and automatic renaming within the index workflow.

Create a picture table to store file names and link each image to a user via user_id. Use insert_id to get the primary key after inserting into the parent table.

Identify a cookie tampering vulnerability in image uploads and demonstrate fixing it by rechecking user identity before every operation and securing the upload process with a scanner.

Prevent duplicate image uploads by using a switch cookie during the upload process. If the switch is on, delete it and proceed; otherwise deny the upload.

learn to start a php session with session_start, avoid any output before it, and identify users via the session id stored in the php sess id cookie.

Start a session and store a value in the global session array under a password key, such as one two three four five six a b c.

Learn how to create a blank canvas with image create true color, specify width and height, handle the returned resource, and note GIF is not supported.

Create a paint brush on a blank canvas using image fill, set a background color, and apply red ink at 0,0 to return true.

Output an image in PHP by using the image function with imagejpeg or imagepng, set the Content-Type header, optionally store the image in a database, and destroy the resource.

assemble the lessons to create a verification code image: build a canvas, allocate colors, add a border, sprinkle random pixels, and render four random characters.

Watermark a picture using a logo or a text string, convert destination image into a canvas with image create from, and obtain width and height with imagesx and imagesy.

Overlay a logo as a watermark on a destination picture by converting the logo to a bitmap and using image copy with x, y, width, height to position it.

Learn to crop a picture with the image copy function by creating canvases, selecting a left top quarter using x, y, width and height, and pasting onto a new canvas.

Scale down a picture to a thumbnail using image copy resized or image copy sampled, then create a new canvas with the original’s width and height and fill it white.