Sams teach yourself PHP, MySQL and Apache all in one

Cover......Page 1
Contents......Page 7
 Who Should Read This Book?......Page 21
 How This Book Is Organized......Page 22
 Conventions Used in This Book......Page 23
Part I: Getting Up and Running......Page 25
  Linux/UNIX Installation......Page 27
  Windows Installation......Page 30
  Mac OS X Installation......Page 36
  Troubleshooting......Page 40
  Current and Future Versions of MySQL......Page 41
  Installing MySQL on Linux/UNIX......Page 42
  Installing MySQL on Mac OS X......Page 44
  Installing MySQL on Windows......Page 46
  Troubleshooting Your Installation......Page 52
  Basic Security Guidelines......Page 53
  Introducing the MySQL Privilege System......Page 55
  Working with User Privileges......Page 57
  Summary......Page 59
  Workshop......Page 60
  Current and Future Versions of Apache......Page 63
  Choosing the Appropriate Installation Method......Page 64
  Installing Apache on Linux/UNIX......Page 65
  Installing Apache on Mac OS X......Page 67
  Installing Apache on Windows......Page 68
  Apache Configuration File Structure......Page 70
  Apache Log Files......Page 76
  Apache-Related Commands......Page 77
  Starting Apache for the First Time......Page 78
  Troubleshooting......Page 80
  Q&A......Page 82
  Workshop......Page 83
  Current and Future Versions of PHP......Page 85
  Building PHP on Linux/UNIX with Apache......Page 86
  Installing PHP on Mac OS X......Page 89
  Installing PHP on Windows......Page 91
  php.ini Basics......Page 93
  Getting Installation Help......Page 94
  The Basics of PHP Scripts......Page 96
  Q&A......Page 101
  Workshop......Page 102
Part II: PHP Language Structure......Page 105
  Variables......Page 107
  Data Types......Page 110
  Operators and Expressions......Page 116
  Constants......Page 125
  Q&A......Page 127
  Workshop......Page 128
  Switching Flow......Page 131
  Loops......Page 137
  Code Blocks and Browser Output......Page 145
  Summary......Page 147
  Workshop......Page 148
  What Is a Function?......Page 151
  Calling Functions......Page 152
  Defining a Function......Page 153
  Returning Values from User-Defined Functions......Page 156
  Variable Scope......Page 157
  Saving State Between Function Calls with the static Statement......Page 160
  More About Arguments......Page 162
  Testing for the Existence of a Function......Page 165
  Summary......Page 166
  Workshop......Page 167
  What Are Arrays?......Page 169
  Creating Arrays......Page 170
  Some Array-Related Functions......Page 174
  Workshop......Page 176
  Creating an Object......Page 179
  Object Inheritance......Page 184
  Q&A......Page 186
  Workshop......Page 187
Part III: Getting Involved with the Code......Page 189
 10: Working with Strings, Dates, and Time......Page 191
  Formatting Strings with PHP......Page 192
  Investigating Strings in PHP......Page 200
  Manipulating Strings with PHP......Page 204
  Using Date and Time Functions in PHP......Page 211
  Summary......Page 217
  Workshop......Page 218
  Creating a Simple Input Form......Page 221
  Accessing Form Input with User-Defined Arrays......Page 223
  Combining HTML and PHP Code on a Single Page......Page 226
  Using Hidden Fields to Save State......Page 228
  Redirecting the User......Page 229
  Sending Mail on Form Submission......Page 231
  Working with File Uploads......Page 237
  Workshop......Page 241
  Introducing Cookies......Page 243
  Setting a Cookie with PHP......Page 245
  Session Function Overview......Page 247
  Starting a Session......Page 248
  Working with Session Variables......Page 249
  Passing Session IDs in the Query String......Page 253
  Using Sessions in an Environment with Registered Users......Page 254
  Summary......Page 255
  Workshop......Page 256
  Including Files with include()......Page 259
  Validating Files......Page 264
  Creating and Deleting Files......Page 268
  Opening a File for Writing, Reading, or Appending......Page 269
  Reading from Files......Page 270
  Writing or Appending to a File......Page 275
  Working with Directories......Page 277
  Opening Pipes to and from Processes Using popen()......Page 280
  Running Commands with exec()......Page 282
  Running Commands with system() or passthru()......Page 283
  Summary......Page 285
  Workshop......Page 286
  Understanding the Image-Creation Process......Page 289
  Necessary Modifications to PHP......Page 290
  Drawing a New Image......Page 291
  Getting Fancy with Pie Charts......Page 295
  Modifying Existing Images......Page 299
  Image Creation from User Input......Page 302
  Using Images Created by Scripts......Page 306
  Summary......Page 308
  Workshop......Page 309
