- Book Home :
- Table of Contents :
- Downloads :
- Errata :
- Forum :
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (1st Edition)-->Table of Contents
- Introduction
- What are Dynamic Web Sites?
- What is PHP?
- What is MySQL?
- What You'll Need
- About This Book
- Companion Web Site
- Chapter 1: Introduction to PHP
- Basic Syntax
- Sending Data to the Web Browser
- Understanding PHP, HTML, and White Space
- Writing Comments
- What Are Variables?
- About Strings
- About Numbers
- About Constants
- Single vs. Double Quotation Marks
- Chapter 2: Programming with PHP
- Creating an HTML Form
- Handling an HTML Form
- Managing Magic Quotes
- Conditionals and Operators
- Validating Form Data
- Sending Values to a Script Manually
- What Are Arrays?
- For and While Loops
- Chapter 3: Creating Dynamic Web Sites
- Using External Files
- Creating and Calling Your Own Functions
- Variable Scope
- Handling HTML Forms with PHP Redux
- Sending Email
- HTTP Headers
- Making Sticky Forms
- Date and Time Functions
- Chapter 4: Introduction to SQL and MySQL
- Designing Tables
- Using the mysql monitor
- Creating Databases and Tables
- Inserting Records
- Selecting Data
- Using Conditionals
- Using LIKE and NOT LIKE
- Sorting Query Results
- Limiting Query Results
- Updating Data
- Deleting Data
- Chapter 5: Advanced SQL and MySQL
- Database Design
- Performing Joins
- Using Functions
- Indexes
- Chapter 6: Using PHP and MySQL
- Making the Template
- Connecting to MySQL and Selecting the Database
- Error Handling
- Executing Simple Queries
- Retrieving Query Results
- Security
- Using mysql_num_rows()
- Updating Records with PHP
- Chapter 7: Cookies and Sessions
- Using Cookies
- Using Sessions
- Sessions and Cookies
- Chapter 8: Security
- HTTP Authentication
- Form Validation with JavaScript
- Regular Expressions
- Database Security
- Chapter 9: Web Application Development
- PHP Debugging Techniques
- SQL and MySQL Debugging Techniques
- PHP Error Management
- MySQL Error Management
- Improving Web Application Performance
- Chapter 10: Extended Topics
- Output Buffering
- Page Caching
- Web Browser Detection
- PHP and JavaScript
- Using PEAR
- Chapter 11: ExampleÑContent Management
- Creating the Template
- Creating the Basic Pages
- Managing URLs
- Managing Files
- Chapter 12: ExampleÑUser Registration
- Creating the Templates
- Writing the Configuration Scripts
- Creating the Home Page
- Registration
- Logging In and Logging Out
- Password Management
- Site Administration
- Chapter 13: ExampleÑE-Commerce
- Creating the Database
- The Administrative Side
- Creating the Public Template
- The Product Catalog
- The Shopping Cart
- Appendix A: Installation
- Installation on Mac OS X
- Installation on Windows
- MySQL Permissions
- Testing Your Installation
- Appendix B: Third-Party Applications
- phpMyAdmin
- Template Systems
- Forum Software
- Content Management
- E-Commerce
- Search Engines
- Code Repositories
- Appendix C: Reference
- PHP
- MySQL
- Appendix D: Resources
- PHP
- MySQL
- SQL
- Security
- Other
- Index
Search This Book!
Newsletter #25 Sent!
The latest newsletter went out today. If you're not subscribed to receive it, you can read it online.(February 2, 2010)
Newsletter #24 Released
The latest newsletter went out today. If you're not subscribed to receive it, you can read it online.(December 17, 2009)
New Blog Series on the Yii Framework
I've been writing a series of articles on the Yii framework for PHP Web development. There are currently seven posts, taking you from start to finish of the development process, with more to come.(November 12, 2009)
