& (ampersand)

HTML entities and, 205

JavaScript characters, 205

# (hash), 101

~ (tilde), 9

About Us page, 66, 67–68

abs (x), JavaScript Math object, 231

absolute keywords, CSS property values, 99–100

absolute units, CSS property values, 99–100

absolute value, JavaScript Math object, 231

access logs, 533–540

action attribute, form elements and, 166–167

Active Server Pages (ASP), 197, 298

addition, HTML entities, 63

addresses, email. See email

addresses, web. See also IP addresses

• overview of, 7–8

• URI (Uniform Resource Identifier), 9

• URL (Uniform Resource Locator), 8–9

• URN (Uniform Resource Name), 9

ADSL (Asymmetric Digital Subscriber Line), 27

Advanced Research Projects Agency (ARPA), 3

AJAX (Asynchronous JavaScript and XML)

• example, home page welcome message, 315–318

• overview of, 13

• page refresh and, 306–315

alert( ) method, 203–206, 216

alt attribute, HTML, 60–61

ALTER command, MySQL, 376–378

ampersand (&)

• HTML entities and, 62, 63

• JavaScript characters, 205

Analog

• configuring, 542–543

• getting and installing, 541

• getting input for, 541–542

• output, checking of, 543–553

• overview of, 540–541

• running of, 543

anchor, DOM objects, 207–209

anchor tag, 66

AngularJS, 14

anomalies, database design and, 362

Apache, 5

• web pages, placing on Web, 32–35

API (Application Programming Interface)

• Document Object Model (DOM) and, 207–209

Apple, Safari browser, 5

architecture, web browser communication, 5–6

area, DOM objects, 207–209

ARPA (Advanced Research Projects Agency), 3

ARPANET, 3

arrays, JavaScript, 219–220

• slide show image file storage, 273

arrays, PHP, 432–433

• associative arrays, 309–310

• $_SESSION, superglobal array variable, 309–310

article element, HTML, 77–78

ASCII codes, JavaScript characters, 234

aside element, HTML, 77–78

ASP (Active Server Pages), 197, 298

aspect ratio, defined, 269

assistive technologies, 184

associative arrays, 309–310, 433

Asymmetric Digital Subscriber Line (ADSL), 27

Asynchronous JavaScript and XML. See AJAX (Asynchronous JavaScript and XML)

ATTLIST declaration, XML, 515

attributes

• database terminology, 361

• HTML tags and, 57–62

• style attribute, 94

• XML, basics of, 505–508, 514–516

authuser,534

Backbone.js, 14

background properties, CSS markup basics, 98, 99

backslash ( ), special characters and, 205

backspace, JavaScript characters, 205

backward compatibility, 115

bandwidth, defined, 27

base tag, HTML, 71–72, 75–76

Berners-Lee, Tim, 4

block-level elements, HTML, 76–77

body, CSS markup basics, 98

body, DOM objects, 207–209

body element, slide shows onload attribute, 268–269

boolean expressions, 214–216, 222–223

boolean function, defined, 216

Bootstrap, 14

borders, CSS markup basics, 98, 117–121

box model, CSS, 116–121

Boyce-Codd Normal Form (BCNF), 363

Brackets text editor, 28

break, switch statements and, 271, 272

British pound sterling, HTML entities, 63

browsers

• addresses and address resolution, 7–8

• client-server model and, 4–5

• commonly used browsers, 4–5

• JavaScript interpretation, 197

• MIME (Multipurpose Internet Mail Extensions), file types, 30

• overview of, 4

• responsive design, CSS and, 140–148

• video formats and, 150

• web development add-ons, 54–55

• web pages, basic structure and HTML, 48–49

• web pages, testing of, 30–31

• web protocols and communication architecture, 5–6

button, DOM objects, 207–209

bytes, web-server access logs, 534

cable modem Internet service, 27

calculations, in forms, 227–232

calling methods, 201

camel notation, 107

carriage return, JavaScript characters, 205, 234

cascading, inheritance and, 110–114

Cascading Style Sheets. See CSS (Cascading Style Sheets)

case statements, 271–272

catalogs, browsing of products, 447–454

CDATA, XML document type definitions, 514–515

CDMA (Code Division Multiple Access), 27

ceil (x), JavaScript Math object, 231

cent, HTML entities, 63

center element, in HTML forms, 167–168, 170

CGI (Common Gateway Interface), 14

character set

• JavaScript, 234–235

• web page validation, 53

checkbox, DOM objects, 207–209, 216

checkbox attribute, form input fields, 168, 173

checkout for purchases, 476–490

• customer receipt display, 476–485

• database updates and logout, 485–490

Chrome. See Google Chrome

class attributes, CSS and, 105–107

class definition, CSS, 106, 108–110

clear property, CSS and, 121–128

clickstream analysis, Pathalizer, 543–559

clickstream analysis, StatViz, 560

client machine, defined, 4

client programs, defined, 4–5

client-server architecture, defined, 4

client-server database interaction

• additional resources and references, 499–501

• checkout for purchases, 476–490

  • customer receipt display, 476–485

  • database updates and logout, 485–490

• e-store sessions after login, 444–447

• logging in and logging out, 431–444

• overview of, 414–415

• PHP and MySQL connections, 415–419

• product catalogs, browsing of, 447–454

• purchasing products, 455–476

  • createOrder( ),466

  • getExistingOrder( ), getting product details, 464–465

  • pages / shoppingCart .php script, 457–461

  • product information in cart, display of, 466–472

  • scripts / shoppingCartProcess .php script, 461–463

  • shoppingCartAddItem.php, 472–475

  • shoppingCartDeleteItem .php, 475–476

  • shopping cart table footer, display of, 472

  • shopping cart table header, display of, 466–468

• registration, 419–431

  • getting valid registration form data, 420–425

  • processing of registration, 425–431

• utility files for MySQL command-line interface, 491–492

client-side computation and validation, JavaScript. See also JavaScript

• additional information and resources, 253–257

• arrays, 219–220

• character modifiers, 235

• comments, 203

