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.