PHP 6 and MySQL 5 for Dynamic Web Sites: Visual Quickpro Guide

✍ Scribed by Ullman, Larry Edward

• Publisher: Peachpit Press
• Year: 2007;2008
• Tongue: English
• Leaves: 641
• Series: Visual quickpro guide
• Category: Library

✦ Synopsis

With step-by-step instructions, complete scripts, and expert tips to guide readers, this work gets right down to business - after grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), it goes on to cover security, sessions and cookies, and using additional Web tools.

✦ Table of Contents

Cover......Page 1
Contents......Page 6
Introduction......Page 10
What Are Dynamic Web Sites?......Page 11
What You'll Need......Page 17
About This Book......Page 18
Companion Web Site......Page 20
Chapter 1: Introduction to PHP......Page 22
Basic Syntax......Page 23
Sending Data to the Web Browser......Page 27
Writing Comments......Page 31
What Are Variables?......Page 35
Introducing Strings......Page 39
Concatenating Strings......Page 42
Introducing Numbers......Page 44
Introducing Constants......Page 48
Single vs. Double Quotation Marks......Page 51
Chapter 2: Programming with PHP......Page 54
Creating an HTML Form......Page 55
Handling an HTML Form......Page 59
Conditionals and Operators......Page 63
Validating Form Data......Page 67
Introducing Arrays......Page 73
For and While Loops......Page 91
Chapter 3: Creating Dynamic Web Sites......Page 94
Including Multiple Files......Page 95
Handling HTML Forms, Revisited......Page 105
Making Sticky Forms......Page 110
Creating Your Own Functions......Page 113
Chapter 4: Introduction to MySQL......Page 128
Naming Database Elements......Page 129
Choosing Your Column Types......Page 131
Choosing Other Column Properties......Page 135
Accessing MySQL......Page 137
Chapter 5: Introduction to SQL......Page 144
Creating Databases and Tables......Page 145
Inserting Records......Page 148
Selecting Data......Page 152
Using Conditionals......Page 154
Using LIKE and NOT LIKE......Page 157
Sorting Query Results......Page 159
Limiting Query Results......Page 161
Updating Data......Page 163
Deleting Data......Page 165
Using Functions......Page 167
Chapter 6: Advanced SQL and MySQL......Page 178
Database Design......Page 179
Performing Joins......Page 194
Grouping Selected Results......Page 199
Creating Indexes......Page 201
Using Different Table Types......Page 206
Performing FULLTEXT Searches......Page 209
Performing Transactions......Page 215
Chapter 7: Error Handling and Debugging......Page 220
Error Types and Basic Debugging......Page 221
Displaying PHP Errors......Page 227
Adjusting Error Reporting in PHP......Page 229
Creating Custom Error Handlers......Page 232
PHP Debugging Techniques......Page 237
SQL and MySQL Debugging Techniques......Page 241
Chapter 8: Using PHP with MySQL......Page 244
Modifying the Template......Page 245
Connecting to MySQL......Page 247
Executing Simple Queries......Page 251
Retrieving Query Results......Page 260
Ensuring Secure SQL......Page 264
Counting Returned Records......Page 270
Updating Records with PHP......Page 272
Chapter 9: Common Programming Techniques......Page 280
Sending Values to a Script......Page 281
Using Hidden Form Inputs......Page 285
Editing Existing Records......Page 291
Paginating Query Results......Page 298
Making Sortable Displays......Page 306
Chapter 10: Web Application Development......Page 312
Sending Email......Page 313
Date and Time Functions......Page 319
Handling File Uploads......Page 323
PHP and JavaScript......Page 336
Understanding HTTP Headers......Page 343
Chapter 11: Cookies and Sessions......Page 348
Making a Login Page......Page 349
Making the Login Functions......Page 352
Using Cookies......Page 357
Using Sessions......Page 370
Improving Session Security......Page 379
Chapter 12: Security Methods......Page 382
Preventing Spam......Page 383
Validating Data by Type......Page 390
Preventing XSS Attacks......Page 395
Preventing SQL Injection Attacks......Page 398
Database Encryption......Page 404
Chapter 13: Perl-Compatible Regular Expressions......Page 410
Creating a Test Script......Page 411
Defining Simple Patterns......Page 415
Using Quantifiers......Page 418
Using Character Classes......Page 421
Finding All Matches......Page 424
Using Modifiers......Page 428
Matching and Replacing Patterns......Page 430
Chapter 14: Making Universal Sites......Page 434
Character Sets and Encoding......Page 435
Creating Multilingual Web Pages......Page 437
Unicode in PHP......Page 441
Collation in PHP......Page 445
Transliteration in PHP......Page 448
Languages and MySQL......Page 451
Time Zones and MySQL......Page 455
Working with Locales......Page 458
Chapter 15: Example—Message Board......Page 462
Making the Database......Page 463
Writing the Templates......Page 472
Creating the Index Page......Page 481
Creating the Forum Page......Page 482
Creating the Thread Page......Page 487
Posting Messages......Page 492
Chapter 16: Example—User Registration......Page 504
Creating the Templates......Page 505
Writing the Configuration Scripts......Page 511
Creating the Home Page......Page 519
Registration......Page 521
Activating an Account......Page 530
Logging In and Logging Out......Page 534
Password Management......Page 540
Chapter 17: Example—E-Commerce......Page 550
Creating the Database......Page 551
The Administrative Side......Page 557
Creating the Public Template......Page 574
The Product Catalog......Page 578
The Shopping Cart......Page 590
Recording the Orders......Page 600
Appendix A: Installation......Page 608
Installation on Windows......Page 609
Installation on Mac OS X......Page 612
MySQL Permissions......Page 615
Testing Your Installation......Page 619
Configuring PHP......Page 622
Index......Page 624
C......Page 625
D......Page 626
E......Page 628
G......Page 629
I......Page 630
M......Page 631
P......Page 633
R......Page 635
S......Page 636
T......Page 638
U......Page 639
W......Page 640
Z......Page 641

✦ Subjects

Computer Science;Programming;Computers;Nonfiction;Reference;Technical