• Document Object Model (DOM)

  • accessing id attributes, 214

  • feedback form validation and, 236–243

  • form interactions, 209–216

  • forms, computation in, 227–232

  • forms, name validation, 241

  • forms, phone number validation, 242

  • form validation and, 217–226

  • name attributes, 216

  • overview of, 206–209

• email address validation, 224–226, 242–243

• examples of page displays, 198–206

  • alert( ) methods, escape characters, 203–206

  • embedded JavaScript, 199–202

  • linking to external file, 202–203

• form validation with, 217–226, 241, 243–248

• function body, 213

• function syntax for, 212–213

• history of, 195, 196

• if-else statements, 214–216

• interpretation vs. compiling, 195–197

• JavaScript, overview, 194, 195–198

• logical operators and boolean expressions, 222–223

• Math object, 230–232

• methods for objects, 201

• Modernizr, form validation and, 243–248

• overview, 194

• parameters, 201, 213

• placement of code, 198

• regular expression, 233–235

• relational operators and functions, 223–224

• restrictions on, 197

• security and, 217

• special characters, 234–235

• strings, 201

• structure, presentation, and behavior of pages, 195

• syntax, 201, 203

• variables, 213

client-side content behavior, JavaScript

• additional information and resources, 295–296

• dropdown menu options

  • CSS for, 278–279

  • onmouseover and onmouseout attributes, 277–278

  • overview of, 276–277

  • sample HTML file, 261–264

  • show( ) and hide( ) functions, 279–280

• example pages, Nature’s Source, 280–288

• overview, 260–261

• slide shows, JavaScript

  • arrays, storing image files, 273

  • img element, revised, 269

  • for loop, 273–274

  • onload attribute of body element, 268–269

  • rotate( ) and startRotation( ) functions, 275–276

  • rotate.js script, 269–276

  • sample HTML file, 261–264

  • sample JavaScript file, 264–268

  • switch statement, 270–272

Code Division Multiple Access (CDMA), 27

color. See also CSS (Cascading Style Sheets)

• browser default values, 101

• CSS property values, 100–102

columns. See CSS (Cascading Style Sheets)

.com, use of, 7

comments, CSS syntax, 103

comments, XML basics, 506

common markup, multiple documents, 71–76

communication architecture, web browsers, 5–6

communication protocol

• defined, 5

• web browsers and, 5–6

comparison operators, JavaScript, 223–224

compliers, 195–197

composite keys, 364–366

computations, in forms, 227–232

concatenation operator, PHP, 304

conditional statements, 214–216

connectToDatabase.php, 438–439

constructor method, 270

Contact Us page, 66

containers, elements as, 165

content, CSS box model, 117–121

content behavior. See JavaScript, content behavior

contextual selector, 98

control characters, JavaScript and, 205

cookies, overview of, 14

copyright symbol, HTML entities, 63

CREATE command, MySQL, 373–376

• copying tables, 399–400

createOrder( ),466

CSS (Cascading Style Sheets)

• additional information and resources, 157–162

• class and id attributes, 105–107

• class definitions, using, 108–110

• code readability, tips for, 106

• comments, syntax for, 103

• conflict resolution, 112–113

• CSS3, responsive design and, 140–148

• CSS box model, 116–121

• CSS class selector definition, 106

• declarations, 97–99

• default.css file, 168

• div and span elements, 107–108

• for dropdown menus, 278–279

• e-commerce site, example of, 10

• examples of

  • inheritance, 110–114

  • multipage site with menu and footer, 134–140

  • responsive design, 140–148

  • simple files sample, 95–97

  • simple home page, 129–134

  • using home page video, 148–150

• history of, 92–93

• inheritance and cascade, 110–114

• measurement property values, 99–100

• overview of, 13

• page layout and, 62

• page layout with float and clear via div elements, 121–123

• page layout with float and clear via HTML5

• semantic elements, 123–125

• placement of style rules, 94–95

• property values, 97–102

• pseudo-class, 140

• reset, as best practice, 125–128

• selectors, 97–99

• structure, comments, and formatting, 102–104

• style rules and syntax, 93–94

• validation of style sheets, 114–116

• web page structure and presentation, 46

• XML data styling and, 517

• XSLT, comparison with, 522–523

CSS validator, 114–116

currency, HTML entities, 63

customer receipt display and database update, 476–490

database, defined, 361

database keys, 364–366

databases, relational. See also client-server database interaction; MySQL

• additional resources and references, 367–368, 410–412

• copying a database, 401–407

• database architecture, 362–367

• database keys, 364–366

• database normalization, 363–364

• design goals for, 362

• functional dependencies, 365–366

• importing and exporting tables and databases, 399–407

• Nature’s Source, database set-up, 372–391

• overview of, 361

• sample data model, Nature’s Source, 369–370

• table relationships, 366–367

data collection. See HTML forms

data mining

• additional resources and references, 567–568

• clickstream analysis, Pathalizer, 543–559

• overview of, 532–533

• user session visualization, StatViz, 559–563

• web access log analyzers, list of, 540–541

• web-server access logs, 533–540

  • interpreting of, 563–565

  • summarizing with Analog, 540–553

data storage, MySQL, server-side data storage, 360–361

data types

• JavaScript strings, 201

• variables, JavaScript and, 213

data validation, JavaScript and DOM, 217–226

Date, JavaScript method, 269–270

DATE, MySQL data type, 369

date and time data, web-server access logs, 534, 535

date( ) function, PHP, 305

declaration block, 94

declarations, CSS style syntax, 94, 97–99. See also CSS (Cascading Style Sheets)

declarations, XML document type definitions and, 511, 513

default attribute values, XML, 515–516

default.css,168

DELETE command, MySQL, 389–390

deletion anomalies, 362

descendant selector, 98

desktop, CSS and responsive design, 140–148

details element, HTML, 77–78

device display, CSS and responsive design, 140–148

DHTML (Dynamic HTML), 13

dial-up Internet service, 27

dictionaries, PHP arrays and, 433

directories

• common markup, 75

