Books & Videos

Table of Contents

  1. Chapter 1 Introduction to Dynamic Web Content

    1. HTTP and HTML: Berners-Lee’s Basics

    2. The Benefits of PHP, MySQL, JavaScript, and CSS

    3. The Apache Web Server

    4. About Open Source

    5. Bringing It All Together

    6. Test Your Knowledge

  2. Chapter 2 Setting Up a Development Server

    1. What Is a WAMP, MAMP, or LAMP?

    2. Installing a WAMP on Windows

    3. Installing a MAMP on Mac OS X

    4. Installing a LAMP on Linux

    5. Working Remotely

    6. Using a Program Editor

    7. Using an IDE

    8. Questions

  3. Chapter 3 Introduction to PHP

    1. Incorporating PHP Within HTML

    2. This Book’s Examples

    3. The Structure of PHP

    4. Test Your Knowledge

  4. Chapter 4 Expressions and Control Flow in PHP

    1. Expressions

    2. Operators

    3. Conditionals

    4. Looping

    5. Implicit and Explicit Casting

    6. PHP Dynamic Linking

    7. Test Your Knowledge

  5. Chapter 5 PHP Functions and Objects

    1. PHP Functions

    2. Including and Requiring Files

    3. PHP Version Compatibility

    4. PHP Objects

    5. Test Your Knowledge

  6. Chapter 6 PHP Arrays

    1. Basic Access

    2. The foreach...as Loop

    3. Multidimensional Arrays

    4. Using Array Functions

    5. Test Your Knowledge

  7. Chapter 7 Practical PHP

    1. Using printf

    2. Date and Time Functions

    3. File Handling

    4. System Calls

    5. XHTML

    6. Test Your Knowledge

  8. Chapter 8 Introduction to MySQL

    1. MySQL Basics

    2. Summary of Database Terms

    3. Accessing MySQL via the Command Line

    4. Indexes

    5. MySQL Functions

    6. Accessing MySQL via phpMyAdmin

    7. Test Your Knowledge

  9. Chapter 9 Mastering MySQL

    1. Database Design

    2. Normalization

    3. Relationships

    4. Transactions

    5. Using EXPLAIN

    6. Backing Up and Restoring

    7. Test Your Knowledge

  10. Chapter 10 Accessing MySQL Using PHP

    1. Querying a MySQL Database with PHP

    2. A Practical Example

    3. Practical MySQL

    4. Test Your Knowledge

  11. Chapter 11 Form Handling

    1. Building Forms

    2. Retrieving Submitted Data

    3. An Example Program

    4. Test Your Knowledge

  12. Chapter 12 Cookies, Sessions, and Authentication

    1. Using Cookies in PHP

    2. HTTP Authentication

    3. Using Sessions

    4. Test Your Knowledge

  13. Chapter 13 Exploring JavaScript

    1. JavaScript and HTML Text

    2. Using Comments

    3. Semicolons

    4. Variables

    5. Operators

    6. Variable Typing

    7. Functions

    8. Global Variables

    9. The Document Object Model (DOM)

    10. Test Your Knowledge

  14. Chapter 14 Expressions and Control Flow in JavaScript

    1. Expressions

    2. Operators

    3. The with Statement

    4. Using onerror

    5. Using try...catch

    6. Conditionals

    7. Looping

    8. Explicit Casting

    9. Test Your Knowledge

  15. Chapter 15 JavaScript Functions, Objects, and Arrays

    1. JavaScript Functions

    2. JavaScript Objects

    3. JavaScript Arrays

    4. Test Your Knowledge

  16. Chapter 16 JavaScript and PHP Validation and Error Handling

    1. Validating User Input with JavaScript

    2. Regular Expressions

    3. Redisplaying a Form After PHP Validation

    4. Test Your Knowledge

  17. Chapter 17 Using Ajax

    1. What Is Ajax?

    2. Using XMLHttpRequest

    3. Implementing Ajax via POST Requests

    4. Using GET Instead of POST

    5. Sending XML Requests

    6. Using Frameworks for Ajax

    7. Test Your Knowledge

  18. Chapter 18 Introduction to CSS

    1. Importing a Style Sheet

    2. Embedded Style Settings

    3. CSS Rules

    4. Style Types

    5. CSS Selectors

    6. The CSS Cascade

    7. The Difference Between <div> and <span>

    8. Measurements

    9. Fonts and Typography

    10. Managing Text Styles

    11. CSS Colors

    12. Positioning Elements

    13. Pseudoclasses

    14. Pseudoelements

    15. Shorthand Rules

    16. The Box Model and Layout

    17. Test Your Knowledge

  19. Chapter 19 Advanced CSS with CSS3

    1. Attribute Selectors

    2. The box-sizing Property

    3. CSS3 Backgrounds

    4. CSS3 Borders

    5. Box Shadows

    6. Element Overflow

    7. Multicolumn Layout

    8. Colors and Opacity

    9. Text Effects

    10. Web Fonts

    11. Transformations

    12. Transitions

    13. Test Your Knowledge

  20. Chapter 20 Accessing CSS from JavaScript

    1. Revisiting the getElementById Function

    2. Accessing CSS Properties from JavaScript

    3. Inline JavaScript

    4. Adding New Elements

    5. Using Interrupts

    6. Test Your Knowledge

  21. Chapter 21 Bringing It All Together

    1. Designing a Social Networking Site

    2. On the Website

    3. functions.php

    4. header.php

    5. setup.php

    6. index.php

    7. signup.php

    8. checkuser.php

    9. login.php

    10. profile.php

    11. members.php

    12. friends.php

    13. messages.php

    14. logout.php

    15. styles.css

  1. Appendix Solutions to the Chapter Questions

    1. Chapter 1 Answers

    2. Chapter 2 Answers

    3. Chapter 3 Answers

    4. Chapter 4 Answers

    5. Chapter 5 Answers

    6. Chapter 6 Answers

    7. Chapter 7 Answers

    8. Chapter 8 Answers

    9. Chapter 9 Answers

    10. Chapter 10 Answers

    11. Chapter 11 Answers

    12. Chapter 12 Answers

    13. Chapter 13 Answers

    14. Chapter 14 Answers

    15. Chapter 15 Answers

    16. Chapter 16 Answers

    17. Chapter 17 Answers

    18. Chapter 18 Answers

    19. Chapter 19 Answers

    20. Chapter 20 Answers

  2. Appendix Online Resources

    1. PHP Resource Sites

    2. MySQL Resource Sites

    3. JavaScript Resource Sites

    4. Ajax Resource Sites

    5. Miscellaneous Resource Sites

    6. O’Reilly Resource Sites

  3. Appendix MySQL’s FULLTEXT Stopwords

  4. Appendix MySQL Functions

    1. String Functions

    2. Date Functions

    3. Time Functions

  5. Colophon