Index_P

P

page.php, 371, 377–378

paging defined, 119, 368

Perl, 54

permissions and privileges defined, 126–127

Personal Home Page, 2

Personal Web Server, 5

PHP

coding, example of, 10–12

concatenation, 57

connection scripts, 154, 155–156, 304, 338–339

delimiters for, 8, 54–55, 66

ereg function defined, 234–235

eregi function defined, 234–235

errors, 173–175

favorite TV shows

display titles, 195–196

drop titles, 196–197

favorites with warnings, script for, 218–219

field size, altering, 192

files, form of, 55, 56–57

files and records, 254–255

inserting records, 211–217

installing, 393–394

magic quotes feature, 183

mail order business

display current shopping cart, script for, 312–314

display customer data, script for, 314–318

display products, script for, 309–311, 311–312

programming in, 57–61, 66

purpose of, 126

query statements, 168

quiz show application

checking answer, script for, 347–348

clear tables, script for, 349–350

entity-relationship diagrams, 9, 336

inputting questions, script for, 340–342

selecting category, script for, 217, 342–343

selecting questions, script for, 343–347

showing scores, script for, 348–349

showscores.php script, 348–349

signin.php, 371, 376–377

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

recordsets in, 169

regular expressions, 234–235

require command, 161, 169

running, 395

scripts

beginning, 59–61

cleartables.php script, 349–350

cookies without expiration, 284–285

delete specific titles, 195–196

forms, 171–173

functions for file handling, 256–257

register.php, 371, 372–375

session variables, setting, 290–292

showids.php, 371, 379–380

updating records, 201, 202, 203, 306–307

session_register(‘cart’), 279

session_start(), 279

session_unregister(‘cart’), 279

setcookie function, 278

SID constant, 279, 280

sizeOf function in, 69

stripslashes function in, 183

tables, creating, 203–205, 304–305, 339–340

uploading files, 257–258, 266–270, 308–309

validation, 238–242

variables, local, 167

and XML, 383

XML data, code for, 386–388

PHP Hypertext Preprocessor, 2

phpinfo() function in PHP, 60

physical design of databases, 78, 84, 95–96

POST method, SQL, 370

post method in PHP, 67

primary keys

concatenated, 83, 85, 87, 190

defined, 6, 105

specifying, Access, 143

process diagrams

defined, 92–93

developing, 93–94

mail order business, 301

quiz show application, 10, 336, 337

processes defined, 93

process modeling defined, 92

product catalog, creating, 131–137

projects

airline flights database, 120–122

catalog of favorite TV shows

ASP script for inputting new titles, 178–180

ASP script for showing, 176–177

creating the table, 165–168

delete specific titles, script for, 195

displaying categories, 225

displaying categories, script, 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, 195–196

drop titles, 196–197

favorites with warnings, script for, 218–219

find warnings with specified term, 248–250

inputting new data, 178–180

PHP script for forms, 171–173

showing favorites, script for, 176–177

showing favorites for adding warning, script, 219–220

tables, 165–168

warning records, inserting, 190–191

college courses, database design, 39, 86–89

mail order business

collecting customer information, script for, 327–331

and databases, 79–84, 84–86

display current shopping cart, script for, 312–314

display customer data, script for, 314–318

displaying shopping cart, script for, 324–327

display products, script for, 309–311, 311–312

entity-relationship diagram (ERD), 81, 86, 300

inputting quantities, script for, 322–323

process diagrams, 301

storyboards, 301–302

quiz show application

adding new questions, script for, 351–353

checking answers, 347–348, 359–360

choosing questions, 355–359

clear tables, script for, 349–350

entity-relationship diagram (ERD), 9, 336

entity-relationship diagrams, 9, 336

inputting questions, script for, 340–342

random function, 360–361

selecting category, script for, 217, 342–343, 353–355

selecting questions, script for, 343–347

showing scores, script for, 348–349, 360–361

showscores.php script, 348–349

signin.php, 371, 376–377

score keeping application, 254, 257, 258–260

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

property defined, 9, 33

proprietary software defined, 2

pseudo-random functions in PHP and ASP defined, 58–59

put method in PHP, 67, 74