• web pages, placing on Web, 33–35

directory permissions, 34

displayExistingItemColumns( ), 466–472

displayFirstFourColumns( ), 466–472

displayHeader( ), function, 466–468

displayNewItemColumns( ), 466–472

div element, HTML, 77, 107–108

• CSS page with float and clear, 121–123

division, HTML entities, 63

Django, 14

DNS (Domain Name Server), 7–8

DNS (Domain Name System), 7–9

DOCTYPE declaration, 53

• XML document connections, 512–513

document, DOM objects, 207–209

document level, style rule placement, 94–95

document root, 8–9

• directory hierarchies, 33

document type definition (DTD), XML, 14, 510–516

Dojo, 14

DOM (Document Object Model)

• additional information and resources, 253–257

• email address validation, 242–243

• feedback form validation with, 236–243

• forms, computations in, 227–232

• forms, first and last name validation, 241

• forms, telephone number validation, 242

• form validation with, 217–226

• id attribute, 214

• overview of, 13, 206–209

Domain Name Server (DNS), 7–8

Domain Name System (DNS), 7–9

DOUBLE, MySQL data type, 369

double quote, JavaScript characters, 205

DROP command, MySQL, 379–380

dropdown list-boxes, 173–174

dropdown menus, JavaScript

• CSS for, 278–279

• onmouseover and onmouseout attributes, 277–278

• sample HTML file, 261–264

• show( ) and hide( ) functions, 279–280

DTD (Document Type Definition), 14, 510–516

Dynamic HTML (DHTML), 13

dynamic typing, 213

dynamic web page, defined, 29–30

echo statements, PHP, 303

• product catalogs, browsing of, 454

e-commerce websites, example-Jones &

• Bartlett Learning, 9–12

EditPad Lite, 28

.edu, use of, 7

elements, HTML, 46–47. See also JavaScript

• block-level elements, 76–77

• as containers, 165

• Document Object Model (DOM), id attributes, 214

• Document Object Model (DOM), name attributes, 216

• Document Object Model (DOM) and, 206–209

• form element, 165–168

• inline-level elements, 76–77

• script element, 200

• semantic elements, HTML5, 76–78

• style element, 94

elements, PHP arrays and, 432–433

elements, XML basics, 505–509, 514–516

em, font size values, 100

Emacs, 28

email

• address validation, 224–226, 242–243

• example, BMI calculator form responses, 348–349

• MIME (Multipurpose Internet Mail Extensions), 30

• server-side functionality, feedback forms, 328–338

emailAlreadyExists( ) function, 430–431

embedded style sheet, 94

Ember, 14

empty elements, HTML, 51

encoding scheme, web page validation, 53

entities, HTML, 62, 63

entity references, XML, 506

environment variables, 439–440

equal to, JavaScript operators, 223–224

escape characters, JavaScript, 203–206

escape characters, MySQL, 382–383

euro, HTML entities, 63

event, DOM objects, 207–209

event attribute, 210

ex, font size values, 100

exp (x), JavaScript Math object, 231

explicit labels, 185

Explorer. See Microsoft Internet Explorer

exponents, JavaScript Math object, 231

external level, style rule placement, 94–95

external scripts, JavaScript alert( ) method, 203–206

false, logical operators, 222–223

feedback forms

• GET method, PHP, 319–322

• implementing sever-side functionality, feedback form, 327–338

• POST method, PHP, 319

• validation of, 236–243

Fiber-To-The-Premises (FTTP), 27

field, database terminology, 361

fields, forms, 168–171

fieldset element, HTML forms, 179–184

figcaption element, HTML, 77–78

figure element, HTML, 77–78

file extensions

• .css, 94

• JavaScript, .js, 197–198

• overview of, 30

• video, 150

file permissions, 34

File Transfer Protocol (FTP), 6

FileUpload, DOM objects, 207–209

Firefox, overview of, 4–5

Firefox Web Developer, 54–57

#FIXED, 515

float property, CSS and, 121–128

floor (x), JavaScript Math object, 231

fonts. See also CSS (Cascading Style Sheets)

• CSS markup basics, 98

• CSS property value formats, 99–102

footer element, HTML, 77–78

footers, CSS multipage site example, 134–140

foreign keys, 364–366, 370

for loop, browsing product catalogs, 454

for loop, slide show image repetition, 273–274

form, DOM objects, 207–209

formatting. See also CSS (Cascading Style Sheets); HTML (Hypertext Markup Language)

• web page structure and presentation, 46

form element, overview of, 165–168

form feed, JavaScript characters, 205, 234

form fields, 168–171

forms

• DOM objects for, 207–209

• email address validation, 224–226, 242–243

• example, server-side BMI calculator, 338–349

• first and last name validation, 241

• implementing functionality, feedback form, 327–338

• JavaScript and DOM interactions, 206–210

  • feedback form validation, 236–243

  • forms, computations in, 227–232

  • form validation, 217–226

  • function syntax, 210–213

  • id attributes, DOM elements, 214

  • if-else statements, 214–216

  • name attribute, DOM elements, 216

• loginForm.php, 433–441

• Modernizr, validation and, 243–248

• processing of registration forms, 425–431

• telephone number validation, 242

• user registration, getting valid data, 420–425

Foundation, 14

FQDN (Fully Qualified Domain Name), 7–9

FROM, MySQL keyword modifier, 394–396

FTP (File Transfer Protocol), 6

FTTP (Fiber-To-The-Premises), 27

Fully Qualified Domain Name (FQDN), 7–9

function

• email address validation, 224–226

• forms, computations in, 227–232

• PHP syntax and use, 345–346

function, JavaScript syntax, 212–213

function, Object-Oriented Programming (OOP), 201

• use of term, 210, 212

functional dependencies, databases, 365–366

function body, JavaScript, 213

getDate, JavaScript, 270

getDay, JavaScript, 270

getExistingOrder( ), getting product details, 464–465

getFullYear, JavaScript, 270

getHours, JavaScript, 270

GET method, PHP, 319–322, 324–327

