PHP & MySQL For Dummies 3rd edition (For Dummies (Computer/Tech))

✍ Scribed by Janet Valade

• Publisher: For Dummies
• Year: 2006
• Tongue: English
• Leaves: 450
• Series: For Dummies Computer/Tech
• Edition: 3
• Category: Library

✦ Synopsis

This is the first book I have ever felt the need to review. I am writing this because I am back on amazon to try to find a book that actually teaches me what I am trying to learn. The book has halfass examples with incomplete information to work from. When you do run into a snag during part of the examples, there is no guidance on how to resolve common errors. In short the book sucks and makes me not want to ever buy another book from the "for dummies" series. If you buy this book, you truly are a dummy.

✦ Table of Contents

PHP & MySQL For Dummies, 3rd Edition......Page 0
Table of Contents......Page 7
About This Book......Page 15
Conventions Used in This Book......Page 16
Foolish Assumptions......Page 17
How This Book Is Organized......Page 18
Where to Go from Here......Page 19
Part I - Developing a Web Database Application Using PHP and MySQL......Page 21
Introduction to PHP and MySQL......Page 23
What Is a Web Database Application?......Page 24
MySQL, My Database......Page 26
PHP, a Data Mover......Page 29
MySQL and PHP, the Perfect Pair......Page 32
Keeping Up with PHP and MySQL Changes......Page 33
The Required Tools......Page 35
Finding a Place to Work......Page 36
Testing, Testing, 1, 2, 3......Page 46
Planning Your Web Database Application......Page 51
Presenting the Two Running Examples in This Book......Page 56
Designing the Database......Page 58
Designing the Sample Databases......Page 64
Types of Data......Page 70
Taking a Look at the Sample Database Designs......Page 73
Developing the Application......Page 75
Part II - MySQL Database......Page 77
Communicating with MySQL......Page 79
Building a Database......Page 87
Moving Data Into and Out of the Database......Page 91
Controlling Access to Your Data......Page 107
Setting Up MySQL Accounts......Page 112
Backing Up Your Data......Page 118
Restoring Your Data......Page 121
Upgrading MySQL......Page 124
Part III - PHP......Page 125
Adding a PHP Section to an HTML Page......Page 127
Writing PHP Statements......Page 130
Using PHP Variables......Page 133
Using PHP Constants......Page 136
Working with Numbers......Page 137
Working with Character Strings......Page 139
Working with Dates and Times......Page 142
Comparing Values......Page 146
Joining Comparisons with and/or/xor......Page 153
Adding Comments to Your Program......Page 155
PHP Building Blocks for Programs......Page 157
Useful Simple Statements......Page 158
Using PHP Arrays......Page 165
Useful Conditional Statements......Page 177
Using Loops......Page 182
Using Functions......Page 192
PHP and MySQL Functions......Page 201
Making a Connection......Page 203
Getting Information from a Database......Page 209
Getting Information from the User......Page 220
Putting Information into a Database......Page 252
Getting Information in Files......Page 264
Moving Information from One Web Page to the Next......Page 269
Moving Your User from One Page to Another......Page 270
Moving Information from Page to Page......Page 273
Using PHP Sessions......Page 281
Part IV - Applications......Page 289
Organizing the Application......Page 291
Keeping It Private......Page 299
Completing Your Documentation......Page 302
Designing the Application......Page 303
Building the Database......Page 305
Designing the Look and Feel......Page 313
Writing the Programs......Page 320
Building a Members Only Web Site......Page 341
Building the Database......Page 342
Designing the Look and Feel......Page 347
Writing the Programs......Page 351
Planning for Growth......Page 369
Part V - The Part of Tens......Page 371
Communicate with MySQL......Page 373
Send E-Mail......Page 374
Handle Arrays......Page 376
Format Values......Page 377
Find Out about Strings......Page 379
Change the Case of Strings......Page 380
Missing Semicolons......Page 381
Missing Dollar Signs......Page 382
Invisible Output......Page 383
Numbered Arrays......Page 384
Missing Mates......Page 385
Confusing Parentheses and Brackets......Page 386
Part VI - Appendixes......Page 387
On Windows......Page 389
On Linux and Unix......Page 395
On Mac......Page 400
Verifying a Downloaded File......Page 402
Configuring MySQL......Page 403
Installing PHP on Unix, Linux, or Mac with Apache......Page 405
Installing PHP on Windows......Page 414
Configuring PHP......Page 418
Selecting a Version of Apache......Page 421
Installing Apache on Linux and Unix......Page 422
Installing Apache on Windows......Page 426
Installing Apache on Mac......Page 430
Configuring Apache......Page 431
Index......Page 433