Index

Symbols

! (Not) logical operator
- in JavaScript, Logical Operators, Logical operators
- in PHP, Logical operators, Operator Precedence, Logical operators
!= (inequality) operator
- in JavaScript, Comparison Operators
- in PHP, Comparison operators, Operator Precedence
!== (not identical) operator
- in JavaScript, Comparison Operators
- in PHP, Comparison operators, Operator Precedence
" (quotation marks, double)
- escaping in JavaScript, Escape Characters
- in JavaScript strings, String Variables
- in PHP heredocs, Multiple-Line Commands
- in PHP multi-line commands, Multiple-Line Commands
- in PHP strings, String types
$ () function
- in JavaScript, Another Use for the $ Symbol
- in jQuery, The css Method
$ (dollar) symbol
- in JavaScript, Another Use for the $ Symbol
- in jQuery, jQuery Syntax-Avoiding Library Conflicts
- in PHP, The $ symbol, Constants, Accessing Objects
$.each method, The $.each Method
$.map method, The $.map Method
$= (attribute selector) operator, The $= operator
$GLOBALS variable, Superglobal variables
$this variable (PHP), Writing Methods
$_POST arrays, The $_POST Array
% (modulus) operator
- in JavaScript, Arithmetic Operators, Operator Precedence
- in PHP, Arithmetic operators, Operator Precedence
%= (modulus and assignment) operator
- in JavaScript, Assignment Operators
- in PHP, Assignment operators
& (ampersand), prefacing PHP variables, Passing Arguments by Reference
& (And) bitwise operator
- in JavaScript, Operator Precedence
- in PHP, Associativity
&& (And) logical operator
- in JavaScript, Logical Operators, Logical operators
- in PHP, Logical operators, Operator Precedence, Logical operators
&= (bitwise AND and assignment) operator
- in JavaScript, Operator Precedence
- in PHP, Associativity
' (quotation marks, single)
- escaping in JavaScript, Escape Characters
- in JavaScript strings, String Variables
- in PHP heredocs, Multiple-Line Commands
- in PHP strings, String types
() (parentheses)
- casting operators in PHP, Implicit and Explicit Casting
- in functions in PHP, PHP Functions
- in regular expressions, Grouping Through Parentheses
- operator precedence and, Operator Precedence
* (asterisk)
- in MySQL, SELECT
- in regular expressions, Matching Through Metacharacters
- showing instead of password, Logging In, login.php
- wildcard/universal selector in CSS, The Universal Selector
* (multiplication) operator
- in JavaScript, Arithmetic Operators
- in PHP, Arithmetic operators, Operator Precedence
** (exponentiation) operator, in PHP, Arithmetic operators
*/ character, Using Comments
*= (attribute selector) operator, The *= operator
*= (multiplication and assignment) operator
- in JavaScript, Assignment Operators
- in PHP, Assignment operators
+ (addition) operator
- in JavaScript, Arithmetic Operators
- in PHP, Arithmetic operators, Operator Precedence
+ (string concatenation) operator in JavaScript, String Concatenation
++ (increment) operator
- in JavaScript, Incrementing, Decrementing, and Shorthand Assignment
- in PHP, Arithmetic operators, Operator Precedence
+= (addition and assignment) operator
- in JavaScript, Assignment Operators
- in jQuery, Animations
- in PHP, Assignment operators
, (comma)
- in JavaScript, for Loops
- in PHP, for Loops
- (hyphen), in regular expressions, Indicating a Range
- (minus sign)
- unary operator in JavaScript, Operator Precedence
- unary operator in PHP, Associativity
- (subtraction) operator
- in JavaScript, Arithmetic Operators
- in PHP, Arithmetic operators, Operator Precedence, Associativity
-- (decrement) operator
- in JavaScript, Incrementing, Decrementing, and Shorthand Assignment
- in PHP, Arithmetic operators, Operator Precedence
-= (subtraction and assignment) operator
- in JavaScript, Assignment Operators
- in jQuery, Animations
- in PHP, Assignment operators
-> operator, Writing Methods, Connecting to a MySQL Database
. (dot)
- in regular expressions, Fuzzy Character Matching
- prefacing CSS class statements, Using Classes
... (ellipsis), indicating truncated text, The text-overflow Property
.= (concatenation assignment) operator (PHP), Assignment operators, String concatenation, Operator Precedence
/ (division) operator
- in JavaScript, Arithmetic Operators
- in PHP, Assignment operators, Operator Precedence
/ (forward slash)
- /* and */ in multiline comments, Using Comments
- /**/ in CSS comments, Using Comments
- // in JavaScript comments, Older and Nonstandard Browsers
- in regular expressions, Matching Through Metacharacters
/* character, Using Comments
/= (division and assignment) operator
- in JavaScript, Assignment Operators
- in PHP, Arithmetic operators, Operator Precedence
3D transformations, 3D Transformations
: (colon) character
- in CSS, CSS Rules
- in PHP, TRUE or FALSE?
:: (scope resolution) operator, Static Methods
; (semicolons)
- in CSS, Using Semicolons
- in JavaScript, JavaScript and HTML Text, Semicolons
- in MySQL, The semicolon
- in PHP, Semicolons, for Loops
< (less than) operator
- in JavaScript, Comparison Operators, Comparison operators
- in PHP, Comparison operators, Operator Precedence, Comparison operators
<< (bitwise left shift) operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
<<< (heredoc) operator (PHP), Multiple-Line Commands
<<= (bitwise left shift and assignment) operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
<= (less than or equal to) operator
- in JavaScript, Comparison Operators, Comparison operators
- in PHP, Comparison operators, Operator Precedence, Comparison operators
<> (not equal) operator (PHP), Comparison operators, Operator Precedence
<?php?> tag, Incorporating PHP Within HTML
= (assignment) operator
- in JavaScript, Assignment Operators
- in PHP, Assignment operators
- not confusing with == operator, Comparison operators, Equality
== (equality) operator
- in JavaScript, Comparison Operators, Equality operators
- in PHP, Comparison operators, Operator Precedence, Equality, HTTP Authentication
- not confusing with = operator, Comparison operators
=== (identity) operator
- in JavaScript, Comparison Operators, Equality operators
- in PHP, Comparison operators, Operator Precedence, HTTP Authentication
=> operator (PHP), assigning value to array index, Assignment Using the array Keyword
> (greater than) operator
- in JavaScript, Comparison Operators, Comparison operators
- in PHP, Comparison operators, Operator Precedence, Comparison operators
>= (greater than or equal to) operator
- in JavaScript, Comparison Operators, Comparison operators
- in PHP, Comparison operators, Operator Precedence, Comparison operators
>> (bitwise right shift) operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
>>= (bitwise right shift and assignment) operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
>>>= (zero-fill right shift) bitwise operator in JavaScript, Associativity
? operator (PHP), The ? Operator
?: (ternary) operator
- in JavaScript, The ? Operator
- in PHP, Operators, Operator Precedence, The ? Operator
@ (error control) operator (PHP), Associativity
[] (square brackets)
- accessing array elements, Multidimensional Arrays, Multidimensional Arrays
- in fuzzy matching, Character Classes
- in PHP function definitions, Defining a Function
- in regular expressions, Character Classes
- negation of character class with, Negation
- precedence in JavaScript, Operator Precedence
\ (backslash)
- in JavaScript strings, Escape Characters
- in PHP strings, Escaping characters
- in regular expressions, Fuzzy Character Matching
\c (cancel in MySQL), Canceling a command
\n (newline) character, Escaping characters, Escape Characters
\r (carriage return) character, Escaping characters, Escape Characters
\t (tab) character, Escaping characters, Multidimensional Arrays, Escape Characters
^ (bitwise xor) operator
- in JavaScript, Operators
- in PHP, Operator Precedence
^ (caret), in regular expressions, Negation
^= (attribute selector) operator, The ^= operator
^= (bitwise XOR and assignment) operator
- in JavaScript, Associativity
- in PHP, Operator Precedence
__ (double underscore), Predefined Constants, Writing Methods
{ } (curly braces)
- in for loops in PHP, for Loops
- in functions in PHP, Defining a Function
- in if statements in PHP, The if Statement
- in while statements in PHP, while Loops
| (Or) bitwise operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
|= (bitwise OR and assignment) operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
|| (Or) logical operator
- in JavaScript, Logical Operators, Logical operators
- in PHP, Logical operators, Operator Precedence, Logical operators

A

AAC (Advanced Audio Encoding), About Codecs
acknowledgments, Acknowledgments
ActiveX technology, What Is Asynchronous Communication?
addColorStop method (HTML5), The addColorStop Method in Detail
addition (+) operator
- in JavaScript, Arithmetic Operators
- in PHP, Arithmetic operators, Operator Precedence
advisory locks, Locking Files for Multiple Accesses
after method (jQuery), Adding and Removing Elements
Ajax (Asynchronous JavaScript and XML), Using Asynchronous Communication (see also asynchronous communication)
alert function (JavaScript), Using alert
alignment, of text, Managing Text Styles
ALTER command (MySQL), The AUTO_INCREMENT attribute-Creating a FULLTEXT index
- adding new columns, Adding a new column
- changing column data types, Changing the data type of a column
- overview of, The AUTO_INCREMENT attribute
- removing columns, Removing a column
- renaming columns, Renaming a column
- renaming tables, Renaming a table
AMPPS server
- alternatives to, Alternative WAMPs
- documentation, Installing AMPPS on Windows
- evolution of, Alternative WAMPs
- macOS installation, Installing AMPPS on macOS-Accessing the Document Root (macOS)
- MySQL access, Windows users-Linux users
- PHP version selection, Installing AMPPS on Windows, Installing AMPPS on macOS, PHP Functions and Objects
- Windows installation, Installing AMPPS on Windows-Accessing the Document Root (Windows)
ancestor elements, selecting all, Selecting all ancestor elements
And (&&) logical operator
- in JavaScript, Logical Operators, Logical operators
- in PHP, Logical operators, Operator Precedence, Logical operators
and (low-precedence) logical operator (PHP), Logical operators, Operator Precedence
animation
- using interrupts for, Using Interrupts for Animation-Using Interrupts for Animation
- using jQuery, Animations-Stopping Animations
Apache web server
- benefits of, The Apache Web Server
- documentation, Session Security
- in WAMPs, MAMPs, and LAMPs, What Is a WAMP, MAMP, or LAMP?
arc method (HTML5), The arc Method
arcTo method (HTML5), The arcTo Method
arguments array, in JavaScript, The arguments array
arguments, in PHP, PHP Functions, Passing Arguments by Reference
arithmetic operators
- in JavaScript, Arithmetic Operators
- in PHP, Arithmetic operators, Operators, Operator Precedence
Array keyword (JavaScript), Assignment using the array keyword
array keyword (PHP), Assignment Using the array Keyword
arrays (JavaScript)
- array methods, Using Array Methods
- assigning values to, Arrays
- associative, Associative Arrays
- multidimensional, Multidimensional Arrays
- numeric, Numeric Arrays
- returning arrays with functions, Returning an Array
arrays (PHP)
- array functions, Using Array Functions-end
- assignment using array keyword, Assignment Using the array Keyword
- associative, Associative Arrays
- basics of, Arrays
- benefits of, PHP Arrays
- foreach...as loops, The foreach...as Loop
- multidimensional, Multidimensional Arrays
- numerically indexed, Numerically Indexed Arrays
- returning values from functions in, Returning an Array
- two-dimensional, Two-dimensional arrays
array_combine function (PHP), PHP Version Compatibility
AS keyword (MySQL), Using AS
assignment
- array element values in JavaScript, Assigning element values
- multiline string assignment in PHP, Multiple-Line Commands
- multiple-assignment statements, Associativity
- setting variable type by in JavaScript, Assignment Operators
- shorthand assignment of CSS properties, Shorthand Rules
- string variables in JavaScript, String Variables
- using Array keyword in JavaScript, Assignment using the array keyword
- using array keyword in PHP, Assignment Using the array Keyword
assignment operators
- in JavaScript, Assignment Operators
- in PHP, Assignment operators, Operators, Operator Precedence, Equality
associative arrays
- in JavaScript, Associative Arrays
- in PHP, Associative Arrays
associativity, Associativity, Associativity
asterisk (*)
- in MySQL, SELECT
- in regular expressions, Matching Through Metacharacters
- showing instead of password, Logging In, login.php
- wildcard/universal selector in CSS, The Universal Selector
asynchronous communication
- Ajax and, Using Asynchronous Communication
- benefits of, Using JavaScript
- defined, What Is Asynchronous Communication?
- Google Maps example, Using Asynchronous Communication
- implementation with XMLHttpRequest, Using XMLHttpRequest-Using Frameworks for Asynchronous Communication
- jQuery and, Using Asynchronous Communication
- libraries facilitating, Introduction to jQuery
- online resources, Asynchronous Communication Resource Sites
- role of modern technology in, Bringing It All Together
Atom feeds, Date Constants
attr method (jQuery), The val and attr Methods
attribute selectors (CSS), The Attribute Selector, Attribute Selectors
audio (HTML5)
- <audio> element, The <audio> Element
- codecs (encoders/decoders), About Codecs
- history of delivery formats, HTML5 Audio and Video
- supporting non-HTML5 browsers, Supporting Non-HTML5 Browsers
authentication (HTTP), HTTP Authentication-An Example Program
autocomplete attribute, The autocomplete Attribute
autofocus attribute, The autofocus Attribute
AUTO_INCREMENT data type (MySQL), The AUTO_INCREMENT attribute, Using AUTO_INCREMENT

B

backgrounds (see under CSS; CSS3)
backslash (\)
- in JavaScript strings, Escape Characters
- in PHP strings, Escaping characters
- in regular expressions, Fuzzy Character Matching
BCRYPT algorithm, Using password_hash, An Example Program
BEGIN statement (MySQL), Using BEGIN
Berners-Lee, Tim, Introduction to Dynamic Web Content
bezierCurveTo method (HTML5), The bezierCurveTo Method
BINARY data type (MySQL), The BINARY data type
binary operators, Operators
bitwise left shift (<<) operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
bitwise left shift and assignment (<<=) operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
bitwise operators
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
bitwise OR and assignment (|=) operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
bitwise right shift (>>) operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
bitwise xor (^) operator
- in JavaScript, Operators
- in PHP, Operator Precedence
bitwise XOR and assignment (^=) operator
- in JavaScript, Associativity
- in PHP, Operator Precedence
BLOB data types (MySQL), The BLOB data types
Boolean expressions
- in JavaScript, Expressions
- in PHP, TRUE or FALSE?
Boolean operators, Logical operators
Boolean values, Expressions, Relational Operators
borders, applying using CSS
- adjusting padding, Adjusting Padding
- box model and layout, The Box Model and Layout
- box-sizing property and, The box-sizing Property
- CSS3 backgrounds and, CSS3 Backgrounds-Multiple Backgrounds
- CSS3 borders, CSS3 Borders-The border-radius Property
- <div> vs. <span> elements, The Difference Between div and span Elements
- properties controlling, Applying Borders
- shorthand rule for, Shorthand Rules
- using universal selector, The Universal Selector
box model (CSS)
- adjusting padding, Adjusting Padding
- applying borders, Applying Borders
- setting margins, Setting Margins
break command
- in JavaScript looping, Breaking Out of a Loop
- in PHP looping, Breaking Out of a Loop
- in PHP switch statements, Breaking out
browsers
- audio types supported by, About Codecs
- common HTML tags in use, Other HTML5 Tags
- cross-browser compatibility, Why jQuery?
- debugging JavaScript errors, Debugging JavaScript Errors
- support for HTML5, Introduction to HTML5
- supporting older/nonstandard, Older and Nonstandard Browsers, Supporting Non-HTML5 Browsers, Supporting Older Browsers
- video types supported by, The Video Codecs
- window properties in CSS, Other Properties-Other Properties
bumpyCaps/bumpyCase, Defining a Function
<button> element, The autofocus Attribute

C

C++ Redistributable Visual Studio, Installing AMPPS on Windows
call-time pass-by-reference, Passing Arguments by Reference
callback functions
- animation using, Using callbacks
- defined, The readyState property
camelCase, Defining a Function
canvas (HTML5)
- benefits of, The Canvas
- clip method, The clip Method
- creating and accessing, Creating and Accessing a Canvas-Using Patterns for Fills
- drawing lines, Drawing Lines-The miterLimit Property
- editing at pixel level, Editing at the Pixel Level-The createImageData Method
- filing areas, Filling Areas
- graphical effects, Advanced Graphical Effects-The globalAlpha Property
- isPointInPath method, The isPointInPath Method
- manipulating images, Manipulating Images-Editing at the Pixel Level
- transformations, Transformations-The setTransform Method
- using paths, Using Paths-The rect Method
- working with curves, Working with Curves-The bezierCurveTo Method
- writing text to, Writing Text to the Canvas-The measureText Method
caret (^), in regular expressions, Negation
carriage return (\r) character, Escaping characters, Escape Characters
Cascading Style Sheets (see CSS (Cascading Style Sheets))
case command
- in JavaScript, The switch Statement
- in PHP, The switch Statement
casting
- explicit in JavaScript, Explicit Casting
- implicit/explicit in PHP, Implicit and Explicit Casting
- operators in PHP, Associativity
CDNs (content delivery networks), Including jQuery
CHANGE keyword (MySQL), Renaming a column
CHAR data type (MySQL), Data Types
character sets, Data Types
charAt method (JavaScript), Returning a Value
checkboxes, Checkboxes-Checkboxes
checkdate function (PHP), Using checkdate
child elements, accessing, Child Elements
class keyword (PHP), Declaring a Class
__CLASS__ constant, Predefined Constants
classes
- dynamic application of in jQuery, Dynamically Applying Classes
- in JavaScript, Declaring a Class
- in PHP, Terminology-Declaring a Class
clearInterval function (JavaScript), Using Interrupts
clearQue method (jQuery), Stopping Animations
clearRect method (HTML5), The clearRect Method
clients
- request/response procedure, The Request/Response Procedure-The Request/Response Procedure
- role in internet communications, HTTP and HTML: Berners-Lee’s Basics
clone operator, Cloning Objects
code examples, obtaining and using, Using PHP, This Book’s Examples, String variables, Including the Functions, On the Website
codecs (encoders/decoders)
- purpose of, About Codecs
- supported by <audio> tag, About Codecs
- supported by <video> tag, The Video Codecs
colon (:) character
- in CSS, CSS Rules
- in PHP, TRUE or FALSE?
color input type, The color Input Type
colors
- in CSS, CSS Colors-Gradients
- in CSS3, Colors and Opacity
- in forms, The autocomplete Attribute, The color Input Type
- in HTML, Using printf, Using sprintf
columns
- defined, MySQL Basics, MySQL Basics
- working with in MySQL, Changing the data type of a column-Removing a column
comma (,)
- in JavaScript, for Loops
- in PHP, for Loops
commands
- in MySQL, The semicolon-Creating a table
- multiple-line (PHP), Multiple-Line Commands-Multiple-Line Commands
comments
- in CSS, Using Comments
- in JavaScript, Using Comments
- in PHP, Using Comments
COMMIT command (MySQL), Using COMMIT
Common Gateway Interface (CGI), The Benefits of PHP, MySQL, JavaScript, CSS, and HTML5
compact function (PHP), compact
companion website, This Book’s Examples
comparison operators
- in JavaScript, Comparison Operators, Comparison operators
- in PHP, Comparison operators, Operators, Operator Precedence, Comparison operators
concat method (JavaScript), concat
concatenation, String concatenation, String Concatenation
conditionals (JavaScript)
- ? operator, The ? Operator
- else statements, The else Statement
- if statements, Conditionals
- switch statements, The switch Statement
conditionals (PHP)
- ? operator, The ? Operator
- else statements, The else Statement
- elseif statements, The elseif Statement
- if statements, The if Statement
- switch statements, The switch Statement-Alternative syntax
console.log function (JavaScript), Using console.log
constants (PHP), Constants-Predefined Constants, TRUE or FALSE?, Declaring Constants, Date Constants
constructors
- in JavaScript, Declaring a Class
- in PHP, Constructors, Subclass constructors
content types, Using $_FILES
continue statements
- in JavaScript, The continue Statement
- in PHP, The continue Statement
control flow (see flow control)
$_COOKIE variable, Superglobal variables, Accessing a Cookie
cookies
- accessing, Accessing a Cookie
- alerting users to, Using Sessions
- date constants in PHP, Date Constants
- defined, Using Cookies in PHP
- destroying, Destroying a Cookie
- vs. local storage, Local Storage
- request/response procedure, Using Cookies in PHP
- requiring, Forcing cookie-only sessions
- setting in PHP, Setting a Cookie
- third-party cookies, Using Cookies in PHP
copy function (PHP), Copying Files
count function (PHP), count
COUNT parameter (MySQL), SELECT COUNT
CREATE INDEX command (MySQL), Using CREATE INDEX
createImageData method (HTML5), The createImageData Method
createLinearGradient method (HTML5), The createLinearGradient Method
createRadialGradient method (HTML5), The createRadialGradient Method
cross-document messaging, Cross-Document Messaging-Cross-Document Messaging
cross-site scripting, Fetching a result, Preventing HTML Injection
CSS (Cascading Style Sheets) (see also CSS3)
- benefits of, The Benefits of PHP, MySQL, JavaScript, CSS, and HTML5-Using CSS, Introduction to CSS
- box model and layout using, The Box Model and Layout-Object Contents
- browser compatibility and, Advanced CSS with CSS3
- cascade precedence, The CSS Cascade-Some rules are more equal than others
- classes, Using Classes
- comments in, Using Comments
- CSS rules, CSS Rules-Using Comments
- CSS selectors, CSS Selectors-Selecting by Group
- <div> vs. <span> elements, The Difference Between div and span Elements
- element IDs, Using IDs
- fonts and typography supported by, Fonts and Typography-font-weight
- importing stylesheets, Importing a Stylesheet
- JavaScript access to CSS properties, Accessing CSS Properties from JavaScript-Using Interrupts for Animation
- managing colors and gradients, CSS Colors-Gradients
- managing text styles, Managing Text Styles-Indenting
- measurements supported by, Measurements
- online resources, CSS Resource Sites
- positioning elements with, Positioning Elements-Fixed Positioning
- pseudoclasses and, Pseudoclasses-Pseudoclasses
- purpose of, Introduction to CSS
- semicolons in, Using Semicolons
- shorthand rules, Shorthand Rules
- social networking app example, styles.css-javascript.js
- style types, Style Types-Inline Styles
- versions of, Advanced CSS with CSS3
CSS3
- attribute selectors, Attribute Selectors
- background properties, CSS3 Backgrounds-Multiple Backgrounds
- border properties, CSS3 Borders-The border-radius Property
- box shadow effect, Box Shadows
- box-sizing property, The box-sizing Property
- browser compatibility and, Advanced CSS with CSS3
- colors and opacity, Colors and Opacity-The opacity Property
- element overflow declarations, Element Overflow
- history of, Advanced CSS with CSS3
- vs. JavaScript, Advanced CSS with CSS3
- multicolumn layout, Multicolumn Layout-Multicolumn Layout
- text effects, Text Effects-The word-wrap Property
- transformations, Transformations-3D Transformations
- transitions, Transitions-Shorthand Syntax
- web fonts, Web Fonts-Google Web Fonts
CSV format, dumping data in, Dumping Data in CSV Format
curly braces ({ })
- in for loops in PHP, for Loops
- in functions in PHP, Defining a Function
- in if statements in PHP, The if Statement
- in while statements in PHP, while Loops
currency conversion, Precision Setting
curves, working with on canvas, Working with Curves-The bezierCurveTo Method

D

data types (MySQL)
- AUTO_INCREMENT data type, The AUTO_INCREMENT attribute
- BINARY, The BINARY data type
- BLOB, The BLOB data types
- CHAR, Data Types
- DATE and TIME, DATE and TIME types
- numeric, Numeric data types
- TEXT data types, The TEXT data types
- VARCHAR, Data Types
database queries (see also MySQL; databases)
- AUTO_INCREMENT, Using AUTO_INCREMENT
- building/executing, Building and executing a query
- closing connections, Closing a connection
- example of, A Practical Example-Running the Program
- fetching results, Fetching a result
- fetching rows, Fetching a row
- hacking prevention, Preventing Hacking Attempts-Using mysqli Procedurally
- login file creation, Creating a Login File
- MySQL database connection, Connecting to a MySQL Database-Closing a connection
- mysqli procedural use, Using mysqli Procedurally-Using mysqli Procedurally
- process of, Querying a MySQL Database with PHP
- secondary queries, Performing Additional Queries
- table creation, Creating a Table
- tables, adding data to, Adding Data
- tables, deleting data in, Deleting Data
- tables, describing, Describing a Table
- tables, dropping, Dropping a Table
- tables, retrieving data from, Retrieving Data
- tables, updating data in, Updating Data
databases (see also MySQL; database queries)
- anonymity and, Databases and Anonymity
- backup and restore for, Backing Up and Restoring-Planning Your Backups
- defined, MySQL Basics
- design considerations, Database Design
- normalization process, Normalization-When Not to Use Normalization
- primary keys in, Primary Keys: The Keys to Relational Databases
- relationships in, Relationships-Databases and Anonymity
- terminology surrounding, Summary of Database Terms
- transactions in, Transactions-Using EXPLAIN
DATE and TIME data types (MySQL), DATE and TIME types
date and time functions (PHP)
- checkdate function, Using checkdate
- date constants, Date Constants
- date function, Date and Time Functions
- date function format specifiers, Date and Time Functions
- determining current timestamp, Date and Time Functions
date functions (MySQL)
- CURDATE(), Date Functions
- DATE(expr), Date Functions
- DATE_ADD(date, INTERVAL expr unit), Date Functions
- DATE_FORMAT(date, format), Date Functions
- DATE_SUB, Date Functions
- DAY(date), Date Functions
- DAYNAME(date), Date Functions
- DAYOFWEEK(date), Date Functions
- DAYOFYEAR(date), Date Functions
- expected epr values, Date Functions
- LAST_DAY(date), Date Functions
- MAKEDATE(year, dayofyear), Date Functions
- MONTH(date), Date Functions
- MONTHNAME(date), Date Functions
- SYSDATE(), Date Functions
- WEEK(date [, mode]), Date Functions
- WEEKDAY(date), Date Functions
- YEAR(date), Date Functions
date pickers, in forms, Date and Time Pickers
DateTime class (PHP), Date and Time Functions
debugging
- JavaScript errors, Debugging JavaScript Errors
- PHP magic constants, Predefined Constants
decrement (--) operator
- in JavaScript, Incrementing, Decrementing, and Shorthand Assignment
- in PHP, Arithmetic operators, Operator Precedence
define function (PHP), Constants, Declaring Constants
DELETE command (MySQL), DELETE
derived classes, Terminology
DESC keyword (MySQL), ORDER BY
DESCRIBE command (MySQL), Creating a table, Adding a new column, Creating an Index
destructors (PHP), Destructors
development server setup
- AMPPS installation on macOS, Installing AMPPS on macOS-Accessing the Document Root (macOS)
- AMPPS installation on Windows, Installing AMPPS on Windows-Accessing the Document Root (Windows)
- bundled programming packages, What Is a WAMP, MAMP, or LAMP?
- IDEs (integrated development environments), Using an IDE
- program editors, Using a Program Editor
- recommended browsers, Setting Up a Development Server
- remote access, Working Remotely-Using FTP, MySQL on a remote server
- role of development servers, Setting Up a Development Server
die function (PHP), Creating a File, Connecting to a MySQL Database, HTTP Authentication
different_user function (PHP), Preventing session hijacking
__DIR__ constant, Predefined Constants
DISTINCT parameter (MySQL), SELECT DISTINCT
division (/) operator
- in JavaScript, Arithmetic Operators
- in PHP, Arithmetic operators, Operator Precedence
do...while loops
- in JavaScript, do...while Loops
- in PHP, do...while Loops
DOCTYPE declaration, Introduction to CSS
document root
- accessing AMPPS on macOS, Accessing the Document Root (macOS)
- accessing AMPPS on Windows, Accessing the Document Root (Windows)
document.write function (JavaScript), JavaScript and HTML Text, About document.write
dollar symbol ($)
- in JavaScript, Another Use for the $ Symbol
- in PHP, The $ symbol, Constants, Accessing Objects
DOM (Document Object Model) (see also CSS (Cascading Style Sheets))
- adding elements to, Adding New Elements, Adding and Removing Elements
- alternatives to adding/removing elements from, Alternatives to Adding and Removing Elements
- JavaScript access to CSS properties, Accessing CSS Properties from JavaScript-Using Interrupts for Animation
- JavaScript and, The Document Object Model-Using the DOM
- manipulating with jQuery, Manipulating the DOM-Adding and Removing Elements
- removing elements from, Removing Elements, Adding and Removing Elements
- traversing with jQuery, DOM Traversal-Using jQuery Without Selectors
- XML documents and, About XML-Why use XML?
dot (.)
- in regular expressions, Fuzzy Character Matching
- prefacing CSS class statements, Using Classes
drag and drop feature, Drag and Drop
drawImage method (HTML5), The drawImage Method, Selecting an Image Area
DROP keyword (MySQL), Removing a column
drop-down lists, <select>
dynamic linking (PHP), PHP Dynamic Linking-Dynamic Linking in Action
dynamic web design
- Apache web server and, The Apache Web Server
- asynchronous communication, Bringing It All Together
- basic web operations, HTTP and HTML: Berners-Lee’s Basics
- benefits of modern technologies, The Benefits of PHP, MySQL, JavaScript, CSS, and HTML5-Using CSS
- early history, Introduction to Dynamic Web Content
- HTML5 and, And Then There’s HTML5
- open source technologies and, About Open Source
- request/response procedure, The Request/Response Procedure-The Request/Response Procedure
- responsive design, Handling Mobile Devices

E

each function (PHP), The foreach...as Loop
ease functions (CSS), Transition Timing
echo statements (PHP)
- in arrays, Multidimensional Arrays
- vs. print command, The Difference Between the echo and print Commands
- using operators, Variable incrementing and decrementing
editors, Accessing the Document Root (Windows), Accessing the Document Root (macOS), Using a Program Editor
Editra, Using a Program Editor
element overflow declarations, Element Overflow
ellipsis (...), indicating truncated text, The text-overflow Property
else statements
- in JavaScript, The else Statement
- in PHP, The else Statement
elseif statements (PHP), The elseif Statement
email addresses, validating on forms, Validating the email
encapsulation, Terminology
end function (PHP), end
_END..._END tags (PHP), Multiple-Line Commands
end-of-page scripts, Waiting Until the Document Is Ready
endswitch command (PHP), Alternative syntax
$_ENV variable, Superglobal variables
equality (==) operator
- in JavaScript, Comparison Operators, Equality operators
- in PHP, Comparison operators, Operator Precedence, Equality, HTTP Authentication
error control (@) operator (PHP), Associativity
error handling
- JavaScript errors, Debugging JavaScript Errors
- parse error messages in PHP, Semicolons
escape characters
- in JavaScript, Escape Characters
- in PHP, Escaping characters, Steps You Can Take
escapeshellcmd function (PHP), System Calls
event functions and properties (jQuery)
- blur and focus, The blur and focus Events
- click and dblclick, The click and dblclick Events
- documentation, Event Functions and Properties
- keypress, The keypress Event-The keypress Event
- mouse events, The mousemove Event-Alternative Mouse Methods
- passing keyboard interrupts, Considerate Programming
- submit, The submit Event
- this keyword, The this Keyword
event handling in jQuery, Handling Events
events (JavaScript)
- attaching to objects in scripts, Attaching Events to Objects in a Script
- attaching to other events, Attaching to Other Events
exclusive or (xor) logical operator (PHP), Logical operators, Operator Precedence
exec system call (PHP), System Calls-System Calls
execution operators (PHP), Operators
EXPLAIN command (MySQL), Using EXPLAIN
explicit casting (JavaScript), Explicit Casting
explicit casting (PHP), Implicit and Explicit Casting
explode function (PHP), explode
exponentiation (**) operator, in PHP, Arithmetic operators
expressions
- in JavaScript, Expressions
- in PHP, Expressions-Literals and Variables
extends keyword (PHP), Inheritance
extract function (PHP), extract

F

fade effects, Fading In and Out
fetch_array method, Fetching a row
fetch_assoc method, Fetching a result
fgets function (PHP), Reading from Files
file handling (PHP)
- copying files, Copying Files
- deleting files, Deleting a File
- file creation, Creating a File
- file pointers and file handles, Updating Files
- file_exists function, Checking Whether a File Exists
- fopen modes, Creating a File
- form data validation, Validation
- including/requiring files, Including and Requiring Files
- locking files for multiple accesses, Locking Files for Multiple Accesses
- moving files, Moving a File
- naming rules, File Handling
- reading files in total, Reading an Entire File
- reading from files, Reading from Files
- sequence of, Creating a File
- updating files, Updating Files
- uploading files, Uploading Files-Validation
__FILE__ constant, Predefined Constants
$_FILES array (PHP), Using $_FILES
$_FILES variable, Superglobal variables
file_exists function (PHP), Checking Whether a File Exists
file_get_contents (PHP), Reading an Entire File
fillRect method (HTML5), The fillRect Method
fillText method (HTML5), The fillText Method
final keyword (PHP), Final methods
Flash, Supporting Non-HTML5 Browsers
flock function (PHP), Locking Files for Multiple Accesses
flow control (JavaScript)
- conditionals, Conditionals-The ? Operator
- explicit casting, Explicit Casting
- expressions, Expressions
- literals and variables, Literals and Variables
- looping, Looping-The continue Statement
- onerror events, Using onerror
- operators, Operators-Logical operators
- try...catch construct, Using try...catch
- with statements, The with Statement
flow control (PHP)
- conditionals, Conditionals-The ? Operator
- dynamic linking in action, Dynamic Linking in Action
- dynamic linking in PHP, PHP Dynamic Linking
- expressions, Expressions-Literals and Variables
- implicit and explicit casting, Implicit and Explicit Casting
- looping, Looping-The continue Statement
- operators, Operators-Logical operators
font property (HTML5), The font Property
fonts
- fonts and typography, Fonts and Typography
- text effects, Text Effects
- text styles, Managing Text Styles
- web fonts, Web Fonts
fopen function (PHP), Creating a File
for loops
- in JavaScript, for Loops
- in PHP, for Loops
forEach method (JavaScript), forEach
foreach...as loops (PHP), The foreach...as Loop
form attribute, The form Attribute
form data validation, Validation (see also file handling)
form handling
- autocompleting fields, The autocomplete Attribute
- building forms, Building Forms
- checkboxes, Checkboxes-Checkboxes
- color selection, The color Input Type
- date/time pickers, Date and Time Pickers
- drop-down lists, <select>
- example program, An Example Program-An Example Program
- helpful hints, adding, The placeholder Attribute
- hidden fields, Hidden fields
- immediate element focus, The autofocus Attribute
- input image dimensions, The width and height Attributes
- interacting with entire element, Labels
- overriding form settings, Override Attributes
- radio buttons, Radio buttons
- required fields, The required Attribute
- restricting input to numbers/ranges, The number and range Input Types
- retrieving submitted data, Retrieving Submitted Data
- sanitizing input, Sanitizing Input-Sanitizing Input
- specifying form to which input applies, The form Attribute
- specifying min/max input values, The min and max Attributes
- stepping through number values, The step Attribute
- submit button text and graphics, The submit button
- supplying default values, Default Values
- supplying lists, The list Attribute
- text areas, Text areas
- text boxes, Text boxes
formaction attribute, Override Attributes
forward slash (/)
- /* and */ in multiline comments in PHP, Using Comments
- /**/ in CSS comments, Using Comments
- // in JavaScript comments, Older and Nonstandard Browsers
- in regular expressions, Matching Through Metacharacters
fread function (PHP), Reading from Files
fseek function (PHP), Updating Files
FTP (File Transfer Protocol), Using FTP
FULLTEXT indexes (MySQL), Creating a FULLTEXT index, MySQL’s FULLTEXT Stopwords-MySQL’s FULLTEXT Stopwords
__FUNCTION__ constant, Predefined Constants
functions (JavaScript)
- creating, Functions
- defining, Defining a Function
- returning arrays, Returning an Array
- returning values, Returning a Value
functions (MySQL)
- benefits of, MySQL Functions
- date functions, Date Functions-Date Functions
- string functions, String Functions-String Functions
- time functions, Time Functions-Time Functions
functions (PHP)
- advantages of, PHP Functions and Objects
- arguments accepted by, PHP Functions
- array functions, Using Array Functions-end
- basics of, Functions
- defining, Defining a Function
- including and requiring files, Including and Requiring Files
- naming rules, Defining a Function
- nesting for execution order, Returning a Value
- passing arguments by reference, Passing Arguments by Reference
- purpose of, PHP Functions and Objects
- returning arrays from, Returning an Array
- returning global variables, Returning Global Variables
- returning values from, Returning a Value
- social networking app example, functions.php-The Functions
- using (calling), PHP Functions
- variable scope, Recap of Variable Scope
- version compatibility and, PHP Version Compatibility
function_exists function (PHP), PHP Version Compatibility
fuzzy character matching, Fuzzy Character Matching

