PHP, MySQL & JavaScript All in One, Sams Teach Yourself

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

PART I: Getting Up and Running
1 Installation QuickStart Guide
2 Dynamic Web Basics

PART II: PHP Language Structure
5 The Building Blocks of PHP
6 Flow Control Functions in PHP
7 Working with Functions
8 Working with Arrays
9 Working with Objects

PART III: Getting Involved with the Code
10 Working with Strings, Dates, and Time
11 Working with Forms
12 Working with Cookies and User Sessions
13 Working with Files and Directories
14 Working with Images

PART IV: PHP and MySQL Integration
15 Understanding the Database Design Process
16 Learning Basic SQL Commands
17 Using Transactions and Stored Procedures in MySQL
18 Interacting with MySQL Using PHP

PART V: Advanced JavaScript Programming
19 JavaScript Best Practices
20 Using Third-Party JavaScript Libraries and Frameworks
21 A Closer Look at jQuery
22 First Steps Toward Creating Rich Interactions with jQuery UI
23 AJAX: Remote Scripting

PART VI: Advanced Web Page Design with CSS
24 Working with Margins, Padding, Alignment, and Floating
25 Understanding the CSS Box Model and Positioning
26 Using CSS to Do More with Lists, Text, and Navigation
27 Creating Fixed or Liquid Layouts

PART VII: Basic Projects
28 Managing a Simple Mailing List
29 Creating a Simple Discussion Forum
30 Creating an Online Storefront
31 Creating a Shopping Cart Mechanism
32 Restricting Access to Your Applications
33 Logging and Monitoring Web Server Activity
34 Application Localization

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.