← Back to training
Course
PHP AND MYSQL
This 2‑month part‑time skill development course on PHP and MySQL is designed to empower students with practical skills for self-employment and career growth in web development. You’ll learn PHP programming fundamentals, database management with MySQL, and how to build dynamic web applications that handle real data effectively.
Verified AICTE InstituteCertificate Included2 MonthsPart-TimeBeginner
HTMLHTML5PHPPHPSQLMySQL
Award
CERTIFICATE
Eligibility
Below SSC
Learning Outcomes
- ✓ Understand PHP syntax, variables, data types, and operators
- ✓ Build dynamic pages using decisions, loops, and functions
- ✓ Work confidently with arrays, strings, files, sessions, and cookies
- ✓ Capture and validate HTML form data, including file uploads
- ✓ Connect PHP applications to MySQL and perform CRUD operations
- ✓ Use joins and parameterized queries for real-world database work
- ✓ Handle exceptions and debug common PHP/MySQL errors
Curriculum
PHP AND MYSQL syllabus
Expand modules to see topics
Module 1: Introduction to PHP
- • Evaluation of PHP
- • Basic Syntax
- • Defining Variables and Constants
- • PHP Data Types
- • Operators and Expressions
Module 2: Decisions and Loops
- • Making Decisions
- • Repetitive Tasks with Looping
- • Mixing Decisions and Looping with HTML
Module 3: Functions
- • What is a Function?
- • Defining and Calling Functions
- • Call by Value and Call by Reference
- • Recursive Functions
- • String Operations
Module 4: Arrays
- • Anatomy of an Array
- • Index-Based and Associative Arrays
- • Accessing Array Elements
- • Looping Through Arrays
- • Useful Library Functions
Module 5: Handling HTML Forms with PHP
- • Capturing Form Data
- • Dealing with Multi-Value Fields
- • File Upload Forms
- • Redirecting After Form Submission
Module 6: Working with Files and Directories
- • Understanding Files and Directories
- • Opening, Closing, Copying, Renaming, and Deleting Files
- • Working with Directories
- • File Uploading and Downloading
Module 7: Session and Cookie Handling
- • Introduction to Session Control
- • Managing Sessions with PHP
- • Working with Cookies
- • Registering and Destroying Session Variables
Module 8: Database Connectivity with MySQL
- • Introduction to RDBMS
- • Connecting to MySQL Database
- • Performing Basic Database Operations (DML)
- • Setting Query Parameters
- • Executing Queries
- • Joins (Cross, Inner, Outer, Self Joins)
Module 9: Exception Handling
- • Understanding Exceptions and Errors
- • Try, Catch, Throw
- • Error Tracking and Debugging