Sams Teach Yourself PHP, MySQL & JavaScript All in One (English) 6th 版本

Julie C. Meloni


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









- 使用HTML5和CSS構建網頁
- 使用JavaScript構建動態、互動式網頁
- 使PHP、MySQL和JavaScript共同創建現代、符合標準的網絡應用程序
- 使用AJAX增強互動性
- 利用jQuery等JavaScript庫
- 使用Cookie和用戶會話
- 通過基於Web的表單獲取用戶輸入
- 使用基本的SQL命令
- 使用PHP與MySQL數據庫交互
- 編寫易於維護的代碼並開始使用版本控制
- 判斷何時使用Bootstrap、Foundation、React、Angular和Laravel等框架有用
- 創建基於Web的討論論壇或日曆
- 在您的網站上添加商店和購物車


第一部分 網絡應用程序基礎知識
1 理解網絡的工作原理
2 結構化HTML和使用層疊樣式表
3 理解CSS盒模型和定位
4 介紹JavaScript
5 介紹PHP

第二部分 開始動態網站
6 理解動態網站和HTML5應用程序
7 JavaScript基礎知識:變量、字符串和數組
8 JavaScript基礎知識:函數、對象和流程控制
9 理解JavaScript事件處理
10 使用jQuery的基礎知識

第三部分 提升您的網絡應用程序
11 AJAX:開始遠程腳本
12 PHP基礎知識