The IEEE Boston Section Techsite

Your Boston Section IEEE information source.

HOMEDECEMBERJANUARYCONFERENCES AND EVENTSNEWS AND EDITORIALOFFICERSIEEE LINKSCONTACT

Course:  Dynamic Web Pages using PHP and Apache ServerWeb Page

Online registration is closed. Contact the office for more information at 781-229-1530 Ext 2

Lecturer: Jeffrey Goldberg, Qualware Instructional Services
Date:  Saturday, Novermber 15, 2003, 8:30 AM - 5:00 PM
Location: WPI’s Waltham Campus, 60 Hickory Drive, Waltham, MA
Text: PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide 
by Larry UllmanPublisher: Peachpit Press; 1st edition (May 21, 2003)

Objective: This is an newly created, intensive, fast paced one day mini-course covering everything you need to know about creating dynamic, interactive web pages, and understanding how they operate.

This mini-course will start with a quick overview on the evolution of Dynamic Web Pages from the static web pages of the early ’90s through Perl-based CGI (Common Gateway Interface) script and server side include techniques of the mid ’90s, through VB and Java Scripting. After a quick review of the  HTML language basics including tables, frames and forms, it will then proceed to a discussion of the client-server three tier networks of the twenty-first century. In these systems, browsers talk to web servers which in turn request  data from in-house SQL (Structured Query Language) database servers. The web server running PHP/JSP/ASP is then responsible for formatting up and presenting this data as dynamic web pages.

PHP is a widely-used, Perl and ‘C’ like-syntax, general-purpose server-side scripting language that is especially suited for Web development and can be embedded into HTML documents.

After reviewing the basics that are applicable in both the Microsoft and Unix environments, this course will teach Web Technologies services from the rarely taught Unix server point of view. Unix platforms, rather than Microsoft platforms, are typically the server of choice for large scalable systems such as “eBay”(r).

This course will introduce Java Script, maybe touch upon Java Applets and JSP (Java Server Pages), but the focus is on using SQL within PHP HTML documents running under Apache. PHP, a Hypertext Preprocessor language, which replacesASP on Unix platforms, will be examined in detail in the afternoon session where the course, through demonstrations,will attempt to explain how modern interactive web pages are designed, and how easy it is to make the contents of databases show up dynamically as web pages.

Prerequisite: Although the course will include a very quick review of SQL basics, it is strongly recommended that individuals not proficient in relational databases, SQL and HTML enrole in the Structured Query Language (SQL) Lab Crash Course scheduled for Saturday, October 11, 2003.

Targeted for: Individuals with experience in web browsing and creating simple web documents by hand, or experience using a web conversion tool but having some minimal knowledge of HTML. Some previous experience in any modernstructural programming language is recommended. This course is for those who would like to develop a better  understanding of web capabilities and understand the bigger picture, how the whole system works. The course will concentrate on explaining the fundamentals upon which all web documents and web services are built, with special focus on using Java Script and PHP to make web sites interactive. Using demonstrations, the class will develop insight into what is possible and is not possible on the web using current technology. The material in this courses is appropriate for individuals maintaining pages on a provider’s server as well as those interested in setting up their own personal or company information server.

Although this is not a lab course, the class is structured to be as interactive as possible by making use of live demonstrations that reviewing and emphasis the concepts taught in the class, and personal laptop computers can be brought to class for experimentation.

Handouts: Copies of the course outline slides will be providedalong with relevant handouts when appropriate.

