Index_S

Save Sonnet program files

closing, 219–220

creating, 215–217

CSS, 222

loading, 220–221

opening, 217–219, 222

reading, 222

writing, 219

saving files, 229–231

scope, variables, 106–108

Scope Demo program, 106–108

scripts, tables, 276–278

searches

data, 55–59

shortcuts, 57–59

templates, 57–59

security

files, 217–219, 247, 255–256

passwords

databases, 302

forms, 25

<select> HTML tag, 28–29, 64–65

SELECT SQL command, 275–276, 285–286. See also queries

selecting

databases, 303

files, directories, 228

form elements, 26

records, 313–316

tables, 275–276

semicolon line termination character (;), 44–48, 303

sentry variables, 121–122

servers

connecting

clients, 279

programs, 302–303

three-tiered architecture, 348

server-side programming, 3

setType() function, 51

shortcuts, searches, 57–59

Show Heros database, 300–302

size, arrays, 134

slashes (/), 229

sorting queries, 289–290

SOURCE SQL command, 276–278

spaces, filenames, 249

split() function, 184–185, 193, 235, 251–255

splitting arrays, 235, 251–255

Spy database. See also spyLib program; Spy Master program

building, 334–339

inner joins, 339–342

link tables, 342–346

tables

foreign keys, 336–337

primary keys, 335–336

values, 337

Spy Master program. See also Spy database; spyLib program

connecting database, 360

creating records, 369–370

database queries, 357–358

deleting records, 368–369

edit table form, 361–363

editing records, 366–367

editing tables, 365–366

function library, 356

overview, 348–353

query form, 358–361

state diagram, 354–356

updating records, 367–368

viewing queries, 363–365

spyLib program. See also Spy database; Spy Master program

buttons, 394

connecting database, 372–373

creating records, 389–392

CSS, 371

deleting records, 388–389

editing fields, 384–387

editing records, 379–384

foreign keys, 386–387

global variables, 371–372

list boxes, 393–394

primary keys, 385–386

processing records, 392–393

query lists, 373–374

query tables, 374–379

updating records, 387–388

SQL (structured query language), 266–267

clauses

FROM, 286–287

LIKE, 288–289

ORDER BY, 289–290

WHERE, 287–288, 339–342

commands, 270. See also queries

CREATE, 270–273

DESCRIBE, 273–274

DROP, 277

INSERT, 274–275, 337

SELECT, 275–276, 285–286

SOURCE, 276–278

UPDATE, 290–291, 321–322

USE, 270–271

comments, 277

queries, 285–286

columns, 286–287

creating, 303

data, 55–59

databases, 357–358

fields, 288–289, 304–305

forms, 358–361

lists (spyLib program), 373–374

multi-dimensional arrays, 174–176

result sets, 303–306

rows, 287–288

sorting, 289–290

tables (spyLib program), 374–379

two-dimensional associative arrays, 179–181

updating, 290–291

viewing, 363–365

quotes, 358

SQLyog

connecting, 279

databases, 278–279

tables

creating, 280

editing, 280–281

exporting, 281–285

state diagrams, 354–356

statements

break, 94

case, 94

else, 86–88

else…if, 88–91

if, 81–86

branching, 94–97

if…else, 86–88

if…else…if, 88–91

SQL. See commands

switch, 91–94

branching, 94–97

Word Puzzle Maker program, 197–200

storing files, 229–231

Story program, 40

building, 68–74

overview, 66–67

reading, 71–73

strings. See also values

arrays, 184–185

case sensitivity, 193

concatenating, 186–187

databases, 272

embedded, 185–186

manipulating, 182–184

overview, 181

replacing, 225

substrings, 185–186

trimming, 185

variables, 42–44

multi-line, 47–48

Word Puzzle Maker program, 193, 200–206

strstr() function, 186

strtoupper() function, 193

structured query language. See SQL

style sheets. See CSS

styles (CSS)

external, 19–21

local, 14–15

page, 15–19

Submit button (forms), 31

substr() function, 185–186

substrings, 185–186

super hero generator Web site, 280

support, PHP, 32

Switch Dice program, 91–94

switch statements, 91–94

branching, 94–97

Word Puzzle Maker Program, 197–200

systems, content management, 3