Syllabus of PHP Training in Tutorsvalley

• PHP & MySQL Course Syllabus
• Introduction to Web & PHP
• What is PHP?
• The history of PHP
• Why choose PHP?
• Installation overview

First Steps

• Embedding PHP code on a page
• Outputting dynamic text
• The operational trail
• Inserting code comments

Exploring Data Types

• Variables
• Strings
• String functions
• Associative arrays
• Array functions
• Booleans
• NULL and empty
• Type juggling and casting
• Constants

Control Structures: Logical Expressions

• If statements
• Else and else if statements
• Logical operators
• Switch statements
• Control Structures: Loops
• While loops
• For loops
• Understanding array pointers

User-Defined Functions

• Defining functions
• Function arguments
• Returning values from a function
• Multiple return values
• Scope and global variables
• Setting default argument values

Debugging

• Common problems
• Warnings and errors
• Debugging and troubleshooting

Building Web Pages with PHP

• Links and URLs
• Including and requiring files
• Modifying headers
• Page redirection
• Output Buffering

Working with Forms and Form Data

• Building forms
• Detecting form submissions
• Single-page form processing
• Validating form values
• Problems with validation logic
• Displaying  validation errors
• Custom  validation functions
• Single-page form with  validations

Working with Cookies and Sessions

 

 

 

• Unsetting cookie values
• Working with sessions

MySQL Basic

• MySQL introduction
• Creating a database
• Creating a database table
• CRUD in MySQL
• Populating a MySQL database
• Relational database tables
• Populating the relational table

Using PHP to Access MySQL

• Database APIs in PHP
• Connecting to MySQL with PHP
• Retrieving data from MySQL
• SQL injection
• Escaping strings for MySQL
• Introducing prepared statements

Building a Content Management System (CMS)

• Blueprinting the application
• Building the CMS database
• Establishing your work area
• Creating and styling the first page
• Making page assets reusable
• Connecting the application to the database

Using Site Navigation to Choose Content

• Adding pages to the navigation  subjects
• Refactoring the navigation
• Selecting pages from the navigation
• Moving the navigation to a function

Application CRUD

• Finding a subject in the database
• Refactoring the page selection
• Creating a new subject form
• Processing form values and adding subjects
• Passing data in the session
• Validating form values
• Creating an edit subject form
• Using single-page submission
• Deleting a subject
• Cleaning up
• Assignment: Pages CRUD
• Assignment results: Pages CRUD

Building the Public Area

• The  public appearance
• Protecting page visibility

Regulating Page Access

• User authentication overview
• Admin CRUD
• Encrypting passwords
• Salting passwords
• Adding password encryption to CMS
• New PHP password functions
• Creating a login system
• Checking for authorization
• Creating a logout page

Advanced PHP Techniques

• Using  variable variables
• Applying more array functions
• Establishing global and static variable scope
• Making a reference assignment
• Using references as function arguments
• Using references as function return values

Introduction to Object-Oriented Programming (OOP)

• Introducing the concept and basics of OOP
• Defining classes
• Defining class methods
• Instantiating a class
• Referencing an instance
• Defining class properties

OOP in Practice

• Understanding class inheritance
• Setting access modifiers
• Referencing the Parent class
• Using constructors and destructors
• Cloning objects
• Comparing objects

Working with Files and Directories

• File system basics
• Understanding file permissions
• Setting file permissions
• PHP permissions
• Accessing files
• Writing to files
• Deleting files
• Moving the file pointer
• Reading files
• Viewing directory content

Sending Emails

• Configuring PHP for email
• Sending email with mail()
• Using headers
• Reviewing SMTP
• Using PHPMailer