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 |