PHPand PostgreSQL

PHP 5 and PostgreSQL Bootcamp is five intensive days of hands-on programming designed for web application developers who need to master web design with PHP 5 driven by a PostgreSQL database back-end.

What You’ll Learn

Upon completion of PHP and PostgreSQL, the student will be able to:

PHP 5 & PostgreSQL Bootcamp

• Use PHP and PostgreSQL to build a complete CRM website and application
• Understand how to integrate PHP and PostgreSQL with complementary web technologies (e.g., CSS, XML, pdf, AJAX) to produce professional web solutions
• Implement security measures to prevent the most common kinds of attacks in a web environment
• Understand how to integrate third-party libraries (e.g., PEAR) into PHP applications, dramatically reducing development time

Section	Contents

PHP 5 & PostgreSQL	Click to Show

PHP 5 & PostgreSQL	Click to Hide
PHP 5 Fundamentals	Introduction to variables, decision-making, and loops
Functions	Learning how to use existing PHP5 functions and write your own
Objects	Understanding PHP5's implementation of object-oriented programming concepts
Arrays	Learning how to manage groups of scalars, objects
Databases	Using PDO as a lightweight data access layer to a PostgreSQL database
Dynamic Web Pages	Integrating PHP and PostgreSQL to produce a public-facing web page
Dates and Times	Mastering PHP5's date and time model
Multidimensional Arrays	Dealing with arrays of arrays, most commonly encountered with record sets retrieved from a database
State in a Stateless Land	How to manage different page states (e.g., list, edit, save, and delete) in the essentially stateless web environment
Views	Understanding PostgreSQL Views
Dynamic Functions	Using variables to make dynamic function calls
Advanced SQL	Introduction of aggregate functions, case statements, and subselects
Form Handling	Using PEAR::HTML_Quickform and PDO to manage form and related database content
Javascript	Introduction to javascript
Remembering Users	Learning how cookies and session variables interact to establish user identity
Security	Implementing common sense solutions to common web-based security concerns
Archiving	Managing different deletion strategies from the PHP5 and PostgreSQL perspective
XML	Introduction to XML on the web, including how to create an RSS feed
Web Services	Implementing web services to provide functionality external to the core web application
File Upload	Handling PHP5 file uploads, with either a file-system or PostgreSQL solution.
AJAX	Integrating AJAX into PHP5 and PostgreSQL web applications
FPDF	Introduction to FPDF, a lightweight PHP5-based library for producing dynamic PDFs on the web
Graphics	Using the PHP5 GD library to produce web graphics

Requirements

For best results, students should have some experience with HTML.