Home > Store

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

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

eBook (Watermarked)

  • Your Price: $28.79
  • List Price: $35.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.

Description

  • Copyright 2018
  • Dimensions: 7" x 9-1/8"
  • Edition: 6th
  • eBook (Watermarked)
  • ISBN-10: 0-13-443960-0
  • ISBN-13: 978-0-13-443960-0

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

Sample Content

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

Updates

Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020