Web Programming – PHP/MySql
Web Programming – PHP/MySql
₹8,000.00
Curriculum
Week-1
🖥️ What PHP is and how it works in websites
⚙️ Setting up a local server (XAMPP/WAMP)
📝 Writing your first PHP script
🔄 Embedding PHP in HTML
🔤 Basic syntax, variables, and output (echo, print)
🌐 Used for server-side scripting
🧩 Integrates well with databases
🛠️ Powers popular CMS platforms like WordPress
🆓 Free and open-source
Features that make PHP developer-friendly
⚡ Fast and efficient
Technical and cost advantages
🔒 Has built-in security tools
🌐 What HTML is and how it works
🏗️ Structure of a basic HTML page
🏷️ Common HTML tags (<html>, <head>, <body>, <h1> to <h6>, <p>, etc.)
🔗 Creating links and adding images
📄 Saving and running your first HTML file in a browser
Week-2
🔤 PHP Syntax
🖥️ Echo & Print
🧠 Variables
🔢 Data Types
➕ Operators
🧰 Built-in Functions
🗂️ Comments
📄 PHP File Extension
🖥️ Echo & Print
🧠 Variables
🔢 Data Types
➕ Operators
🧰 Built-in Functions
🗂️ Comments
📄 PHP File Extension
🔢 1. Scalar Data Types :
📜 String – Text data
🔢 Integer – Whole numbers
🔣 Float/Double – Decimal numbers
🔘 Boolean – True or False
📜 String – Text data
🔢 Integer – Whole numbers
🔣 Float/Double – Decimal numbers
🔘 Boolean – True or False
🗃️ 2. Compound Data Types
📦 Array – Stores multiple values
🧱 Object – Instances of classes
➕ Operators in PHP
➕Arithmetic Operators
🧪Comparison Operators
⚙️Assignment Operators
🔗Logical Operators
🔀String Operators
PHP control statements
if 🔁 else 🔄 elseif 🎚️ switch 🔃 while
🔂 do...while 🔢 for 📦 foreach 🛑 break ⏭️ continue
🛑
break
⏭️ continue
🎚️ switch...case
🔃 while – Repeats code while a condition is true
🔂 do...while – Executes code once, then repeats while condition is true
🔢 for – Loops a specific number of times using counter
📦 foreach – Loops through each element in an array
Week-3
📏 strlen() 🔠 strtoupper() 🔡 strtolower() ✂️ substr() 🔍 strpos()
🔁 str_replace() 🧱 trim() 🔗 explode() 🔗 implode() 🔀 strrev()
This refers to the overall concept of using arrays in PHP, including:
Declaring arrays (indexed, associative, multidimensional)
Accessing elements
Looping through arrays (foreach, for, etc.)
Basic operations like adding, updating, or deleting elements
It’s more about how you handle and use arrays in PHP.
📚 Array Functions = The toolbox: predefined PHP functions to manage arrays efficiently.
array_push()
array_merge()
sort()
in_array()
🧱 What is a Method?
🧑🏫 How to Define Methods
📞 How to Call a Method
🔄 Passing Parameters to Methods
🧠 $this Keyword
Week-4
📤 Sending Data
📥 Receiving Data
🛡️ Form Validation
🧼 Input Sanitization
🔁 Processing Logic
🧭 Client-Side Validation
🚫 Prevent Empty Submissions
🔢 Check Data Format
⚡ Improve User Experience
🔐 Combine with PHP
📅 Date Functions in PHP
🕒 date() ⏰ time() 📆 strtotime() 🔄 mktime() 🗓️ getdate()
➗ Math Functions in PHP
➕ abs() ➖ round() ✖️ pow() ➗ sqrt() 🔢 rand()
🖥️ Practice Programs in PHP
👋 Hello World🔢 Basic Calculator 📋 Form Data Handling 🔄 Looping and Conditional Statements
🧮 Simple Array Operations 📝 String Manipulation 🛠️ File Upload and Handling
🔐 User Login Authentication 📅 Date and Time Display 🛢️CRUD Operations with MySQL
Week-5
🗄️ What is MySQL
⚙️ How MySQL stores and manages data in tables.
🔗 The role of MySQL in web applications alongside PHP.
💻 Basic concepts: databases, tables, rows, and columns.
📡 How to connect PHP with MySQL to store and retrieve data.
🏗️ Creating a new database using CREATE DATABASE command.
📂 Selecting the database to use with USE command.
🏷️ Creating tables with CREATE TABLE including defining columns and data types.
🔑 Setting primary keys and constraints.
📝 Basic syntax to insert, update, and delete table records.
🔹 CREATE DATABASE 🔹 USE 🔹 CREATE TABLE
🔹 INSERT INTO 🔹 SELECT 🔹 UPDATE
🔹 DELETE 🔹 DROP TABLE 🔹 DROP DATABASE
➕ INSERT — Add new records to a table.
✏️ UPDATE — Modify existing records based on conditions.
❌ DELETE — Remove records from a table based on conditions.
SELECT INSERT UPDATE
DELETECREATE DROPALTER WHERE FROM JOIN Week-6
✅ What You Will Learn:
➕ Create — Insert new records into MySQL database using PHP.
👀 Read — Retrieve and display records from the database.
✏️ Update — Modify existing records through PHP scripts.
❌ Delete — Remove records from the database using PHP.
✅ What You Will Learn:
-
🔄 INNER JOIN — Select records with matching values in both tables.
-
🟠 LEFT JOIN (or LEFT OUTER JOIN) — Select all records from left table and matched records from right table.
-
🟢 RIGHT JOIN (or RIGHT OUTER JOIN) — Select all records from right table and matched records from left table.
-
⚪ FULL JOIN (or FULL OUTER JOIN) — Select all records when there is a match in either table. (Note: MySQL uses
UNIONfor this) -
❌ SELF JOIN — Join a table with itself.
✅ What You Will Learn:
-
📦
GROUP BY— Group rows that have the same values in specified columns. -
🔢 Use with aggregate functions like
COUNT(),SUM(),AVG(),MAX(),MIN() -
🧮 Summarize data (e.g., total sales per product, number of users per city)
-
🔎 Combine with
HAVINGto filter grouped results. -
📄 Useful for reports and analytics from large datasets.
✅ What You Will Learn:
🧩 How to connect PHP with a MySQL database using mysqli or PDO.
🔐 Securely handle database credentials (host, username, password, database name).
🔄 Open and close database connections.
📤 Execute SQL queries (INSERT, SELECT, UPDATE, DELETE) from PHP.
⚠️ Handle connection errors and query failures gracefully.
Week-7
✅ What You Will Learn:
🔹 Built-in Functions – Predefined functions provided by PHP (e.g., strlen(), array_push())
🛠️ User-Defined Functions – Functions created by the developer for specific tasks
🧱 Anonymous Functions (Closures) – Functions without a name, often used for callbacks
🧑🏫 Recursive Functions – Functions that call themselves to solve complex problems
🧬 Magic Functions – Special functions starting with double underscores (e.g., __construct(), __destruct())
✅ What You Will Learn:
🧠 What cookies are and why they’re used (store small data on the user’s browser)
📝 How to set a cookie using setcookie()
📥 How to retrieve a cookie using $_COOKIE
⌛ How to set expiration time for cookies
❌ How to delete cookies by setting their time in the past
✅ What You Will Learn:
🧠 What sessions are and how they store user data on the server
🟢 How to start a session using session_start()
📦 How to store data in a session using $_SESSION
🔍 How to access session data across multiple pages
❌ How to destroy a session using session_destroy()
Week-8
✅ What You Will Learn:
🔎 What filters are and why they’re used (validate & sanitize user input)
🧪 Use of filter_var() and filter_input() functions
✅ Validation filters (e.g., FILTER_VALIDATE_EMAIL, FILTER_VALIDATE_INT)
🧼 Sanitization filters (e.g., FILTER_SANITIZE_STRING, FILTER_SANITIZE_EMAIL)
🔐 Improve security by preventing XSS, SQL injection, and invalid data
✅ What You Will Learn:
🧭 What a namespace is — a way to organize and avoid name conflicts in large applications
🧱 How to define a namespace using the namespace keyword
🔗 How to use elements from a namespace with the use keyword
⚙️ Handle multiple classes/functions with the same name across different files
📦 Structure code better in large-scale or modular PHP projects
✅ What You Will Learn:
🧑🏭 How to define a class using the class keyword
🧰 How to create objects (instances) from a class
🛠️ How to declare properties (variables) and methods (functions) inside a class
🧬 Use of constructors (__construct) for initializing objects
🔐 Understanding access modifiers: public, private, protected
Week-9
✅ What You Will Learn:
🧱 Constructor (__construct) – Automatically runs when an object is created
⚙️ Used to initialize properties or set up starting logic
❌ Destructor (__destruct) – Automatically runs when an object is destroyed
🧹 Used for cleanup tasks like closing connections or freeing resources
🔄 Helps manage the object lifecycle efficiently in OOP
✅ What You Will Learn:
👨👦 What inheritance is — a class (child) can inherit properties and methods from another class (parent)
🧱 Use of the extends keyword to create a child class
🔄 How to reuse code and avoid repetition using inheritance
⚙️ How to override parent methods in the child class
🔐 Access control with public, protected, and private in inheritance
✅ What You Will Learn:
📝 What an interface is — a contract that defines methods a class must implement
🧱 How to declare an interface using the interface keyword
🔗 How classes implement interfaces with the implements keyword
⚙️ Interfaces enforce method signatures without method bodies
🔄 Support for multiple interfaces by a single class (multiple inheritance)
Week-10
✅ What You Will Learn:
🟢 Public — Accessible from anywhere (inside and outside the class)
🟡 Protected — Accessible within the class and its subclasses
🔴 Private — Accessible only within the class itself
🛡️ Control the visibility of properties and methods
⚙️ Helps implement encapsulation and protect data
✅ What You Will Learn:
🏷️ Properties — Variables that hold data inside a class
🔧 Methods — Functions that define behaviors inside a class
🧱 How to declare properties and methods
📞 How to access properties and call methods using objects
🔐 Use of access modifiers (public, protected, private) with properties and methods
✅ What You Will Learn:
🧩 What iterables are — any value that can be looped over with foreach
📚 Includes arrays and objects implementing the Traversable interface
🔄 How to use foreach to iterate over iterables
⚙️ Benefits of using iterables for flexible and readable code
🛠️ How to create custom iterable objects by implementing Iterator or IteratorAggregate
Week-11
✅ What You Will Learn:
❗ What exceptions are — a way to handle errors gracefully
🧱 How to throw exceptions using throw keyword
🛡️ How to catch exceptions with try-catch blocks
🔄 Use of finally block for cleanup code
⚙️ Creating custom exception classes for specific error handling
✅ What You Will Learn:
📁 How to open and close files using PHP functions
📝 Reading data from files (fread(), file_get_contents())
✍️ Writing data to files (fwrite(), file_put_contents())
🗑️ Deleting and renaming files
🔐 Handling file permissions and errors
Week-12
✅ What You Will Learn:
🔀 Conditional Statements — if, else, elseif, switch to control program flow
🔄 Loops — for, while, do-while, foreach for repetition
🔗 Logical Operators — && (AND), || (OR), ! (NOT) for complex conditions
🧩 Functions — Modularize code with reusable blocks
⚙️ Error Handling — Basic error control using try-catch and custom logic
✅ What You Will Learn:
🧩 Applying PHP & MySQL concepts in a real-world scenario
🛠️ Building a complete project: front-end form, back-end logic, database integration
🔗 Connecting user inputs with database operations (CRUD)
🛡️ Implementing validation, security (sessions, sanitization)
📈 Debugging and testing your application for functionality
There are no reviews yet.