O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

PHP, MySQL, & JavaScript All-in-One For Dummies

Book Description

Explore the engine that drives the internet

It takes a powerful suite of technologies to drive the most-visited websites in the world. PHP, mySQL, JavaScript, and other web-building languages serve as the foundation for application development and programming projects at all levels of the web. 

Dig into this all-in-one book to get a grasp on these in-demand skills, and figure out how to apply them to become a professional web builder. You’ll get valuable information from seven handy books covering the pieces of web programming, HTML5 & CSS3, JavaScript, PHP, MySQL, creating object-oriented programs, and using PHP frameworks.

  • Helps you grasp the technologies that power web applications      
  • Covers PHP version 7.2
  • Includes coverage of the latest updates in web development
  • Perfect for developers to use to solve problems
This book is ideal for the inexperienced programmer interested in adding these skills to their toolbox. New coders who've made it through an online course or boot camp will also find great value in how this book builds on what you already know.

Table of Contents

  1. Cover
  2. Introduction
    1. About This Book
    2. Foolish Assumptions
    3. Icons Used in This Book
    4. Beyond the Book
    5. Where to Go from Here
  3. Book 1: Getting Started with Web Programming
    1. Chapter 1: Examining the Pieces of Web Programming
      1. Creating a Simple Web Page
      2. Creating a Dynamic Web Page
      3. Storing Content
    2. Chapter 2: Using a Web Server
      1. Recognizing What’s Required
      2. Considering Your Server Options
      3. Tweaking the Servers
    3. Chapter 3: Building a Development Environment
      1. Knowing Which Tools to Avoid
      2. Working with the Right Tools
  4. Book 2: HTML5 and CSS3
    1. Chapter 1: The Basics of HTML5
      1. Diving into Document Structure
      2. Looking at the Basic HTML5 Elements
      3. Marking Your Text
      4. Working with Characters
      5. Making a List (And Checking It Twice)
      6. Building Tables
    2. Chapter 2: The Basics of CSS3
      1. Understanding Styles
      2. Styling Text
      3. Working with the Box Model
      4. Styling Tables
      5. Positioning Elements
    3. Chapter 3: HTML5 Forms
      1. Understanding HTML5 Forms
      2. Using Input Fields
      3. Adding a Text Area
      4. Using Drop-Down Lists
      5. Enhancing HTML5 Forms
      6. Using HTML5 Data Validation
    4. Chapter 4: Advanced CSS3
      1. Rounding Your Corners
      2. Using Border Images
      3. Looking at the CSS3 Colors
      4. Playing with Color Gradients
      5. Adding Shadows
      6. Creating Fonts
      7. Handling Media Queries
    5. Chapter 5: HTML5 and Multimedia
      1. Working with Images
      2. Playing Audio
      3. Watching Videos
      4. Getting Help from Streamers
  5. Book 3: JavaScript
    1. Chapter 1: Introducing JavaScript
      1. Knowing Why You Should Use JavaScript
      2. Seeing Where to Put Your JavaScript Code
      3. The Basics of JavaScript
      4. Controlling Program Flow
      5. Working with Functions
    2. Chapter 2: Advanced JavaScript Coding
      1. Understanding the Document Object Model
      2. Finding Your Elements
      3. Working with Document Object Model Form Data
    3. Chapter 3: Using jQuery
      1. Loading the jQuery Library
      2. Using jQuery Functions
      3. Finding Elements
      4. Replacing Data
      5. Changing Styles
      6. Changing the Document Object Model
      7. Playing with Animation
    4. Chapter 4: Reacting to Events with JavaScript and jQuery
      1. Understanding Events
      2. Focusing on JavaScript and Events
      3. Looking at jQuery and Events
    5. Chapter 5: Troubleshooting JavaScript Programs
      1. Identifying Errors
      2. Working with Browser Developer Tools
      3. Working Around Errors
  6. Book 4: PHP
    1. Chapter 1: Understanding PHP Basics
      1. Seeing the Benefits of PHP
      2. Understanding How to Use PHP
      3. Working with PHP Variables
      4. Using PHP Operators
      5. Including Files
    2. Chapter 2: PHP Flow Control
      1. Using Logic Control
      2. Looping
      3. Building Your Own Functions
      4. Working with Event-Driven PHP
    3. Chapter 3: PHP Libraries
      1. How PHP Uses Libraries
      2. Text Functions
      3. Math Functions
      4. Date and Time Functions
      5. Image-Handling Functions
    4. Chapter 4: Considering PHP Security
      1. Exploring PHP Vulnerabilities
      2. PHP Vulnerability Solutions
    5. Chapter 5: Object-Oriented PHP Programming
      1. Understanding the Basics of Object-Oriented Programming
      2. Using Magic Class Methods
      3. Loading Classes
      4. Extending Classes
    6. Chapter 6: Sessions and Carts
      1. Storing Persistent Data
      2. PHP and Cookies
      3. PHP and Sessions
      4. Shopping Carts
  7. Book 5: MySQL
    1. Chapter 1: Introducing MySQL
      1. Seeing the Purpose of a Database
      2. Presenting MySQL
      3. Advanced MySQL Features
    2. Chapter 2: Administering MySQL
      1. MySQL Administration Tools
      2. Managing User Accounts
    3. Chapter 3: Designing and Building a Database
      1. Managing Your Data
      2. Creating Databases
      3. Building Tables
    4. Chapter 4: Using the Database
      1. Working with Data
      2. Searching for Data
      3. Playing It Safe with Data
    5. Chapter 5: Communicating with the Database from PHP Scripts
      1. Database Support in PHP
      2. Using the mysqli Library
      3. Putting It All Together
  8. Book 6: Creating Object-Oriented Programs
    1. Chapter 1: Designing an Object-Oriented Application
      1. Determining Application Requirements
      2. Creating the Application Database
      3. Designing the Application Objects
      4. Designing the Application Layout
      5. Coding the Website Layout
    2. Chapter 2: Implementing an Object-Oriented Application
      1. Working with Events
      2. Bidder Object Events
      3. Item Object Events
      4. Logging Out of a Web Application
      5. Testing Web Applications
    3. Chapter 3: Using AJAX
      1. Getting to Know AJAX
      2. Communicating Using JavaScript
      3. Using the jQuery AJAX Library
      4. Transferring Data in AJAX
      5. Modifying the AuctionHelper Application
    4. Chapter 4: Extending WordPress
      1. Getting Acquainted with WordPress
      2. Installing WordPress
      3. Examining the Dashboard
      4. Using WordPress
      5. Exploring the World of Plugins
      6. Creating Your Own Widget
  9. Book 7: Using PHP Frameworks
    1. Chapter 1: The MVC Method
      1. Getting Acquainted with MVC
      2. Comparing MVC to Other Web Models
      3. Seeing How MVC Fits into N-Tier Theory
      4. Implementing MVC
    2. Chapter 2: Selecting a Framework
      1. Getting to Know PHP Frameworks
      2. Knowing Why You Should Use a Framework
      3. Focusing on Popular PHP Frameworks
      4. Looking At Micro Frameworks
    3. Chapter 3: Creating an Application Using Frameworks
      1. Building the Template
      2. Creating an Application Scaffold
      3. Modifying the Application Scaffold
  10. About the Author
  11. Connect with Dummies
  12. Index
  13. End User License Agreement