American English

PHP, MySQL & JavaScript All in One, Sams Teach Yourself ,6th edition::9780134439587

Published by Sams Publishing (September 21, 2017) © 2018

Julie Meloni
    VitalSource eTextbook (Lifetime access)
    €22,99
    Adding to cart… The item has been added
    ISBN-13: 9780134439587

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

    Language: American English

    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: 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