Learning PHP, MySQL & JavaScript. 7th Edition Robin Nixon

Spis treści książki

• Preface
  • Audience
  • Assumptions This Book Makes
  • Organization of This Book
  • Conventions Used in This Book
  • Using Code Examples
  • OReilly Online Learning
  • How to Contact Us
  • Acknowledgments
• 1. Introduction to Dynamic Web Content
  • HTTP and HTML: Berners-Lees Basics
  • The Request/Response Procedure
  • The Benefits of PHP, MySQL, JavaScript, CSS, and HTML
    • MariaDB: The MySQL Clone
    • Using PHP
    • Using MySQL
    • Using JavaScript
    • Using CSS
  • And Then Theres HTML5
  • The Apache Web Server
  • Node.js: An Alternative to Apache
  • About Open Source
  • Bringing It All Together
  • Questions
• 2. Setting Up a Development Server
  • What Is a WAMP, MAMP, or LAMP?
  • Installing AMPPS on Windows
    • Testing the Installation
    • Accessing the Document Root (Windows)
    • Alternative WAMPs
  • Installing AMPPS on macOS
  • Installing a LAMP on Linux
  • Working Remotely
    • Logging In
    • Transferring Files
  • Using a Code Editor
  • Questions
• 3. Introduction to PHP
  • Incorporating PHP Within HTML
  • This Books Examples
  • The Structure of PHP
    • Using Comments
    • Basic Syntax
      • Semicolons
      • The $ symbol
    • Variables
      • String variables
      • Numeric variables
      • Arrays
      • Two-dimensional arrays
      • Variable-naming rules
    • Operators
      • Arithmetic operators
      • Assignment operators
      • Comparison operators
      • Logical operators
      • Operator precedence
    • Variable Assignment
      • Variable incrementing and decrementing
      • String concatenation
      • String types
      • Escaping characters
    • Multiline Strings
      • Using a nowdoc
    • Variable Typing
    • Constants
    • Predefined Constants
    • The Difference Between the echo and print Commands
    • Functions
    • Variable Scope
      • Local variables
      • Global variables
      • Static variables
      • Superglobal variables
      • Superglobals and security
  • Questions
• 4. Expressions and Control Flow in PHP
  • Expressions
    • TRUE or FALSE?
    • Literals and Variables
  • Operators
    • Operator Precedence
    • Associativity
    • Relational Operators
      • Equality operators
      • Comparison operators
      • Logical operators
  • Conditionals
    • The if Statement
    • The else Statement
    • The elseif Statement
    • The switch Statement
      • Breaking out
      • Default action
      • Alternative syntax
    • The ? (or Ternary) Operator
  • Looping
    • while Loops
    • do...while Loops
    • for Loops
    • Breaking Out of a Loop
    • The continue Statement
  • Implicit and Explicit Casting
  • PHP Modularization
  • Questions
• 5. PHP Functions and Objects
  • PHP Functions
    • Defining a Function
    • Returning a Value
    • Returning an Array
    • Returning Global Variables
    • Recap of Variable Scope
  • Including and Requiring Files
    • The include Statement
    • Using include_once
    • Using require and require_once
  • PHP Version Compatibility
  • PHP Objects
    • Terminology
    • Declaring a Class
    • Creating an Object
    • Accessing Objects
    • Cloning Objects
    • Constructors
    • Destructors
    • Writing Methods
    • Declaring Properties
    • Static Methods
    • Declaring Constants
    • Property and Method Scope
    • Static Properties
    • Inheritance
      • The parent keyword
      • Subclass constructors
      • Final methods
  • Questions
• 6. PHP Arrays
  • Basic Access
    • Numerically Indexed Arrays
    • Associative Arrays
    • Assignment Using the array Keyword
  • The foreach...as Loop
  • Multidimensional Arrays
  • Using Array Functions
    • is_array
    • count
    • sort
    • shuffle
    • explode
    • compact
    • reset
    • end
  • Questions
