Sams Teach Yourself PHP, MySQL and Apache in 24 Hours

✍ Scribed by Julie C. Meloni

• Publisher: Sams
• Year: 2002
• Tongue: English
• Leaves: 561
• Category: Library

✦ Synopsis

Exactly as described, Good Quality, complete with CD, Good condition, Delivery time to the UK was a bit of a downer though it did arrive sooner than expected.

✦ Table of Contents

Main Page......Page 1
Table of content......Page 2
Copyright......Page 8
Lead Author......Page 11
Contributing Authors......Page 12
Acknowledgments......Page 13
We Want to Hear from You!......Page 14
Reader Services......Page 15
Introduction......Page 16
Who Should Read This Book?......Page 17
How This Book Is Organized......Page 18
Conventions Used in This Book......Page 19
Part I: Getting Up and Running......Page 20
Hour 1. Installing and Configuring MySQL......Page 21
How to Get MySQL......Page 22
Installing MySQL on Linux/Unix......Page 23
Installing MySQL on Windows......Page 26
Troubleshooting Your Installation......Page 29
Basic Security Guidelines......Page 30
Introducing the MySQL Privilege System......Page 33
Working with User Privileges......Page 36
Summary......Page 39
Q&A......Page 40
Workshop......Page 41
Hour 2. Installing and Configuring Apache......Page 44
Choosing the Appropriate Installation Method......Page 45
Installing Apache on Linux/Unix......Page 46
Installing Apache on Windows......Page 49
Apache Configuration File Structure......Page 52
Apache Log Files......Page 55
Apache-Related Commands......Page 56
Starting Apache for the First Time......Page 59
Troubleshooting......Page 62
Summary......Page 65
Q&A......Page 66
Workshop......Page 67
Hour 3. Installing and Configuring PHP......Page 70
Building PHP on Linux/Unix with Apache......Page 71
Installing PHP Files on Windows......Page 74
'php.ini' Basics......Page 77
Testing Your Installation......Page 78
Getting Installation Help......Page 81
The Basics of PHP Scripts......Page 84
Summary......Page 87
Q&A......Page 88
Workshop......Page 91
Part II: Basic Language Elements......Page 94
Hour 4. The Building Blocks of PHP......Page 95
Variables......Page 96
Data Types......Page 99
Operators and Expressions......Page 102
Constants......Page 105
Summary......Page 108
Q&A......Page 109
Workshop......Page 110
Hour 5. Flow Control Functions in PHP......Page 113
Switching Flow......Page 114
Loops......Page 117
Code Blocks and Browser Output......Page 120
Summary......Page 123
Q&A......Page 124
Workshop......Page 125
Hour 6. Working with Functions......Page 128
What Is a Function?......Page 129
Calling Functions......Page 130
Defining a Function......Page 133
Returning Values from User-Defined Functions......Page 136
Dynamic Function Calls......Page 139
Variable Scope......Page 140
Saving State Between Function Calls with the 'static' Statement......Page 143
More About Arguments......Page 146
Creating Anonymous Functions......Page 149
Testing for the Existence of a Function......Page 152
Summary......Page 155
Q&A......Page 156
Workshop......Page 157
Hour 7. Learning Basic SQL Commands......Page 160
Learning the MySQL Data Types......Page 161
Learning the Table Creation Syntax......Page 164
Using the 'INSERT' Command......Page 166
Using the 'SELECT' Command......Page 169
Using 'WHERE' in Your Queries......Page 172
Selecting from Multiple Tables......Page 175
Using 'JOIN'......Page 178
Using the 'UPDATE' Command to Modify Records......Page 181
Using the 'REPLACE' Command......Page 184
Using the 'DELETE' Command......Page 186
Summary......Page 189
Q&A......Page 190
Workshop......Page 191
Hour 8. Interacting with MySQL Using PHP......Page 194
Connecting to MySQL with PHP......Page 195
Working with MySQL Data......Page 198
Summary......Page 201
Workshop......Page 202
Part III: Getting Involved with the Code......Page 203
Hour 9. Working with Forms......Page 204
Predefined Variables......Page 205
Creating a Simple Input Form......Page 208
Accessing Form Input with User-Defined Arrays......Page 211
Combining HTML and PHP Code on a Single Page......Page 214
Using Hidden Fields to Save State......Page 217
Redirecting the User......Page 219
Sending Mail on Form Submission......Page 222
Creating the Form......Page 224
Creating the Script to Send the Mail......Page 226
Working with File Uploads......Page 229
Summary......Page 232
Workshop......Page 233
Hour 10. Working with Files......Page 236
Including Files with 'include()'......Page 237
'include_once()'......Page 240
Testing Files......Page 241
Creating and Deleting Files......Page 244
Opening a File for Writing, Reading, or Appending......Page 245
Reading from Files......Page 246
Writing or Appending to a File......Page 249
Working with Directories......Page 252
Summary......Page 255
Q&A......Page 256
Workshop......Page 257
Hour 11. Working with Dates and Times......Page 260
Using Date and Time Functions in PHP......Page 261
Using Date and Time Functions in MySQL......Page 264
Summary......Page 267
Workshop......Page 268
Hour 12. Creating a Simple Calendar......Page 271
Building a Simple Display Calendar......Page 272
Creating a Calendar Library......Page 275
Summary......Page 278
Q&A......Page 279
Workshop......Page 280
Hour 13. Working with Strings......Page 281
Formatting Strings with PHP......Page 283
Investigating Strings in PHP......Page 286
Manipulating Strings with PHP......Page 289
Frequently Used String Functions in MySQL......Page 292
Summary......Page 295
Q&A......Page 296
Workshop......Page 299
Hour 14. Creating a Simple Discussion Forum......Page 302
Types of Table Relationships......Page 303
Understanding Normalization......Page 306
Following the Design Process......Page 309
Creating a Discussion Forum......Page 312
Summary......Page 315
Q&A......Page 316
Workshop......Page 317
Hour 15. Restricting Access to Your Applications......Page 318
Authentication Overview......Page 319
Apache Authentication Module Functionality......Page 322
Using Apache for Access Control......Page 325
Combining Apache Access Methods......Page 328
Limiting Access Based on HTTP Methods......Page 329
Introducing Cookies......Page 330
Setting a Cookie with PHP......Page 333
Restricting Access Based on Cookie Values......Page 336
Summary......Page 339
Q&A......Page 340
Workshop......Page 343
Hour 16. Working with User Sessions......Page 346
Session Function Overview......Page 347
Starting a Session......Page 348
Working with Session Variables......Page 351
Passing Session IDs in the Query String......Page 354
Destroying Sessions and Unsetting Variables......Page 355
Summary......Page 356
Q&A......Page 357
Workshop......Page 358
Hour 17. Logging and Monitoring Server Activity......Page 361
Standard Apache Access Logging......Page 362
Standard Apache Error Logging......Page 365
Managing Apache Logs......Page 368
Logging Custom Information to a Database......Page 371
Summary......Page 374
Q&A......Page 375
Workshop......Page 376
Part IV: Simple Projects......Page 377
Hour 18. Managing a Simple Mailing List......Page 378
Developing the Subscription Mechanism......Page 379
Developing the Mailing Mechanism......Page 382
Summary......Page 385
Q&A......Page 386
Workshop......Page 387
Hour 19. Creating an Online Address Book......Page 388
Planning and Creating the Database Tables......Page 389
Creating a Menu......Page 392
Creating the Record Addition Mechanism......Page 393
Viewing Records......Page 396
Creating the Record Deletion Mechanism......Page 399
Adding Subentries to a Record......Page 402
Summary......Page 405
Workshop......Page 406
Hour 20. Creating an Online Storefront......Page 409
Planning and Creating the Database Tables......Page 410
Displaying Categories of Items......Page 413
Displaying Items......Page 416
Summary......Page 419
Workshop......Page 420
Hour 21. Creating a Shopping Cart Mechanism......Page 421
Planning and Creating the Database Tables......Page 422
Integrating the Cart with Your Storefront......Page 425
Payment Methods and the Checkout Sequence......Page 428
Summary......Page 431
Workshop......Page 432
Part V: Administration and Fine-Tuning......Page 433
Hour 22. Apache Performance Tuning and Virtual Hosting......Page 434
Scalability Issues......Page 435
Load Testing with ApacheBench......Page 438
Proactive Performance Tuning......Page 441
Preventing Abuse......Page 444
Implementing Virtual Hosting......Page 445
Summary......Page 448
Q&A......Page 449
Workshop......Page 452
Hour 23. Setting Up a Secure Web Server......Page 455
The Need for Security......Page 456
The SSL Protocol......Page 457
Installing SSL......Page 460
Managing Certificates......Page 463
SSL Configuration......Page 466
Summary......Page 469
Q&A......Page 470
Workshop......Page 471
Hour 24. Optimizing and Tuning MySQL......Page 472
Building an Optimized Platform......Page 473
MySQL Startup Options......Page 476
Optimizing Your Table Structure......Page 479
Optimizing Your Queries......Page 480
Using the 'FLUSH' Command......Page 483
Using the 'SHOW' Command......Page 486
Summary......Page 489
Q&A......Page 490
Workshop......Page 491
Index......Page 494
Index SYMBOL......Page 495
Index A......Page 498
Index B......Page 501
Index C......Page 504
Index D......Page 507
Index E......Page 510
Index F......Page 513
Index G......Page 516
Index H......Page 517
Index I......Page 520
Index J......Page 523
Index K......Page 524
Index L......Page 525
Index M......Page 528
Index N......Page 531
Index O......Page 534
Index P......Page 537
Index Q......Page 540
Index R......Page 541
Index S......Page 544
Index T......Page 547
Index U......Page 550
Index V......Page 553
Index W......Page 556
Index X......Page 559
Index Y......Page 560
Index Z......Page 561