Dynamic Server Pages

1
Dynamic Server Pages
2
Lesson 1Introduction to PHP
3
Objectives

• Define PHP
• Identify platforms and Web servers that support
  PHP
• Describe the installation and configuration of
  PHP
• Discuss add-on modules used with PHP
• Create a Web publishing directory with the Apache
  server

4
What Is PHP?

• Server-side scripting language
• Embedded in HTML documents
• Known as PHP Hypertext Preprocessor

5
Supported Platformsand Web Servers

• PHP modules
• CGI interpreter or Apache module?

6
Installationand Configuration

• Installing MySQL
• Installing Apache and PHP

7
Summary

• Define PHP
• Identify platforms and Web servers that support
  PHP
• Describe the installation and configuration of
  PHP
• Discuss add-on modules used with PHP
• Create a Web publishing directory with the Apache
  server

8
Lesson 2PHP Fundamentals
9
Objectives

• Describe the structure of PHP pages
• Define variables and data types
• Discuss constants, variable functions, and arrays
• Define and use operators and functions
• Describe and use conditional statements and loops

10
PHP Mechanics

• Script delimiters
• Page structure
• Containers
• Comments

11
PHP Variables

• Data types
• Integer
• Double
• String
• Constants
• Type casting
• Variable functions

12
PHP Operators

• Operator precedence

13
Statements

• Conditional statements
• Loops

14
PHP Arrays

• Associative arrays
• Multi-dimensional arrays
• Sorting arrays

15
PHP Functions

• The function statement
• Passing arguments
• Variable scope
• Assigning a function to a variable

16
Summary

• Describe the structure of PHP pages
• Define variables and data types
• Discuss constants, variable functions, and arrays
• Define and use operators and functions
• Describe and use conditional statements and loops

17
Lesson 3String Manipulationand File
Input/Output
18
Objectives

• Discuss PHP string functions
• Describe and use regular expressions
• Define and use pattern matching
• Open and close files on the server
• Write to and read from files on the server
• Create and use flat database files

19
String Functions

• strlen() function
• substr() function
• strpos() function
• trim() function
• strtolower() and strtoupper() functions
• ucfirst() and ucwords() functions
• printf() and sprintf() functions

20
Regular Expressionsand Pattern Matching

• Common escape sequences
• Built-in character classes

21
RegularExpression Functions

• ereg() and eregi() functions
• ereg_replace() and eregi_replace() functions

22
File Inputand Output

• Opening files
• File mode specifiers
• Reading files
• Writing to files
• Moving within files

23
Summary

• Discuss PHP string functions
• Describe and use regular expressions
• Define and use pattern matching
• Open and close files on the server
• Write to and read from files on the server
• Create and use flat database files

24
Lesson 4PHP and Databases
25
Objectives

• Explain the basics of databases
• Explain database structure and schemas
• Define and use the SQL
• Discuss Cursors and ResultSets
• Define stored procedures
• Describe the MySQL database server

26
Objectives (contd)

• Create databases and database tables using MySQL
  and PHP
• Add records to a MySQL database
• Search a MySQL database
• Update and delete records from a MySQL database

27
RelationalDatabases

• Tuples
• Attributes
• Objects

28
DatabaseSchemas
BankAccount Table Customer Table
Integer ID
Integer ID
Double Balance
String FName
Boolean Checking
String LName
String Address
Date StartDate
Integer Customer
29
Structured Query Language (SQL)

• Data Definition Language (DDL)
• Data Query Language (DQL)
• Data Manipulation Language (DML)

30
Cursors and ResultSets

• ResultSet RecordSet
• Loop construct
• The next() method

31
MySQL and PHP

• PHP provides functions that allow Web-based
  applications to interface with the MySQL database
  server

32
Summary

• Explain the basics of databases
• Explain database structure and schemas
• Define and use the SQL
• Discuss Cursors and ResultSets
• Define stored procedures
• Describe the MySQL database server

33
Summary (contd)

• Create databases and database tables using MySQL
  and PHP
• Add records to a MySQL database
• Search a MySQL database
• Update and delete records from a MySQL database

34
Lesson 5Debugging PHPand PHP Security
35
Objectives

