Web Development (PHP MySQL)

The Web Development course has been designed to equip the student with fundamental knowledge and skills in web programming by using PHP & MySQL. The course acknowledges that the candidate has little or no knowledge with respect to these technologies. The course content has been designed with content that addresses the needs of web application programing in back end, be it for academic purposes or for professional ones.

Outline

Introduction of 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
  • Numbers part one: Integers
  • Numbers part two: Floating points
  • Arrays
  • Associative arrays
  • Array functions
  • Booleans
  • NULL and empty
  • Type juggling and casting
  • Constants

Control Structures: Logical Expressions

  • If statements
  • Else and elseif statements
  • Logical operators
  • Switch statements

Control Structures: Loops

  • While loops
  • For loops
  • Foreach loops
  • Continue
  • Break
  • 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
  • Using GET values
  • Encoding GET values
  • Encoding for HTML
  • 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

  • Working with cookies
  • Setting cookie values
  • Reading cookie values
  • Unsetting cookie values
  • Working with sessions

MySQL Basics

  • 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
  • Working with retrieved data
  • Creating records with PHP
  • Updating and deleting records with PHP
  • SQL injection
  • Escaping strings for MySQL
  • Introducing prepared statements

Advanced PHP Techniques

  • Using variable variables
  • Applying more array functions
  • Building dates and times: Epoch/Unix
  • Formatting dates and times: Strings and SQL
  • Setting server and request variables
  • 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
  • Using setters and getters
  • Working with the static modifier
  • Reviewing the scope resolution operator
  • 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
  • Examining file details
  • Working with directories
  • Viewing directory content

Sending Emails

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

Schedule

The course is delivered in 30 contact hours of training.
Classes are usually held two times a week on three-hour sessions or one times a week on six-hour sessions.

Audience

The course is intended for students with some experience with Java. Exception to this can be programmers who have some real world experience with Object Oriented languages such as C++ or C# because of their similar syntax and structure. The candidate must have moderate understanding and reading skills in English language in order to pursue the course.

For booking exams please visit our Testing Center.

Course Price Invoice
Web Development (PHP MySQL) 198.00 €

For upcoming classes and schedules, please click here.