getMilliseconds, JavaScript, 270

getMonth, JavaScript, 270

getSeconds, JavaScript, 270

getUniqueID( ) function, 430–431

global methods, JavaScript, 204

Global System for Mobile (GSM), 27

global variables, 275

Google Chrome, overview of, 4–5

.gov, use of, 7

Graphical User Interface (GUI), 4, 32–35

greater than, HTML entities, 63

greater than, JavaScript operators, 223–224

greater than or equal to, JavaScript operators, 223–224

GROUP BY, MySQL keyword modifier, 394–396

GSM (Global System for Mobile), 27

GUI (Graphical User Interface), 4, 32–35

hash tables, 433

head element

• DOM objects, 207–209

• web page validation, 54

header( ), PHP functions, 434

header element, HTML, 77–78

headers, CSS markup basics, 97

headings, HTML for, 49–51. See also CSS (Cascading Style Sheets)

height attribute, HTML, 60–61

hexadecimal, JavaScript characters, 234

hex value, 100–101, 102

hidden, DOM objects, 207–209

hide( ), function, 279–280

• onmouseover and onmouseout attributes, 277–278

home page. See also slide shows, JavaScript

• example, home page welcome message, 315–318

• example of, Jones & Bartlett Learning, 9–12

• menu hyperlinks, 65–67

• video use, CSS and, 148–150

horizontal tab, JavaScript characters, 234

host machines

• domain names and, 7–8

hover, CSS pseudo-class, 140

HTML (Hypertext Markup Language). See also CSS (Cascading Style Sheets); HTML forms; JavaScript

• additional information and references, 84–89

• base tag, 71–72, 75–76

• block-level elements, 76–77

• class and id attributes, CSS and, 105–107

• development history, 44–46

• div element, 77, 107–108

• Document Object Model (DOM) and, 206–209

• dropdown menus, sample file, 261–264

• e-commerce site, example of, 10

• empty elements, 51

• entities, 62, 63

• Firefox Web Developer and, 54–57

• headings, paragraphs, line breaks, and lists, 49–51

• HTML5 semantic elements, 76–78

• images, 57–62

• inline-level elements, 76–77

• JavaScript code placement, 198

• menu hyperlinks, 65–67

• metacharacters, 62, 63

• overview of, 4, 13

• PHP instructions, overview, 302

• script element, 200

• slide shows, sample file for, 261–264

• span element, 77, 107–108

• special characters, 62, 63

• SSI and common markup, 71–76

• tables, 57–62

• tag attributes, 57–62

• tags and elements, overview of, 46–47

• unordered lists, 51

• valid web pages, 51–57

• web development tools, 28

• web pages, basic structure, 48–49

• web page structure and presentation, 46

HTML5

• additional information and references, 84–89

• form controls, 187

• Modernizr, form validation, 243–248

• pattern, form validation, 420–425

• regular expressions, 233–235

• script element, 200

• semantic elements, 76–78, 123–125

• valid web pages, 51–52

HTML5 Boilerplate, 14

.html file extensions, 30

HTML forms

• additional information and resources, 190–192

• assistive technologies and, 184

• DOM objects for, 207–209

• dropdown list-boxes, 173–174

• email address validation, 224–226, 242–243

• example, server-side BMI calculator, 338–349

• first and last name validation, 241

• form element, 165–168

• HTML5 form controls, 187

• implementing server-side functionality, feedback form, 328–338

• input element, 168–171

• JavaScript and DOM interactions, 206–210

  • feedback form validation, 236–243

  • forms, computations in, 227–232

  • form validation, 217–226

  • function syntax, 210–213

  • id attribute, DOM elements, 214

  • if-else statements, 214–216

  • name attribute, DOM elements, 216

• logical groupings, behind-the-scenes, 184–186

• loginForm.php, 433–441

• Modernizr, validation and, 243–248

• organizing form controls, 179–184

• overview, 13, 164–165

• processing of registration, 425–431

• submit and reset buttons, 179

• submitting forms to web, 186–187

• telephone number validation, 242

• textarea element, 175–179

• user registration, getting valid data, 420–425

• uses of, 165

HTML-Kit, 28

HTTP (HyperText Transfer Protocol), 6

• as stateless protocol, 309–310

hyperlinks. See also dropdown menus, JavaScript

• web page connections, 62–67

hypertext, 4. See also HTML (hypertext markup language)

id attribute, CSS and, 105–107

id attribute, DOM elements, 214

if-else statements, JavaScript, 214–216

image, DOM objects, 207–209

images. See also multimedia content; slide shows, JavaScript

• arrays, storing image files, 273

• aspect ratio, defined, 269

• HTML for, 57–62

• pixels, 61

• rotate( ) and startRotation( ) functions, slide shows, 275–276

• switch statement, 270–272

• XML, basics of, 508

img elements

• DOM objects and, 207–209

• slide shows, JavaScript, 269

• slide shows, rotate.js script, 269–276

implicit labels, 184

#IMPLIED, 515–516

index.html, 59

• SSI and common markup, 71–76

• web page connections, HTML for, 63–65

inheritance, CSS and, 110–114

inline level, style rule placement, 94–95

inline-level elements, HTML, 76–77

input element

• checkboxes, 168, 173

• HTML5 form controls, 187

• HTML forms, 168–171

• radio buttons, 168, 172

• textboxes, 168, 171–172

INSERT command, 380–384

insertion anomalies, 362

INTEGER, MySQL data type, 369

Integrated Services Digital Network (ISDN), 27

Internet, overview of, 3, 4

Internet Explorer, 4–5

Internet Model architecture, 6

Internet Service Provider (ISP), 26–28

interpreters, programming language, 195–197

interpret mode, PHP, 302

inventory management systems, database, 391

invoking methods, 201

IP addresses, 7

• client-server interactions, 418

• web-server access logs, 533–540

ISDN (Integrated Services Digital Network), 27

ISP (Internet Service Provider), 26–28

Japanese yen, HTML entities, 63

Java, 195, 196

JavaScript, computation and data validation

