Level 1

towerdevelopmentData Management

Dec 16, 2012 (4 years and 11 months ago)

301 views

Level 1: Site creation basics


Module1.
Introduction to PHP


* Apache server installation and configuration


* PHP installation and configuration


* Installing PHP as a module of Apache


* History of PHP


* Comparison with dynamic content al
ternatives (Perl, CGI, ASP, JSP, Servlets , CGI,
etc)


* PHP tools and set up (web browser/server, editor, libraries, etc)


* Create a basic PHP Script


* Taking user input


* Self Referring Forms


* Selecting alternatives


* Use PHP to g
enerate HTTP headers


* Pass PHP variables via the URL


* Debugging Tips


Module2.
PHP fundamentals
-

intro

Variables and Expressions in PHP


* Identifiers


* Data Types (integers, floats, strings and booleans)


* Text constants, interpolati
on, here documents


* Creating Variables


* Variable assignment


* Variable Scope


* User
-
defined Constants


* HTTP environment variables


* Magic Constants


* Variable References

Conditional Tests and Events in PHP


* True and Fals
e


* If


* Comparing Strings and Numbers


* else and elseif


* The switch / case statement


* The ? : Operator


* Comparing for equality or identity


Module3.
PHP fundamentals

PHP Flow Control


* Loops


* while


* do ... while



* for


* break and continue


* exit


Module4.
PHP fundamentals

PHP Functions


* Purpose of functions


* Built
-
in functions


* Declaring functions


* Functions Arguments


* Arguments
-

Call by Reference


* Default Arguments


* R
eturn


* Returning References


* Variable Scope (global vs local)


* Static variables


* Recursion


* include and require


* Variable function calls


Module5.
Working with HTTP


forms


* HTTP1.1


* GET and POST methods


* Us
e PHP to generate HTTP headers


* HTTP environment variables


* Exercise: building calculator



Level 2: Webdevelopment, using PHP with DBSMs


Module1.

Handling Databases with PHP


* PHP's database APIs


* Error
-
handling strategies


* Connection/disconnection, log in/log out


* Escaping strings in SQL statements


* Including common access functions


* Doing simple SQL queries via PHP


* Building HTML tables using SQL Queries


* Show access to: MySQL, PostgreSQL & MS
-
SQL


* Using PEAR DB


Module2.
PHP and MySQL : Installing Required Software

Summary:

After completing this module, students will be able to:

To install and configure MySQL

To install and configure Apache with PHP

To create MySQL users and grant privileges

To test PHP and MySQL installations

To configure PHP

Topics:

Installing MySQL

Installing Apache with PHP

Setting MySQL permissions

Testing the installation

Configuring PHP


Module3.
PHP

and MySQL : PHP Basics

Summary:

After completing this module, students

will be able to:

Identify basic PHP syntax

Create basic PHP scripts

Send data to the Web browser

Apply variables, strings, and constants to a PHP a script

Topics:

PHP

Basic syntax

Sending data

Understanding PHP, HTML, and white space

Writing comments

Usin
g variables

Using strings

Using numbers

Using constants


Module4.
PHP and MySQL : Programming with PHP

Summary:

After completing this module, students will be able to:

Handle HTML forms using PHP scripts

Validate form data

Manage arrays using various types

of loops

Work with magic quotes

Topics:

Creating HTML forms

Handling HTML forms

Managing magic quotes

Using conditionals and operators

Validating form data

Using arrays

Creating and accessing arrays

Multidimensional arrays

Arrays and strings

Sorting array
s

For and While loops


Module5.
PHP and MySQL : Creating Dynamic Web Sites

Summary:

After completing this module, students will be able to:

Create PHP scripts using multiple files

Display and handle HTML forms within a single PHP script

Create and call fun
ctions

Create functions that take arguments and return values

Set and alter variable scope

Send email from a PHP script

Topics:

Including multiple files

Using PHP redux

Making sticky forms

Creating your own functions

Creating a function that takes argument
s

Setting default argument values

Returning values from a function

Variable scope

Date and time functions


Module6.
PHP and MySQL : SQL and MySQL

Summary:

After completing this module, students will be able to:

Choose column types and other column properti
es

Create databases and tables

Insert records, select, update and delete data

Use conditionals and functions

Topics:

MySQL

Choosing column types

Choosing other column properties

Using mysql client

Creating databases and tables

Inserting records

Selecting d
ata

Using conditionals

Using LIKE and NOT LIKE

Sorting and limiting query results

Updating and deleting data

Using text and numeric functions

Formatting date and time functions


