Index

A

Access

and ASP, 175–176

concatenated primary keys, 83, 85, 87, 190

connection scripts, 318–319

database, creating, 140–151

as DBMS, 7, 78

features of, 127

like operator, 248

primary keys, specifying, 143

queries, specifying, 148–151

records, updating, 319–322

regexp operator, 250

relationships in, 207, 208, 209, 210

stand-alone system, 190–191

tables, creating, 140–151, 206–211

warning records, inserting, 190–191

Active Server Pages. See ASP

addslashes function in PHP, 183

addup function, JavaScript, 39

ADOVBS constants, ASP, 163

agents defined, 93

airline flights database, creating, 120–122

alter query, SQL, 186–187

alter statement, SQL, 105, 113

Andreesen, Marc, 16

Apache, 5

applications, planning, 5–6

arrays

associative, 169, 302–303

defined, 46

indexing of, PHP, 66

askquestion.asp script, 355–359

askquestion.php script, 343–347

ASP

Access and, 175–176

adding warning, script, 220–223

ADOVBS constants in, 163

catalog of favorite TV shows, project

delete specific titles, script for, 195

displaying categories, 225

displaying favorites with counts of warnings, 223–225

displaying favorites with warnings in specified category, script, 226–227

display titles, script for, 193–194

find warnings with specified term, 248–250

inputting new data, 178–180

script for, 176–177

showing favorites for adding warning, script, 219–220

defined, 2, 101

delimiters for, 8, 54–55, 66

escape/unescape functions, 181–183

field size, altering, 192–193

files and records, 254–255

form data, obtaining, 55–57, 71

getVarDate() method in, 278

include command, 161

mail order business

collecting customer information, script for, 327–331

displaying shopping cart, script for, 324–327

inputting quantities, script for, 322–323

math functions in, 58–59

open method of the recordset in, 162

problem input, 180–183

programming in, 57–61

pseudo-random functions in, 58–59

purpose of, 126

queries, making, 162–164

query string in, 74

quiz show application

adding new questions, script for, 351–353

checking answers, script for, 359–360

choosing question, script for, 355–359

entity-relationship diagrams, 9, 336

random function, 360–361

selecting category, script for, 353–355

showing scores, script for, 360–361

random.asp script, 360–361

random functions in, 58–59

reading and writing text files, 255–257, 263–266

records, updating, 197–200, 319–322

recordset, 162

Request.query String() object method in, 71

scripting languages and, 8

scripts

askquestion.asp, 355–359

beginning, 59–61

checkanswer.asp, 359–360

choosecategory.asp, 353–355

connection scripts, 154, 156–162, 318–319, 351

contents collection, 279

cookies collection in, 278

cookies with expiration, 286

cookies without expiration, 283–284

inputquestions.asp, 351–353

methods and properties for file handling, 256

random.asp, 360–361

showscores.asp, 361–362

session.contents.count, 303

session object, 279, 280

sessions, script for, 292–294

showscores.asp script, 361–362

States and Capitals quiz, 69–74

validation, 242–243

variable names, 56, 160

and VBScript, 54, 57

and XML, 383

attribute defined, 9, 17, 33, 78

authentication, 369–370

auto_increment directive, SQL, 112