• additional information and resources, 253–257

• arrays, 219–220

• character modifiers, 235

• comments, 203

• Document Object Model (DOM)

  • accessing id attributes, 214

  • feedback form validation and, 236–243

  • forms, computation in, 227–232

  • forms, first and last name validation, 241

  • forms, telephone number validation, 242

  • form validation and, 217–226

  • interactions with, forms, 209–216

  • name attributes, 216

  • overview of, 206–209

• e-commerce site, example of, 11

• email address validation, 224–226, 242–243

• examples of page displays, 198–206

  • alert( ) methods and escape characters, 203–206

  • embedded JavaScript, 199–202

  • linking to external files, 202–203

• form validation with, 217–226, 243–248, 420–425

• function body, 213

• function syntax for, 212–213

• history of, 195, 196

• if-else statements, 214–216

• interpretation vs. compiling, 195–197

• logical operators and boolean expressions, 222–223

• Math object, 230–232

• methods for objects, 201

• Modernizr, form validation and, 243–248

• overview, 13, 28, 194

• parameters, 201, 213

• pattern, form validation, 420–425

• placement of code, 198

• regular expression, 233–235

• relational operators and functions, 223–224

• restrictions on, 197

• security and, 217

• special characters, 234–235

• strings, 201

• structure, presentation, and behavior of pages, 195

• syntax, 201, 203

• variables, 213

JavaScript, content behavior

• additional information and resources, 295–296

• Date method, 269–270

• dropdown menu options

  • CSS for, 278–279

  • onmouseover and onmouseout attributes, 277–278

  • overview of, 276–277

  • sample HTML file, 261–264

  • show( ) and hide( ) functions, 279–280

• example pages, Nature’s Source, 280–288

• overview of, 260–261

• slide shows

• arrays, storing image files, 273

• img element, revised, 269

• for loop, 273–274

• onload attribute of body element, 268–269

• rotate( ) and startRotation( ) functions, 275–276

• rotate.js script, 269–276

• sample HTML file, 261–264

• sample JavaScript file, 264–268

• switch statement, 270–272

Java Server Pages (JSP), 298

joins, data retrieval in MySQL, 397–399

Jones & Bartlett Learning, example website, 9–12

Joomla!, 14

jQuery, 14, 15

.js file extension, 197–198

JSP (Java Server Pages), 298

keys, PHP arrays and, 433

key/value pair, 310

• GET method, PHP, 320

keywords, CSS color property values, 101–102

Knockout, 14

label element, HTML forms, 184–186

language (lang) attribute, 53

legacy fixes, 68–70

• CSS page with float and clear, 121–123

legend element, HTML forms, 179–184

less than, HTML entities, 63

less than, JavaScript operators, 223–224

less than or equal to, JavaScript operators, 223–224

li, CSS markup basics, 98

LIMIT, MySQL keyword modifier, 394–396

line breaks, HTML for, 49–51

link, DOM objects, 207–209

linking, hypertext and, 4. See also dropdown menus, JavaScript

• web page connections, 62–67

Linux

• text editor, pico, 28

• web pages, placing on Web, 32–35

lists. See also CSS (Cascading Style Sheets); dropdown menus, JavaScript

• CSS markup basics, 98, 135–140

• dropdown list-boxes, 173–174

• HTML for, 49–51

• HTML for browser defaults, 67–68

• menus as, 135–140

LiveScript, 195, 196

LOAD command, MySQL, 384–388

log (x), JavaScript Math object, 231

logging in and out, client-server

• databases, 431–444

• database updates and logout, 485–490

logical groupings, HTML forms, 184–186

logical operators, 222–223

loginForm.php, 433–441

loginFormValidate( ),435

logout.php, 441–444

loop control statements, for loop, 273–274

mail( ) function, PHP, 334–335

main element, HTML, 77–78

maintenance nightmare, 71

many-to-many table relationships, 367

maps, 433

margins, CSS markup basics, 98, 117–121

mark element, HTML, 77–78

Math object, JavaScript, 230–232

max (x, y), JavaScript Math object, 231

maxlength, form input textboxes, 172

measurement property values, CSS markup, 99–100

memory, $_SESSION superglobal array variable, 309–310

menus. See also dropdown menus, JavaScript

• CSS multipage site example, 134–140

• dropdown menus, overview of, 276–277

• example of, Jones & Bartlett Learning, 10

• hyperlinks and, 65–67

• lists as, 135–140

• responsive design, CSS and, 148

metacharacters, HTML, 62, 63

metacharacters, JavaScript regular expressions, 233–235

metadata, XML basics, 508

meta element

• responsive design, CSS and, 146–148

• web page validation, 54

meta element, DOM objects, 207–209

method, Object-Oriented Programming (OOP), 201

• constructor method, defined, 270

• use of term, 210, 212

Microsoft IIS (Internet Information Server), 5

Microsoft Internet Explorer, 4–5

MIME (Multipurpose Internet Mail Extensions), 30

min (x, y), JavaScript Math object, 231

mobile, CSS and responsive design, 140–148

Modernizr, form validation and, 243–248

modifiers, JavaScript characters, 235

modulus operator, 229

MooTools, 14

mouse actions

• hover, CSS pseudo-class and, 140

• onmouseover and onmouseout attributes, 277–278

.mp3 file extensions, 30

multimedia content

• aspect ratio, defined, 269

• home page video, CSS and, 148–150

• HTML file organization and, 57–62

• overview of, 28

• slide shows, JavaScript

  • arrays, storing image files, 273

  • img element, revised, 269

  • for loop, 273–274

  • onload attribute of body element, 268–269

  • rotate( ) and startRotation( ) functions, 275–276

  • rotate.js script, 269–276

  • sample HTML file, 261–264

  • sample JavaScript file, 264–268

  • switch statement, 270–272

Multipurpose Internet Mail Extensions (MIME), 30

MySQL

• additional resources and references, 367–368, 410–412

• command-line interface, 392–399

  • data retrieval using joins, 397–399

  • record set restrictions, setting of, 396–397

  • SELECT command, 394–396

