PHP Basics and Conditional Logic
- PHP introduction
- Environment setup in different platforms
- Script syntax
- How to declare variable and data types
- Constants
- Arrays
- Strings
- Web concepts
- Decision making statements
- loop types
- operators
- Annie’s Quizzes
Functions and Error Handling
- What is Functions
- Creating PHP functions
- PHP functions with parameters
- Argument by reference
- setting default values for function parameter
- dynamic function calls
- PHP mails
- how to send text mail
- how to send html emails
- how to send attachments with emails
- regular expressions
- POSIX regular expressions
- predefined character ranges
- Regexp POSIX functions
- PERL style regular expressions
- Regexp PERL compatible functions
- Date and time functions
- Built-in functions
- file inclusion
- file manipulations
- exception handling
- bugs ,debugging
- Annie’s Quizzes
Object Oriented Programming
- What is Object Oriented Concepts
- Defining classes
- Creating Objects
- Member functions
- Constructor and Destructor
- Inheritance
- Function overriding
- Access Specifiers- private
- public and protected members
- Interfaces, Constants
- Abstract Classes
- Static keyword
- Final keyword
- calling parent constructors
- Annie’s Quizzes
MySQL Installation and Basics
- Database Introduction
- MySQL installation on various platforms
- MySQL connection
- Database creation
- Database Manipulations- Add
- Edit Retrieve and Delete.
- Table creation and table manipulations- Add Edit
- Retrieve and Delete Annie’s Quizzes
Advance Queries and Data Manipulation using PHP
- LIKE clause
- Sorting
- Joins
- Handling NULL Values
- Regular Expressions
- Transactions
- ALTER Command
- Indexes
- Temporary Tables
- Clone Tables
- Database Information
- Sequences Handling Duplicates
- SQL Injections
- Select
- insert
- update and delete using PHP script
- Annie’s Quizzes
MVC Infrastructure Basics & Introduction to CakePHP
- Introduction to MVC
- What are Model-View-Controller
- Why use framework in the project (conventional vs. MVC project)
- Installation of CakePHP
- CakePHP folder structure
- File naming conventions
- Important config file (core.php, database.php)
- Annie’s Quizzes
CakePHP Controller, Views and Layout
- Application flow - How Controller and view interacts/ exchanges data
- What are CakePHP helpers?
- Most commonly used helpers like Form HTML
- Session
- Cookie etc
- Create a controller and how URLs mapped to controller and views
- Create views and layouts
- Annie’s Quizzes
Models and Database Interaction in CakePHP
- Models: What are models and how they interact with database?
- Accessing and manipulating table data using find save
- update methods of the model
- Joining tables
- conditions
- conditions other than =(LIKE, BETWEEN,)
- order by in CakePHP models
- Change database dynamically using the definitions in database
- php config file
- Annie’s Quizzes
- Q & A, Quick Recap.
Creating Dynamic Forms using CakePHP Html Helpers
- Introduction to basic html form
- get, post methods
- Generate form elements like input boxes, dropdowns, radio buttons, and links using CakePHP html helper
- Form validation using Model validation definitions
- Create, retrieve and delete cookies
- Create, retrieve and delete session variables
- File handling in CakePHP (create, delete, read files)
- CakePHP Global variables and their use
- Annie’s Quizzes
- Q & A, Quick Recap
Using MVC & CakePHP to develop a website