Dreamweaver MX : PHP web development

This title is all about making dynamic PHP web sites with Dreamweaver MX. It covers PHP, enough to get the reader up to speed with the technology, and how to use Dreamweaver MX to produce PHP code quickly and efficiently. It also covers site design and databases and SQL. It uses an example project, a hotel reservation system, that is built up through the chapters to demonstrate the concepts explained.

Introduction	p. 1
Style Conventions	p. 2
Support/Feedback	p. 3
Web Support	p. 3
Chapter 1 What Is PHP?	p. 5
What Is PHP and What Is It for?	p. 5
Introducing Dreamweaver MX	p. 12
Dreamweaver MX and PHP	p. 20
Installing and Configuring PHP	p. 21
Summary	p. 28
Chapter 2 What Is MySQL?	p. 31
What Is MySQL?	p. 31
Installing and Configuring MySQL	p. 33
MySQL Basics	p. 35
The MySQL Console	p. 35
Introduction To Databases and SQL	p. 35
Selecting the Working Database	p. 37
Tables in MySQL	p. 38
Configuring MySQL	p. 40
Additional Tools for MySQL	p. 46
MyCC	p. 46
PHPMyAdmin	p. 49
Summary	p. 53
Chapter 3 Getting Started with Dreamweaver MX	p. 55
The Essentials	p. 55
Creating a Site Definition	p. 56
Site Definition Wizard--A Step-By-Step Guide	p. 56
Advanced Site Definition--An Overview	p. 65
Creating a Database Connection	p. 70
Summary	p. 72
Chapter 4 Planning the Web Site	p. 75
Architecture of a Dynamic Web Site	p. 76
The Brief	p. 76
Determining Site Features	p. 77
Planning the Database Structure	p. 78
Determining Site Functionality and Features	p. 80
Summary	p. 88
Chapter 5 Beginning Site Development	p. 91
Setting Up the Database	p. 91
The bookings Table	p. 91
The clients Table	p. 92
The room Table	p. 93
The users Table	p. 94
Creating the Tables	p. 94
Using Templates To Standardize Layout	p. 102
Summary	p. 115
Chapter 6 Manipulating the Database	p. 117
Database Operations within Dreamweaver MX	p. 117
The Hotel Booking System	p. 117
Making a Booking	p. 118
Changing a Booking	p. 119
Canceling a Booking	p. 120
Building the Pages	p. 120
Creating the Bookings Pages	p. 121
Changing a Booking	p. 146
Canceling a Booking	p. 159
Editing the Template--Linking the Pages	p. 162
Suggestions for Expansion	p. 164
Summary	p. 165
Chapter 7 Advanced SQL Usage	p. 167
Creating an Advanced Recordset	p. 167
The SELECT Statement	p. 168
Using DISTINCT	p. 168
Choosing Columns	p. 169
Tables, Joining Tables, and Foreign Keys	p. 172
Filtering Rows	p. 178
Grouping	p. 182
Filtering Using HAVING	p. 187
Sorting the Recordset	p. 187
Limiting the Number of Rows	p. 188
Modifying the Structure of Existing Tables	p. 190
The ALTER TABLE Syntax	p. 190
Optimization	p. 191
Summary	p. 195
Chapter 8 Creating a Search System	p. 199
Search Engines	p. 199
Designing the User Interface	p. 201
Building Your Page	p. 201
Retrieving the Value Entered By the User	p. 203
Building the Query	p. 204
The Base Query	p. 205
Creating the Dynamic Query	p. 206
Displaying the Results	p. 212
Summary	p. 215
Chapter 9 Hand Coding within Dreamweaver MX	p. 217
PHP Code Syntax	p. 217
Statements	p. 218
Variables	p. 218
Control Structures	p. 221
Functions	p. 223
PHP Resources	p. 223
Why Hand Code within Dreamweaver MX?	p. 224
Coding Options in Dreamweaver MX	p. 224
Code View and Code Inspector	p. 224
Code Options in Preferences Window	p. 225
New Hand Coding Features in MX	p. 227
Good Hand Coding Practices	p. 240
Code Options	p. 241
Indenting Code	p. 241
Commenting Your Code	p. 242
Naming Variables	p. 243
Balancing Braces	p. 244
Practical Example--Login System for Dreamweaver Hotel	p. 246
Overview of Our Login System	p. 246
The Database Users Table	p. 247
Create Users Page--The Layout	p. 247
The PHP Include File	p. 249
Create Users Page--Adding the Code	p. 252
The Login Page	p. 256
The Menu Page	p. 260
Create Users Page--Security	p. 261
Summary	p. 262
Chapter 10 The Server Behavior Builder	p. 265
What Is the Server Behavior Builder?	p. 265
When To Use the Server Behavior Builder	p. 268
How To Build a Server Behavior	p. 268
Starting the Server Behavior Builder	p. 269
The Code Blocks	p. 269
Building an Interface for Our Server Behavior	p. 276
Finishing the Server Behavior	p. 280
How To Copy a Server Behavior	p. 281
Summary	p. 282
Chapter 11 Debugging Your Code	p. 285
Programming Errors	p. 285
Syntax Errors	p. 286
Run-time Errors	p. 288
Logic Errors	p. 289
Error Types in PHP	p. 290
Custom Error Handling	p. 296
Viewing Your Server Settings	p. 305
Debugging Techniques	p. 307
Creating a Custom Debugging Function	p. 307
Two Brains Are Better Than One	p. 314
SQL Errors	p. 314
Where To Seek Help	p. 314
Macromedia Forums	p. 314
Web Sites	p. 315
Newsgroups	p. 315
Summary	p. 316
Index	p. 319

Available:*

On Order

Summary

Summary

Table of Contents