• database architecture, 362–367

• database design goals, 362

• database functional dependencies, 365–366

• database keys, 364–366

• database normalization, 363–364

• database table relationships, 366–367

• data types, 369

• e-commerce site, example of, 12

• history of, 371–372

• importing and exporting tables and databases, 399–407

• keyword modifiers, 394–396

• Nature’s Source, database set-up, 372–391

  • ALTER command, 376–378

  • CREATE command, 373–376

  • DELETE command, 389–390

  • DROP command, 379–380

  • INSERT command, 380–384

  • inventory management systems, 391

  • LOAD command, 384–388

  • SELECT command, 388–389

  • TRUNCATE command, 390–391

  • UPDATE command, 388

• overview of, 13

• relational databases, overview, 361

• sample data model, Nature’s Source, 369–370

• server-side data storage, overview of, 360–361

MySQL, client-server database interactions

• additional resources and references, 499–501

• checkout for purchases, 476–490

  • customer receipt display, 476–485

  • database updates and logout, 485–490

• e-store sessions after login, 444–447

• logging in and logging out, 431–444

• overview of, 414–415

• PHP and MySQL connections, 415–419

• product catalogs, browsing of, 447–454

• purchasing products, 455–476

  • createOrder( ),466

  • getExistingOrder( ), getting product details, 464–465

  • pages / shoppingCart.php script, 457–461

  • product information in cart, display of, 466–472

  • scripts / shoppingCartProcess .php script, 461–463

  • shoppingCartAddItem.php, 472–475

  • shoppingCartDeleteItem .php, 475–476

  • shopping cart table footer, display of, 472

  • shopping cart table header, display of, 466–468

• registration, 419–431

  • getting valid registration form data, 420–425

  • processing of registration, 425–431

• utility files for MySQL command-line interface, 491–492

mysqli_connect( ), PHP functions, 418–419

n, JavaScript characters, 204–205

name attribute, DOM elements, 216

names, form validation, 241

namespaces, XML, 517–520

natural keys, 364–366

Nature's Source database set-up, 372–391. See also MySQL

nav element, HTML, 77–78

navigation, web pages. See also dropdown menus, JavaScript

• dropdown menus, overview of, 276–277

• hyperlinks, 62–67

• mouse hover, CSS pseudo-class, 140

• onmouseover and onmouseout attributes, 277–278

• Site Map page, 67–70

nested elements, HTML

• block and inline elements, 76–77

• Document Object Model (DOM) and, 206–209

• inheritance, 112

nested elements, XML, 507–508

Netscape, 195, 196

new line, JavaScript characters, 205, 234

Node.js, 14, 196

non-semantic elements, HTML, 77

normal forms, databases, 363–364

normalization, databases, 363–364

Notepad, Notepad ++, 28

not equal to, JavaScript operators, 223–224

null, JavaScript characters, 234

numerical calculations, in forms, 227–232

numerical qualifiers, XML, 516

object, database terminology, 361

Object-Oriented Programming (OOP), 201

• function and method, use of terms, 210, 212

octal number, 34

• JavaScript characters, 234

one-to-many table relationships, 366–367

one-to-one table relationships, 366–367

online validators, 52–57

onload attribute of body element, 268–269

onmouseover and onmouseout attributes, 277–278

OOP (Object-Oriented Programming), 201

• function and method, use of terms, 210, 212

open-source software, 12–13

• for server-side computation, 196–197

Open Systems Interconnect Model, 6

Opera, 5

operator precedence, 111

operators, JavaScript computations, 229

option element, HTML forms

• DOM objects, 207–209

• dropdown list-boxes, 173–174

options array, 219–220

Oracle, 197

ORDER BY, MySQL keyword modifier, 394–396

order forms, e-commerce site example, 11

ordinary characters, JavaScript regular expressions, 233–235

.org, use of, 7

p, CSS markup basics, 97

padding, 98, 117–121

page break, JavaScript characters, 205, 234

page layout, 62, 121–125

page refresh, AJAX and, 306–315

pages / shoppingCart.php script, 457–461

paragraphs, HTML for, 49–51. See also CSS (Cascading Style Sheets)

Parallel Project exercises

• client-server database interaction, 498–499

• CSS (Cascading Style Sheets), use of, 156–157

• homepage design, 17–19

• HTML forms, 190

• HTML table tagging, 82–83

• JavaScript, computation and form validation, 252–253

• JavaScript, content behavior, 294–295

• relational databases, 410

• server-side preprocessing, 354

• web mining, 566–567

• web page creation, 37

• XML, use of, 526

parameter list, defined, 213

parameters

• for methods, 201

• PHP functions, syntax and use, 346

parent-child relationships, 112

password, DOM objects, 207–209

password, loginForm.php, 435

Pathalizer, 543–559

pattern attribute

• HTML5 form controls, 187

• user registration form validation, 420–425

payment for purchases, customer receipt display, 476–490. See also products, purchasing of

percent (%), remainder operator, 229

period (.), PHP concatenation operator, 304

Perl, 14

• overview of, 298, 300

• server-side computation, 196–197

permissions, file and directory octal number, 34

Personal Home Page (PHP), e-commerce site example, 11–12

personalized message, logins, 439–440, 445, 447

PHP (Hypertext Preprocessor / Personal Home Page)

• arrays, overview of, 432–433

• development and testing, 349–350

• functions, syntax and use, 345–346

• history of, 300–301

• modes for file I/O, 337

• overview of, 13, 28, 301–302

• parameters, syntax and use, 346

• server-side computation, 196–197

• server-side preprocessing

  • additional information and references, 355–357

  • date( ) function, 305

  • example, BMI calculator form, 338–349

  • example, home page welcome message, 315–318

  • example, unnecessary form with GET method, 324–326

  • GET method, 319–322, 326–327

  • implementing functionality, feedback form, 327–338

  • mail( ) function, 334–336

  • overview of, 298–300

  • page refresh, AJAX and, 306–315

  • POST method, 319, 322–324, 326–327

  • script structure and syntax, 302–306

  • $_SESSION, superglobal array variable, 309–310

  • welcome.php, 305–306

