index_F

F

fatalsToBrowser method, phonebook.cgi, 117

f_dir=/path, data source name, 20

fetch

all records from database, 38–41

code example, 56–58

from Internet, 306

some records from database, 41–42

fetch function

importance of, 22, 518

index.cgi (photo album program), 453

Quizzer.pm, 154

view_all.cgi, 190

FETCH method, BasicSession.pm, 257, 262

fetchall_arrayref function, 51–53, 157, 518–519

fetchrow_array function

index.cgi (photo album program), 449

photo_dumper.pl, 291

report_html.pl, 329

report_text.pl, 325

SmallAuction.pm, 212

syntax, 51-53, 519

view_all.cgi, 190

fetchrow_arrayref function, 48

fetchrow_hashref function

index.cgi (photo album program), 446, 452

Quizzer.pm, 159

syntax, 53-55, 519

test_chooser.cgi, 140

field, database table, 28

$field variable, 44

%fields hash, 80

file handle, compared to database handle, 19

fill_person_list subroutine, graphical phonebook application, 361–362

fill_phone_list subroutine, graphical phonebook application, 364

fill_pr_list subroutine, graphical phonebook application, 373, 376

filter key, view_item.cgi, 201

finish method

report_html.pl, 329

report_text.pl, 326

First Normal Form (1NF), normalization, 11

FIRSTKEY method, BasicSession.pm, 257, 261–262

Fisher, Ronald A. (Statistical Tables), 160

fisher_yates_shuffle subroutine

Quizzer.pm, 160

take_test.cgi, 145

FLOAT data type, 5

footer.tmpl, 199, 274, 475

for loop, 40, 44

force_install, 498

foreach loop, 75, 92

foreign key, auction database, 183

form, hidden field, 115

<form> tag, 106, 230

frames, graphical phonebook application, 361

FROM keyword

code example, 39

SELECT statement, relationship to, 37