PHP, MySQL & JavaScript All in One, Sams Teach Yourself / Edition 6

by Julie Meloni

Overview

In just a short time, you can learn how to use PHP, MySQL, and JavaScript together to create dynamic, interactive websites and applications using three leading web development technologies.

No previous programming experience is required. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of full-stack web application development – from HTML, CSS, and JavaScript on the front end, to PHP scripting and MySQL databases on the server.

Regardless of whether you run Linux, Windows, or MacOS, the book includes complete instructions to install all the software you need to set up a stable environment for learning, testing, and production.

Step-by-step instructions carefully walk you through the most common web application development tasks.

Practical, hands-on examples show you how to apply what you learn.

Quizzes and exercises help you test your knowledge and stretch your skills.

Learn how to:

• Build web pages with HTML5 and CSS

• Use JavaScript to build dynamic, interactive web pages

• Get PHP, MySQL, and JavaScript to work together to create modern, standards-compliant web applications

• Enhance interactivity with AJAX

• Leverage JavaScript libraries such as jQuery

• Work with cookies and user sessions

• Get user input with web-based forms

• Use basic SQL commands

• Interact with the MySQL database using PHP

• Write maintainable code and get started with version control

• Decide when frameworks such as Bootstrap, Foundation, React, Angular,

and Laravel can be useful

• Create a web-based discussion forum or calendar

• Add a storefront and shopping cart to your site

Contents at a Glance

PART I Web Application Basics

1 Understanding How the Web Works

2 Structuring HTML and Using Cascading Style Sheets

3 Understanding the CSS Box Model and Positioning

4 Introducing JavaScript

5 Introducing PHP

PART II Getting Started with Dynamic Web Sites

6 Understanding Dynamic Web Sites and HTML5 Applications

7 JavaScript Fundamentals: Variables, Strings, and Arrays

8 JavaScript Fundamentals: Functions, Objects, and Flow Control

9 Understanding JavaScript Event Handling

10 The Basics of Using jQuery

PART III Taking Your Web Applications to the Next Level

11 AJAX: Getting Started with Remote Scripting

12 PHP Fundamentals: Variables, Strings, and Arrays

13 PHP Fundamentals: Functions, Objects, and Flow Control

14 Working with Cookies and User Sessions

15 Working with Web-Based Forms

PART IV Integrating a Database into Your Applications

16 Understanding the Database Design Process

17 Learning Basic SQL Commands

18 Interacting with MySQL Using PHP

PART V Getting Started with Application Development

19 Creating a Simple Discussion Forum

20 Creating an Online Storefront

21 Creating a Simple Calendar

22 Managing Web Applications

PART VI Appendixes

A Installation QuickStart with XAMPP

B Installing and Configuring MySQL

C Installing and Configuring Apache

D Installing and Configuring PHP

Product Details

ISBN-13:	9780672337703
Publisher:	Pearson Education
Publication date:	09/28/2017
Series:	Sams Teach Yourself
Pages:	704
Product dimensions:	6.90(w) x 9.10(h) x 1.50(d)

About the Author

Julie C. Meloni is a technical consultant who has been developing web-based applications since the Web first saw the light of day. She has authored numerous books and articles on web-based programming and scripting languages and database topics, and you can find translations of her work in 18 different languages.

Table of Contents

Part I: Web Application Basics

CHAPTER 1: Understanding How the Web Works
A Brief History of HTML and the World Wide Web
Creating Web Content
Understanding Web Content Delivery
Selecting a Web Hosting Provider
Testing with Multiple Web Browsers
Creating a Sample File
Using FTP to Transfer Files
Understanding Where to Place Files on the Web Server
CHAPTER 2: Structuring HTML and Using Cascading Style Sheets
Getting Started with a Simple Web Page
HTML Tags Every Web Page Must Have
Using Hyperlinks in Web Pages
Organizing a Page with Paragraphs and Line Breaks
Organizing Your Content with Headings
Understanding Semantic Elements
How CSS Works
A Basic Style Sheet
A CSS Style Primer
Using Style Classes
Using Style IDs
Internal Style Sheets and Inline Styles
CHAPTER 3: Understanding the CSS Box Model and Positioning
The CSS Box Model
The Whole Scoop on Positioning
Controlling the Way Things Stack Up
Managing the Flow of Text
Understanding Fixed Layouts
Understanding Fluid Layouts
Creating a Fixed/Fluid Hybrid Layout
Considering a Responsive Web Design
CHAPTER 4: Introducing JavaScript
Learning Web Scripting Basics
How JavaScript Fits into a Web Page
Exploring JavaScript’s Capabilities
Basic JavaScript Language Concepts
JavaScript Syntax Rules
Using Comments
Best Practices for JavaScript
Understanding JSON
Using the JavaScript Console to Debug JavaScript
CHAPTER 5: Introducing PHP
How PHP Works with a Web Server
The Basics of PHP Scripts
Code Blocks and Browser Output

