H

Index
byGareth Downes-Powellet al.
Wrox Press 2003

hand coding, see coding by hand.

HAVING clause, SELECT, 187

filtering recordset rows, 187

header() function, PHP

login system example, hotel booking, 259

HomeSlte code editing tool, Dreamweaver, 13

integrated in Dreamweaver MX, 13

host table, MySQL, 41

hotel booking system, case study, 117

add_user_record.php, 121

adding Insert Record behavior, 127

adding parameters to page redirection URL, 128

connecting to database, 126

creating page, 121

name/address details, 123

title/country, 124

displaying, 128

validating form, 125

architecture, 77

diagram, 78

book_a_room.php, 129

creating page, 129

displaying, 130

booking system, 82

planning, flowchart, 83

SSL for credit card transactions, 83

booking_cancelled.php, 161

creating page, 161

URL variable selection, 161

displaying, 162

booking_details.php, 131

creating database recordsets, 134

inserting name/surname recordset values, 135

creating form, 132

adult/children no. selection, 132

dates/room type selection, 132

smoking/non-~ room selection, 133

special requirements input, 133

displaying, 138

hiding/displaying text, 136

inserting record into database, 137

booking_updated.php, 156

creating page, 156

creating recordsets, 157

booking/client ID recordsets, 157

displaying, 158

cancel_booking.php, 159

creating form, 159

Delete Record behavior, adding, 160

adding parameter, 160

displaying, 160

canceling booking, 159

booking_cancelled.php, 161

cancel_booking.php, 159

change_booking.php, 146

creating form, 146

displaying, 147

change_booking_details.php, 147

creating form, 147

creating recordsets

user details retrieval, advanced recordset, 149

displaying, 156

dynamic list/menu/check box/radio group, adding, 150

Update Record behavior, adding, 154

adding parameters, 155

changing booking, 146

booking_updated.php, 156

change_booking.php, 146

change_booking_details.php, 147

confirm_booking.php, 140

advanced recordset, adding, 141

adding variable parameter, 142

adding variable to WHERE clause, 143

creating page, 140

creating recordsets, 141

displaying, 145

dynamic check boxes/radio buttons, adding, 144

adding link to change_booking_details, 145

database structure, planning, 78

info types stored, 79

table layout/relationships, building, 79

database tables, creating, 94

bookings table, 91

clients table, 92

layout, standardizing using templates, 102

MySQL Monitor, using, 98

phpMyAdmin, using, 94

table wizard, creating table, 96

room table, 93

users table, 94

editing template & updating page links, 162

page links, listing, 163

updating links, 163

layout, designing, 86

layout, standardizing using templates, 102

accessing templates, 110

creating layout, Fireworks MX, 102

exporting sliced images into Dreamweaver, 104

saving layout as template, 104

defining content placement area, 109

Navigation Bar, creating/adding to template, 105

adding layer to page, 105

Insert Navigation Bar dialogue, 106

saving bar as Library Item, 109

login system, administration, 246

create users PHP page, 261

database users table, 247

include PHP page, 249

login PHP page, 256

menu PHP page, 260

overview, PHP pages, 246

planning, flowchart, 85

making a booking, 121

add_user_record.php, 121

book_a_room.php, 129

booking_details.php, 131

confirm_booking.php, 119

confirm_booking.php, 140

overview, 6

requirements, 76

search engine, building, 201

building base query, 205

building dynamic query, 206

displaying results, 212

UI design, 201

site functionality/features, determining, 80

booking system, 82

flowcharts, symbols, 80

login system, administration, 85

$HTTP_POST_VARS/-_GET_~ arrays, PHP, 203

search engines, building query, 211

search engines, UI design, 203



Dreamweaver MX PHP Web Development
Dreamweaver Mx: Advanced Php Web Development
ISBN: 1904151191
EAN: 2147483647
Year: 2001
Pages: 88

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net