N

names and naming
- constants in PHP, Constants
- files in PHP, File Handling
- functions in PHP, Defining a Function
- SQL commands, MySQL Commands
- tables, MySQL Commands
- variables in JavaScript, Variables
- variables in PHP, Variable-naming rules
__NAMESPACE__, Predefined Constants
NATURAL JOIN keyword (MySQL), NATURAL JOIN
newline (\n) character, Escaping characters, Escape Characters
noConflict method (jQuery), Avoiding Library Conflicts
normalization process
- appropriate use of, When Not to Use Normalization
- First Normal Form, First Normal Form
- goal of, Normalization
- schemas for, Normalization
- Second Normal Form, Second Normal Form-Second Normal Form
- Third Normal Form, Third Normal Form
Not (!) logical operator
- in JavaScript, Logical Operators, Logical operators
- in PHP, Logical operators, Operator Precedence, Logical operators
not equal (<>) operator (PHP), Comparison operators, Operator Precedence
not identical (!==) operator
- in JavaScript, Comparison Operators
- in PHP, Comparison operators, Operator Precedence
NULL value, TRUE or FALSE?
number input type, The number and range Input Types
numeric arrays
- in JavaScript, Numeric Arrays
- in PHP, Numerically Indexed Arrays
numeric data types (MySQL), Numeric data types
numeric variables
- in JavaScript, Numeric Variables
- in PHP, Numeric variables

