PHP & MySQL For Dummies 3rd edition

About the Author......Page 6
Author’s Acknowledgments......Page 8
Contents at a Glance......Page 10
Table of Contents......Page 12
About This Book......Page 20
Conventions Used in This Book......Page 21
Foolish Assumptions......Page 22
How This Book Is Organized......Page 23
Where to Go from Here......Page 24
Part I - Developing a Web Database Application Using PHP and MySQL......Page 26
Introduction to PHP and MySQL......Page 28
What Is a Web Database Application?......Page 29
MySQL, My Database......Page 31
PHP, a Data Mover......Page 34
MySQL and PHP, the Perfect Pair......Page 37
Keeping Up with PHP and MySQL Changes......Page 38
The Required Tools......Page 40
Finding a Place to Work......Page 41
Testing, Testing, 1, 2, 3......Page 51
Planning Your Web Database Application......Page 56
Presenting the Two Running Examples in This Book......Page 61
Designing the Database......Page 63
Designing the Sample Databases......Page 69
Types of Data......Page 75
Taking a Look at the Sample Database Designs......Page 78
Developing the Application......Page 80
Part II - MySQL Database......Page 82
Communicating with MySQL......Page 84
Building a Database......Page 92
Moving Data Into and Out of the Database......Page 96
Controlling Access to Your Data......Page 112
Setting Up MySQL Accounts......Page 117
Backing Up Your Data......Page 123
Restoring Your Data......Page 126
Upgrading MySQL......Page 129
Part III - PHP......Page 130
Adding a PHP Section to an HTML Page......Page 132
Writing PHP Statements......Page 135
Using PHP Variables......Page 138
Using PHP Constants......Page 141
Working with Numbers......Page 142
Working with Character Strings......Page 144
Working with Dates and Times......Page 147
Comparing Values......Page 151
Joining Comparisons with and/or/xor......Page 158
Adding Comments to Your Program......Page 160
PHP Building Blocks for Programs......Page 162
Useful Simple Statements......Page 163
Using PHP Arrays......Page 170
Useful Conditional Statements......Page 182
Using Loops......Page 187
Using Functions......Page 197
PHP and MySQL Functions......Page 206
Making a Connection......Page 208
Getting Information from a Database......Page 214
Getting Information from the User......Page 225
Putting Information into a Database......Page 257
Getting Information in Files......Page 269
Moving Information from One Web Page to the Next......Page 274
Moving Your User from One Page to Another......Page 275
Moving Information from Page to Page......Page 278
Using PHP Sessions......Page 286
Part IV - Applications......Page 294
Organizing the Application......Page 296
Keeping It Private......Page 304
Completing Your Documentation......Page 307
Designing the Application......Page 308
Building the Database......Page 310
Designing the Look and Feel......Page 318
Writing the Programs......Page 325
Building a Members Only Web Site......Page 346
Building the Database......Page 347
Designing the Look and Feel......Page 352
Writing the Programs......Page 356
Planning for Growth......Page 374
Part V - The Part of Tens......Page 376
Communicate with MySQL......Page 378
Send E-Mail......Page 379
Handle Arrays......Page 381
Format Values......Page 382
Find Out about Strings......Page 384
Change the Case of Strings......Page 385
Missing Semicolons......Page 386
Missing Dollar Signs......Page 387
Invisible Output......Page 388
Numbered Arrays......Page 389
Missing Mates......Page 390
Confusing Parentheses and Brackets......Page 391
Part VI - Appendixes......Page 392
On Windows......Page 394
On Linux and Unix......Page 400
On Mac......Page 405
Verifying a Downloaded File......Page 407
Configuring MySQL......Page 408
Installing PHP on Unix, Linux, or Mac with Apache......Page 410
Installing PHP on Windows......Page 419
Configuring PHP......Page 423
Selecting a Version of Apache......Page 426
Installing Apache on Linux and Unix......Page 427
Installing Apache on Windows......Page 431
Installing Apache on Mac......Page 435
Configuring Apache......Page 436
Index......Page 438