• 7. Practical PHP
  • Using printf
    • Precision Setting
    • String Padding
    • Using sprintf
  • Date and Time Functions
    • Date Constants
    • Using checkdate
  • File Handling
    • Checking Whether a File Exists
    • Creating a File
    • Reading from Files
    • Copying Files
    • Moving a File
    • Deleting a File
    • Updating Files
    • Locking Files for Multiple Accesses
    • Reading an Entire File
    • Uploading Files
      • Using $_FILES
      • Validation
  • System Calls
  • Questions
• 8. Introduction to MySQL
  • MySQL Basics
  • Key Database Terms
  • Accessing MySQL via the Command Line
    • Starting the Command-Line Interface
      • Windows users
      • macOS users
      • Linux users
      • MySQL on a remote server
    • Using the Command-Line Interface
      • The semicolon
      • Canceling a command
    • MySQL Commands
      • Creating a database
      • Creating users
      • Creating a table
    • Data Types
      • The CHAR data type
      • The BINARY data type
      • The TEXT data types
      • The BLOB data types
      • Numeric data types
      • DATE and TIME types
      • The AUTO_INCREMENT attribute
      • Adding data to a table
      • Renaming a table
      • Changing the data type of a column
      • Adding a new column
      • Renaming a column
      • Removing a column
      • Deleting a table
  • Indexes
    • Creating an Index
      • Using CREATE INDEX
      • Adding indexes when creating tables
      • Primary keys
      • Creating a FULLTEXT index
    • Querying a MySQL Database
      • SELECT
      • SELECT COUNT
      • SELECT DISTINCT
      • DELETE
      • WHERE
      • LIMIT
      • MATCH...AGAINST
      • MATCH...AGAINST in Boolean mode
      • UPDATE...SET
      • ORDER BY
      • GROUP BY
    • Joining Tables
      • NATURAL JOIN
      • JOIN...ON
      • Using AS
    • Using Logical Operators
  • MySQL Functions
  • Accessing MySQL via phpMyAdmin
  • Questions
• 9. Mastering MySQL
  • Database Design
  • Primary Keys: The Keys to Relational Databases
  • Normalization
    • First Normal Form
    • Second Normal Form
    • Third Normal Form
    • When Not to Use Normalization
  • Relationships
    • One-to-One
    • One-to-Many
    • Many-to-Many
    • Databases and Privacy
  • Transactions
    • Transaction Storage Engines
    • Using START TRANSACTION
    • Using COMMIT
    • Using ROLLBACK
  • Using EXPLAIN
  • Backing Up and Restoring
    • Using mysqldump
    • Creating a Backup File
      • Backing up a single table
      • Backing up all databases
    • Restoring from a Backup File
    • Dumping Data in CSV Format
    • Planning Your Backups
  • Questions
• 10. Accessing MySQL Using PHP
  • Querying a MySQL Database with PHP
    • The Process
    • Creating a Login File
    • Connecting to a MySQL Database
      • Building and Executing a Query
      • Fetching a Result
      • Fetching a Row While Specifying the Style
      • Closing a Connection
  • A Practical Example
    • The $_POST Array
    • Deleting a Record
    • Displaying the Form
    • Querying the Database
    • Running the Program
  • Practical MySQL
    • Creating a Table
    • Describing a Table
    • Dropping a Table
    • Adding Data
    • Retrieving Data
    • Updating Data
    • Deleting Data
    • Using AUTO_INCREMENT
      • Using insert IDs
    • Performing Additional Queries
  • Preventing Hacking Attempts
    • Steps You Can Take
    • Using Placeholders
    • Preventing JavaScript Injection into HTML
  • Questions
• 11. Form Handling
  • Building Forms
  • Retrieving Submitted Data
    • Default Values
    • Input Types
      • Text boxes
      • Text areas
      • Checkboxes
      • Labels
      • Radio buttons
      • Hidden fields
      • <select>
      • The submit button
      • The autocomplete attribute
      • The autofocus attribute
      • The placeholder attribute
      • The required attribute
      • Override attributes
      • The width and height attributes
      • The step attribute
      • The form attribute
      • The list attribute
      • The color input type
      • The min and max attributes
      • The number and range input types
      • Date and time pickers
    • Sanitizing Input
  • An Example Program
  • Questions