O

object-oriented programming (OOP), PHP Objects
objects (JavaScript)
- accessing, Accessing Objects
- creating, Creating an Object
- declaring classes, Declaring a Class
- extending, Extending JavaScript objects
- prototype keyword, The prototype Keyword
objects (jQuery), jQuery Objects
objects (PHP)
- accessing, Accessing Objects
- basics of, PHP Objects
- cloning, Cloning Objects
- constructors, Constructors, Subclass constructors
- creating, Creating an Object
- declaring classes, Declaring a Class
- declaring constants, Declaring Constants
- declaring properties, Declaring Properties
- destructors, Destructors
- inheritance, Inheritance-Final methods
- property and method scope, Property and Method Scope
- purpose of, PHP Functions and Objects
- static methods, Static Methods
- static properties, Static Properties
- terminology surrounding, Terminology
- writing methods, Writing Methods
occurrences, Terminology, Declaring a Class
Ogg format, The Video Codecs
Ogg Vorbis, About Codecs
one-to-many relationship, One-to-Many
one-to-one relationship, One-to-One
one-way function, Storing Usernames and Passwords
onerror events, Using onerror
online resources, Online Resources-Miscellaneous Resource Sites
opacity property (CSS), The opacity Property
open source technologies, About Open Source
operands, Operators
operating systems
- audio types supported by, About Codecs
- video types supported by, The Video Codecs
operators (JavaScript)
- arithmetic, Arithmetic Operators
- assignment, Assignment Operators
- associativity, Associativity
- comparison, Comparison Operators, Comparison operators
- escape characters, Escape Characters
- in JavaScript, Assignment Operators
- increment, decrement, shorthand, Incrementing, Decrementing, and Shorthand Assignment
- logical, Logical Operators, Logical operators, Logical operators
- precedence of, Operator Precedence
- relational, Relational Operators
- string concatenation, String Concatenation
- types of, Operators
operators (PHP)
- arithmetic, Arithmetic operators
- assignment, Assignment operators
- associativity of, Associativity
- basics of, Operators
- comparison, Comparison operators
- logical, Logical operators
- overview of types, Operators
- precedence of, Operator Precedence-Operator Precedence
- relational operators, Relational Operators-Logical operators
or (low precedence) logical operator (PHP), Logical operators, Operator Precedence
Or (|) bitwise operator
- in JavaScript, Operator Precedence
- in PHP, Operator Precedence
Or (||) logical operator
- in JavaScript, Logical Operators, Logical operators
- in PHP, Logical operators, Operator Precedence, Logical operators
ORDER BY keyword (MySQL), ORDER BY
OuterHeight Method (jQuery), The outerWidth and OuterHeight Methods
outerWidth method (jQuery), The outerWidth and OuterHeight Methods
override attributes, Override Attributes