• Explain debugging PHP applications
• Describe errors and error handling
• Describe PHP security issues
• Explain safe mode

36
DebuggingPHP Applications

• Syntax errors
• Runtime errors
• Logical errors
• Error messages in PHP
• Parse errors
• Fatal errors
• Warnings
• Notices
• Error handling

37
Preventing Errors

• Script by design
• Keep the script simple
• Adhere to strict naming conventions
• Use a modular approach

38
PHPSecurity Issues

• Securing the server
• Settings
• Configuration options
• Safe mode
• Writing secure PHP applications

39
Summary

• Explain debugging PHP applications
• Describe errors and error handling
• Describe PHP security issues
• Explain safe mode

40
Lesson 6Active Server Pages
41
Objectives

• Define an ASP file and ASP-based applications
• Describe ISAPI programs
• Discuss the Web servers that support ASP
  applications
• Describe the structure of ASP technology
• Define and create virtual directories
• Define and use server-side include files
• Create and use a global.asa file

42
Introduction

• Microsoft Internet Information Server
• Internet Server Application Programming Interface

43
ASP Mechanics

• Dynamic link library
• Comparing ASP and other technologies
• ODBC
• Out-of-process
• In-process

44
Virtual Directoriesand ASP Applications

• Virtual directories are mappings between a name
  and an actual path to a real directory
• Virtual directories contain
• global.asa file
• default.htm or default.asp

45
ASP Delimiters

• Server-side includes
• ASP support for scripting languages

46
Global.asaStarting a Web Application

• Global.asa defines the properties of a Web
  application

47
Summary

• Define an ASP file and ASP-based applications
• Describe ISAPI programs
• Discuss the Web servers that support ASP
  applications
• Describe the structure of ASP technology
• Define and create virtual directories
• Define and use server-side include files
• Create and use a global.asa file

48
Lesson 7Using VBScript
49
Objectives

• Identify and use VBScript operators and
  expressions
• Define and use VBScript variables and data types
• Declare VBScript arrays
• Define and use conditional statements and looping
  constructs
• Create subroutines and functions

50
VBScript

• Scripting languages
• Scripting engines

51
Differences BetweenVBScript and JavaScript

• Calling functions and subroutines
• Function calls and implementation in JavaScript
  and VBScript
• Event-driven programming

52
DeclaringVariables with VBScript

• Declaring variables
• Dim keyword
• Public keyword
• Private keyword
• Naming variables
• Arrays, ReDim, and Preserve
• Collections
• Option Explicit
• Data subtypes and conversion functions

53
Program Flow

• If statements
• Select Case statements
• Looping constructs
• ForNext statements
• Do loops
• WhileWend statements

54
Summary

• Identify and use VBScript operators and
  expressions
• Define and use VBScript variables and data types
• Declare VBScript arrays
• Define and use conditional statements and looping
  constructs
• Create subroutines and functions

55
Lesson 8ASP Intrinsic Objects
56
Objectives

• Identify and use ASP intrinsic objects
• Define and use properties and methods of ASP
  objects
• Use the Request and Response objects
• Identify Server object properties
• Identify the ObjectContext object
• Discuss object scope

57
ASP Objects

• ScriptingContext
• Server
• Application

• Session
• Request
• Response

58
Summary

• Identify and use ASP intrinsic objects
• Define and use properties and methods of ASP
  objects
• Use the Request and Response objects
• Identify Server object properties
• Identify the ObjectContext object
• Discuss object scope

59
Lesson 9ASP DefaultComponents
60
Objectives

• Identify and use ASP default components
• Define and use properties and methods of ASP
  components
• Create and write to a flat database file

61
Global Objects

• ltOBJECTgt tag
• ID parameter
• ProgID parameter
• ClassID parameter

62
ASP DefaultComponents

• Ad Rotator
• Browser Capabilities
• Content Linking
• Content Rotator
• Counters

• Page Counter
• Permission Checker
• FileSystemObject
• ActiveX Data Objects

63
Summary

• Identify and use ASP default components
• Define and use properties and methods of ASP
  components
• Create and write to a flat database file