• 12. Cookies, Sessions, and Authentication
  • Using Cookies in PHP
    • Setting a Cookie
    • Accessing a Cookie
    • Destroying a Cookie
  • HTTP Authentication
    • Storing Usernames and Passwords
      • Using password_hash
      • Using password_verify
    • An Example Program
  • Using Sessions
    • Starting a Session
    • Ending a Session
    • Setting a Timeout
    • Session Security
      • Preventing session hijacking
      • Forcing cookie-only sessions
      • Preventing session fixation
      • Using a shared server
  • Questions
• 13. Exploring JavaScript
  • Outputting the Results
    • Using console.log
    • Using alert
    • Writing into Elements
    • Using document.write
  • JavaScript and HTML Text
    • Using Scripts Within a Document Head
    • Including JavaScript Files
    • Debugging JavaScript Errors
  • Using Comments
  • Semicolons
  • Variables
    • String Variables
    • Numeric Variables
    • Arrays
  • Operators
    • Arithmetic Operators
    • Assignment Operators
    • Comparison Operators
    • Logical Operators
    • Incrementing, Decrementing, and Shorthand Assignment
    • String Concatenation
    • Escape Characters
  • Variable Typing
  • Functions
  • Global Variables
  • Local Variables
    • Using let
    • Using const
  • The Document Object Model
    • Another Use for the $ Symbol
    • Using the DOM
  • Questions
• 14. Expressions and Control Flow in JavaScript
  • Expressions
  • Literals and Variables
  • Operators
    • Operator Precedence
    • Associativity
    • Relational Operators
      • Equality operators
      • Comparison operators
      • Truthy and falsy values
      • Logical operators
  • Using onerror
  • Using try...catch
  • Conditionals
    • The if Statement
    • The else Statement
    • The switch Statement
      • Breaking out
      • Default action
    • The ? Operator
  • Looping
    • while Loops
    • do...while Loops
    • for Loops
    • Breaking Out of a Loop
    • The continue Statement
  • Explicit Casting
  • Questions
• 15. JavaScript Functions, Objects, and Arrays
  • JavaScript Functions
    • Defining a Function
      • The rest parameter
      • The arguments array
    • Returning a Value
    • Returning an Array
  • JavaScript Objects
    • Declaring a Class
    • Creating an Instance
    • Accessing Objects
    • Static Methods and Properties
    • The Legacy Objects Simulated with Functions
  • JavaScript Arrays
    • Arrays
      • Assigning element values
      • Assignment using the array keyword
    • Associative Arrays
    • Multidimensional Arrays
    • Using Array Methods
      • some and every
      • includes
      • map
      • filter
      • indexOf
      • concat
      • forEach
      • join
      • push and pop
      • Using reverse
      • sort
  • Anonymous Functions
  • Arrow Functions
  • Questions
• 16. JavaScript and PHP Validation and Error Handling
  • Validating User Input with JavaScript
    • The validate.html Document (Part 1)
    • The validate.html Document (Part 2)
      • Validating the forename
      • Validating the surname
      • Validating the username
      • Validating the password
      • Validating the age
      • Validating the email
      • Using a separate JavaScript file
  • Regular Expressions
    • Matching Through Metacharacters
    • Wildcard Matching
    • Grouping Through Parentheses
    • Character Classes
    • Indicating a Range
    • Negation
    • Some More Complicated Examples
    • Summary of Metacharacters
    • General Modifiers
    • Using Regular Expressions in JavaScript
    • Using Regular Expressions in PHP
  • Redisplaying a Form After PHP Validation
  • Questions
• 17. Using Asynchronous Communication
  • The Fetch API
    • Your First Asynchronous Program
    • The Server Half of the Asynchronous Process
    • Cross-Origin Resource Sharing (CORS)
      • Origin
      • Same-origin and cross-origin requests
    • Using GET Instead of POST
    • Sending JSON Requests
  • Using XMLHttpRequest
  • Using Frameworks for Asynchronous Communication
  • Questions
