Practical PHP and MySQL: Building Eight Dynamic Web Applications

Jono Bacon9780132239974, 0-13-223997-3

Suddenly, it’s easy to build commercial-quality Web applications using free and open source software. With this book, you’ll learn from eight ready-to-run, real-world applications-all backed by clear diagrams and screenshots, well-documented code, and simple, practical explanations. Leading open source author Jomo Bacon teaches the core skills you’ll need to build virtually any application. You’ll discover how to connect with databases, upload content, perform cacading deletes, edit records, validate registrations, specify user security, create reusable components, use Pear extensions, and even build Ajax applications.

---

Table of contents :
Contents……Page 8
Foreword……Page 12
About the Author……Page 13
Acknowledgments……Page 14
A Different Approach……Page 16
What You Need to Use This Book……Page 18
Onward……Page 19
CHAPTER 1 A New Approach……Page 20
The Technology……Page 21
How the Dynamic Web Works……Page 23
Summary……Page 27
CHAPTER 2 Getting Started with PHP and MySQL……Page 30
Setting Up PHP and MySQL……Page 31
Getting Started with PHP……Page 32
Rolling in MySQL……Page 50
Connecting to MySQL in PHP……Page 60
Summary……Page 66
About the Disc……Page 68
Running the Applications……Page 71
Using XAMPP……Page 72
Summary……Page 75
CHAPTER 4 Building a Weblog……Page 78
Project Overview: Blogtastic Use Case……Page 79
Building the Database……Page 80
Starting to Code……Page 83
Viewing Specific Entries……Page 97
Building the Category Browser……Page 107
Don’t Just Let Anyone Log In……Page 110
Rolling Your Own Categories……Page 117
Creating New Blog Entries……Page 118
Update a Blog Entry……Page 121
Summary……Page 125
Under the Hood……Page 126
Before You Begin……Page 129
Creating the Database……Page 130
Creating the Site Design……Page 137
Displaying the Forums……Page 139
Managing User Logins……Page 148
Posts and Replies……Page 165
Creating Administrator-Specific Pages……Page 173
Summary……Page 182
CHAPTER 6 Creating a Shopping Cart……Page 184
Project Overview……Page 185
Building the Database……Page 186
Starting to Code……Page 190
Managing User Logins……Page 195
Displaying and Selecting Products……Page 199
Checking It Out……Page 211
Administrator Pages……Page 223
Summary……Page 231
Project Overview……Page 234
Building the Database……Page 235
Starting to Code……Page 238
Displaying Auction Items……Page 241
Dealing with Users……Page 255
Adding an Item……Page 258
Processing Auctions……Page 274
Scheduling the Page to Be Run……Page 277
Summary……Page 278
Project Overview……Page 280
Building the Database……Page 281
Starting to Code……Page 282
Viewing Events……Page 292
Summary……Page 317
CHAPTER 9 FAQ Content Management System……Page 318
Project Overview……Page 319
Building the Database……Page 320
Starting to Code……Page 325
Displaying Questions……Page 336
Dealing with Logins……Page 345
Adding and Moderating Questions……Page 356
Managing Subjects……Page 371
Managing Topics……Page 375
Subject Ownership……Page 379
Summary……Page 391
CHAPTER 10 Building a Re-Usable Project……Page 394
Project Overview……Page 395
Building the Database……Page 396
Using Directories Intelligently……Page 400
Starting to Code: Building the Backbone……Page 401
Downloading Releases……Page 408
Viewing Screenshots……Page 411
Available Projects Viewer……Page 412
Administering Projects……Page 413
Changing General Settings……Page 421
Managing Downloads……Page 422
Deleting Releases……Page 429
Managing Screenshots……Page 430
Deleting Images……Page 434
Adding a New Project……Page 435
Deploying the Application……Page 436
Summary……Page 439
Project Overview……Page 440
Installing PEAR Packages……Page 441
Building the Database……Page 443
Starting to Code……Page 446
Handling User Logins……Page 455
Viewing and Rating Stories……Page 460
Managing Stories……Page 466
Managing Categories……Page 472
Creating Your Search Engine……Page 476
Summary……Page 482
Project Overview……Page 484
Laying Out the Site……Page 486
Starting to Code……Page 489
Start Building the Stylesheet……Page 494
Formatting the Main Items……Page 496
Creating an About Page……Page 502
Creating a Frequently Asked Questions Page……Page 504
Formatting Tables……Page 507
Summary……Page 510
A……Page 514
B……Page 515
C……Page 516
D……Page 518
F……Page 519
G……Page 520
L……Page 521
M……Page 522
P……Page 523
R……Page 524
S……Page 525
U……Page 526
X……Page 527