PHP Basics
How PHP Works, The php.ini File, Basic PHP Syntax, PHP Tags, PHP Statements and Whitespace, Comments, PHP Functions, Variable Types, Variable Names (Identifiers), Type Strength, Variable Scope, Constants, Variable-Testing and Manipulation Functions, PHP Operators, Creating Dynamic Pages, Single Quotes vs. Double Quotes
Flow Control
Conditional Processing, If Conditions, Loops (while, do…while, for), break and continue
Arrays
Enumerated Arrays (Initializing Arrays, Appending to an Array, Reading from Arrays), Looping through Arrays, Associative Arrays (Initializing Associative Arrays, Reading from Associative Arrays, Looping through Associative Arrays), Two-dimensional Arrays (Reading from Two-dimensional Arrays, Looping through Two-dimensional Arrays), Array Manipulation Functions
PHP and HTML Forms
HTML Forms, How HTML Forms Work, A Sample HTML Form, Form Variables
String Manipulation
Formatting Strings (Concatenation, String Manipulation Functions, Examples of String Functions) Magic Quotes ( magic_quotes_gpc, magic_quotes_runtime, Recommendation on Magic Quotes)
Reusing Code and Writing Functions
Including Files ( require, require_once), auto_prepend_file and auto append file, User Functions (Defining and Calling Functions, Default Values, Variable Scope), By Reference vs. By Value, Form Processing, Code Organization
Simple SELECTs
Introduction to the Northwind Database, Some Basics (Comments, Whitespace and Semi-colons), Case Sensitivity, SELECTing All Columns in All Rows, SELECTing Specific Columns, Sorting Records (Sorting By a Single Column, Sorting By Multiple Columns), Sorting By Column Position, Ascending and Descending Sorts, The WHERE Clause and Operator Symbols (Checking for Equality, Checking for Inequality, Checking for Greater or Less Than, Checking for NULL), WHERE and ORDER BY
The WHERE Clause and Operator Words (The BETWEEN Operator, The IN Operator, The LIKE Operator, The NOT Operator), Checking Multiple Conditions (AND, OR, Order of Evaluation)
Subqueries, Joins and Unions
Subqueries, Joins (Table Aliases, Multi-table Joins, Outer Joins), Unions (UNION ALL, UNION Rules)
Inserting, Updating and Deleting Records
INSERT, UPDATE, DELETE
Managing Data
Querying a Database (mysql() Overview, mysql Methods and Properties, Inserting and Updating Records, mysql Prepared Statements)
Authentication with PHP and MYSQL
A Database-less Login Form
Session Control and Cookies
Sessions (Configuring Sessions, Session Functions),
Cookies
Sending Email with PHP
mail(), Shortcomings of mail(), PHPMailer
File System Management
Opening a File fopen(), Reading from a File fgets(), Writing to a File fwrite(), File Locking flock(), Uploading Files via an HTML Form, Getting File Information, More File Functions, Directory Functions (Getting a Directory Listing), Getting a Directory Listing, Ajax with PHP (Ajax Overview, Ajax Technology Stack, Ajax Implementations, Installing and configuring HTML_Ajax Pear Module, Ajax Server, Ajax Client) Creating a Dreamweaver site (Site creation – basic, Site creation – advanced)
Database connections
Database basics, Introduction to MYSQL, Server behaviors
Querying the database
Building a MYSQLquery using the Simple view, Building a MYSQLquery using the Advanced view, Adding fields from the resulting records to your page
Displaying and formatting query results
Using Repeat Region to display multiple records, Formatting results,
Paging through records
Schemes for recordset navigation, Paging to first, last, previous, and next records
Show region if…
Selectively displaying information based on a conditional Disabling the first and previous record links if the first page of results is displayed, Disabling the last and next record links if the last page of results is displayed
Displaying the count of the number of records returned
Creating master-detail views
Overview of the importance of master-detail views and how they convey, information, Creating a master-detail view
Advanced recordsets and multi-table queries
Method 1 – Simple recordset with filter, Method 2 – Advanced recordset, Method 3 – Advanced recordset and multi-table Queries
Dynamically populating forms
Populating text fields, text areas, and hidden fields, Populating selection lists, radio button lists, and checkboxes
Building record insertion forms
Building the insertion form by hand, Allowing Dreamweaver to generate the record insertion form automatically, Creating a page that confirms the record insertion, Validating form entries using JavaScript behaviors
Understanding stored procedures
How they are created in the database, Advantages/disadvantages of stored procedures versus MYSQL
Calling a stored procedure without passing parameters, Passing input parameters to a stored procedure, Retrieving parameters from a stored procedure
Updating records
Manually constructing a form that allows the user to update a record, Using Dreamweaver to automatically generate a form for updating the record, Validating the edited information using JavaScript behaviors, Building a confirmation page to display the result of updating the record
Deleting records
Precautions to take to ensure that records are not inadvertently deleted, Building an appropriate record deletion interface, complete with confirmation dialog
Implementing user login/logout with Dreamweaver
Overview of Web application security issues, Preferred approach: configuring the Web server to manage security, Alternative approach: having Dreamweaver automatically generate code for logging users in, authenticating them, and logging them out In-depth instruction on using Dreamweaver with PHP to implement user, login/logout and page-by-page authentication.
