Training Calendar

Mon Tue Wed Thu Fri Sat Sun
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

psmb

Total Visitors

50%United States United States
27.5%China China
15%Canada Canada
5%Malaysia Malaysia
2.5%United Kingdom United Kingdom

Last Week: 3
This Month: 3
Last Month: 26
Total: 50067

Web Application Development Using PHP and MySQL

 

Course Overview

PHP can be used to create interactive dynamic websites and its rapidly gaining in popularity because of it a flexible, cross-platform technology that provides amazingly powerful features. During this five-day course, participants will learn fundamental terms and techniques necessary for producing useful and realistic PHP applications. This course is designed to give participants the knowledge to develop/maintain HTML/PHP code that utilizes the MySQL Database system. Through a hands-on approach, this instructor-led course will help the participants improve PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are dynamic efficient, and solid.

 

 

Prerequisites

Basic knowledge in HTML, Basic Programming.

 

Target Audience

Software Developers who want to learn how PHP and MySQL can be used for the rapid prototyping and deployment of dynamic websites.

 

PHP & MySQL (Basic-to-Intermediate) – Schedule

Day 1

09.00am – 10.00am

PHP Overview

  • What is PHP?
  • The history of PHP
  • Why choose PHP?
  • Installation overview

Windows Installation

  • Overview
  • Installing XamppServer
  • Finding the document root
  • Configuring PHP
  • Configuring MySQL
  • Text editor
10.00am – 10.30am

Breakfast

10.30am – 01.00pm

First Steps

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

Exploring Data Types

  • Variables      
  • Strings
  • Constants      
  • Arrays
  • Associative arrays

01.00pm – 02.00pm

Lunch

02.00pm – 05.00pm

Control Structures: Logical Expressions

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

Control Structures: Loops

  • While loops
  • For loops  
  • Foreach loops

User-Defined Functions

  • Defining functions  
  • Function arguments  
  • Returning values from a function
  • Scope and global variables 

Day 2

09.00am – 10.00am

Building Web Pages with PHP

  • Links and URLs
  • Using GET values  
  • Encoding GET values
  • Encoding for HTML

10.00am – 10.30am

Breakfast

10.30am – 01.00pm

Loops

  • While loops
  • For loops
  • Foreach loops
  • Continue
  • Break
  • Understanding array pointers

01.00pm – 02.00pm

Lunch

02.00pm – 05.00pm

Working with Sessions

  • Sessions

MySQL Basics

  • SQL Overview
  • MySQL insert
  • MySQL Read
  • MySQL Update
  • MySQL Update

Using PHP to Access MySQL

  • 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 & Escape string for mySQL

                                                                        Day 3

09.00am – 10.00am

Building a Content Management System (CMS)

  • Blueprinting the application
  • Building the CMS database
  • Establishing your work area

10.00am – 10.30am

Breakfast

10.30am – 01.00pm

  • 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
  • Highlighting the current page
  • Moving the navigation to a function

01.00pm – 02.00pm

Lunch

02.00pm – 05.00pm

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

Day 4

09.00am – 10.00am

Building the Public Area

  • The public appearance
  • Using a context for conditional code
  • Adding a default subject behaviour
  • The public content area
  • Protecting page visibility

10.00am – 10.30am

Breakfast

10.30am – 01.00pm

Regulating Page Access

  • User authentication overview
  • Admin CRUD
  • Creating a login system
  • Checking for authorization
  • Creating a logout page

01.00pm – 02.00pm

Lunch

02.00pm – 05.00pm

Conclusion