SBB (Server Behavior Builder), Dreamweaver MX, 265 building server behavior, example, 268 building UI controls for parameters, 279 finalizing, 280 inserting code block into document, 270 positioning/selecting code block, 275 inserting parameters into code block, 273 parameters, listing, 274 setting server behavior title, 275 steps, 268 building UI, Generate Behavior Dialog Box, 276 code blocks, UI, 271 behavior/selection, 272 inserting parameters into, 273 list/area, 271 controls, UI, 277 ColdFusion Data Source menu, 277 Connection/- Table/- Column menus, 277 Editable Recordset/- Field menus, 277 List Menu/Checkbox/Radio Group, 279 Recordset Fields ordered list, 278 Recordset/- Field menus, 277 Text Field comma-separated list, 278 Text Field/Dynamic ~/URL ~/Numeric ~, 278 copying server behaviors, example, 281 overview, 265 main window, 269 pre-defined server behaviors, 266 starting, 269
scripting client-/server-side, comparing, 6
search engines, SQL, 199 building query dynamically, 204 base query, 205 creating recordset, 205 dynamic query, 206 advanced recordset, creating, 207 parameters, adding to recordset, 208 Default/Runtime Value options, 208 modifying query for price range, 210 PHP source code, updating, 211 displaying results, 212 inserting dynamic values into page, 213 repeating region, 213 executing query, 200 functionality, overview, 199 diagram, 200 hotel booking system, building for, 201 base query, building, 205 displaying results, 212 dynamic query, building, 206 beds no./price range options, selecting, 206 UI design, 201 UI design, 201 example designing, 201 elements, listing, 202 retrieving user input values, 203 $HTTP_POST_VARS/~_GET_~, using, 203 example, 203 tools contained in Forms tab, Insert, 201
security login system example, hotel booking, 261
SELECT statement, SQL, 167 columns, selecting, 169 filtering recordset rows, SELECT...HAVING, 187 filtering table rows, SELECT...WHERE, 178 grouping rows, GROUP BY, 182 hotel booking system, 92 limiting rows no., SELECT...LIMIT, 188 lottery example, 189 simple example, 188 linking/joining tables, SELECT...JOIN, 172 FROM, using, 172 optimization using indexes, 191 retrieving rows without table reference, 167 sorting recordset rows, SELECT...ORDER BY, 187 syntax, 168 DISTINCT/-ROW, NOT selecting same row twice, 168 USING keyword, 177
server behaviors PHP support, Dreamweaver UltraDev, 11 pre-defined, 266 SBB (Server Behavior Builder), 265 building server behavior, 268 copying server behavior, 281
Server Behaviors panel, Application, 17 pre-defined behaviors, 266 Display Record Count, 267 Dynamic Text/~ Form Elements, 267 Insert/Update/Delete Record, 267 Recordset/~ Paging, 266 Repeat Region/Show -, 266
servers, 31
session_start() function, PHP login system example, hotel booking, 259
set_error_handler() function, PHP, 297 additional parameters, PHP 4.0.2, 298 customErrorHandler() example, 301 example, 298 output, 298
SHOW COLUMNS FROM query, SQL, 101 hotel booking system, 101
SHOW DATABASES query, SQL, 38
Show 'Down Image' Initially option, Insert Navigation Bar, 108
Show Region pre-defined behavior, Server Behaviors, 267
site definition, Advanced Cloaking file types NOT uploadable to server, 68 Design Notes, usefulness, 68 Local Info, local machine settings, 66 Default Images Folder/Enable Cache options, 66 Remote Info, remote machine settings, 67 Site Map Layout, options specifying, 69 Testing Server, configuring testing server, 67
site definition, Basic Configuration Wizard, 56 editing files locally/testing remotely, 60 checking files in/out, 62 communicating with testing server, 62 connecting to testing server, 60 FTP option, 61 Local/Network option, 61 RDS option NOT available for PHP, 61 copying edited file to remote server, 60 editing files, overview, 58 editing/testing files locally, 59 communicating with testing server, 60 editing/testing files remotely using FTP, 63 checking files in/out, 64 communicating with testing server, 64 editing/testing files remotely using LAN, 63 communicating with testing server, 63 naming site, 57 overview, 56 configuration, ways of, 56 server technology, choosing, 58 ColdFusion MX automatically detected, 58 summary, reviewing all entered values, 65
site definition, Dreamweaver MX, 55 connecting to database, 70 creating connection, 71 errors, handling, 71 naming convention, connections, 71 testing connection, 71 creating, overview, 56 Basic Configuration Wizard, using, 56 pre-requisites, 55
Site Map Layout category, Advanced Site Definition, 69
Site panel, Files, 17
slicing, 102 hotel booking system, creating layout, 102
Snippets panel, Code, 237 adding function snippet, example, 238 wrapping snippet around code block, 239 editing/deleting snippet, 240 inserting snippet into code block, 240 sharing snippet, 240
SQL (Structured Query Language), 32 ALTER TABLE functionality, 194 indexes, creating/deleting, 194 errors, handling, 314 MySQL, 32 queries/commands, 37 data access, 37 databases, 37 granting privileges, 44 tables, 38 SELECT functionality, 167 columns, choosing, 169 filtering recordset rows, 187 filtering table rows, 178 grouping rows, 182 limiting rows no., 188 linking/joining tables, 172 optimization using indexes, 191 retrieving rows without table reference, 167 sorting recordset rows, 187 statements, executing MyCC, 48 PHPMyAdmin, 52
SSL (secure Sockets Layer) hotel booking system, 83
statements, PHP, 218 see also control structures.
strings
appending to strings, 220 assigning to variables, 219
Style Sheet/Accessibility options, tag editor, 230
sum(expr) function, MySQL GROUP BY using, 187
symbols, flowcharts, 80 manual input, 82 |