64
Lesson 10ActiveX Data Objects
65
Objectives

• Define ODBC and OLE DB
• Define and use ADO
• Define and create DSNs
• Insert records into a database using ASP and ADO
• Update and delete records in a database using ASP
  and ADO

66
Open DatabaseConnectivity and OLE DB
67
ActiveXData Objects
68
RegisteringData Source Names

• User DSNs
• System DSNs
• File DSNs

69
Summary

• Define ODBC and OLE DB
• Define and use ADO
• Define and create DSNs
• Insert records into a database using ASP and ADO
• Update and delete records in a database using ASP
  and ADO

70
Lesson 11Error Handling and Debugging for ASP
Applications
71
Objectives

• Discuss debugging ASP applications
• Discuss errors and error handling
• Define the VBScript Err object
• Describe and create custom error numbers
• Discuss error logging
• Discuss the Microsoft Script Debugger

72
DebuggingASP Applications

• Handling errors
• The Err object
• Logging errors
• Microsoft Script Debugger

73
Summary

• Discuss debugging ASP applications
• Discuss errors and error handling
• Define the VBScript Err object
• Describe and create custom error numbers
• Discuss error logging
• Discuss the Microsoft Script Debugger

74
Lesson 12Project Management in Application
Development
75
Objectives

• Discuss project management fundamentals
• Define source and revision control
• Discuss coding standards
• Define code optimization
• Define and use a test assessment plan
• Discuss application testing both before and after
  deployment

76
Project Management Fundamentals

• What is project management?
• Business process/functionality design
• Technology/architecture design
• Implementation/development
• Pilot/parallel
• Cutover/live
• Further study
• PMI
• ISO 9000 series

77
Source andRevision Control

• Program code control
• Version-control software
• Revision Control System (UNIX)
• Source Code Control System (UNIX)
• Visual SourceSafe (Microsoft)

78
Coding Standards

• Indentation and margins
• Matching brackets
• Parentheses
• Reserved words and keywords
• Naming conventions
• Language constructs
• Comments
• Error handling

79
Code Optimization

• Loops
• General optimization tips
• Variables
• Arrays
• ASP optimization

80
Test Assessment Plans

• Creating a test plan
• Glass-box testing
• Black-box testing
• Post-live testing

81
Summary

• Discuss project management fundamentals
• Define source and revision control
• Discuss coding standards
• Define code optimization
• Define and use a test assessment plan
• Discuss application testing both before and after
  deployment

82
Lesson 13Data Integrityand Security Issues
83
Objectives

• Discuss basic database construction issues
• Explain data integrity
• Define various mechanisms for insuring data
  integrity
• Discuss the different goals of security
• Explain the basis of encryption
• Examine the different protocols used as
  encryption is applied to various situations

84
DatabaseDesign Fundamentals

• Designing the database
• Data integrity
• Data input anomalies

85
DatabaseSecurity Issues

• Data Control Language
• Other security-related issues
• Hardware volatility and failure
• Concurrent access
• User authorization
• General security information

86
Security Goals

• Transmission integrity
• Authentication
• Secrecy

87
Encryption

• Algorithm
• Key
• Key length
• Key space

88
Symmetric, Asymmetric, and One-Way Algorithms

• Symmetric encryption example
• Rot-13
• One-way encryption
• Public-key encryption
• Private-key encryption

89
Protocols

• Authentication and digital signatures
• Diffie-Hellman key exchange and certificate
  authorities
• X.509 format

90
Summary

• Discuss basic database construction issues
• Explain data integrity
• Define various mechanisms for insuring data
  integrity
• Discuss the different goals of security
• Explain the basis of encryption
• Examine the different protocols used as
  encryption is applied to various situations

91
Dynamic Server Pages

• Introduction to PHP
• PHP Fundamentals
• String Manipulation and File Input/Output
• PHP and Databases
• Debugging PHP and PHP Security
• Active Server Pages
• Using VBScript

92
Dynamic Server Pages

• ASP Intrinsic Objects
• ASP Default Components
• ActiveX Data Objects
• Error Handling and Debugging for ASP Applications
• Project Management in Application Development
• Data Integrity and Security Issues