Part IV: PHP and MySQL Integration......Page 311
  The Importance of Good Database Design......Page 313
  Types of Table Relationships......Page 314
  Understanding Normalization......Page 318
  Following the Design Process......Page 321
  Workshop......Page 323
 16: Learning Basic SQL Commands......Page 325
  Learning the MySQL Data Types......Page 326
  Learning the Table Creation Syntax......Page 329
  Using the INSERT Command......Page 330
  Using the SELECT Command......Page 332
  Using WHERE in Your Queries......Page 335
  Selecting from Multiple Tables......Page 337
  Using the UPDATE Command to Modify Records......Page 343
  Using the REPLACE Command......Page 345
  Using the DELETE Command......Page 346
  Frequently Used String Functions in MySQL......Page 348
  Using Date and Time Functions in MySQL......Page 356
  Summary......Page 368
  Q&A......Page 369
  Workshop......Page 370
  What Are Transactions?......Page 373
  What Are Stored Procedures?......Page 377
  Workshop......Page 379
  Connecting to MySQL with PHP......Page 381
  Working with MySQL Data......Page 385
  Summary......Page 391
  Workshop......Page 392
Part V: Basic Projects......Page 393
  Developing the Subscription Mechanism......Page 395
  Developing the Mailing Mechanism......Page 403
  Summary......Page 406
  Workshop......Page 407
  Planning and Creating the Database Tables......Page 409
  Creating an Include File for Common Functions......Page 412
  Creating a Menu......Page 413
  Creating the Record Addition Mechanism......Page 414
  Viewing Records......Page 418
  Creating the Record Deletion Mechanism......Page 425
  Adding Subentries to a Record......Page 427
  Summary......Page 432
  Workshop......Page 433
  Designing the Database Tables......Page 435
  Creating an Include File for Common Functions......Page 436
  Creating the Input Forms and Scripts......Page 437
  Displaying the Topic List......Page 441
  Displaying the Posts in a Topic......Page 444
  Adding Posts to a Topic......Page 448
  Q&A......Page 451
  Workshop......Page 452
  Planning and Creating the Database Tables......Page 453
  Displaying Categories of Items......Page 457
  Displaying Items......Page 461
  Workshop......Page 464
  Planning and Creating the Database Tables......Page 465
  Integrating the Cart with Your Storefront......Page 467
  Payment Methods and the Checkout Sequence......Page 475
  Summary......Page 477
  Workshop......Page 478
  Building a Simple Display Calendar......Page 479
  Creating a Calendar Library......Page 493
  Q&A......Page 499
  Workshop......Page 500
  Authentication Overview......Page 501
  Apache Authentication Module Functionality......Page 503
  Using Apache for Access Control......Page 508
  Combining Apache Access Methods......Page 510
  Limiting Access Based on HTTP Methods......Page 511
  Restricting Access Based on Cookie Values......Page 512
  Summary......Page 517
  Workshop......Page 518
  Standard Apache Access Logging......Page 521
  Standard Apache Error Logging......Page 527
  Managing Apache Logs......Page 529
  Logging Custom Information to a Database......Page 531
  Summary......Page 535
  Workshop......Page 536
  About Internationalization and Localization......Page 537
  About Character Sets......Page 538
  Environment Modifications......Page 539
  Creating a Localized Page Structure......Page 541
  Q&A......Page 546
  Workshop......Page 547
  What Is XML?......Page 549
  Accessing XML in PHP Using DOM Functions......Page 552
  Accessing XML in PHP Using SimpleXML Functions......Page 555
  Q&A......Page 558
  Workshop......Page 559
Part VI: Administration and Fine-Tuning......Page 561
  Scalability Issues......Page 563
  Load Testing with ApacheBench......Page 567
  Proactive Performance Tuning......Page 569
  Preventing Abuse......Page 571
  Implementing Virtual Hosting......Page 572
  Q&A......Page 577
  Workshop......Page 578
  The Need for Security......Page 581
  The SSL Protocol......Page 582
  Obtaining and Installing SSL Tools......Page 587
  Managing Certificates......Page 590
  SSL Configuration......Page 592
  Summary......Page 593
  Workshop......Page 594
  Building an Optimized Platform......Page 595
  MySQL Startup Options......Page 597
  Optimizing Your Table Structure......Page 599
  Optimizing Your Queries......Page 600
  Using the FLUSH Command......Page 601
  Using the SHOW Command......Page 602
  Summary......Page 608
  Workshop......Page 609
  Staying in the Loop......Page 611
  Upgrading Apache......Page 613
  Summary......Page 615
  Workshop......Page 616
Index......Page 617
 A......Page 619
 C......Page 621
 D......Page 623
 E......Page 626
 F......Page 627
 H......Page 630
 I......Page 631
 L......Page 633
 M......Page 634
 O......Page 637
 P......Page 638
 Q - R......Page 640
 S......Page 641
 T......Page 645
 U......Page 647
 V......Page 648
 W......Page 649
 Y - Z......Page 650