Why Learn PHP?

PHP is a widely used server-side programming language that’s become increasingly fast and powerful over the years. PHP works well with HTML and databases, making it a great language for anyone interested in building dynamic web applications.

Note on Prerequisites:

Advanced knowledge in HTML, CSS and JavaScript (recommended to follow “Advanced Multimedia Web Design & Development Techniques” course first).

Installing PHP and SQL

Installing

  • a text editor
  • WAMP or XAMPP (or equivalent),
  • MySQL Database

Data Management

  • The value of Data Management
  • Introduction to Database
  • Database Terminology
  • File Systems vs. Database Systems
  • Phases of database design
  • Conceptual Database Design
  • Entity-Relationship (ER) Models
  • Enhanced ER Diagrams

Relational Database Design

  • SQL- Data Definition Language (DDL)
  • SQL – Data Manipulation Language (DML)
  • Database Programming Stored Procedures, Functions, Triggers)

PHP Fundamentals

  • Server Configuration
  • PHP Basics
  • Data Types
  • Flow Control (use of loops)
  • String Manipulation
  • Use of Array

Writing Functions in PHP

  • Introductions to Functions
  • User Defined Functions
  • PHP Functions

HTML Form Processing

  • HTML Form Basics
  • GET Method
  • POST Method
  • Client-Side form Validation (Using JavaScript)

Manipulating and interacting with files in PHP

  • Directory Manipulation
  • File Uploading

Session handling & Cookies

  • Server Variables
  • Use of Sessions & Cookies
  • Application development using sessions and cookies.

Managing Data with MySQL

  • Introduction to MySQL RDBMS
  • Designing a database
  • Use of MySQL Tools
  • Database programming

Object Oriented Programming with PHP

  • Understanding Classes and Objects
  • Using Constructors and Destructors
  • Extending Classes through Inheritance
  • Controlling the visibility of properties and Methods
  • Static Properties and Methods
  • PHP Magic Constants
  • PHP Exception Handling

Connecting MySQL with PHP

  • PHP Connect to MySQL Server
  • Connecting to MySQL Database Server
  • Creating MySQL Database Using PHP
  • Creating Tables inside MySQL Database Using PHP
  • Inserting Data into a MySQL Database Table
  • Insert Data into a Database from an HTML Form
  • PHP MySQL Prepared Statements
  • Selecting Data from Database Tables
  • Filtering the Records
  • Updating Database Table Data

Introduction to PHP Data Objects (PDO)

  • Introduction to PDO
  • Compare MySQL with PDO
  • Application Development with PDO & PHP

JavaScript and libraries (ReactJS)

  • Client-side programing with JavaScript
  • Modern front-end development with ReactJS

Using PHP frameworks to develop applications (CodeIgniter will be used)

  • Developing PHP applications based on MVC (Model View Controller) using Codeigniter
  • Queary builder and Form validations with Codeigniter
  • Connecting MySQL database with codeigniter

Building a CRUD Application

Bringing all the previous concepts together and develop your own customized web application.