Learning PHP and MySQL
Learning PHP and MySQL By Michele E. Davis, Jon A. Phillips
June 2006
Pages: 376

| Table of Contents | Index | Sample Chapter

Table of Contents

  1. Chapter 1 Dynamic Content and the Web

    1. PHP and MySQL's Place in Web Development

    2. The Components of a PHP Application

    3. Integrating Many Sources of Information

    4. Requesting Data from a Web Page

    5. Chapter 1 Questions

  2. Chapter 2 Installation

    1. Developing Locally

    2. Working Remotely

    3. Chapter 2 Questions

  3. Chapter 3 Exploring PHP

    1. PHP and HTML Text

    2. Coding Building Blocks

    3. Chapter 3 Questions

  4. Chapter 4 PHP Decision Making

    1. Expressions

    2. Operator Concepts

    3. Conditionals

    4. Looping

    5. Chapter 4 Questions

  5. Chapter 5 Functions

    1. Calling Functions

    2. Defining Functions

    3. Object-Oriented Programming

    4. Chapter 5 Questions

  6. Chapter 6 Arrays

    1. Array Fundamentals

    2. Chapter 6 Questions

  7. Chapter 7 Database Basics

    1. Database Design

    2. Structured Query Language

    3. Chapter 7 Questions

  8. Chapter 8 Using MySQL

    1. MySQL Database

    2. Managing the Database

    3. Backing Up and Restoring Data

    4. Advanced SQL

    5. Chapter 8 Questions

  9. Chapter 9 Getting PHP to Talk to MySQL

    1. The Process

    2. Querying the Database with PHP Functions

    3. Using PEAR

    4. Chapter 9 Questions

  10. Chapter 10 Working with Forms

    1. Building a Form

    2. Templates

    3. Chapter 10 Questions

  11. Chapter 11 Practical PHP

    1. String Functions

    2. Date and Time Functions

    3. File Manipulation

    4. Calling System Calls

    5. Chapter 11 Questions

  12. Chapter 12 Modifying MySQL Objects and PHP Data

    1. Changing Database Objects from PHP

    2. Manipulating Table Data

    3. Displaying Results with Embedded Links

    4. Presenting a Form to Add and Process in One File

    5. Updating Data

    6. Deleting Data

    7. Performing a Subquery

    8. Chapter 12 Questions

  13. Chapter 13 Cookies, Sessions, and Access Control

    1. Cookies

    2. PHP and HTTP Authentication

    3. Sessions

    4. Using Auth_HTTP to Authenticate

    5. Chapter 13 Questions

  14. Chapter 14 Security

    2. Session Security

    3. Chapter 14 Questions

  15. Chapter 15 Validation and Error Handling

    1. Validating User Input with JavaScript

    2. Pattern Matching

    3. Redisplaying a Form After PHP Validation Fails

    4. Chapter 15 Questions

  16. Chapter 16 Sample Applications

    1. Building a Blog

    2. Chapter 16 Questions

  17. Chapter 17 Finishing Your Journey

    1. Finding Help on the Web

    2. Web Sites

    3. Zend

    4. Lampshade

    5. Chapter 17 Questions

  1. Appendix Answers to Chapter Questions

    1. Chapter 1

    2. Chapter 2

    3. Chapter 3

    4. Chapter 4

    5. Chapter 5

    6. Chapter 6

    7. Chapter 7

    8. Chapter 8

    9. Chapter 9

    10. Chapter 10

    11. Chapter 11

    12. Chapter 12

    13. Chapter 13

    14. Chapter 14

    15. Chapter 15

    16. Chapter 16

    17. Chapter 17

  2. Colophon

Return to Learning PHP and MySQL