SkillManthan Logo - Best IT Training Institute in Lucknow
Loading your future skills...
+91-6392-361-443,+91-9120-341-047
theskillmanthan@gmail.com
Register Now Skill Test
Download Courses - SkillManthan Technologies Pvt Ltd
Course Banner

Foundation of PHP & MySQL

Learn PHP & MySQL from scratch — build dynamic websites, connect databases, manage backend logic and start your journey toward full-stack web development.


Course Description

This course focuses on server-side programming using PHP along with MySQL database. You will build real applications, perform CRUD operations, handle forms, authentication and learn industry-level coding practices.

Detailed Course Syllabus

L.N. Contents Hours
1
  1. Introduction to Web
  2. Client vs Server
  3. Introduction to PHP
  4. Installing XAMPP / WAMP
  5. Running First PHP Script
  6. PHP Syntax, Comments, Echo/Print
2
2
  1. Variables & Data Types
  2. Constants
  3. Operators
    • Arithmetic
    • Relational
    • Logical
    • Assignment
  4. Input / Output
2
3
  1. Control Statements
  2. if / if-else / else-if
  3. Switch
  4. Loops
    • for
    • while
    • do-while
    • foreach
2
4
  1. Arrays
  2. Indexed Array
  3. Associative Array
  4. Multidimensional Array
  5. Array Functions
2
5
  1. Functions
  2. User Defined Functions
  3. Include / Require
  4. Form Handling (GET / POST)
2
6
  1. Working with MySQL
  2. Database & Tables
  3. Primary Key, Auto Increment
  4. CRUD Operations (SQL)
2
7
  1. PHP & MySQL Connectivity
  2. Connecting Database
  3. Insert / Select / Update / Delete
  4. Displaying Data in Table
2
8
  1. Form Validation
  2. Server Side Validation
  3. Sanitization & Security Basics
2
9
  1. Session & Cookies
  2. User Login
  3. User Logout
  4. Role Based Access (Intro)
2
10
  1. File Uploading
  2. Image Handling
  3. Storing File Path in Database
2
11
  1. Mini Project
  2. Student Management System OR Simple Blog Website
  3. Assessment & Debugging Session
2