Foreword     xi
About the Author     xii
Acknowledgments     xiii
Introduction     1
A Different Approach     1
What You Need to Use This Book     3
Conventions     4
Onward     4
A New Approach     5
The Technology     6
How the Dynamic Web Works     8
Summary     12
Getting Started with PHP and MySQL     15
Setting Up PHP and MySQL     16
Getting Started with PHP     17
Rolling in MySQL     35
Connecting to MySQL in PHP     45
Summary     51
Running the Projects     53
About the Disc     53
Running the Applications     56
Using XAMPP     57
Summary     60
Building a Weblog     63
Project Overview: Blogtastic Use Case     64
Building the Database     65
Starting to Code     68
Viewing Specific Entries     82
Building the Category Browser     92
Don't just Let Anyone Log In     95
Rolling Your Own Categories     102
Creating New BlogEntries     103
Update a Blog Entry     106
Summary     110
Discussion Forums     111
Under the Hood     111
Building Your Own Forums     114
Before You Begin     114
Creating the Database     115
Creating the Site Design     122
Displaying the Forums     124
Managing User Logins     133
Posts and Replies     150
Creating Administrator-Specific Pages     158
Summary     167
Creating a Shopping Cart     169
Project Overview     170
Building the Database     171
Starting to Code     175
Managing User Logins     180
Displaying and Selecting Products     184
Checking It Out     196
Administrator Pages     208
Summary     216
Building an Online Auction Site     219
Project Overview     219
Building the Database     220
Starting to Code     223
Displaying Auction Items     226
Dealing with Users     240
Adding an Item     243
Processing Auctions      259
Scheduling the Page to Be Run     262
Summary     263
Creating a Web-Based Calendar     265
Project Overview     265
Building the Database     266
Starting to Code     267
Viewing Events     277
Summary     302
FAQ Content Management System     303
Project Overview     304
Building the Database     305
Starting to Code     310
Displaying Questions     321
Dealing with Logins     330
Adding and Moderating Questions     341
Managing Subjects     356
Managing Topics     360
Subject Ownership     364
Summary     376
Building a Re-Usable Project     379
Project Overview     380
Building the Database     381
Using Directories Intelligently     385
Starting to Code: Building the Backbone     386
Downloading Releases     393
Viewing Screenshots     396
Available Projects Viewer     397
Administering Projects     398
Changing General Settings     406
Managing Downloads      407
Deleting Releases     414
Managing Screenshots     415
Deleting Images     419
Adding a New Project     420
Deploying the Application     421
Summary     424
Building a News Web Site     425
Project Overview     425
Installing PEAR Packages     426
Building the Database     428
Starting to Code     431
Handling User Logins     440
Viewing and Rating Stories     445
Managing Stories     451
Managing Categories     457
Creating Your Search Engine     461
Summary     467
Web Site Design     469
Project Overview     469
Laying Out the Site     471
Starting to Code     474
Start Building the Stylesheet     479
Formatting the Main [left angle bracket]div[right angle bracket] Items     481
Creating an About Page     487
Creating a Frequently Asked Questions Page     489
Formatting Tables     492
Summary     495
Index     499