Books & Videos

Learning PHP, MySQL, and JavaScript

Release Date: July 2009

Pages: 528

Read on O'Reilly Online Learning with a 10-day trial

Where’s the cart? Now you can get everything with O'Reilly Online Learning. To purchase books, visit Amazon or your favorite retailer. Questions? See our FAQ or contact customer service:

1-800-889-8969 / 707-827-7019
support@oreilly.com

Download Example Code

View/Submit Errata

If you know HTML, this guide will have you building interactive websites quickly. You'll learn how to create responsive, data-driven websites with PHP, MySQL, and JavaScript, regardless of whether you already know how to program. Discover how the powerful combination of PHP and MySQL provides an easy way to build modern websites complete with dynamic data and user interaction. You'll also learn how to add JavaScript to create rich Internet applications and websites.

Learning PHP, MySQL, and JavaScript explains each technology separately, shows you how to combine them, and introduces valuable web programming concepts, including objects, XHTML, cookies, and session management. You'll practice what you've learned with review questions in each chapter, and find a sample social networking platform built with the elements introduced in this book.

This book will help you:

Understand PHP essentials and the basics of object-oriented programming
Master MySQL, from database structure to complex queries
Create web pages with PHP and MySQL by integrating forms and other HTML features
Learn about JavaScript, from functions and event handling to accessing the Document Object Model
Use libraries and packages, including the Smarty web template system, PEAR program repository, and the Yahoo! User Interface Library
Make Ajax calls and turn your website into a highly dynamic environment
Upload and manipulate files and images, validate user input, and secure your applications

Chapter 1 Introduction to Dynamic Web Content
1. HTTP and HTML: Berners-Lee’s Basics
2. The Benefits of PHP, MySQL, and JavaScript
3. The Apache Web Server
4. About Open Source
5. Bringing It All Together
6. Test Your Knowledge: Questions
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. Test Your Knowledge: Questions
Chapter 3 Introduction to PHP
1. Incorporating PHP Within HTML
2. This Book’s Examples
3. The Structure of PHP
4. Test Your Knowledge: Questions
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: Questions
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: Questions
Chapter 6 PHP Arrays
1. Basic Access
2. The foreach...as Loop
3. Multidimensional Arrays
4. Using Array Functions
5. Test Your Knowledge: Questions
Chapter 7 Practical PHP
1. Using printf
2. Date and Time Functions
3. File Handling
4. System Calls
5. XHTML
6. Test Your Knowledge: Questions
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: Questions
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: Questions
Chapter 10 Accessing MySQL Using PHP
1. Querying a MySQL Database with PHP
2. A Practical Example
3. Practical MySQL
4. Test Your Knowledge: Questions
Chapter 11 Form Handling
1. Building Forms
2. Retrieving Submitted Data
3. An Example Program
4. Test Your Knowledge: Questions
Chapter 12 Templating with Smarty
1. Why Smarty?
2. Installation
3. Creating Scripts
4. Creating Templates
5. A Practical Example
6. Test Your Knowledge: Questions
Chapter 13 Cookies, Sessions, and Authentication
1. Using Cookies in PHP
2. HTTP Authentication
3. Using Sessions
4. Test Your Knowledge: Questions
Chapter 14 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
10. Test Your Knowledge: Questions
Chapter 15 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: Questions
Chapter 16 JavaScript Functions, Objects, and Arrays
1. JavaScript Functions
2. JavaScript Objects
3. JavaScript Arrays
4. Test Your Knowledge: Questions
Chapter 17 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: Questions
Chapter 18 Using Ajax
1. What Is Ajax?
2. Using XMLHttpRequest
3. Test Your Knowledge: Questions
Chapter 19 Using YUI for Ajax and More
1. Choosing a Framework
2. Using YUI
3. Other Uses for YUI
4. Test Your Knowledge: Questions
Chapter 20 Bringing It All Together
1. Designing a Social Networking Site
2. On the Website
3. rnfunctions.php
4. rnheader.php
5. rnsetup.php
6. index.php
7. rnsignup.php
8. rnsignup.php (YUI version)
9. rncheckuser.php
10. rnlogin.php
11. rnprofile.php
12. rnmembers.php
13. rnfriends.php
14. rnmessages.php
15. rnlogout.php

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
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
Appendix MySQL’s FULLTEXT Stopwords
Appendix MySQL Functions
1. String Functions
2. Date Functions
3. Time Functions
Appendix Using PEAR and PHPUnit
1. Installation
2. Creating a Connect Instance
3. Rewriting to Use PEAR
4. Adding Other PEAR Packages
5. Unit Testing with PHPUnit
Colophon

Books & Videos

Learning PHP, MySQL, and JavaScript

Read on O'Reilly Online Learning with a 10-day trial

Table of Contents

Chapter 1 Introduction to Dynamic Web Content

HTTP and HTML: Berners-Lee’s Basics

The Benefits of PHP, MySQL, and JavaScript

The Apache Web Server

About Open Source

Bringing It All Together

Test Your Knowledge: Questions

Chapter 2 Setting Up a Development Server

What Is a WAMP, MAMP, or LAMP?

Installing a WAMP on Windows

Installing a MAMP on Mac OS X

Installing a LAMP on Linux

Working Remotely

Using a Program Editor

Using an IDE

Test Your Knowledge: Questions

Chapter 3 Introduction to PHP

Incorporating PHP Within HTML

This Book’s Examples

The Structure of PHP

Test Your Knowledge: Questions

Chapter 4 Expressions and Control Flow in PHP

Expressions

Operators

Conditionals

Looping

Implicit and Explicit Casting

PHP Dynamic Linking

Test Your Knowledge: Questions

Chapter 5 PHP Functions and Objects

PHP Functions

Including and Requiring Files

PHP Version Compatibility

PHP Objects

Test Your Knowledge: Questions

Chapter 6 PHP Arrays

Basic Access

The foreach...as Loop

Multidimensional Arrays

Using Array Functions

Test Your Knowledge: Questions

Chapter 7 Practical PHP

Using printf

Date and Time Functions

File Handling

System Calls

XHTML

Test Your Knowledge: Questions

Chapter 8 Introduction to MySQL

MySQL Basics

Summary of Database Terms

Accessing MySQL via the Command Line

Indexes

MySQL Functions

Accessing MySQL via phpMyAdmin

Test Your Knowledge: Questions

Chapter 9 Mastering MySQL

Database Design

Normalization

Relationships

Transactions

Using EXPLAIN

Backing Up and Restoring

Test Your Knowledge: Questions

Chapter 10 Accessing MySQL Using PHP

Querying a MySQL Database with PHP

A Practical Example

Practical MySQL

Test Your Knowledge: Questions

Chapter 11 Form Handling

Building Forms

Retrieving Submitted Data

An Example Program

Test Your Knowledge: Questions

Chapter 12 Templating with Smarty

Why Smarty?