• sessions, overview of, 431–432

• sprintf( ) function, 346–347

• variable declarations, 321–322

PHP, client-server database interaction

• additional resources and references, 499–501

• checkout for purchases, 476–490

  • customer receipt display, 476–485

  • database updates and logout, 485–490

• e-store sessions after login, 444–447

• logging in and logging out, 431–444

• overview, 414–415

• PHP and MySQL connections, 415–419

• product catalogs, browsing of, 447–454

• purchasing products, 455–476

  • createOrder( ),466

  • getExistingOrder( ), getting product details, 464–465

  • pages / shoppingCart.php script, 457–461

  • product information in cart, display of, 466–472

  • scripts / shoppingCartProcess. php script, 461–463

  • shoppingCartAddItem.php, 472–475

  • shoppingCartDeleteItem .php, 475–476

  • shopping cart table footer, display of, 472

  • shopping cart table header, display of, 466–468

• registration, 419–431

  • getting valid registration form data, 420–425

  • processing of registration, 425–431

• utility files for MySQL command-line interface, 491–492

phpMyAdmin, Nature’s Source database

• set-up, 372–391

• copying a database, 401–407

pico, 28

pixels, 61, 100

placeholder attribute, 269

pop-up menus, e-commerce site example, 10–11

pop-up windows

• accessing DOM elements, 216

• JavaScript alert( ) method, 203–206

$_POST array values, 333–334

POST method, PHP, 319, 322–324, 326–327

pow (x, y), JavaScript Math object, 231

primary keys, 364–366, 370

procedure, Object-Oriented Programming (OOP), 201

product catalogs, browsing of, 447–454

products, purchasing of, 455–476

• checkout, 476–490

  • customer receipt display, 476–490

  • database updates and logout, 485–490

• createOrder( ), 466

• getExistingOrder( ), getting product details, 464–465

• pages / shoppingCart.php script, 457–461

• product information in cart, display of, 466–472

• scripts / shoppingCartProcess.php script, 461–463

• shoppingCartAddItem.php, 472–475

• shoppingCartDeleteItem.php, 475–476

• shopping cart table footer, display of, 472

• shopping cart table header, display of, 466–468

programming languages. See also JavaScript; PHP (Hypertext Preprocessor / Personal Home Page)

• compilers and interpreters, 195–197

property, database terminology, 361

property, style declarations, 94, 97–99

property values, CSS style syntax, 97–99

protocols

• communication protocols, defined, 5

• web protocols, defined, 5

• web protocols, types of, 6

Prototype, 14

pseudo-class, CSS, 140

public_html, 33

purchases. See products, purchasing of

PuTTY, 32

Python, server-side computation, 196–197

queries

• database design goals, 362

• SQL and, 371

quotes (single or double), JavaScript characters, 205

radio, DOM objects, 207–209

radio attribute, form input fields, 168, 172

radio buttons, 172

random ( ), JavaScript Math object, 231

read mode, PHP, 302

receipts, checkout for purchases, 476–490

record, database, 361

registered symbol, HTML entities, 63

registration, client-server interactions, 419–431

• getting valid registration form data, 420–425

• logging in and logging out, 431–444

• processing of registration, 425–431

registrationFormProcess.php script, 429

regular expression

• email address validation, 224–226

• feedback form validation, use in, 236–243

• forms, email address validation, 242–243

• forms, telephone number validation, 242

• HTML5, 233–235

• JavaScript, 233–235

relational databases. See also client-server database interaction; MySQL

• additional resources and references, 367–368, 410–412

• copying a database, 401–407

• database architecture, 362–367

• database keys, 364–366

• database normalization, 363–364

• design goals for, 362

• functional dependencies, 365–366

• importing and exporting tables and databases, 399–407

• Nature’s Source, database set-up, 372–391

• overview of, 361

• sample data model, Nature’s Source, 369–370

• table relationships, 366–367

relational operators, JavaScript, 223–224

relative keywords, CSS property values, 99–100

relative units, CSS property values, 99–100

remainder operator, 229

remotehost,534

repetition, JavaScript characters, 235

reset attribute, form input fields, 169

• DOM objects, 207–209

reset buttons, HTML forms, 179

responsive design, example CSS for, 140–148

rfc1413,534

rgb, color values, 100–101, 102

rotate( ) function, slide shows, 275–276

rotate.js script, 269–276

round (x), JavaScript Math object, 230–231

rounding of numbers, 230–232

Safari, 5

sans-serif font, 98

schema, XML document type definition and, 511

script.aculo.us, 14

script element, 200

• embedded JavaScript element, 200–202

• linking to external JavaScript files, 203

scripts. See also client-server database interaction; MySQL; PHP (Hypertext Preprocessor / Personal Home Page)

• PHP and MySQL connections, 415–419

• PHP script structure and syntax, 302–306

• subscripts, PHP arrays and, 433

scripts directory, 197–198

• JavaScript and DOM interactions, form example, 206–209

scripts / shoppingCartProcess .php script, 461–463

search windows, example-Jones & Bartlett Learning, 9–10

section element, HTML, 77–78

security

• JavaScript and, 217

• server-side functionality, feedback forms, 327–338

SELECT command, MySQL, 388–389, 394–396

• copying tables, 399–400

selectedIndex, DOM objects, 220–221

select element, HTML forms

• DOM objects, 207–209

• dropdown list-boxes, 173–174

• options array, JavaScript, 219–220

selectors, CSS style syntax, 94, 97–99. See also CSS (Cascading Style Sheets)

semantic elements, HTML5, 76–78

semicolon (;), HTML entities and, 62, 63

Send Feedback button, 328–338

server logs, 533–540

server machine

• defined, 4

• web pages, placing on Web, 31–35

server-side computation. See also client-server database interaction

