Learn everything about the dynamic power of PHP and MySQL in real-world applications with the practical information and step-by-step instructions in PHP and MySQL: Create - Modify – Reuse. The authors, experts in tune with common web development tasks, will guide you through several projects that are complete, tested, and ready to be implemented, so that you can understand by doing. Understand all aspects of design, such as portability, design flow, and integration, and become proficient at solving problems that developers face in everyday circumstances.
Introduction xi
Chapter 1: User Registration 1
Plan the Directory Layout 1
Planning the Database 2
Writing Shared Code 3
User Class 5
CAPTCHA 9
Templates 11
Registering a New User 12
E-mailing a Validation Link 17
Logging In and Out 21
Changing Information 25
Forgotten Passwords 28
Summary 30
Chapter 2: Community Forum 31
Design of the Forum 31
Designing the Database 32
Working with Permissions and Bitwise Operators 33
Updating the User Class 35
Code and Code Explanation 40
Adding Forums 41
Adding Posts 43
Displaying Forums and Posts 47
Pagination 55
Avatars 56
BBCode 59
Summary 62
Chapter 3: Mailing List 63
Design of the Mailing List 63
Choosing POP3 64
Designing the Database 65
Code and Code Explanation 66
The POP3 Client 66
The Configuration File 73
Account Management 73
Processing Messages 79
Processing the Digest 83
Setting Up the Mailing List 83
Summary 86
Chapter 4: Search Engine 87
Designing the Search Engine 87
Problems with Full-Text Search 88
Designing the Database 89
Code and Code Explanation 91
Administrative Interface 91
Crawler/Indexer 98
Front End 104
Summary 110
Chapter 5: Personal Calendar 113
Designing the Application 113
Designing the Database 114
Code and Code Explanation 115
Creating a Month-View Calendar 115
Creating a Day-View Calendar 120
Adding and Showing Events 121
Sending Reminders 129
Exporting the Calendar 130
Summary 135
Chapter 6: Ajax File Manager 137
Design of the Ajax File Manager 137
JavaScript and Ajax 138
The XMLHttpRequest Object 139
Code and Code Explanation 142
Main Interface 143
Client-Side Functionality 147
Server-Side Functionality 160
Summary 175
Chapter 7: Online Photo Album 177
Design of the Online Photo Album 177
Code and Code Explanation 178
Views 178
Helper Files 188
QuickTime Thumbnails 190
Thumbnail Caching 192
Summary 193
Chapter 8: Shopping Cart 195
Designing the Shopping Cart 195
Designing the Database 196
Code and Code Explanation 197
The ShoppingCart Class 197
Working with the Shopping Cart 201
Building the Storefront 209
Adding Inventory 217
Summary 238
Chapter 9: Web Site Statistics 239
Determining What to Collect 239
Designing the Database 241
Obtaining Data 242
Code and Code Explanation 244
Pie Chart 244
Bar Chart 248
The Report 253
Summary 264
Chapter 10: News/Blog System 265
Tables 265
Adding Posts 267
Generating the RSS 278
Displaying Posts 282
Adding Comments 285
Summary 289
Chapter 11: Shell Scripts 291
Designing the Script 292
General Shell Scripting Advice 293
Code and Code Explanation 294
The CommandLine Class 294
startproject 303
The Skeleton 313
Summary 314
Chapter 12: Security and Logging 315
Cross-Site Scripting 315
Path Traversal 318
Injection 320
SQL Injection 320
Command Injection 324
Weak Authentication 325
Logging 327
Preventing Accidental Deletes 330
Summary 332
Index 333
Anonymous
Posted Fri Jun 20 00:00:00 EDT 2008
Someone new to both PHP and MySQL might ask, why this combination? Why should I learn both in tandem? Because, as the authors explain, in many practical situations this duo is used by programmers especially for web applications. This is really an implicit subtitle for the book. The chapters are characterised by application examples all devoted to the web. As in writing web pages for a community forum. The pages are coded in PHP, and the data created by users is then stored in a MySQL backend database. This overall method is followed in other examples. The PHP code samples seem easy to understand. The language has been found, or more accurately, it has been revved into its current version, such that much code is indeed easy to write and understand, and not just the text's examples. One chapter, on shopping cart code, complements a recent book on e-commerce, Wiley Pathways E-Business (Wiley Pathways). It spoke to non-programmers about the travails of starting an e-commerce website. A requirement was for a shopping cart. One way is to hire a programmer. Expensive. But if you are that programmer, consider looking at the extended example offered in the current text. It is extensive enough that it could be used as a code base for your task.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
Learn everything about the dynamic power of PHP and MySQL in real-world applications with the practical information and step-by-step instructions in PHP and MySQL: Create - Modify – Reuse. The authors, experts in tune with common web development tasks, will guide you through several projects that are complete, tested, and ready to be implemented, so that you can understand by doing. Understand all aspects of design, such as portability, design flow, and integration, and become proficient at solving problems that ...