index_D

D

D format, date function, 281

d format, date function, 281

d formatting directive, sprintf() function, 303

data, table data

inserting, 123–130

selecting and displaying, 130–133

data files

reading, 72–73

writing, 70–72

database-driven authentication

user validation, using HTML forms, 144–149

variables, validating users with, 142–144

databases. See also tables

connecting to

Microsoft SQL Server, 103–107

MySQL database, 91–95

ODBC connections, 107

Oracle databases, 99–103

PostgreSQL databases, 95–99

flat tables, 80

normal forms

first normal form, 81–82

overview, 80

second normal form, 82–83

third normal form, 83–84

relational, 78–80

structure of, 76–77

unique identifiers, importance of, 77–78

Web based-database example, product catalog

administration menu development, 166–169

basic information, 164–166

ID fields, 165

MASTER_PRODUCTS table, 165–166

records, adding, 169–176

records, deleting, 189–196

records, editing, 176–188

date and time functions, 280–283

date() function, 280–281

db_connect() function, 49–50

decbin(), 290–291

dechex() function, 291–292

decoct() function, 292

decrement operators, 257

define() function, 37

DELETE command, 89–90, 193

$depth array, 240

DESCRIBE command, 166, 210

DevShed Web site, 309

die() function, 92, 96, 100, 104, 173, 295

directives

AuthGroupFile, 139

AuthName, 139

AuthType, 139

AuthUserFile, 139

flag, 15

require, 139

value, 15

diskfreespace() function, 284–285

$display_block text string, 200

division operator (/), 38, 255

documents, HTML, 24–26

dollar sign ($), 34, 252

Domain argument, setcookie() function, 153

double equals sign (==), 38, 256

double slashes (//), 33, 251

DROP command, 86, 90

drop-down list boxes, 29, 54

DSO (dynamic shared object), 11

dynamic content, displaying

browser specific code, 61–63

environment variable usage, 60–61

URLs, redirecting users to, 57–60

dynamic shared object (DSO), 11