Buying Options
Learning PHP, MySQL, and JavaScript
Print $39.99
Add to Cart
Print+Ebook $43.99
Add to Cart
Ebook $31.99
(Android, Mobi, PDF, ePub)
Add to Cart
Safari Books Online
Add to Cart
What is this?
Print £30.99
Add to Cart
What is this?

Learning PHP, MySQL, and JavaScript

A Step-by-Step Guide to Creating Dynamic Websites

By
Robin Nixon
Publisher:
O'Reilly Media
Released:
July 2009
Pages:
528
Press Release
Description

With this simple, streamlined guide, non-programmers will quickly learn how to create responsive, data-driven websites with PHP, MySQL, and JavaScript. 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.

Full Description
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, and JavaScript

    3. The Apache Web Server

    4. About Open Source

    5. Bringing It All Together

    6. Test Your Knowledge: Questions

  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. Test Your Knowledge: 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: Questions

  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: Questions

  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: Questions

  6. Chapter 6 PHP Arrays

    1. Basic Access

    2. The foreach...as Loop

    3. Multidimensional Arrays

    4. Using Array Functions

    5. Test Your Knowledge: Questions

  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: Questions

  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: Questions

  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: Questions

  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: Questions

  11. Chapter 11 Form Handling

    1. Building Forms

    2. Retrieving Submitted Data

    3. An Example Program

    4. Test Your Knowledge: Questions

  12. 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

  13. Chapter 13 Cookies, Sessions, and Authentication

    1. Using Cookies in PHP

    2. HTTP Authentication

    3. Using Sessions

    4. Test Your Knowledge: Questions

  14. 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

  15. 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

  16. Chapter 16 JavaScript Functions, Objects, and Arrays

    1. JavaScript Functions

    2. JavaScript Objects

    3. JavaScript Arrays

    4. Test Your Knowledge: Questions

  17. 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

  18. Chapter 18 Using Ajax

    1. What Is Ajax?

    2. Using XMLHttpRequest

    3. Test Your Knowledge: Questions

  19. 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

  20. 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

  1. Appendix Solutions to the Chapter Questions

    1. Answers

    2. Answers

    3. Answers

    4. Answers

    5. Answers

    6. Answers

    7. Answers

    8. Answers

    9. Answers

    10. Answers

    11. Answers

    12. Answers

    13. Answers

    14. Answers

    15. Answers

    16. Answers

    17. Answers

    18. Answers

    19. 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. 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

  6. Colophon

View Full Table of Contents
Product Details
Title:
Learning PHP, MySQL, and JavaScript
By:
Robin Nixon
Publisher:
O'Reilly Media
Formats:
  • Print
  • Ebook
  • Safari Books Online
Print Release:
July 2009
Ebook Release:
July 2009
Pages:
528
Print ISBN:
978-0-596-15713-5
| ISBN 10:
0-596-15713-4
Ebook ISBN:
978-0-596-80476-3
| ISBN 10:
0-596-80476-8
Customer Reviews
About the Author

  1. Robin Nixon

    Robin Nixon has worked with and written about computers since the early 1980s (his first computer was a Tandy TRS 80 Model 1 with a massive 4KB of RAM!). During this time he has written in excess of 500 articles for many of the UK's top computer magazines. Learning PHP, MySQL & JavaScript is his third book.

    Robin started his computing career in the Cheshire homes for disabled people, where he was responsible for setting up computer rooms in a number of residential homes, and for evaluating and tailoring hardware and software so that disabled people could use the new technology--sometimes by means of only a single switch operated by mouth or finger.

    After writing articles for computer magazines about his work with disabled people, he eventually worked full time for one of the country's main IT magazine publishers, where he held several roles including editorial, promotions, and cover disc editing.

    With the dawn of the Internet in the 1990s, Robin branched out into developing websites. One of these presented the world's first radio station licensed by the music copyright holders, and was featured in several news reports on TV and radio networks in the United Kingdom. In order to enable people to continue to surf while listening, Robin also developed the first known pop-up windows.

    Robin lives on the southeast coast of England with his wife Julie, a trained nurse, and five children, where he also finds time to foster three disabled children, as well as working full time from home as a technical author.

    View Robin Nixon's full profile page.

Colophon

The animals on the cover of Learning PHP, MySQL, and JavaScript are sugar gliders (Petaurus breviceps). Sugar gliders are small, gray-furred creatures that grow to an adult length of six to seven-and-a-half inches. Their tails, which are distinguished by a black tip, are usually as long as their bodies. Membranes extend between their wrists and ankles and provide an aerodynamic surface that helps them glide between trees.

Sugar gliders are native to Australia and Tasmania. They prefer to live in the hollow parts of eucalyptus and other types of large trees with several other adult sugar gliders and their own children.

Though sugar gliders reside in groups and defend their territory together, they don't always live in harmony. One male will assert his dominance by marking the group's territory with his saliva and then by marking all group members with a distinctive scent produced from his forehead and chest glands. This ensures that members of the group will know when an outsider approaches; group members will fight off any sugar glider not bearing their scent. However, a sugar glider group will welcome and mark an outsider if one of their adult males dies (the group will typically replace a deceased adult female with their one of their own female offspring).

Sugar gliders make popular pets because of their inquisitive, playful natures, and because many think they are cute. But there are disadvantages to keeping sugar gliders as pets: as they are exotic animals, sugar gliders need specialized, complicated diets consisting of items such as crickets, a variety of fruits and vegetables, and mealworms; healthy housing requires a cage or space no less than the size of an aviary; their distinctive scents can be bothersome to humans; as they are nocturnal creatures, they will bark, hiss, run, and glide all night long; it's not uncommon for them to extricate their bowels while playing or eating; and in some states and countries, it is illegal to own sugar gliders as household pets.

The cover image is from Dover's Animals. The cover font is Adobe ITC Garamond. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSansMonoCondensed.

  • Book cover of Learning PHP, MySQL, and JavaScript
Got a Question?
icons
Favicon Service and support by Satisfaction