Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Start ReadingShareBuy Print Version
    Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition

    • Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition

    • By:

    • Publisher: O'Reilly Media, Inc.

    • Pub. Date:

    • Print ISBN-13: 978-1-4493-1926-7

    • Pages in Print Edition: 586

    • Subscriber Rating: 4 out of 5 rating4 [2 Ratings]

    2ebooken
    Subscriber Reviews • Browse Similar Topics

    Overview

    Learn how to build interactive, data-driven websites—even if you don’t have any previous programming experience. If you know how to build static sites with HTML, this popular guide will help you tackle dynamic web programming. You’ll get a thorough grounding in today’s core open source technologies: PHP, MySQL, JavaScript, and CSS. Explore each technology separately, learn how to combine them, and pick up valuable web programming concepts along the way.

    Subscriber Reviews

    Average Rating: 4 out of 5 rating Based on 2 Ratings

    No Subscribers have provided a review for this book.

    Table of Contents

     

    View Sample

    Learning PHP, MySQL, JavaScript, and CSS, 2E

    View Sample

    Dedication

    View Sample
    Preface
    View Sample

    Audience

    View Sample

    Assumptions This Book Makes

    View Sample

    Organization of This Book

    View Sample

    Supporting Books

    View Sample

    Conventions Used in This Book

    View Sample

    Using Code Examples

    View Sample

    Safari® Books Online

    View Sample

    How to Contact Us

    View Sample

    Acknowledgments

    View Sample

    Content Updates

    View Sample
    1. Introduction to Dynamic Web Content
    View Sample

    HTTP and HTML: Berners-Lee’s Basics

    View Sample

    The Benefits of PHP, MySQL, JavaScript, and CSS

    View Sample

    The Apache Web Server

    View Sample

    About Open Source

    View Sample

    Bringing It All Together

    View Sample

    Test Your Knowledge

    View Sample
    2. Setting Up a Development Server
    View Sample

    What Is a WAMP, MAMP, or LAMP?

    View Sample

    Installing a WAMP on Windows

    View Sample

    Installing a MAMP on Mac OS X

    View Sample

    Installing a LAMP on Linux

    View Sample

    Working Remotely

    View Sample

    Using a Program Editor

    View Sample

    Using an IDE

    View Sample

    Questions

    View Sample
    3. Introduction to PHP
    View Sample

    Incorporating PHP Within HTML

    View Sample

    This Book’s Examples

    View Sample

    The Structure of PHP

    View Sample

    Test Your Knowledge

    View Sample
    4. Expressions and Control Flow in PHP
    View Sample

    Expressions

    View Sample

    Operators

    View Sample

    Conditionals

    View Sample

    Looping

    View Sample

    Implicit and Explicit Casting

    View Sample

    PHP Dynamic Linking

    View Sample

    Test Your Knowledge

    View Sample
    5. PHP Functions and Objects
    View Sample

    PHP Functions

    View Sample

    Including and Requiring Files

    View Sample

    PHP Version Compatibility

    View Sample

    PHP Objects

    View Sample

    Test Your Knowledge

    View Sample
    6. PHP Arrays
    View Sample

    Basic Access

    View Sample

    The foreach...as Loop

    View Sample

    Multidimensional Arrays

    View Sample

    Using Array Functions

    View Sample

    Test Your Knowledge

    View Sample
    7. Practical PHP
    View Sample

    Using printf

    View Sample

    Date and Time Functions

    View Sample

    File Handling

    View Sample

    System Calls

    View Sample

    XHTML

    View Sample

    Test Your Knowledge

    View Sample
    8. Introduction to MySQL
    View Sample

    MySQL Basics

    View Sample

    Summary of Database Terms

    View Sample

    Accessing MySQL via the Command Line

    View Sample

    Indexes

    View Sample

    MySQL Functions

    View Sample

    Accessing MySQL via phpMyAdmin

    View Sample

    Test Your Knowledge

    View Sample
    9. Mastering MySQL
    View Sample

    Database Design

    View Sample

    Normalization

    View Sample

    Relationships

    View Sample

    Transactions

    View Sample

    Using EXPLAIN

    View Sample

    Backing Up and Restoring

    View Sample

    Test Your Knowledge

    View Sample
    10. Accessing MySQL Using PHP
    View Sample

    Querying a MySQL Database with PHP

    View Sample

    A Practical Example

    View Sample

    Practical MySQL

    View Sample

    Test Your Knowledge

    View Sample
    11. Form Handling
    View Sample

    Building Forms

    View Sample

    Retrieving Submitted Data

    View Sample

    An Example Program

    View Sample

    Test Your Knowledge

    View Sample
    12. Cookies, Sessions, and Authentication
    View Sample

    Using Cookies in PHP

    View Sample

    HTTP Authentication

    View Sample

    Using Sessions

    View Sample

    Test Your Knowledge

    View Sample
    13. Exploring JavaScript
    View Sample

    JavaScript and HTML Text

    View Sample

    Using Comments

    View Sample

    Semicolons

    View Sample

    Variables

    View Sample

    Operators

    View Sample

    Variable Typing

    View Sample

    Functions

    View Sample

    Global Variables

    View Sample

    The Document Object Model (DOM)

    View Sample

    Test Your Knowledge

    View Sample
    14. Expressions and Control Flow in JavaScript
    View Sample

    Expressions

    View Sample

    Operators

    View Sample

    The with Statement

    View Sample

    Using onerror

    View Sample

    Using try...catch

    View Sample

    Conditionals

    View Sample

    Looping

    View Sample

    Explicit Casting

    View Sample

    Test Your Knowledge

    View Sample
    15. JavaScript Functions, Objects, and Arrays
    View Sample

    JavaScript Functions

    View Sample

    JavaScript Objects

    View Sample

    JavaScript Arrays

    View Sample

    Test Your Knowledge

    View Sample
    16. JavaScript and PHP Validation and Error Handling
    View Sample

    Validating User Input with JavaScript

    View Sample

    Regular Expressions

    View Sample

    Redisplaying a Form After PHP Validation

    View Sample

    Test Your Knowledge

    View Sample
    17. Using Ajax
    View Sample

    What Is Ajax?

    View Sample

    Using XMLHttpRequest

    View Sample

    Implementing Ajax via POST Requests

    View Sample

    Using GET Instead of POST

    View Sample

    Sending XML Requests

    View Sample

    Using Frameworks for Ajax

    View Sample

    Test Your Knowledge

    View Sample
    18. Introduction to CSS
    View Sample

    Importing a Style Sheet

    View Sample

    Embedded Style Settings

    View Sample

    CSS Rules

    View Sample

    Style Types

    View Sample

    CSS Selectors

    View Sample

    The CSS Cascade

    View Sample

    The Difference Between <div> and <span>

    View Sample

    Measurements

    View Sample

    Fonts and Typography

    View Sample

    Managing Text Styles

    View Sample

    CSS Colors

    View Sample

    Positioning Elements

    View Sample

    Pseudoclasses

    View Sample

    Pseudoelements

    View Sample

    Shorthand Rules

    View Sample

    The Box Model and Layout

    View Sample

    Test Your Knowledge

    View Sample
    19. Advanced CSS with CSS3
    View Sample

    Attribute Selectors

    View Sample

    The box-sizing Property

    View Sample

    CSS3 Backgrounds

    View Sample

    CSS3 Borders

    View Sample

    Box Shadows

    View Sample

    Element Overflow

    View Sample

    Multicolumn Layout

    View Sample

    Colors and Opacity

    View Sample

    Text Effects

    View Sample

    Web Fonts

    View Sample

    Transformations

    View Sample

    Transitions

    View Sample

    Test Your Knowledge

    View Sample
    20. Accessing CSS from JavaScript
    View Sample

    Revisiting the getElementById Function

    View Sample

    Accessing CSS Properties from JavaScript

    View Sample

    Inline JavaScript

    View Sample

    Adding New Elements

    View Sample

    Using Interrupts

    View Sample

    Test Your Knowledge

    View Sample
    21. Bringing It All Together
    View Sample

    Designing a Social Networking Site

    View Sample

    On the Website

    View Sample

    functions.php

    View Sample

    header.php

    View Sample

    setup.php

    View Sample

    index.php

    View Sample

    signup.php

    View Sample

    checkuser.php

    View Sample

    login.php

    View Sample

    profile.php

    View Sample

    members.php

    View Sample

    friends.php

    View Sample

    messages.php

    View Sample

    logout.php

    View Sample

    styles.css

    View Sample
    A. Solutions to the Chapter Questions
    View Sample

    Chapter 1 Answers

    View Sample

    Chapter 2 Answers

    View Sample

    Chapter 3 Answers

    View Sample

    Chapter 4 Answers

    View Sample

    Chapter 5 Answers

    View Sample

    Chapter 6 Answers

    View Sample

    Chapter 7 Answers

    View Sample

    Chapter 8 Answers

    View Sample

    Chapter 9 Answers

    View Sample

    Chapter 10 Answers

    View Sample

    Chapter 11 Answers

    View Sample

    Chapter 12 Answers

    View Sample

    Chapter 13 Answers

    View Sample

    Chapter 14 Answers

    View Sample

    Chapter 15 Answers

    View Sample

    Chapter 16 Answers

    View Sample

    Chapter 17 Answers

    View Sample

    Chapter 18 Answers

    View Sample

    Chapter 19 Answers

    View Sample

    Chapter 20 Answers

    View Sample
    B. Online Resources
    View Sample

    PHP Resource Sites

    View Sample

    MySQL Resource Sites

    View Sample

    JavaScript Resource Sites

    View Sample

    Ajax Resource Sites

    View Sample

    Miscellaneous Resource Sites

    View Sample

    O’Reilly Resource Sites

    View Sample

    C. MySQL’s FULLTEXT Stopwords

    View Sample

    D. MySQL Functions

    View Sample
    String Functions
    View Sample

    CONCAT()

    View Sample

    CONCAT_WS()

    View Sample

    LEFT()

    View Sample

    RIGHT()

    View Sample

    MID()

    View Sample

    LENGTH()

    View Sample

    LPAD()

    View Sample

    RPAD

    View Sample

    LOCATE()

    View Sample

    LOWER()

    View Sample

    UPPER()

    View Sample

    QUOTE()

    View Sample

    REPEAT()

    View Sample

    REPLACE()

    View Sample

    TRIM()

    View Sample

    LTRIM() and RTRIM()

    View Sample
    Date Functions
    View Sample

    CURDATE()

    View Sample

    DATE()

    View Sample

    DATE_ADD()

    View Sample

    DATE_FORMAT()

    View Sample

    DAY()

    View Sample

    DAYNAME()

    View Sample

    DAYOFWEEK()

    View Sample

    DAYOFYEAR()

    View Sample

    LAST_DAY()

    View Sample

    MAKEDATE()

    View Sample

    MONTH()

    View Sample

    MONTHNAME()

    View Sample

    SYSDATE()

    View Sample

    YEAR()

    View Sample

    WEEK()

    View Sample

    WEEKDAY()

    View Sample
    Time Functions
    View Sample

    CURTIME()

    View Sample

    HOUR()

    View Sample

    MINUTE()

    View Sample

    SECOND()

    View Sample

    MAKETIME()

    View Sample

    TIMEDIFF()

    View Sample

    UNIX_TIMESTAMP()

    View Sample

    FROM_UNIXTIME()

    View Sample

    Index

    View Sample

    About the Author

    View Sample

    Colophon

    View Sample

    Copyright

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    Visit the catalog page for Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition

    • Catalog Page

    Visit the errata page for Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition

    • Errata