For more info: Email to courses@qualware.com (jeffg@qualware.com

PRELIMINARY AGENDA:

Morning Session 1: The Evolution of Dynamic Web Pages and an Introduction to Server Architecture

Understanding How Server and Browser Communicate
Server Process and Server/Document Root
Submitting Data to a Server
Client Browser/Web Server Model and Protocols
Common Gateway Interface
CGI’s Stateless Environment
Server Side Includes, HTML Forms with CGI
Basic Data Passing Methods
Gets vs Post, Actions, Encoding, etc
Workload Division, Interactive Web Methods
Home Page Installation
Optional Page Counters, Perl Scripts
IP Address and DNS, Security and Performance

Morning Session 2: Basic Browser Architecture and HTML Language

URLs, HTML Language Basics, using images and gifs
Advanced HTML
including Frames, Tables and Forms
Input Objects, Windows and Targets
Review HTML Tag Operation by interactively
creating a class home page
Example registration form
Demo Server-Side/Forms/CGI scripts/
A simple visitor counter

Morning Session 3: Running Applications Locally on the Browser

Cascading Style Sheets
Quick mention of VB Script
Java Script and the Document Object Model (DOM)
Java Script Functions, Events and Event Handlers
Controlling the Browser using the Window Objects
Demonstration of the added features using Java Script
User Interaction and Data Verification
Pop-up windows and Document.writes
for creating client-side dynamic html code
Keeping Control of your browser
Overview of Java Applets
Introduction to using PHP

Lunch Break: 12:15pm - 1:15pm (Lunch not included)

Afternoon Session 1: Introduction to PHP

PHP Hypertext Preprocessor Capabilities and Language Syntax, Compared and Contrasted to Perl
Features, Parsing and Advanced Escaping; Variables and Primitive Data Types
Strings and Quoting Options; Limited Casting; PHP Arrays; Math Operator and Assignment Precedence
Comparison and Logical Operators; Decision Statements and Looping Constructs
User Defined Functions, Scope and Lifetime; Predefined Variables and Connecting to the Web Server

Afternoon Session 2: Design Truly Intelligent Interactive Web Pages

Using PHP in Forms, or a Simple Registration Form
Using Check Boxes, Radio Buttons, Text Boxes
Decoding Data Sent to Your CGI Program
Using Environment Variables
Quick overview of the SQL Language
PHP’s interface to SQL and Database
Database Connectivity using MySQL
Introduction to MySQL Database Functionality
DB Terminology and Constraints, Supported Data Types
Class Database Demonstration Exercise
Creating and Updating Tables,
Interactive Demo of pets.php

Afternoon Session 3: Web Statistics, Administration and Management

Web Server Configurations
Setting Up Apache, MySQL Service
PHP Security and Configuring Access Control
Restricted Access and Password Protection
Demo Apache Access Control of User Directories
Database and Security Issues
Controlling MySQL Database Access
Hidden Fields, Cookies to retain state
Demo mysql.php as a generalized database access script.
Create a form to inserts info into the pet dabtabase.
User Logging and Visitor Information Data Collection.

Live interactive demo on many of the topics discussed. This will be a 8:30 am to 5 pm Saturday session with a 12:15 - 1:15 pm lunch break.

Lecturer’s biography: Jeffrey Goldberg is a long time innovative user of UNIX and Internet services. Mr. Goldberg currently develops and teaches courses on Unix Fundamentals, Shelland Perl Programming, Unix System Administration and Security, TCP/IP NetworkAdministration in a Multi-Platform Environment, Introduction to Programming, Basic and Advanced Visual Basic Programming incorporating SQL Database Access, Web Technologies such as VB Script, Java Script, Java, Visual ‘C’ and ‘C++’, for Worcester Polytechnic Institute and Boston University. Mr. Goldberg is continually adding new cutting-edge technology to his curriculum, and accepts requests for customized on-site corporate training classes. New course available this fall: Development of Dynamic Web Pages Using Apache, SQL and PHP on a Unix Server. Besides operating Qualware Instructional Services, Mr. Goldberg is also a principal of Qualware Consulting Group, which designs electronics for faulttolerant networks, specialized network adapter hardware and embedded customizedcontroller cards. Mr. Goldberg has recently form a new company called Qualware Internet Services specializing in Internet/Intranet security, application servers, web hosting, and dynamic web applications. For more information, e-mail to training@qualware.com or contact Mr. Goldberg at 781-229-1530 or j.goldberg@ieee.org or  www.consultme.com/qualware

Course Fee Schedule:

REGISTRATION RECEIVED BY
November 3, 2003
REGISTRATION. RECEIVED AFTER
November 3, 2003
IEEE MEMBERS $230 IEEE MEMBERS $250
NON-MEMBERS $250 NON-MEMBERS $270

On-line Registration and Payment

Online registration is closed. Contact the office for more information at 781-229-1530 Ext 2


Home ] Accounting ] Amplifier Design ] [ Dynamic Web ] Engenomics ] First Level Security ] JAVA ] LINUX ] Models ] OWL ] Perl ] Quality Assurance ] Radar ] RDF ] Root Cause ] Schedules ] SQL ] SW Med Device ] Software V & V ] Wireless LAN ] Writing SW Req ] XML ] Nanotechnology ]

Copyright © 2003 IEEE Boston Section. All rights reserved.
Maintained by R M Stelting