Learning PHP, MySQL, and JavaScript: A Step-By-Step Guide to Creating Dynamic Websites [NOOK Book]

Overview

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 ...
See more details below
Learning PHP, MySQL, and JavaScript: A Step-By-Step Guide to Creating Dynamic Websites

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$17.99
BN.com price
(Save 43%)$31.99 List Price

Overview

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 LibraryMake Ajax calls and turn your website into a highly dynamic environment
Upload and manipulate files and images, validate user input, and secure your applications
Read More Show Less

Product Details

  • ISBN-13: 9781449379308
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 7/3/2009
  • Series: Animal Guide
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 528
  • Sales rank: 528,434
  • File size: 10 MB

Meet the Author

Robin Nixon has been a freelance author for 25 years and has had over 500 articles and two books published. Currently, she writes a lot of articles on PHP, MySQL, and JavaScript for UK computer magazines such as PC Plus, for which she also writes the monthly Help Desk column.
Read More Show Less

Table of Contents

Preface; Audience; Assumptions This Book Makes; Organization of This Book; Supporting Books; Conventions Used in This Book; Using Code Examples; We’d Like to Hear from You; Safari® Books Online; Acknowledgments; Chapter 1: Introduction to Dynamic Web Content; 1.1 HTTP and HTML: Berners-Lee’s Basics; 1.2 The Benefits of PHP, MySQL, and JavaScript; 1.3 The Apache Web Server; 1.4 About Open Source; 1.5 Bringing It All Together; 1.6 Test Your Knowledge: Questions; Chapter 2: Setting Up a Development Server; 2.1 What Is a WAMP, MAMP, or LAMP?; 2.2 Installing a WAMP on Windows; 2.3 Installing a MAMP on Mac OS X; 2.4 Installing a LAMP on Linux; 2.5 Working Remotely; 2.6 Using a Program Editor; 2.7 Using an IDE; 2.8 Test Your Knowledge: Questions; Chapter 3: Introduction to PHP; 3.1 Incorporating PHP Within HTML; 3.2 This Book’s Examples; 3.3 The Structure of PHP; 3.4 Test Your Knowledge: Questions; Chapter 4: Expressions and Control Flow in PHP; 4.1 Expressions; 4.2 Operators; 4.3 Conditionals; 4.4 Looping; 4.5 Implicit and Explicit Casting; 4.6 PHP Dynamic Linking; 4.7 Test Your Knowledge: Questions; Chapter 5: PHP Functions and Objects; 5.1 PHP Functions; 5.2 Including and Requiring Files; 5.3 PHP Version Compatibility; 5.4 PHP Objects; 5.5 Test Your Knowledge: Questions; Chapter 6: PHP Arrays; 6.1 Basic Access; 6.2 The foreach...as Loop; 6.3 Multidimensional Arrays; 6.4 Using Array Functions; 6.5 Test Your Knowledge: Questions; Chapter 7: Practical PHP; 7.1 Using printf; 7.2 Date and Time Functions; 7.3 File Handling; 7.4 System Calls; 7.5 XHTML; 7.6 Test Your Knowledge: Questions; Chapter 8:Introduction to MySQL; 8.1 MySQL Basics; 8.2 Summary of Database Terms; 8.3 Accessing MySQL via the Command Line; 8.4 Indexes; 8.5 MySQL Functions; 8.6 Accessing MySQL via phpMyAdmin; 8.7 Test Your Knowledge: Questions; Chapter 9: Mastering MySQL; 9.1 Database Design; 9.2 Normalization; 9.3 Relationships; 9.4 Transactions; 9.5 Using EXPLAIN; 9.6 Backing Up and Restoring; 9.7 Test Your Knowledge: Questions; Chapter 10: Accessing MySQL Using PHP; 10.1 Querying a MySQL Database with PHP; 10.2 A Practical Example; 10.3 Practical MySQL; 10.4 Test Your Knowledge: Questions; Chapter 11: Form Handling; 11.1 Building Forms; 11.2 Retrieving Submitted Data; 11.3 An Example Program; 11.4 Test Your Knowledge: Questions; Chapter 12: Templating with Smarty; 12.1 Why Smarty?; 12.2 Installation; 12.3 Creating Scripts; 12.4 Creating Templates; 12.5 A Practical Example; 12.6 Test Your Knowledge: Questions; Chapter 13: Cookies, Sessions, and Authentication; 13.1 Using Cookies in PHP; 13.2 HTTP Authentication; 13.3 Using Sessions; 13.4 Test Your Knowledge: Questions; Chapter 14: Exploring JavaScript; 14.1 JavaScript and HTML Text; 14.2 Using Comments; 14.3 Semicolons; 14.4 Variables; 14.5 Operators; 14.6 Variable Typing; 14.7 Functions; 14.8 Global Variables; 14.9 The Document Object Model; 14.10 Test Your Knowledge: Questions; Chapter 15: Expressions and Control Flow in JavaScript; 15.1 Expressions; 15.2 Operators; 15.3 The with Statement; 15.4 Using onError; 15.5 Using try...catch; 15.6 Conditionals; 15.7 Looping; 15.8 Explicit Casting; 15.9 Test Your Knowledge: Questions; Chapter 16: JavaScript Functions, Objects, and Arrays; 16.1 JavaScript Functions; 16.2 JavaScript Objects; 16.3 JavaScript Arrays; 16.4 Test Your Knowledge: Questions; Chapter 17: JavaScript and PHP Validation and Error Handling; 17.1 Validating User Input with JavaScript; 17.2 Regular Expressions; 17.3 Redisplaying a Form After PHP Validation; 17.4 Test Your Knowledge: Questions; Chapter 18: Using Ajax; 18.1 What Is Ajax?; 18.2 Using XMLHttpRequest; 18.3 Test Your Knowledge: Questions; Chapter 19: Using YUI for Ajax and More; 19.1 Choosing a Framework; 19.2 Using YUI; 19.3 Other Uses for YUI; 19.4 Test Your Knowledge: Questions; Chapter 20: Bringing It All Together; 20.1 Designing a Social Networking Site; 20.2 On the Website; 20.3 rnfunctions.php; 20.4 rnheader.php; 20.5 rnsetup.php; 20.6 index.php; 20.7 rnsignup.php; 20.8 rnsignup.php (YUI version); 20.9 rncheckuser.php; 20.10 rnlogin.php; 20.11 rnprofile.php; 20.12 rnmembers.php; 20.13 rnfriends.php; 20.14 rnmessages.php; 20.15 rnlogout.php; Solutions to the Chapter Questions; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Answers; Online Resources; PHP Resource Sites; MySQL Resource Sites; JavaScript Resource Sites; Ajax Resource Sites; Miscellaneous Resource Sites; O’Reilly Resource Sites; MySQL’s FULLTEXT Stopwords; MySQL Functions; String Functions; Date Functions; Time Functions; Using PEAAAAAAR and PHPUnit; Installation; Creating a Connect Instance; Rewriting to Use PEAR; Adding Other PEAR Packages; Unit Testing with PHPUnit; Colophon;

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!). One of the web sites he developed presented the world's first radio station licensed by the music copyright holders. In order to enable people to continue to surf while listening, Robin also developed the first known pop-up windows. He has also worked full time for one of Britain's main IT magazine publishers, where he held several roles including editorial, promotions, and cover disc editing.

