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