D

Index
byGareth Downes-Powellet al.
Wrox Press 2003

Databases panel, Application, 16

connecting to database, site definition, 71

databases, MySQL, 37

connecting to, site definition, 70

creating, CREATE DATABASE, 38

database-enabled sites, hotel booking system, 117

database servers, 31

displaying, SHOW DATABASES, 38

hotel booking system, 91

overview, 35

company employees/departments example, 36

example, diagram, 35

using, USE, 38

date() function, PHP

custom error handling using, 303

db table, MySQL, 41

DBMS (DataBase Management Systems)

Dreamweaver MX PHP support, 20

debugging, 307

debuginfo() custom example, creating, 309

array support, adding, 310

expanding function, 314

global debug option, adding, 309

include file, creating, 311

running, HTML form & output, 312

turning function ON/OFF, 310

echo(), outputting useful info, 307

gettype(), returning variable type, 308

Default Images Folder option, Local Info, 66

Default menu, Editable Tag Attributes, 112

Default/Runtime Value options, Add Parameter

search engines, building queries, 208

Delete Record server behavior, Dreamweaver MX

hotel booking system, 160

DESC command, SQL, 40

example, 40

Design Notes category, Advanced Site Definition, 68

Design panel, Dreamweaver MX, 15

Behaviors tab, 15

Display Record Count pre-defined behavior, Server Behaviors, 267

display_errors directive, php.ini

global error reporting level change, 294

DISTINCT/-ROW keywords, SELECT

NOT selecting same row twice, 168

Dreamweaver MX, Macromedia, 12

as WYSIWYG web page editor, 56

coding by hand, 224

Code view/inspector, 224

good practices, 240

new features, 227

Preferences window options, 225

functionality, panels overview, 12

Answers, 18

Application, 16

Code, 16

Design, 15

Files, 17

Insert, 14

New Document wizard, 19

Properties Inspector, 18

tabbed document windows, 18

UI, choosing, 13

PHP support, 20

DBMS supported, 20

web servers compatible, 21

Windows/Linux PHP installation, comparing, 20

site definition, creating, 55

Dreamweaver UltraDev, Macromedia, 11

PHP support, 11

limitations, 11

PHAkT/ImpAKT projects, Interakt, 11

server behaviors, using, 11

DROP expression, ALTER TABLE

column, removing, 191

indexes, deleting, 195

DROP TABLE command, SQL, 39

DSO (Dynamic Shared Object), Linux

installing PHP as DSO module, 24

dynamic check boxes/radio groups

hotel booking system, 151

Dynamic text field, SBB UI, see Text Field/ Dynamic ~/URL ~/Numeric ~.

Dynamic Text/~ Form Elements pre-defined behaviors, Server Behaviors, 267

dynamic web pages, 5

client-/server-side scripting, comparing, 6

PHP creating, 5

dynamic web sites, 75

architecture, 76

flowcharts, using, 80

hierarchical structure, 76

hotel booking system, 76

latency, using, 78

site features, determining, 77

database structure, planning, 78

designing, principles, 86

hotel booking system, 86

layout, defining, 86

navigation, 87

site purpose & goal, defining, 86

target audience, defining, 86

tools required, 88

site functionality/features, determining, 80