Cover Image

Learning PHP, MySQL and JavaScript : With JQuery, CSS and HTML5.

Bibliographic Details
Main Author: Nixon, Robin.
Format: eBook
Language:English
Published: Sebastopol : O'Reilly Media, Incorporated, 2018.
Edition:5th ed.
Subjects:
MySQL (Electronic resource).
PHP (Computer program language).
JavaScript (Computer program language).
Electronic books.
Online Access:View fulltext via EzAccess
Table of Contents:
  • Cover
  • Copyright
  • Table of Contents
  • Preface
  • Audience
  • Assumptions This Book Makes
  • Organization of This Book
  • Supporting Books
  • Conventions Used in This Book
  • Using Code Examples
  • O'Reilly Online Learning
  • How to Contact Us
  • Acknowledgments
  • Chapter 1. Introduction to Dynamic Web Content
  • HTTP and HTML: Berners-Lee's Basics
  • The Request/Response Procedure
  • The Benefits of PHP, MySQL, JavaScript, CSS, and HTML5
  • MariaDB: The MySQL Clone
  • Using PHP
  • Using MySQL
  • Using JavaScript
  • Using CSS
  • And Then There's HTML5
  • The Apache Web Server
  • Handling Mobile Devices
  • About Open Source
  • Bringing It All Together
  • Questions
  • Chapter 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
  • Accessing the Document Root (macOS)
  • Installing a LAMP on Linux
  • Working Remotely
  • Logging In
  • Using FTP
  • Using a Program Editor
  • Using an IDE
  • Questions
  • Chapter 3. Introduction to PHP
  • Incorporating PHP Within HTML
  • This Book's Examples
  • The Structure of PHP
  • Using Comments
  • Basic Syntax
  • Variables
  • Operators
  • Variable Assignment
  • Multiple-Line Commands
  • Variable Typing
  • Constants
  • Predefined Constants
  • The Difference Between the echo and print Commands
  • Functions
  • Variable Scope
  • Questions
  • Chapter 4. Expressions and Control Flow in PHP
  • Expressions
  • TRUE or FALSE?
  • Literals and Variables
  • Operators
  • Operator Precedence
  • Associativity
  • Relational Operators
  • Conditionals
  • The if Statement
  • The else Statement
  • The elseif Statement
  • The switch Statement
  • The ? Operator
  • Looping
  • while Loops
  • do...while Loops
  • for Loops
  • Breaking Out of a Loop
  • The continue Statement.
  • Implicit and Explicit Casting
  • PHP Dynamic Linking
  • Dynamic Linking in Action
  • Questions
  • Chapter 5. PHP Functions and Objects
  • PHP Functions
  • Defining a Function
  • Returning a Value
  • Returning an Array
  • Passing Arguments by Reference
  • 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
  • Declaring Constants
  • Property and Method Scope
  • Static Methods
  • Static Properties
  • Inheritance
  • Questions
  • Chapter 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
  • extract
  • compact
  • reset
  • end
  • Questions
  • Chapter 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
  • System Calls
  • XHTML or HTML5?
  • Questions
  • Chapter 8. Introduction to MySQL
  • MySQL Basics
  • Summary of Database Terms
  • Accessing MySQL via the Command Line
  • Starting the Command-Line Interface
  • Using the Command-Line Interface
  • MySQL Commands
  • Data Types
  • Indexes
  • Creating an Index
  • Querying a MySQL Database
  • Joining Tables Together
  • Using Logical Operators.
  • MySQL Functions
  • Accessing MySQL via phpMyAdmin
  • Questions
  • Chapter 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 Anonymity
  • Transactions
  • Transaction Storage Engines
  • Using BEGIN
  • Using COMMIT
  • Using ROLLBACK
  • Using EXPLAIN
  • Backing Up and Restoring
  • Using mysqldump
  • Creating a Backup File
  • Restoring from a Backup File
  • Dumping Data in CSV Format
  • Planning Your Backups
  • Questions
  • Chapter 10. Accessing MySQL Using PHP
  • Querying a MySQL Database with PHP
  • The Process
  • Creating a Login File
  • Connecting to a MySQL Database
  • 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
  • Performing Additional Queries
  • Preventing Hacking Attempts
  • Steps You Can Take
  • Using Placeholders
  • Preventing HTML Injection
  • Using mysqli Procedurally
  • Questions
  • Chapter 11. Form Handling
  • Building Forms
  • Retrieving Submitted Data
  • Default Values
  • Input Types
  • Sanitizing Input
  • An Example Program
  • HTML5 Enhancements
  • The autocomplete Attribute
  • The autofocus Attribute
  • The placeholder Attribute
  • The required Attribute
  • Override Attributes
  • The width and height Attributes
  • The min and max Attributes
  • The step Attribute
  • The form Attribute
  • The list Attribute
  • The color Input Type
  • The number and range Input Types
  • Date and Time Pickers
  • Questions
  • Chapter 12. Cookies, Sessions, and Authentication.
  • Using Cookies in PHP
  • Setting a Cookie
  • Accessing a Cookie
  • Destroying a Cookie
  • HTTP Authentication
  • Storing Usernames and Passwords
  • An Example Program
  • Using Sessions
  • Starting a Session
  • Ending a Session
  • Setting a Timeout
  • Session Security
  • Questions
  • Chapter 13. Exploring JavaScript
  • JavaScript and HTML Text
  • Using Scripts Within a Document Head
  • Older and Nonstandard Browsers
  • 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
  • The Document Object Model
  • Another Use for the Symbol
  • Using the DOM
  • About document.write
  • Using console.log
  • Using alert
  • Writing into Elements
  • Using document.write
  • Questions
  • Chapter 14. Expressions and Control Flow in JavaScript
  • Expressions
  • Literals and Variables
  • Operators
  • Operator Precedence
  • Associativity
  • Relational Operators
  • The with Statement
  • Using onerror
  • Using try...catch
  • Conditionals
  • The if Statement
  • The else Statement
  • The switch Statement
  • The ? Operator
  • Looping
  • while Loops
  • do...while Loops
  • for Loops
  • Breaking Out of a Loop
  • The continue Statement
  • Explicit Casting
  • Questions
  • Chapter 15. JavaScript Functions, Objects, and Arrays
  • JavaScript Functions
  • Defining a Function
  • Returning a Value
  • Returning an Array
  • JavaScript Objects
  • Declaring a Class
  • Creating an Object
  • Accessing Objects
  • The prototype Keyword
  • JavaScript Arrays
  • Numeric Arrays
  • Associative Arrays
  • Multidimensional Arrays.
  • Using Array Methods
  • Questions
  • Chapter 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)
  • Regular Expressions
  • Matching Through Metacharacters
  • Fuzzy Character 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
  • Chapter 17. Using Asynchronous Communication
  • What Is Asynchronous Communication?
  • Using XMLHttpRequest
  • Your First Asynchronous Program
  • Using GET Instead of POST
  • Sending XML Requests
  • Using Frameworks for Asynchronous Communication
  • Questions
  • Chapter 18. Introduction to CSS
  • Importing a Stylesheet
  • Importing CSS from Within HTML
  • Embedded Style Settings
  • Using IDs
  • Using Classes
  • Using Semicolons
  • CSS Rules
  • Multiple Assignments
  • Using Comments
  • Style Types
  • Default Styles
  • User Styles
  • External Stylesheets
  • Internal Styles
  • Inline Styles
  • CSS Selectors
  • The Type Selector
  • The Descendant Selector
  • The Child Selector
  • The ID Selector
  • The Class Selector
  • The Attribute Selector
  • The Universal Selector
  • Selecting by Group
  • The CSS Cascade
  • Stylesheet Creators
  • Stylesheet Methods
  • Stylesheet Selectors
  • The Difference Between div and span Elements
  • Measurements
  • Fonts and Typography
  • font-family
  • font-style
  • font-size
  • font-weight
  • Managing Text Styles
  • Decoration
  • Spacing
  • Alignment
  • Transformation
  • Indenting
  • CSS Colors
  • Short Color Strings
  • Gradients
  • Positioning Elements
  • Absolute Positioning
  • Relative Positioning
  • Fixed Positioning.
  • Pseudoclasses.

Similar Items