Sams Teach Yourself PHP, MySQL and Apache in 24 Hours

Sams Teach Yourself  PHP, MySQL™ and Apache in 24 Hours......Page 2
Copyright © 2003 by Sams Publishing......Page 3
Contents at a Glance......Page 4
Contents......Page 6
Contributing Authors......Page 19
We Want to Hear from You!......Page 21
How This Book Is Organized......Page 22
Conventions Used in This Book......Page 24
PART I Getting Up and Running......Page 26
How to Get MySQL......Page 28
Installing MySQL on Linux/Unix......Page 29
Installing MySQL on Windows......Page 30
Troubleshooting Your Installation......Page 35
Basic Security Guidelines......Page 36
Introducing the MySQL Privilege System......Page 38
Working with User Privileges......Page 39
Summary......Page 42
Workshop......Page 43
Choosing the Appropriate Installation Method......Page 46
Installing Apache on Linux/Unix......Page 47
Installing Apache on Windows......Page 50
Apache Configuration File Structure......Page 53
Apache Log Files......Page 58
Apache-Related Commands......Page 59
Starting Apache for the First Time......Page 61
Troubleshooting......Page 63
Q&A......Page 64
Workshop......Page 65
Building PHP on Linux/Unix with Apache......Page 68
Installing PHP Files on Windows......Page 72
php.ini Basics......Page 73
Testing Your Installation......Page 74
Getting Installation Help......Page 75
The Basics of PHP Scripts......Page 76
Summary......Page 81
Workshop......Page 82
PART II Basic Language Elements......Page 84
HOUR 4 The Building Blocks of PHP......Page 86
Variables......Page 87
Data Types......Page 88
Operators and Expressions......Page 94
Constants......Page 101
Summary......Page 102
Workshop......Page 103
HOUR 5 Flow Control Functions in PHP......Page 106
Switching Flow......Page 107
Loops......Page 113
Code Blocks and Browser Output......Page 122
Summary......Page 124
Workshop......Page 125
HOUR 6 Working with Functions......Page 128
Calling Functions......Page 129
Defining a Function......Page 131
Returning Values from User-Defined Functions......Page 133
Dynamic Function Calls......Page 134
Variable Scope......Page 135
Saving State Between Function Calls with the static Statement......Page 139
More About Arguments......Page 141
Creating Anonymous Functions......Page 145
Testing for the Existence of a Function......Page 146
Summary......Page 148
Workshop......Page 149
HOUR 7 Learning Basic SQL Commands......Page 152
Learning the MySQL Data Types......Page 153
Learning the Table Creation Syntax......Page 156
Using the INSERT Command......Page 157
Using the SELECT Command......Page 159
Using WHERE in Your Queries......Page 162
Selecting from Multiple Tables......Page 164
Using JOIN......Page 166
Using the UPDATE Command to Modify Records......Page 169
Using the REPLACE Command......Page 171
Using the DELETE Command......Page 172
Summary......Page 174
Q&A......Page 175
Workshop......Page 176
Connecting to MySQL with PHP......Page 178
Working with MySQL Data......Page 182
Summary......Page 188
Workshop......Page 189
PART III Getting Involved with the Code......Page 190
HOUR 9 Working with Forms......Page 192
Predefined Variables......Page 193
Creating a Simple Input Form......Page 195
Accessing Form Input with User-Defined Arrays......Page 196
Combining HTML and PHP Code on a Single Page......Page 199
Using Hidden Fields to Save State......Page 201
Redirecting the User......Page 203
Sending Mail on Form Submission......Page 204
Creating the Form......Page 206
Creating the Script to Send the Mail......Page 207
Working with File Uploads......Page 209
Summary......Page 212
Workshop......Page 213
Including Files with include()......Page 214
include_once()......Page 218
Testing Files......Page 219
Creating and Deleting Files......Page 223
Opening a File for Writing, Reading, or Appending......Page 224
Reading from Files......Page 225
Writing or Appending to a File......Page 229
Working with Directories......Page 232
Workshop......Page 235
HOUR 11 Working with Dates and Times......Page 238
Using Date and Time Functions in PHP......Page 239
Using Date and Time Functions in MySQL......Page 244
Summary......Page 256
Workshop......Page 257
Building a Simple Display Calendar......Page 258
Creating a Calendar Library Because dates are ubiquitous in Web interfaces, and because......Page 265
Summary......Page 271
Workshop......Page 272
HOUR 13 Working with Strings......Page 274
Formatting Strings with PHP......Page 275
Investigating Strings in PHP......Page 283
Manipulating Strings with PHP......Page 287
Frequently Used String Functions in MySQL......Page 292
Summary......Page 302
Q&A......Page 303
Workshop......Page 304
HOUR 14 Creating a Simple Discussion Forum......Page 306
Types of Table Relationships......Page 307
Understanding Normalization......Page 311
Following the Design Process......Page 314
Creating a Discussion Forum......Page 315
Summary......Page 329
Workshop......Page 330
Authentication Overview......Page 332
Apache Authentication Module Functionality......Page 334
Using Apache for Access Control......Page 339
Combining Apache Access Methods......Page 341
Limiting Access Based on HTTP Methods......Page 342
Introducing Cookies......Page 343
Setting a Cookie with PHP......Page 344
Restricting Access Based on Cookie Values......Page 346
Summary......Page 351
Workshop......Page 352
HOUR 16 Working with User Sessions......Page 354
Starting a Session......Page 355
Working with Session Variables......Page 356
Destroying Sessions and Unsetting Variables......Page 361
Summary......Page 362
Workshop......Page 363
Standard Apache Access Logging......Page 364
Standard Apache Error Logging......Page 370
Managing Apache Logs......Page 372
Logging Custom Information to a Database......Page 374
Summary......Page 378
Workshop......Page 379
PART IV Simple Projects......Page 380
HOUR 18 Managing a Simple Mailing List......Page 382
Developing the Subscription Mechanism......Page 383
Developing the Mailing Mechanism......Page 389
Workshop......Page 392
Planning and Creating the Database Tables......Page 394
Creating a Menu......Page 397
Creating the Record Addition Mechanism......Page 398
Viewing Records......Page 403
Creating the Record Deletion Mechanism......Page 408
Adding Subentries to a Record......Page 410
Workshop......Page 416
HOUR 20 Creating an Online Storefront......Page 418
Planning and Creating the Database Tables......Page 419
Displaying Categories of Items......Page 423
Displaying Items......Page 426
Workshop......Page 429
HOUR 21 Creating a Shopping Cart Mechanism......Page 430
Planning and Creating the Database Tables......Page 431
Integrating the Cart with Your Storefront......Page 433
Payment Methods and the Checkout Sequence......Page 441
Workshop......Page 443
PART V Administration and Fine-Tuning......Page 444
HOUR 22 Apache Performance Tuning and Virtual Hosting......Page 446
Scalability Issues......Page 447
Load Testing with ApacheBench......Page 450
Proactive Performance Tuning......Page 452
Preventing Abuse......Page 454
Implementing Virtual Hosting......Page 455
Summary......Page 459
Q&A......Page 460
Workshop......Page 461
The Need for Security......Page 462
The SSL Protocol......Page 463
Installing SSL......Page 468
Managing Certificates......Page 470
SSL Configuration......Page 473
Q&A......Page 474
Workshop......Page 475
HOUR 24 Optimizing and Tuning MySQL......Page 476
Building an Optimized Platform......Page 477
MySQL Startup Options......Page 478
Optimizing Your Table Structure......Page 480
Optimizing Your Queries......Page 481
Using the FLUSH Command......Page 482
Using the SHOW Command......Page 483
Q&A......Page 489
Workshop......Page 490
INDEX......Page 492