• 18. Advanced CSS
  • Attribute Selectors
    • The ^= Operator
    • The $= Operator
    • The *= Operator
  • The box-sizing Property
  • CSS Backgrounds
    • The background-clip Property
    • The background-origin Property
    • The background-size Property
    • Using the auto Value
    • Multiple Backgrounds
  • CSS Borders
    • The border-color Property
    • The border-radius Property
  • Box Shadows
  • Element Overflow
  • Multicolumn Layout
  • Colors and Opacity
    • HSL Colors
    • HSLA Colors
    • RGB Colors
    • RGBA Colors
    • The opacity Property
  • Text Effects
    • The text-shadow Property
    • The text-overflow Property
    • The word-wrap Property
  • Web Fonts
  • Google Web Fonts
  • Transformations
  • Transitions
    • Properties to Transition
    • Transition Duration
    • Transition Delay
    • Transition Timing
    • Shorthand Syntax
  • Flexbox
    • Flex Items
    • Flow Direction
    • Justifying Content
    • Aligning Items
    • Aligning Content
    • Resizing Items
    • Flex Wrap
    • Order
    • Item Gaps
  • CSS Grid
    • Grid Container
    • Grid Columns and Rows
    • Grid Flow
    • Placing Grid Items
    • Grid Gaps
    • Alignment
  • Questions
• 19. Accessing CSS from JavaScript
  • Revisiting the getElementById Function
    • The byId Function
    • The style Function
    • The by Function
    • Including the Functions
  • Accessing CSS Properties from JavaScript
    • Some Common Properties
    • Other Properties
  • Inline JavaScript
    • The this Keyword
    • Attaching Events to Objects in a Script
    • Attaching to Other Events
  • Adding New Elements
    • Removing Elements
    • Alternatives to Adding and Removing Elements
  • Time-based Events
    • Using setTimeout
      • Passing an arrow function
      • Canceling a timeout
    • Using setInterval
      • Using the function
      • Canceling an interval
    • Using Time-Based Events for Animation
  • Questions
• 20. Introduction to React
  • What Is the Point of React Anyway?
  • Accessing the React Files
  • Including babel.js
  • Our First React Project
    • Using a Class Instead of a Function
    • Pure and Impure Code: A Golden Rule
    • Using Both a Class and a Function
    • Props and Components
    • The Differences Between Using a Class and a Function
  • React State and Life Cycle
  • Events in React
  • Inline JSX Conditional Statements
  • Using Lists and Keys
  • Unique Keys
  • Handling Forms
    • Using Text Input
    • Using textarea
    • Using select
  • React Native
  • Questions
• 21. Introduction to Node.js
  • Installing Node.js on Windows
  • Installing Node.js on macOS
  • Installing Node.js on Linux
  • Getting Started with Node.js
  • Building a Functioning Web Server
  • Working with Modules
    • Built-in Modules
    • Installing Modules with npm
    • Accessing MySQL
    • Further Information
  • Questions
• 22. Bringing It All Together
  • Designing a Social Networking App
  • Online Repository
  • functions.php
  • header.php
  • setup.php
  • index.php
  • signup.php
    • Checking for Username Availability
    • Logging In
  • checkuser.php
  • login.php
  • profile.php
    • Adding the About Me Text
    • Adding a Profile Image
    • Processing the Image
    • Displaying the Current Profile
  • members.php
    • Viewing a Users Profile
    • Adding and Dropping Friends
    • Listing All Members
  • friends.php
  • messages.php
  • logout.php
  • styles.css
  • javascript.js
  • Questions
• A. Solutions to the Chapter Questions
  • Chapter 1 Answers
  • Chapter 2 Answers
  • Chapter 3 Answers
  • Chapter 4 Answers
  • Chapter 5 Answers
  • Chapter 6 Answers
  • Chapter 7 Answers
  • Chapter 8 Answers
  • Chapter 9 Answers
  • Chapter 10 Answers
  • Chapter 11 Answers
  • Chapter 12 Answers
  • Chapter 13 Answers
  • Chapter 14 Answers
  • Chapter 15 Answers
  • Chapter 16 Answers
  • Chapter 17 Answers
  • Chapter 18 Answers
  • Chapter 19 Answers
  • Chapter 20 Answers
  • Chapter 21 Answers
  • Chapter 22 Answers
• Index

pokaż cały spis treści

ukryj recenzje