• PHP preprocessing

  • additional information and references, 355–357

  • date( ) function, 305

  • example, BMI calculator form, 338–349

  • example, home page welcome message, 315–318

  • example, unnecessary form with GET method, 324–326

  • GET method, 319–322, 326–327

  • implementing functionality, feedback form, 327–338

  • overview of, 298–302

  • page refresh, AJAX and, 306–315

  • PHP, history of, 300–301

  • POST method, 319, 322–324, 326–327

  • script structure and syntax, 302–306

  • $_SESSION, superglobal array variable, 309–310

  • welcome.php, 305–306

• programming languages for, 196–197

server-side data storage, MySQL. See also client-server database interaction

• additional resources and references, 367–368, 410–412

• database architecture, 362–367

• database design goals, 362

• database functional dependencies, 365–366

• database keys, 364–366

• database normalization, 363–364

• database table relationships, 366–367

• importing and exporting tables and databases, 399–407

• MySQL command-line interface, 392–399

  • data retrieval using joins, 397–399

  • record set restrictions, setting of, 396–397

  • SELECT command, 394–396

• MySQL data types, 369

• Nature’s Source, database set-up, 372–391

• overview of, 360–361

• relational databases, overview, 361

• sample data model, Nature’s Source, 369–370

Server-Side Includes. See SSI (Server-Side Includes)

$_SESSION, superglobal array variable, 309–310

sessions

• e-store sessions after login, 444–447

• loginForm.php and, 433–441

• logout.php, 441–444

• PHP, overview of, 431–432

• user session visualization, StatViz, 559–563

shopping cart

• checkout, 476–490

  • customer receipt display, 476–490

  • database updates and logout, 485–490

• createOrder( ), 466

• e-commerce site, example of, 11

• e-store sessions after login, 444–447

• getExistingOrder( ), getting product details, 464–465

• logout.php, 441–444

• pages / shoppingCart.php script, 457–461

• product catalogs, browsing of, 447–454

• product information in cart, display of, 466–472

• purchasing products, 455–476

• scripts / shoppingCartProcess.php script, 461–463

• session logins and, 439

• shoppingCartAddItem.php, 472–475

• shoppingCartDeleteItem.php, 475–476

• shopping cart table footer, display of, 472

• shopping cart table header, display of, 466–468

shoppingCartAddItem.php, 472–475

shoppingCartDeleteItem.php, 475–476

show( ) and hide( ) functions, 279–280

simple keys, 364–366

Simple Mail Transfer Protocol (SMTP), 334–336

single quote, JavaScript characters, 205

Site Map page, 66, 67–70

size attribute, input form textboxes, 172

slide shows, JavaScript

• arrays, storing image files, 273

• for loop, 273–274

• onload attribute of body element, 268–269

• rotate( ) and startRotation( ) functions, 275–276

• sample HTML file, 261–264

• sample JavaScript file, 264–268

• switch statement, 270–272

smartphones, CSS and responsive design, 140–148

SMTP (Simple Mail Transfer Protocol), 334–336

software types, overview of, 12–13

source element, video formats, 150

span element, HTML, 77, 107–108

special characters

• HTML, 62, 63

• JavaScript, 204–206

• regular expressions, JavaScript, 233–235

• XML entity references, 506

sprintf( ), PHP function, 346–347

SQL. See also MySQL

• additional resources and references, 410–412

• database design goals, 362

• history of, 371–372

• importing and exporting tables and databases, 399–407

• Nature’s Source, database set-up, 372–391

  • ALTER command, 379–380

  • DELETE command, MySQL, 389–390

  • DROP command, 379–380

  • INSERT command, 380–384

  • LOAD command, 384–388

  • SELECT command, 388–389

  • TRUNCATE command, 390–391

  • UPDATE command, 388

sqrt (x), JavaScript Math object, 231

square root, JavaScript Math object, 231

src attribute, HTML, 60–61

SSH (Secure SHell), 6

SSI (Server-Side Includes), common markup to multiple documents, 71–76

startRotation( ) function, slide shows, 275–276

stateless protocol, $_SESSION superglobal array variable, 309–310

static web page

• creation of, 29–30

• defined, 29

• offline testing of, 30–31

status, web-server access logs, 534

StatViz, 559–563

string indices, PHP arrays and, 433

string keys, PHP arrays and, 433

strings, PHP concatenation operator (.), 304

string values, 201

• characters for positions, 234

• concatenation of, 204–205, 304

• regular expressions, JavaScript and HTML5, 233–235

style, DOM objects, 207–209

style attribute, 94

style element, 94

style rules, 93–95. See also CSS (Cascading Style Sheets)

style sheet, 93–94. See also CSS (Cascading Style Sheets)

• validation of, 114–116

Sublime Text, 28

submit attribute, form input fields, 169

• DOM objects, 207–209

submit buttons, HTML forms, 179

subscript, PHP arrays and, 433

subtraction, HTML entities, 63

summary element, HTML, 77–78

Sun Microsystems, 195, 196

superglobal arrays, $_SESSION variable, 309–310

superglobal variables, GET method and, 320–321

surrogate keys, 364–366

switch statement, JavaScript, 270–272

tab, JavaScript characters, 205

table, DOM objects, 207–209

TableCell, DOM objects, 207–209

table element, DOM objects for, 207–209

TableRow, DOM objects, 207–209

tables. See also CSS (Cascading Style Sheets); databases, relational

• copying all or part of, 399–400

• database functional dependencies, 365–366

• database keys, 364–366

• database normalization, 363–364

• database table relationships, 366–367

• data retrieval using joins, MySQL, 397–399

• HTML for, 57–62

• importing and exporting, MySQL, 399–407

tablets, CSS and responsive design, 140–148

tabs, JavaScript characters, 234

tags, HTML, 46–47. See also HTML (Hypertext Markup Language)

• anchor tags, 66

• attributes, 57–62

• base tag, 71–72, 75–76

• hyperlinks, 63–67

• menu hyperlinks, 66–67

tags, XML, 504–508. See also XML (eXtensible Markup Language)

• isolating tag sets within XML namespaces, 517–520

TCP/IP (Transmission Control Protocol/Internet Protocol), 6