📘 PHP Basics with VSCode

⚙️ Installation & Configuration

• 📦 Apache2, PHP, and MySQL Setup on Debian
• 🔄 Configure SFTP-Sync in VS Code

🧑‍💻 Introduction to PHP

• 📖 What is PHP?
• 💾 What is MySQL?

🌐 HTTP Requests and Responses

• 🔍 Understanding HTTP Requests
• 📤 Understanding HTTP Responses

🧱 PHP Data Types

🔢 Scalar Types

• 🔢 Integer & Float — Numbers in PHP
• 🔤 String — Working with Text
• 🟢 Boolean — True or False

📚 Compound Types

• 🧮 Arrays — Indexed, Associative, Multidimensional
• 🧱 Objects — OOP in PHP

🧩 Special Types

• 🚫 NULL & Empty — Handling Absence of Value
• 🧪 Resource — External References in PHP

📝 Basic PHP Concepts

• 💬 Using Comments in PHP
• 📤 5 Ways to Output PHP in HTML
• ➕ HTML Output with PHP Calculations
• ➕ PHP Data Types & Variables

🧠 Control Structures

• 🔁 Type Casting & Constants
• 🔄 Conditionals (if, else, elseif, switch)
• 🔃 Loops and Functions

🌍 Scope and SuperGlobals

• 🌐 PHP Scope and Global Variables
• 🗃️ Super Global Variables
• 🧪 urlencode vs rawurlencode

📤 Working with Forms & Superglobals

• 🔎 $_GET
• ✍️ $_POST
• 📥 $_REQUEST
• 🌐 $_SERVER
• 📎 $_FILES
• 🍪 $_COOKIE
• 🔐 $_SESSION
• 💡 $GLOBALS

🛡️ Security Headers

• 🔎 HTTP Security Response Headers
• 🛡️ Strict-Transport-Security (HSTS)
• 🖼️ X-Frame-Options Header
• ⚙️ Modifying Headers in PHP
• 📜 Content-Security-Policy (CSP)
• 🧪 X-XSS-Protection Header
• 🔁 Referrer-Policy
• 🔄 Same-Origin vs Cross-Origin
• 🚫 Feature-Policy / Permissions-Policy
• 📦 X-Content-Type-Options Header

🔤 Regex (Regular Expressions)

• 🧵 Regex in PHP - Introduction
• 🔧 Regex Key Functions in PHP

🔐 Encoding and Decoding

• 🧬 Encode & Decode (HTML Encoding)
• 📦 Base64 Encoding/Decoding
• 🔐 Hashing in PHP

📂 Including and Requiring Files

• 📥 Include & Require in PHP
• 📁 Filesystem Functions in PHP
• ⚠️ Error Reporting in PHP
• 💻 OS Command Execution in PHP

📝 Form Validation

• ✅ Form Validation Basics
• 🛠️ Validation Functions #2
• ⚖️ False Positives in PHP
• 🔁 Type Juggling & Type Casting
• 🚨 Type Juggling Vulnerabilities
• 🛠️ Common Problems in PHP

---

📘 MySQL – Database

🧱 Basic Concepts & Table Operations

• 📚 MySQL and Database Concepts
• 🧰 CREATE, SHOW, DROP (DB & Tables)
• ✍️ Insert Data into Tables
• 🔍 SELECT – Read Data
• ♻️ UPDATE – Modify Data
• 🗑️ DELETE – Remove Data
• 🔁 COMMIT & ROLLBACK – Transactions

🔐 Constraints, Keys & Schema

• 🧩 PRIMARY KEY vs FOREIGN KEY
• 🛠️ ALTER TABLE (Add/Modify Columns)

🔄 Advanced SQL: Join, Filter, Group

• 🔗 JOINs – Table Relationships
• 🧮 GROUP BY – Organize Data
• 🚦 HAVING Clause – Post-Grouping Filters
• 🧠 SubQuery (Nested Queries)
• 🧬 UNION vs UNION ALL

🔎 Conditional Logic & Functions

• 🤔 IF() Clause
• 🔀 CASE Statement

🧮 Operators & Built-in Functions

• ➕ Arithmetic Operators
• 📐 Math Functions (ABS, SQRT, etc.)
• 🔤 String Functions & Operators
• 🕒 Date & Time Functions

🗃️ Views, Indexes & Metadata

• 🧾 Views in MySQL
• 🧷 Indexes in MySQL
• 🔍 Information_Schema – Metadata Queries

---

📘 PHP + MySQL Integration

• 🌐 Using PHP to Access MySQL (MySQLi)
• 🔌 Database Connection in PHP
• 📥 Retrieving Data using MySQLi
• 👨‍💻 Working with Retrieved Data
• 📝 Creating Records with PHP
• ♻️ Updating Records
• 🗑️ Deleting Records
• 👁️ Viewing Records via PHP

---

📘 Other 🔍 (Security & OOP Bonus)

• 🔒 Information Security Audit Tools
• 🎯 Kali GPT Offensive Prompt Field Guide
• 🧱 OOP in PHP – Object-Oriented Guide

---