Module7.
PHP and MySQL : Advanced SQL and MySQL

Summary:

After completing this

module, students will be able to:

Normalize a database into First, Second and Third Normal Forms

Create and populate a database in MySQL

Search a database using joins, groupings, and FULLTEXT searches

Change the search engine type of a table

Create indexe
s to improve the ability to search a database

Topics:

Normalization, keys, and relationships

First Normal Form

Second Normal Form

Third Normal Form

Creating and populating the database

Performing joins

Grouping selected results

Creating indexes

Using diffe
rent table types

Performing basic FULLTEXT searches

Performing Boolean FULLTEXT searches

Optimizing the database


Module8.
PHP and MySQL : Error Handling and Debugging

Summary:

After completing this module, students will be able to:

Identify error types

Vi
ew, log, and debug errors

Adjust PHP's error reporting

Create custom error handlers

Topics:

General error types and debugging

Debugging HTML

Displaying PHP errors

Adjusting PHP error reporting

Creating custom error handlers

Logging PHP errors

PHP debugging

techniques

SQL and MySQL debugging techniques


Module9.
PHP and MySQL : Using PHP with MySQL

Summary:

After completing this module, students will be able to:

Describe how arguments and PHP functions relate to the database

Differentiate between simple and
complex functions depending on execution results

Understand the importance of associative and indexed arrays.

Modify specific scripts to allow for secure data transmission

Update database records using PHP scripts

Topics:

Modifying the template

Connecting
to MySQL and selecting the database

Executing simple queries

Retrieving query results

Ensuring secure SQL

Counting returned records

Updating records with PHP


Module10.
PHP and MySQL : Developing Web Applications

Summary:

After completing this module, stud
ents will be able to:

Adjust behavior for server settings

Pass variables and values to a script

Edit existing records

Paginate query results

Make sortable displays

Use HTTP headers

Topics:

Adjusting behavior for server settings

Sending values manually

Usin
g hidden form inputs

Editing existing records

Paginating query results

Making sortable displays

Understanding HTTP headers


Module11.
PHP and MySQL : Cookies and Sessions

Summary:

After completing this module, students will be able to:

Use cookies

Use sess
ions

Improve session security

Manage the relationship between cookies and sessions

Topics:

Setting cookies

Accessing cookies

Setting cookie parameters

Deleting cookies

Setting session variables

Accessing session variables

Deleting session variables

Changin
g session behavior

Changing the session cookie settings

Using sessions without cookies

Improving session security


Module12.
PHP and MySQL : Web Application Security

Summary:

After completing this module, students will be able to:

Prevent forms from being
submitted multiple times

Validate form data

Define patterns and both match and replace them

Manage database encryption and decryption techniques

Topics:

Preventing multiple submissions

Validating the right form

Handling HTML

Validating data

JavaScript form

validation

Defining a pattern with regular expressions

Matching regular expression patterns

Matching and replacing patterns

Database security and encryption

Secure salt storage


Module13.
PHP and MySQL : Extended Topics

Summary:

After completing this modu
le, students will be able to:

Upload a file in PHP

Develop JavaScript using PHP

Utilize output buffering

Identify Improved MySQL Extension functions

Describe the purpose of PEAR

Topics:

Handling File Uploads

Uploading PHP Files Creating Java

Script Using O
utput Buffering Using the Improved MySQL Extension

New MySQL Features

Using Prepared Statements

Using PEAR


PHP and MySQL : Content Management Example

Summary:

After completing this module, students will be able to:

Create the advanced PHP scripts needed f
or a content management site

Update and add information with a database

Download files through PHP scripts and database interactions

Manage files through PHP scripts and database interactions

Topics:

Creating the template

Creating the basic pages

Managing
URLs

The list() function

The serialize() and urlencode() functions

Managing files

Viewing and downloading files


Module14.
PHP

and MySQL : User Registration Example

Summary:

After completing this module, students will be able to:

Handle user registration

A
ctivate accounts

Create login and logout scripts

Apply password management

Topics:

Creating the templates

Writing the configuration scripts

Creating the home page

Registration

Activating an account

Logging in and logging out

Resetting a password

Changing a

password


Module15.
E
-
Commerce Example

After completing this module, students will be able to:

Create a database for an e
-
commerce site

Create the administrative pages for an e
-
commerce site

Create pages for a customer to browse the inventory and place or
ders from an e
-
commerce site

Create and manage an online shopping cart for your e
-
commerce site

Topics:

Creating the database

The administration side

Creating the public template

The product catalog

The shopping cart

Recording the orders