Read More Show Less

Customer Reviews

Average Rating 3.5
( 33 )
Rating Distribution

5 Star

(12)

4 Star

(7)

3 Star

(4)

2 Star

(3)

1 Star

(7)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
See All Sort by: Showing 1 – 20 of 33 Customer Reviews
  • Posted January 21, 2011

    A must have for inspiring web developers!

    I purchased this book about two weeks ago and I'm already done with it. I couldn't put it down. It's an easy read and I believe it goes further in debt than just the basics. It includes files for the reader to follow along with on their own PC at no additional charge. Robin Nixon does a great job with picking appropriate scenarios and further explaining them in detail as to why he chose them. The flow of chapter contents from PHP-->MySQL-->Ajax/JavaScript is right along with the traditional way that one would develop a dynamic website so you can rest assured that you won't find yourself lost in the process. Robin Nixon also spends a great deal of time explaining the importance of implementing security methods throughout your code. The books sums up with an interesting project where a user will create their very own socializing site. I highly recommend this book to those looking to get a foot in the doorway that is web development and for those looking to refresh their memory as this book also makes a great reference book.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted September 21, 2010

    sample will not open on nook on my laptop

    sample will not open on nook on my laptop. so I am not going to risk paying for a book that might not be able to open and read. Not impressed with the B&N ebook reader and site

    2 out of 5 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted February 2, 2012

    Good Reference and Overall Value

    As someone who has been studying this trio of subjects as a hobbyist for the last year or two I found Nixon's book to offer some usable, alternative methods of programming and the book is certainly a good reference. I'm finding that you really need to study several (if not 10's) of books on these subjects in order to get a good grasp on proper implementation as you would find to be the case on any professional subject. I love these three technologies as it offers the ability for someone who isn't developing in Java, or C# or any of the other C languages to create some really cool, real-life apps. Coupled with HTML5 and CSS I think this opens up so many doors.
    As usual, another programming book that positions itself as `introductory' is really not. I honestly feel the only good beginner books are, oddly, also from O'Reilly offered under the Head First imprint. But, that said, this is a good book to follow up with. VALUE (bad, eh, good, great): Good. BUY or RENT: Buy.

    1 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted May 14, 2011

    Wont open sample

    I mean who uploads these books without testing them. And still after two reviews of the same complaint, here is a third one confirming the complaint.

    1 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted August 21, 2010

    sample file could not be opened by nook

    I'm sure the book is excellent but I'm unable open it on my nook. Other O'Reilly books either open or can't be opened. Does anyone test these files before they're uploaded for sale?

    1 out of 3 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted October 28, 2013

    Verry useful.

    So straight foward and simple to understand.

    Was this review helpful? Yes  No   Report this review
  • Posted December 24, 2011

    Perfect place to start

    I'm new to coding in every way imaginable, and this book has managed to break everything down for me in a very easy to understand manner. I'm glad I bought it first.

    0 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 4, 2010

    No text was provided for this review.

  • Anonymous

    Posted May 17, 2011

    No text was provided for this review.

  • Anonymous

    Posted August 30, 2010

    No text was provided for this review.

  • Anonymous

    Posted August 7, 2009

    No text was provided for this review.

  • Anonymous

    Posted November 24, 2009

    No text was provided for this review.

  • Anonymous

    Posted October 16, 2010

    No text was provided for this review.

  • Anonymous

    Posted September 15, 2010

    No text was provided for this review.

  • Anonymous

    Posted March 30, 2010

    No text was provided for this review.

  • Anonymous

    Posted August 5, 2010

    No text was provided for this review.

  • Anonymous

    Posted July 18, 2011

    No text was provided for this review.

  • Anonymous

    Posted December 10, 2010

    No text was provided for this review.

  • Anonymous

    Posted August 30, 2010

    No text was provided for this review.

  • Anonymous

    Posted October 19, 2010

    No text was provided for this review.

See All Sort by: Showing 1 – 20 of 33 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)