Core Web Application Development with PHP and MySQL

Core Web Application Development with PHP and MySQL

Part I. The Basics of PHP

Chapter 1. Getting Started with PHP
   - Your First PHP Programs
   - Entering PHP Scripts
   - How to Store Data
   - Entering Basic Types in PHP
   - Some Very Useful Functions
   - Summary

Chapter 2. The PHP Language
   - More on Entering Strings
   - More on Data Types
   - Type Conversions
   - Variables and Constants
   - Expressions and Operators
   - Control Structures
   - Summary

Chapter 3. Code Organization and Reuse
   - Basic Code Reuse: Functions
   - Intermediate Code Reuse: Using and Including Files
   - Summary

Chapter 4. Object-Oriented Programming
   - Moving Beyond Libraries
   - Object-Oriented Programming
   - Extending Objects
   - Other Features
   - Summary

Chapter 5. Working with Arrays
   - Arrays Revisited
   - Iterating Over Elements in an Array
   - Multi-Dimensional Arrays
   - Operations on Arrays
   - Summary

Chapter 6. Strings and Characters of the World
   - Strings and PHP
   - Character Sets and Unicode
   - Making Sense of It All in PHP
   - Configuring PHP for Unicode
   - Operating on Strings
   - Summary

Chapter 7. Interacting with the Server: Forms
   - An Example of Forms
   - Working with HTML Forms
   - Working with the Server
   - Redirecting the User
   - Summary

Part II. Database Basics

Chapter 8. Introduction to Databases
   - What Are We Talking About?
   - Motivations for Using a DBMS
   - Major Database Servers
   - How to Select a Database Server
   - Our Choice
   - Common Interfaces
   - Summary

Chapter 9. Designing and Creating Your Database
   - What to Put into the Database
   - Organizing Your Data
   - An Introduction to SQL
   - Creating Databases
   - Setting User Permissions
   - Creating Tables
   - Deleting Tables and Databases
   - Summary

Chapter 10. Using Databases: Storing and Retrieving Data
   - Before We Begin
   - Inserting Data into Our Tables
   - Retrieving Data from Tables
   - Modifying Data in Your Tables
   - Deleting Data from Tables
   - Summary

Chapter 11. Using Databases: Advanced Data Access
   - Transactions
   - More Advanced Queries
   - Modifying Table Schemas
   - Summary

Chapter 12. PHP and Data Access
   - Getting Ready
   - Connecting and Authenticating
   - Executing Queries
   - Queries a Go-Go
   - Old-School Interfaces
   - Summary

Part III. Planning Web Applications

Chapter 13. Web Applications and the Internet
   - A Closer Look at the World Wide Web
   - Designing Web Applications
   - Summary

Chapter 14. Implementing a User Interface
   - User Interface Considerations
   - Implementing Your User Interface
   - Summary

Chapter 15. User Management
   - How Users Connect to Our Application
   - Visitors Versus Known Users
   - Validating Users
   - Summary

Chapter 16. Securing Your Web Applications: Planning and Code Security
   - Strategies for Dealing with Security
   - Identifying the Threats
   - Securing Your Code
   - Summary

Chapter 17. Securing Your Web Applications: Software and Hardware Security
   - Securing Your Web Server and PHP
   - Secure Sockets Layer (SSL)
   - Database Security
   - Protecting the Network
   - Computer and Operating System Security
   - Disaster Planning
   - Summary

Part IV. Implementing Your Web Application

Chapter 18. Error Handling and Debugging
   - How Errors Are Born
   - How PHP Manages Errors
   - Exceptions
   - Debugging
   - Summary

Chapter 19. Cookies and Sessions
   - Cookies: Tasty and Useful
   - Sessions
   - Session Security
   - Summary

Chapter 20. User Authentication
   - Planning for Members
   - Web Server-Provided Authentication
   - Implementing Our Own Authentication
   - Summary

Chapter 21. Advanced Output and Output Buffering
   - Globalization and Locales
   - Formatted Output
   - Output Buffering
   - Summary

Chapter 22. Data Validation with Regular Expressions
   - Using Regular Expressions
   - Data Validation with Regular Expressions
   - Other Regular Expression Functions
   - Summary

Chapter 23. XML and XHTML
   - XML
   - Working with XML in PHP
   - XHTML
   - Summary

Chapter 24. Files and Directories
   - Accessing Files
   - Accessing Directories
   - Security Considerations
   - Summary

Chapter 25. File Uploading
   - Uploading User Files
   - A File-Uploading Example
   - Security Considerations
   - Summary

Chapter 26. Working with Dates and Times
   - Sources of Dates and Times
   - Dates and Times in PHP
   - More Dates and Times in Database Servers
   - Summary

Chapter 27. XML Web Services and SOAP
   - XML Web Services
   - How Web Services Work
   - Using Web Services in PHP
   - Sample: Working with the Google APIs
   - Summary

Chapter 28. Using PEAR
   - Introduction to PEAR
   - Installation and Configuration
   - Basic Commands
   - Example: Using the Date Class
   - Summary

Chapter 29. Development and Deployment
   - Coding Standards
   - Source Code Control
   - Testing
   - Deployment
   - Summary

Part V. Sample Projects and Further Ideas

Chapter 30. Strategies for Successful Web Applications
   - Singleton Objects
   - Session Management
   - A Holistic Approach to Error Handling
   - Database Connection Management
   - PHP Configuration Settings
   - Summary

Chapter 31. An Appointment Manager
   - Overview
   - Installing and Running the Sample
   - Structure and Page Progression
   - Code Walkthrough
   - Suggestions/Exercises
   - Summary

Chapter 32. A Blogging Engine
   - Overview
   - Installing and Running the Sample
   - Structure and Page Progression
   - Code Walkthrough
   - Suggestions/Exercises
   - Summary

Chapter 33. An Ecommerce Application
   - Overview
   - Installing and Running the Sample
   - Structure and Page Progression
   - Code Walkthrough
   - Payment Processing
   - Suggestions/Exercises
   - Summary

Part VI. Appendixes

Appendix A. Installation/Configuration
   - Installation
   - Configuration
   - Summary

Appendix B. Database Function Equivalents
   - Working with Databases
   - Data Description and Creation
   - Other Functions and Interesting Notes
   - Summary

Appendix C. Recommended Reading

This book is divided into two main sections. The first part, taking up about two-thirds of the text, gives you treatment of the "core" part of the language, and the second part provides a set of various advanced topics to show what you can build using Python