index_U

U

undef, phonebook.cgi, 121-122

UNION operation, SELECT statement, 9-10

unique string, creating, 264

uniqueness, normalization, 12

UnixDate function, SmallAuction.pm, 205

unless condition, 158

unshift function, index.cgi (photo album program), 450

update function, graphical phonebook application, 367

UPDATE statement

admin.cgi, 457

BasicSession.pm, 258

graphical phonebook application, 377

syntax, 75, 506

Update_Data subroutine, admin.cgi, 457

Update_Record subroutine, 82, 93

upload.cgi

CGI module, 234

connect function, 235

DBI module, 234

hash slice, 236

header function, 234

prepare function, 235

program listing, 242-243

quote function, 235

qw (quote word) function, 235

strict module, 234

taint switch, 234

warnings switch, 234

use command, add_questions.cgi, 133

use statement, test_chooser.cgi, 139

user

tracking activity of, 245

tracking between pages, 398

user registration Web site

BasicSession module, 255

BasicSession.pm module, 248, 251

CGI module, 248, 255-256

Check_Fields function, 249, 252

CLEAR method, 257

cookie function, 264

DBI module, 256

DELETE method, 257, 260

DESTROY method, 257, 263

EXISTS method, 257, 259

Exporter module, 257

FETCH method, 257, 262

FIRSTKEY method, 257, 261-262

Get_Session function, 248

Get_Session subroutine, 263, 265

header function, 265

index.cgi, 255-256

index.tmpl, 254-255

INSERT statement, 258

namespace, 256

NEXTKEY method, 257, 261-262

our declaration, 256

overview, 246-247

param function, 248

Print_Page function, 256

Print_Page subroutine, 265

STORE method, 257

strict module, 247, 257

taint switch, 247, 255

tie function, 249

Tie::Hash library, 256, 258

TIEHASH method, 257

Tie::StdHash class, 256

TMPL file handle, 266

UPDATE statement, 258

warnings switch, 247, 255

Wrap_Page function, 251, 256, 265

user session data, maintaining between program calls, 443

username, data source name, 21