Building and Programming Web Pages with HTML5, CSS3 & JavaScript

PL-923 : Building websites with PHP and MySQL (Level 2)

  • 39Training hours
  • 13Lectures
  • 7Assistant hours
  • 1300Egyptian pounds
  • 10Students maximum

Enrol on this programme now
and take the following offers and discounts, for a limited time

15%discount on morning sessions
1105 pounds instead of 1300

15%discount on afternoon sessions
1105 pounds instead of 1300

15%discount on evening sessions
1105 pounds instead of 1300


* These offers run for a limited period and may change or be withdrawn without notice. Note that the booking itself has to be made inside the academy.
** Morning slots run from 12:30 to 3:30 in the afternoon, afternoon slots from 4 to 7, and evening slots from 7:30 to 10:30 at night.

Contents of the training programme

Advanced PHP Techniques

  • Multidimensional Arrays
  • Advanced Function Definitions
  • The Heredoc Syntax
  • Using printf() and sprintf()

Developing Web Applications

  • Documenting Code
  • Code Style and Structure
  • Modularizing a Web Site
  • Affecting the Browser Cache

Advanced Database Concepts

  • Storing Sessions in a Database
  • Creating Stored Functions
  • Displaying Results Horizontally

Security Techniques

  • Remembering the Basics
  • Validating Form Data
  • Using PECL Filter
  • Authentication with PEAR Auth
  • Using MCrypt

E-commerce Techniques

  • E-commerce Concepts
  • Creating the Database
  • Creating the Configuration File
  • Making the Template
  • Creating the Index Page
  • Browsing by Category
  • Showing a Product
  • Implementing a Shopping Cart
  • Validating Credit Cards

Basic Object-Oriented Programming

  • OOP Theory
  • Defining a Class
  • Creating an Object
  • The $this Attribute
  • Creating Constructors
  • Creating Destructors
  • Auto loading Classes

Advanced OOP

  • Advanced Theories
  • Inheriting Classes
  • Inheriting Constructors and Destructors
  • Polymorphism
  • Access Control
  • Using the Scope Resolution Operator
  • Creating Static Members
  • Abstract Classes and Methods

Real-World OOP

  • Catching Exceptions
  • Extending the Exception Class
  • Creating a Shopping Cart Class
  • Using the Cart Class

Framework Overview

  • Codeignitr Overview
  • Yii Overview

CMS Overview

  • Joomla Overview
  • Wordpress Overview

Using PEAR

  • Using Benchmark
  • Using HTML_QuickForm
  • Using Mail_Mime
  • Ajax
  • Introduction to Ajax
  • A Simple Example
  • Full-Fledged Ajax
  • Debugging Ajax Applications

XML and PHP

  • What Is XML?
  • XML Syntax
  • Attributes, Empty Elements, and Entities
  • Document Type Definitions
  • Parsing XML
  • Creating an RSS Feed

Cookies

Sending Advanced Email with PHP & HTML

File System Management

  • Opening a File - fopen()
  • Reading from a File - fgets()
  • Writing to a File - fwrite()
  • File Locking - flock()
  • Uploading Files via an HTML Form
  • Getting File Information
  • More File Functions
  • Directory Functions

Advanced MYSQL

Subqueries, Joins and Unions
  • Subqueries
  • Joins
  • Table Aliases
  • Multi-table Joins
  • Outer Joins
  • Unions
  • UNION ALL
  • UNION Rules

MDB2

Advantages and Disadvantages of MDB2
  • Why use a database abstraction layer?
  • When not to use a database abstraction layer?
Using MDB2

Prerequisites

  • A good working knowledge of HTML/CSS
  • A complete grasp of the fundamentals of PHP (a placement test may be set before your registration is accepted - free of charge)

Job title

After finishing this course you can work as a web developer using PHP.

Meet the instructors on this course

Hamada Mahmoud
Hamada Mahmoud
Trainer and web developer

Hamada works as a professional web developer across a number of platforms, PHP and MS ASP.NET among them, and holds Microsoft's certification as a Certified Solutions Developer for web applications, taken after his BSc in Computer Science. He has long practical experience building web applications aimed squarely at the job market, alongside delivering a good many training courses in the field.

A message for the trainer? Send it from here.
Shaimaa Eid
Shaimaa Eid
Trainer and web developer

Shaimaa began programming in 2002, writing statistical applications in C before moving on to Visual C#, and in 2006 she started building web applications on PHP and open-source software. She holds several Microsoft certifications, among them Microsoft Certified Trainer and Certified Solutions Developer for the web. She has long practical experience in building websites and web applications and in running development teams and software projects, and has held a number of positions at software companies, most recently eCoda Solutions, where she is currently the company's development team manager. Alongside all of that, and since 2004 in particular, she has written and delivered many specialist training courses in website design and development at a number of well-regarded academies and training centres.

A message for the trainer? Send it from here.
Mostafa Hefny
Mostafa Hefny
Head of the academy, and PHP application developer

Mostafa began his working life five years ago in website design and development, using languages such as HTML, CSS and PHP, before moving into training. He preferred to pursue his ambitions in that field independently, and founded 7dash Training Academy in early 2010. He has taught web programming languages at 7dash ever since, and later founded a second company specialising in website design and development, which he named "Dominato" - bringing together job-market experience and training skill.

A message for the trainer? Send it from here.

Are you following a particular training track?

Here is where this course sits within every training track that includes it


What else comes with this course


  • Attend more than once, free of charge

  • Drinks cafeteria

  • A comfortable place to study

  • Continuing support

  • Private assistance hours
Book this course

Reserve your seat on this course

Enter your details now and we will call you to fix a date and take you through the booking.



Have a question ?

We are glad to help you get a better grasp of things, so do not hesitate to contact us if you have any questions at all.



98 Mostafa El Nahas
Nasr City - Cairo.