Index_S

S

score keeping application, 254, 257, 258–260

scripts defined, 3

searching, 230–233, 238, 245

security, 369–371

select statement, MySQL, 138–139

select statement, SQL, 106, 110, 115–119, 383–384

server-side scripting languages defined, 3

session.contents.count, ASP, 303

session object, ASP, 279, 280

session_register(‘cart’), PHP, 279

sessions. See also individual commands by name

ASP script for, 292–294

general discussion, 279–280, 288––289, 302–303

PHP script for, 290–292

session_start(), PHP, 279

session_unregister(‘cart’), PHP, 279

setcookie function, PHP, 278

setInterval function, JavaScript, 37

shopping carts, 298–302

show database command, MySQL, 131

showids.php, 371, 379–380

showscores.asp script, 361–362

showscores.php script, 348–349

show table command, MySQL, 135

SID constant, PHP, 279, 280

signin.php, 371, 376–377

Singleton tags, 383

sizeOf function, PHP, 69

slide shows, 46–50

speech recognition, 385

speech synthesis, 385

SQL

alter query, 186–187

alter statement, 105, 113

auto_increment directive, 112

on clause, 106

concatenated primary keys, 190

On condition, 110

count aggregate function, 122, 191

create database command, 112

create statement, 105

create table command, 112

debugging, 191

defined, 7, 78, 104

delete command, 187

delete from tablename statement, 187

delete statement, 106

drop statement, 105

get method, 370

group by clause, 106, 122

group clause, 117

handler script, 188

having clause feature, 120

insert statement, 105, 113, 114

joins, 9, 106–112, 118, 189–190, 191

left joins, 111, 191, 338

like operator defined, 236–237

limit clause, 106, 368

order by clause, 117, 121

POST method, 370

qualifier, 108

queries, 151, 243–245

recordsets, 7, 104

select statement, 106, 110, 115–119, 383–384

standalone SQL statement, 7, 104

statements, 105–106

storyboards, 188, 189

update query, SQL, 114

update statement, 106

where condition, 110, 116

SQLServer, 7

standalone SQL statement defined, 7, 104

Standard Generalized Markup Language (SGML), 382

stateless protocol defined, 274

States and Capitals quiz

in ASP, 69–74

general discussion, 61–63

HTML, 63–64

logical design of, 97

in PHP, 63–69, 170

physical design of, 97–100

process diagrams for, 97, 98, 99

storyboards for, 96, 99, 100

stored procedures, 110, 368

storyboards

defined, 6, 11

mail order business, 301–302

physical design, use in, 95–96

quiz show application, 336, 337

SQL, 188, 189

States and Capitals quiz, 96, 99, 100

string defined, 84

stripslashes function in PHP, 183

structured databases defined, 89

Structured Query Language. See SQL

switch statements, 388–389

systems analysis and design, 5–6

systems analysis defined, 92