P

packet sniffing, Session Security
parent elements
- filtering, Using a filter
- referring to, Parent Elements
- selecting all ancestor elements, Selecting all ancestor elements
parent keyword (PHP), The parent keyword
parent method (jQuery), Parent Elements
parentheses (())
- casting operators in PHP, Implicit and Explicit Casting
- in functions in PHP, PHP Functions
- in regular expressions, Grouping Through Parentheses
- operator precedence and, Operator Precedence
parse error messages (PHP), Semicolons
pass-by-reference feature, Passing Arguments by Reference
password property, Writing Methods
passwords
- BCRYPT algorithm for, Using password_hash, An Example Program
- example program using, An Example Program
- HTTP authentication and, HTTP Authentication
- password_hash function, Using password_hash
- password_verify function, Using password_verify, An Example Program
- salting, Storing Usernames and Passwords
- showing asterisks instead of, Logging In
- storing, Storing Usernames and Passwords
- validating, HTTP Authentication
- validating for form input, HTTP Authentication
password_hash function (PHP), Using password_hash
password_verify function (PHP), Using password_verify
paths, using on canvas, Using Paths-The rect Method
PCM (Pulse Coded Modulation), About Codecs
PhoneGap, What Next?
PHP programming language
- arrays in, Arrays, PHP Arrays-end
- asynchronous communication using, The server half of the asynchronous process
- basic syntax, Basic Syntax
- benefits of, Preface, The Benefits of PHP, MySQL, JavaScript, CSS, and HTML5-Using CSS
- code examples, obtaining and using, This Book’s Examples
- comments, Using Comments
- constants in, Constants
- constants, predefined, Predefined Constants, TRUE or FALSE?
- cookies and, Using Cookies in PHP-Destroying a Cookie
- database queries to MySQL, Accessing MySQL Using PHP-Using mysqli Procedurally
- date and time functions, Date and Time Functions-Using checkdate
- echo vs. print commands, The Difference Between the echo and print Commands
- file handling, File Handling-Validation
- flow control in, Expressions and Control Flow in PHP-Dynamic Linking in Action
- functions in, Functions, PHP Functions and Objects-PHP Version Compatibility
- IDEs (integrated development environments), Using an IDE, Introduction to PHP
- incorporating with HTML, Incorporating PHP Within HTML
- magic quotes feature, Steps You Can Take, Sanitizing Input
- multiple-line commands, Multiple-Line Commands-Multiple-Line Commands
- objects in, PHP Objects-Final methods
- online resources, PHP Resource Sites
- operators in, Operators-Logical operators
- printf function, Using printf-Using sprintf
- regular expressions in, Using Regular Expressions in PHP
- social networking app example, Bringing It All Together-javascript.js
- system calls, System Calls-System Calls
- variable assignment, Variable Assignment-Escaping characters
- variable typing, Variable Typing
- variables in, Variables-Variable-naming rules
- version compatibility, PHP Version Compatibility
- version selection, PHP Functions and Objects
- XHTML vs. HTML5, XHTML or HTML5?
<?php?> tag, Incorporating PHP Within HTML
phpDesigner IDE, Using an IDE
phpinfo function, PHP Functions
phpMyAdmin, accessing MySQL via, Accessing MySQL via phpMyAdmin
phpversion function, PHP Version Compatibility
placeholder attribute, The placeholder Attribute
placeholders (MySQL), Using Placeholders-Using Placeholders
plain text editors, Using a Program Editor
pop method (JavaScript), push and pop
port assignment, String variables
$_POST Array (PHP), The $_POST Array
POST method (HTTP)
- asynchronous communication and, Using GET Instead of POST-Using GET Instead of POST
- in form handling, Building Forms, An Example Program
- jQuery and, Using the POST Method
$_POST variable, Superglobal variables
precedence, Operator Precedence, Operator Precedence
prepend method (jQuery), Adding and Removing Elements
primary keys, Primary keys, Primary Keys: The Keys to Relational Databases
print command (PHP), The Difference Between the echo and print Commands, Returning a Value
printf function (PHP)
- conversion specifier components, Precision Setting
- precision setting, Precision Setting-Precision Setting
- vs. print and echo functions, Using printf
- printf conversion specifiers, Using printf
- sprintf function, Using sprintf
- string conversion specifier components, String Padding
- string padding, String Padding-String Padding
print_r function (PHP), Declaring a Class
privacy policies, Geolocation and the GPS Service
private keyword (PHP), Property and Method Scope
program editors, Using a Program Editor
progressive enhancement, Introduction to jQuery Mobile
properties (CSS)
- accessing from JavaScript, Accessing CSS from JavaScript-Attaching to Other Events
- animating using jQuery, Hiding and Showing-Stopping Animations
- applying, Multiple Assignments
- font properties, Fonts and Typography
- shorthand assignment of, Shorthand Rules
properties (JavaScript)
- defined, Declaring a Class
- static, Static methods and properties
properties (PHP)
- declaring, Declaring Properties
- defined, Terminology
- scope of, Property and Method Scope
protected keyword (PHP), Property and Method Scope
prototype keyword (JavaScript), The prototype Keyword
public keyword (PHP), Property and Method Scope
push method (JavaScript), Assigning element values, push and pop
putImageData method (HTML5), The putImageData Method

Q

querying databases (see database queries)
quotation marks, double (")
- escaping in JavaScript, Escape Characters
- in JavaScript strings, String Variables
- in PHP heredocs, Multiple-Line Commands
- in PHP multi-line commands, Multiple-Line Commands
- in PHP strings, String types
quotation marks, single (')
- escaping in JavaScript, Escape Characters
- in JavaScript strings, String Variables
- in PHP heredocs, Multiple-Line Commands
- in PHP strings, String types