Part II: Getting Started with Dynamic Websites
CHAPTER 6: Understanding Dynamic Websites and HTML5 Applications
Refresher on the Different Types of Scripting
Displaying Random Content on the Client Side
Understanding the Document Object Model
Using window Objects
Working with the document Object
Accessing Browser History
Working with the location Object
More About the DOM Structure
Working with DOM Nodes
Creating Positionable Elements (Layers)
Hiding and Showing Objects
Modifying Text Within a Page
Adding Text to a Page
Changing Images Based on User Interaction
Thinking Ahead to Developing HTML5 Applications
CHAPTER 7: JavaScript Fundamentals: Variables, Strings, and Arrays
Using Variables
Understanding Expressions and Operators
Data Types in JavaScript
Converting Between Data Types
Using String Objects
Working with Substrings
Using Numeric Arrays
Using String Arrays
Sorting a Numeric Array
CHAPTER 8: JavaScript Fundamentals: Functions, Objects, and Flow Control
Using Functions
Introducing Objects
Using Objects to Simplify Scripting
Extending Built-in Objects
Using the Math Object
Working with Math Methods
Working with Dates
The if Statement
Using Shorthand Conditional Expressions
Testing Multiple Conditions with if and else
Using Multiple Conditions with switch
Using for Loops
Using while Loops
Using do…while Loops
Working with Loops
Looping Through Object Properties
CHAPTER 9: Understanding JavaScript Event Handling
Understanding Event Handlers
Using Mouse Events
Using Keyboard Events
Using the load and unload Events
CHAPTER 10: The Basics of Using jQuery
Using Third-Party JavaScript Libraries jQuery Arrives on the Scene
Preparing to Use jQuery
Becoming Familiar with the $().ready Handler
Selecting DOM and CSS Content
Manipulating HTML Content
Putting the Pieces Together to Create a jQuery Animation
Handling Events with jQuery

Part III: Taking Your Web Applications to the Next Level
CHAPTER 11: AJAX: Remote Scripting
Introducing AJAX
Using XMLHttpRequest
Creating a Simple AJAX Library
Creating an AJAX Quiz Using the Library
Debugging AJAX-Based Applications
Using jQuery’s Built-in Functions for AJAX
CHAPTER 12: PHP Fundamentals: Variables, Strings, and Arrays
Variables
Data Types
Using Expressions and Operators
Constants
Understanding Arrays
Creating Arrays
Some Array-Related Constructs and Functions
CHAPTER 13: PHP Fundamentals: Functions, Objects, and Flow Control
Calling Functions
Defining a Function
Returning Values from User-Defined Functions
Understanding Variable Scope
Saving State Between Function Calls with the static Statement
More About Arguments
Testing for the Existence of a Function
Creating an Object
Object Inheritance
Switching Flow
Implementing Loops
CHAPTER 14: Working with Cookies and User Sessions
Introducing Cookies
Setting a Cookie
Deleting a Cookie
Overview of Server-Side Sessions
Working with Session Variables
Destroying Sessions and Unsetting Session Variables
Using Sessions in an Environment with Registered Users
CHAPTER 15: Working with Web-Based Forms
How HTML Forms Work
Creating a Form
Accepting Text Input
Naming Each Piece of Form Data
Labeling Each Piece of Form Data
Grouping Form Elements
Exploring Form Input Controls
Using HTML5 Form Validation
Submitting Form Data
Accessing Form Elements with JavaScript
Accessing Form Elements with PHP
Using Hidden Fields to Save State in Dynamic Forms
Sending Mail on Form Submission

Part IV: Integrating a Database into Your Applications
CHAPTER 16: Understanding the Database Design Process
The Importance of Good Database Design
Types of Table Relationships
Understanding Normalization
Following the Design Process
CHAPTER 17: Learning Basic SQL Commands
Learning the MySQL Data Types
Learning the Table-Creation Syntax
Using the INSERT Statement
Using the SELECT Statement
Using WHERE in Your Queries
Selecting from Multiple Tables
Using the UPDATE Statement to Modify Records
Using the REPLACE Statement
Using the DELETE Statement
Frequently Used String Functions in MySQL
Using Date and Time Functions in MySQL
CHAPTER 18: Interacting with MySQL Using PHP
MySQL or MySQLi?
Connecting to MySQL with PHP
Working with MySQL Data

Part V: Getting Started with Application Development
CHAPTER 19: Creating a Simple Discussion Forum
Designing the Database Tables
Creating an Include File for Common Functions
Creating the Input Forms and Scripts
Displaying the Topic List
Displaying the Posts in a Topic
Adding Posts to a Topic
Modifying the Forum Display with JavaScript
CHAPTER 20: Creating an Online Storefront
Planning and Creating the Database Tables
Displaying Categories of Items
Displaying Items
Using JavaScript with an Online Storefront
CHAPTER 21: Creating a Simple Calendar
Building a Simple Display Calendar
Creating the Calendar in JavaScript
CHAPTER 22: Managing Web Applications
Understanding Some Best Practices in Web Application Development
Writing Maintainable Code
Implementing Version Control in Your Work
Understanding the Value and Use of Code Frameworks

Appendixes
APPENDIX A: Installation QuickStart Guide with XAMPP
APPENDIX B: Installing and Configuring MySQL
APPENDIX C: Installing and Configuring Apache
APPENDIX D: Installing and Configuring PHP