14. Working with Online Data

This lesson will take about 90 minutes to complete. Before beginning, make sure you have copied the files for Lesson 14 to your hard drive as described in the “Getting Started” section at the beginning of the book. If you are starting from scratch in this lesson, use the method described in the “Jumpstart” section of “Getting Started.”

By its very nature, the web is a dynamic environment. Get the most out of your website by connecting it to live data using Spry, ASP, ColdFusion, or PHP.

Working with dynamic content

Except for a few interactive Spry components and a little Flash animation and video, the pages you have built in this training have been mostly static, like text and pictures on paper. Yet, the web is a dynamic environment. The live connection to the Internet makes the delivery of text, pictures, animation, and video only a click away.

Many of the most popular websites today supply content through two-way interactions with their visitors. This “query and response” method of content delivery can’t be accomplished by HTML alone. It requires scripting and a variety of server-based applications that are supported by languages like Ajax, ASP, ColdFusion, JavaScript, and PHP, among others. This technique also requires information stored on the Internet, usually in the form of a table or database.

Until a few years ago, HTML tables were static containers. But now the lowly table has been liberated through the intervention of Ajax. Dreamweaver can easily harness all the power of Ajax through Adobe’s Spry framework and some surprisingly powerful widgets. At the moment, you may lack the ability to develop more sophisticated applications, but there’s no longer any excuse for putting static tables on your website.

Previewing the completed file

To see what Ajax can do for HTML-based tables, let’s preview the completed file.

1 Launch Dreamweaver, if necessary.
Open events_finished.html in the lesson14 folder.
Examine the Events Calendar and Class Schedule tables.

The Events Calendar and Class Schedule are Spry widgets that generate the tables dynamically. Note the placeholder text in the second row of each table, such as: {Date} and {Event}.

2 Preview the page in Live view.

The placeholders are replaced by data from external sources, and additional rows are automatically generated. Note how the text in the Events table is sorted by date.

3 Click the header cell for the Events column.

The table sorts based on the names of the events.

4 Move the cursor over each row in the table.

As the cursor passes over each row, it changes color momentarily.

5 Click any row in the table, and then move the cursor away from that row.

The selected row changes color completely and remains highlighted as the cursor moves away.

6 Repeat steps 3–5 for the Class table.

The Class table exhibits the same behaviors as the Events table. The functionality for sorting tables interactively and creating the hover and select effects are all produced by Ajax scripting.

In the next exercise, you’ll learn how to tap into the power of Ajax by using Spry to liberate data stored in HTML tables and XML files, and you will produce these same effects.

Using HTML and XML data

Before you can display data on your web pages, you’ll need to establish a proper data source. In years past, this meant working with proprietary programming languages like ASP, ColdFusion, and PHP. These are powerful languages that are still used in thousands of websites today, and you’ll learn more about them later in this lesson. But Ajax has revolutionized the role of data within many sites. As powerful as they are, the traditional languages can only display data changes after they reload the entire page. On the other hand, Ajax can update data in real time.

This capability is enabled through the use of HTML and XML data sets. In HTML, the data is stored in tables. XML (Extensible Markup Language) data is stored in a plain-text file using a standardized specification for marking up text. In the following exercises, you’ll work with both HTML and XML data sets.

HTML (left) and XML (right) store information in different ways, but both are accessible to Dreamweaver.

Working with HTML data

Until the advent of Ajax, data stored in HTML tables was static and unusable by the rest of the website. In other words, the data in a table on page A could not be used by page B unless you copied and pasted part or all of the data onto that page, too. The problem with this workflow is obvious. Once you paste the data onto multiple pages, you have to constantly update every page manually when the data changes, creating a lot more work and possibilities for error. Using the Adobe Spry framework, Dreamweaver can now tap into HTML table-based data in a new, dynamic way.

1 If necessary, launch Dreamweaver and switch to Design view. Open events.html from the site root folder.

This page contains two HTML-based tables filled with data. At the moment, the data here is static, but using Ajax via the Spry framework you’ll be able to tap into this data for a variety of purposes. The first step is to move the table into a separate document.

2 Insert the cursor into the Events table and select the <table#calendar> tag selector. Press Ctrl-X/Cmd-X to cut the table.

3 Select File > New.
Choose Blank Page > HTML > <none>.
Click OK/Create.

A new, blank document is created.

4 If necessary, insert the cursor in the Design view window.
Press Ctrl-V/Cmd-V to paste the table.
Insert a new, empty paragraph after the table.

Before a table can be used as a Spry data set, it must have a unique ID.

5 Insert the cursor into the table. Examine the tag selectors.

The tag selector displays <table#calendar>.

6 Select the <table#calendar> tag selector and examine the Property inspector.

Note that the ID field displays the text calendar. You applied IDs to both tables in Lesson 10, “Working with Navigation,” and the ID was preserved when you copied and pasted into this file.

7 Save the file as html-data.html in the site root folder.

There’s no limit to how many tables one file can hold, but don’t go crazy; files containing lots of tables can take longer to download from the Internet and can detract from a user’s overall experience.

8 Click the events.html document tab to bring it to the front.
Repeat step 2 to cut the Class table.
Switch to html-data.html.
Paste the Class table in the empty paragraph below the Events table.

9 Save and close the file.

10 If necessary, click the tab for events.html to bring the document to the front. Insert the cursor at the end of the Green Events and Classes heading and press
Enter/Return to create a new, empty paragraph.

11 Open the Insert panel.
Choose Spry from the Category menu.
Click the Spry Data Set button.

The Spry Data Set dialog box appears.

12 In the Select Data Type menu, choose HTML.
In the Data Set Name field, enter ds_events.
In the Detect field menu, choose Tables.
Click Browse and, from the site root folder, select html-data.html and click Open/Choose.

A preview of the data sources in html-data.html appears in the Data Preview window.

13 In the Data Containers menu in the upper right, choose Calendar. Click the Next button at the bottom of the dialog box.

The Spry Data Set dialog box now displays a window to set data options. In this window you can identify specific types of data, such as text (string), numbers, dates, and HTML code. Identifying the data type is important if you want to sort data by certain values, such as date or cost, or use the data for other special purposes.

14 Choose Date from the Column Name menu.
In the Type menu, choose string.

Note how the Use First Row As Header option is selected. If you use a table that doesn’t contain a header row, this option should be deselected.

15 In the Sort Column field, choose Date.
Examine the order of the data in the Data Preview window.

Note how the column sorts incorrectly, based on the spelling of the month. You can correct this problem by changing its data type.

16 Click the first row of the Date column. In the Type menu, choose date.

The column is now sorted correctly, based on the event date.

For Spry applications, dates can be entered in two basic formats: by spelling out the month, day, and year—typically Jan (or January) 1, 2011—or by standard numeric notation, such as 1/1/2011. However, the Spry Data Set dialog box will not recognize dates written like this: 1-1-2011.

17 Click the first row in the Event column.
In the Type menu, choose string.
Select the Location column. In the Type menu, choose string.
Select the Cost column. In the Type menu, choose number.
Click Next.

The Spry Data Set dialog box now displays the insert options for the data set.

18 Click the Set Up button beside the Insert Table option.

The Spry Data Set–Insert Table dialog box appears. This dialog box allows you to specify what data will be displayed and how it will appear. Feel free to experiment by removing or changing the order of the data columns, and by specifying whether they are sortable or not.

19 Enable the Sort Column When Header Is Clicked option, if necessary.
In the Odd Row Class field, enter odd.
In the Even Row Class field, enter even.
In the Hover Class field, enter rowhover.
In the Select Class field, enter rowselect.
Click OK.

This dialog box assigns CSS classes to style the table interactively, powered by JavaScript. These classes don’t exist yet, otherwise you could select them from the menus.

20 Click Done.

A two-row Spry data table placeholder is inserted in the layout. Some of the formatting on the placeholder should match the default table styling you created in Lesson 8, “Working with Text, Lists, and Tables.” The Spry component is nearly complete; but it still needs custom CSS rules for the classes you assigned in step 19.

Styling Spry tables

The odd/even, hover, and select effects are styled using CSS rules invoked by JavaScript. These rules don’t exist yet. You will also have to reapply some of the table styles you created in Lesson 8.

1 In the CSS Styles panel, select the last rule in mygreen_styles.css.
Click the New CSS Rule icon in the CSS Styles panel.

The new rule will be inserted at the end of the style sheet.

2 In the Selector Type menu, choose Class.
In the Selector Name field, enter odd.
Click OK.

3 In the Background category, enter #FFC and click OK.

4 Create a new CSS class for even.
Assign it a background color of #CFC.

5 Create a new CSS class for rowhover.
Assign it a background color of #9C6.

6 Create a new CSS class for rowselect.
In the Type category Color field, enter #FFF.
Assign it a background color of #990.

7 Save all files.

A dialog box may appear indicating that files are being added to the SpryAssets folder to enable the Spry functionality. Before you test the Spry functionality, let’s reapply the styling for the Date and Cost columns.

8 If necessary, click OK.

9 Insert the cursor in the header for the Date column.
Select the <th> tag selector.
From the Class menu in the Property inspector, choose w100.

10 Select the cells in both rows of the Cost column.
From the Class menu, choose Cost.

The last step is to re-create the table caption. Tag selectors can help you locate specific markup when you work in Code view.

11 Insert the cursor in the table. Click the <table> tag selector. Switch to Code view.
Insert the cursor directly after the opening table tag.
Type <caption>2010 Event Calendar</caption>.

12 Switch to Design view. Save all files.

13 Preview the page in Live view and test the table behaviors.

When you click the header fields, the table sorts based on the data content. When you move the cursor over the rows, they change color. When you click any individual data row, the color of the row changes completely and the text appears in white.

The only problem seems to be coming from the Cost column, which is displaying an error message, NaN, that stands for “Not a Number.” The original table was not designed for this use, and the data contains non-numeric characters. You’ll have to remove these characters from the data table to complete the component.

Updating HTML data

You can correct the data table manually, or you can use Dreamweaver’s Find/Replace command.

1 Open html-data.html from the site root folder. Select the dollar sign ($) in the first row of the Events table. Press Ctrl-F/Cmd-F.

The Find and Replace dialog box appears. The dollar sign ($) is entered in the Find window automatically.

2 Leave the Replace window empty. Confirm that the Current Document and Text options are selected, and click Replace.

The selected dollar sign is removed and Dreamweaver automatically selects the next dollar sign in the file.

3 Continue to click Replace to remove the dollar signs one at a time, or click Replace All to remove them all at once.

Clicking Replace All will close the Find and Replace dialog box. To perform the next step you will have to press Ctrl-F/Cmd-F to re-open the Find and Replace dialog box.

4 Replace the text Free with the number 0 (zero).
Delete the word Donation and leave the cell blank.

5 Close the Find and Replace dialog box. Save and close html-data.html.

6 Click the tab for events.html to bring it to the front. If necessary, preview the page in Live view.

Now that you have removed the non-numeric characters, the HTML-based data displays properly. But users may be confused by prices appearing without dollar signs. Although the dollar sign is incompatible in the data file, there’s a simple trick that will allow you to use it in the final display.

7 Switch back to Design view. Insert the cursor before the data placeholder {cost}. Type $.

The placeholder now appears as ${cost}

8 Preview the document in Live view.

By adding the dollar sign before the data placeholder, Dreamweaver clones it automatically for each data row. You can use this method for all sorts of introductory characters and text.

9 Save all files.

Spry data sets can also be based on XML data.

Working with XML data

XML is a markup language closely related to HTML. They both use the same tag-based method for marking up text. The reason XML is called extensible is because, unlike HTML, you create your own tag names.

The language was invented directly in response to HTML’s limitations in dealing with data in web applications. The simplest way to explain their different roles is this: HTML was designed to display data; XML was designed to define it.

In XML, data elements are placed between opening and closing tag pairs, like this:

<company>Meridien GreenStart</company>

XML can be written by hand or it can be exported from a number of data applications, such as MS Access, MS Excel, FileMaker Pro, and large-scale databases like Oracle and SQL Server. Non-proprietary databases—such as MySQL—are very popular on the web and are also compatible with XML. You will learn about other types of web-based database applications later in this lesson.

Spry data sets can use XML data and HTML data tables interchangeably.

1 If necessary, open events.html. In Design view, insert a new paragraph after the Return to top hyperlink.

The XML-based data set must be inserted outside the <div> element containing the HTML data set. Nested Spry data sets are not allowed in Dreamweaver.

2 In the Insert panel, click the Spry Data Set button.

The Spry Data Set dialog box appears.

3 From the Select Data Type menu, choose XML.
In the Data Set Name field, enter ds_classes.
Browse and select classes.xml from the lesson14 > resources folder.

4 Select the classes tag and note the Data Preview window. Click Next.

The Set Data Options screen appears.

5 For the data type for the first four columns, choose string.
For the Cost column, choose Number.
In the Sort Column menu, choose Class.

This file doesn’t contain date data; the entire contents can be treated as text or numbers.

6 Click Next. For the Insert Table option, click Set Up.

7 Make sure the Sort Column When Header Is Clicked option is selected.
In the Odd Row Class field, enter or select odd.
In the Even Row Class field, enter or select even.
In the Hover Class field, enter or select rowhover.
In the Select Class field, enter or select rowselect.
Click OK.

Selecting the class names from the menus can prevent you from typing the names incorrectly. Since the CSS classes already exist, the new table should be ready to function.

8 Click Done.

The XML-based Spry table is inserted in the page.

9 Save all files and preview the page in Live View.

Both tables display the appropriate data and behave just like the sample you previewed at the beginning of the lesson.

Spry data sets provide a powerful option for importing and displaying HTML and XML source materials dynamically, but it’s not a perfect solution. Although Ajax makes the data display dynamic, the data files are anything but. For one thing, there’s no native method for updating HTML and XML data that changes quickly, like sports scores and weather forecasts.

Instead, developers store data in traditional databases and then, using custom scripting, generate HTML and XML data files periodically or interactively upon a user request. This type of hybrid system brings together the benefits of both techniques, and many sites are following this model today. Although many sites have switched over to Ajax completely, quite a few are still using ASP, ColdFusion, and PHP. In upcoming exercises, you’ll explore how some of these powerful tools and capabilities work.

Choosing a server model

If you decide to build dynamic web applications, one of the first choices you have to make before you write a single line of code is the server model you’ll use for your site. Many factors go into this decision, including the purpose of the site, the type of applications you wish to develop, the cost of the server model, and even the type of database you wish to use. In some cases, the choice of database will select the server; in others, the reverse will be true.

For example, the MS Access database favors the ASP server model, which runs on Windows Server operating systems. On the other hand, the MySQL database, which is typically combined with either ColdFusion or PHP, runs equally well on all servers. Here’s a quick overview of the major server models that you should keep in mind while you are making your choice:

ASP (Active Server Pages) is a Microsoft technology that runs natively in Windows. Dreamweaver provides server behaviors for ASP in Visual Basic (VBScript) but not in JavaScript. While some think it’s difficult to learn and use, it’s included for free with Microsoft’s Internet Information Services (IIS), which means that all Windows users can immediately create applications with little extra setup. Also available is ASP.NET, the successor to ASP, developed to correct some of ASP’s limitations and increase the speed and power of the resulting web applications. Dreamweaver no longer provides server behaviors for ASP JavaScript and ASP.NET, although you will still be able to hand-code and test these pages in the program.

ColdFusion is an Adobe server technology that uses a tag-based syntax that some feel is easier to learn and use than ASP or PHP. For many processes, ColdFusion requires fewer lines of code, which provides advantages during development and deployment of web applications. Unlike the other server technologies described here, ColdFusion is not free, although some feel that the productivity gains are worth the extra cost. ColdFusion can run on Windows, Linux/Unix, and Macintosh servers. To get a head start, you can download and install the free Developer’s Edition of ColdFusion that enables you to build a fully workable dynamic site locally, before you upload it to the Internet.

PHP (PHP Hypertext Processor), originally known as Personal Home Page, is now one of the most popular languages used on the web. It is free and works well with a variety of databases and other services. It offers a similar level of difficulty as ASP, but because of its popularity there are plenty of resources available to obtain code examples as well as support, which is also free, for the most part.

Configuring a local web server

There are two ways to test dynamic pages. You can upload them to your web host and test them live on the Internet; or, you can test the files before you upload them on your own personal computer. While nothing beats the authenticity of the actual Internet servers that will host your site, a local server offers advantages of both speed and security. It also allows you to work offline, without a live connection to the Internet.

Before you can test any of the dynamic web pages that you will build in the next lesson, you must install the applications and components needed for a local web server. This process is tedious and prone to error. It consists of numerous critical steps for loading and configuring all aspects of your chosen environment. As such, it is outside the scope of this book. Luckily, there are many sources both in print and online that can assist you in this endeavor. Here are a few:

In Print:

• Adobe Dreamweaver CS3 with ASP, ColdFusion, and PHP: Training from the Source, Jeffrey Bardzell and Bob Flynn, Adobe Press (2007)

Online:

• ASP and IIS—tinyurl.com/2yx46y or tinyurl.com/ybhfaef

• ColdFusion—tinyurl.com/2h8hey

• PHP—tinyurl.com/39p3gh

Setting up a testing server

At this point, you should have chosen your server model and successfully installed a local testing server. To preview and test dynamic pages, you need to connect to a testing server in Dreamweaver. You may also use the actual web server where you intend to upload your website.

When you choose to test a particular page, Dreamweaver copies the necessary files to the testing server and then loads the document in a browser or in Live view. The testing server is configured in Dreamweaver’s Site Setup dialog box.

1 Select Site > Manage Sites.

2 Select DW-CIB from the Manage Sites dialog box. Click Edit.

3 Select the Servers category.

If you have an existing server configured, you can click the check box under the Testing column in the server list to identify it as your testing server. For the purpose of the following exercises, we’re assuming you have chosen and configured PHP/MySQL as your server model and will use an Apache local web server to test pages on your computer.

The specific examples shown in this book are based on the Windows/Macintosh Apache MySQL PHP (WAMP/MAMP) web servers, available for download at tinyurl.com/crxqfs.

4 Click the Add New Server button at the bottom of the server list.

5 Name the server Local-PHP.
From the Connect Using menu, choose Local/Network.

6 Click the Browse button to the right of the Server Folder field.
Navigate to the MAMP/htdocs folder (In Windows, this folder will probably be named WAMP/www).

7 Create a new folder in htdocs and name it DWCIB-Test.
If necessary, double-click the new folder to open it.
Click Select/Choose.

For Mac users, the Server Folder field displays the path Applications/MAMP/htdocs/DWCIB-Test. For Windows users, the path will be C:wampwww.

8 Enter the path to the testing site in the Web URL field.

For the MAMP PHP testing server, the default URL will probably be http://Localhost:8888/DWCIB-Test, but for other types of server models, the URL may be different. Enter the URL appropriate for your server. Without the correct URL, the page may not load correctly in your local server.

9 Click the Advanced button.

The dialog box displays the Advanced configuration options.

10 From the Server Model menu, choose PHP MySQL.

11 Click Save.

12 Click the Testing option in the Servers category to enable the testing server.

13 Click Save to dismiss the Site Setup dialog box. Dreamweaver will probably prompt you to rebuild the cache. Click OK.

14 Click Done to close the Manage Sites dialog box.

Your testing server for PHP is now configured. Although the server is intended for one specific language, other scripting languages may still be supported, depending on your server setup. As you may have noticed from the menu in step 10, Dreamweaver supports all the major server models. The importance of what server model you select can’t be overstated. Changing server models once you start to build pages would probably require you to scrap all your work and start over.

Building database applications

One thing ties all of these applications together. They all require a database of some sort. Database applications come in two basic categories: stand-alone and server-based. Stand-alone applications like MS Access and Apple FileMaker Pro are usually accessible by one user at a time in a desktop environment. In some cases, multiple users can be allowed to access the data, but the total number of simultaneous users is typically small. Server-based databases—like IBM DB2, Oracle, and SQL Server—are much more robust and can easily host thousands of simultaneous requests for information. But with this power comes a hefty price tag. Between these two tiers exists a popular alternative: MySQL, which offers server-based capabilities at a great price—free. A more robust enterprise version of MySQL is also available, but it’s not free. Check it out at tinyurl.com/235onn.

For the purposes of creating dynamic applications on the Internet, both types of databases can be used effectively. Which one you will use depends primarily on the type of data and how much of it you need to store, how many users will access the data at any particular time, and cost. If you expect the number of simultaneous users to be from 1 to 1000, then a stand-alone database application may work for you. If you’re trying to build the next Amazon.com, then you need to focus exclusively on server-based applications.

Luckily for the purposes of this lesson, Dreamweaver interfaces with stand-alone and server-based databases in an almost identical fashion.

Database design basics

A database is similar to a spreadsheet. Data is stored in a series of columns and rows. Spreadsheets typically supply the names of the columns and rows for you, using letters (A, B, C) for the columns and numbers (1, 2, 3) for the rows. Databases differ in this area by requiring you to supply the column, or field, names. Rows, or records, are usually delineated with unique numbers or IDs. Some databases refer to these as unique keys, or just keys. The key allows you or your data application to retrieve a specific record or set of records.

Spreadsheets (left) and databases (right) have common roots and can perform similar tasks.

Simple databases store all the information being gathered in a single table, usually called a flat file. Using a single table for everything often leads to the duplication of data when certain types of information are entered multiple times, as when you take new orders from repeat customers. For example, the customer’s name, address, and phone number are entered in the same table for each order they place. This type of redundant data bloats the size of the database unnecessarily and can cause errors over time. For example, if an order is shipped to an address listed in a previous order.

One way to prevent duplication is to separate certain types of data into their own tables and then link the various tables together. This process of linking multiple tables creates what is called a relational database and makes for a much more efficient system.

Relational databases typically store the customer and product information as separate functions, and then bring them together in an orders table that keeps track of what products are ordered by each customer. That way, if any changes need to be made to a customer or product record, it only has to be made in one place, where it will instantly update all other instances. All the popular databases in use today support these types of relationships.

Relational databases store information in separate tables and connect them together in logical relationships. This prevents data duplication and makes the database function more efficiently.

An online database is typically stored within a subfolder of the target website, where it can be accessed by any page on the site. Databases can provide a variety of different types of information, from product descriptions and pricing, to customer names and addresses, to complete site editorial content. While some databases are configured to be read-only, where data is served in only one direction, most online databases are capable of both serving and capturing data, providing the utmost power and flexibility.

Connecting to a database

Once your database is created, properly uploaded, and configured, you need to connect each dynamic page to it before the data can be accessed. Each server model features specific methods for connecting to a database. For our exercises, we will concentrate on the PHP/MySQL using the WAMP/MAMP environment as noted earlier.

Connecting to MySQL

In a PHP/MySQL environment, database connections are handled by custom scripts or by configuration files located on your hard drive or on the server. These scripts and configuration files handle the connection and any required user authentication.

There are numerous ways to write the code for these items, depending on the server model and specific database, so it’s best to consult your server administrator or support staff to obtain the proper syntax. Many times, Dreamweaver can help you create the needed files and write the necessary code. In this exercise, you will connect to a MySQL database on a PHP server model.

1 Before attempting to complete this exercise, you first have to install and configure the necessary files and components for a PHP server and MySQL database.

Here is a sample start page for a MAMP installation. The URL of this start page and displays the port: 8888 for the MAMP Apache server and the page displays the port: 8889 for the MySQL database server. Note the host name, ports, and other configuration settings in your own start page. You will need these specifications to connect to your servers and databases.

The master Lessons folder on the disc that came with this book contains a MySQL folder holding the greendata database intended for this training. Copy this database to the testing server as required under your PHP/MySQL server installation.

If the greendata MySQL database is installed correctly, it will appear in the database list displayed on the phpAdmin page.

2 Configure a testing server in Dreamweaver for PHP/MySQL.

The PHP/MySQL configuration should point to the folder on your hard drive that will eventually hold your web content on the testing server. In Windows, it’s typically named www; on the Mac it’s called htdocs. However, the name on your server may be different.

To learn more about setting up a testing server, check out the Dreamweaver Help file or tinyurl.com/ybn4hul.

Although you wouldn’t normally develop applications for ASP and PHP at the same time for a single site, it’s possible to install and configure both servers to run concurrently, if desired. Check out tinyurl.com/y9at5ab to learn how.

3 If necessary, launch Dreamweaver.
Create a new page based on the site template.
Save the page into the root folder as products.php.

MySQL databases can be used by all major server models. In this exercise, you’ll use PHP.

4 Click the plus () icon in the Databases panel and choose MySQL Connection.

The MySQL Connection dialog box opens.

5 When the MySQL Connection dialog box opens, create a connection name and enter your server name, your user name and password, and the database name. If you have multiple databases available or if you are unsure of the exact name of the database, you can click the Select button and choose it from a list.

6 Click Test.

Dreamweaver reports a successful connection to the database.

7 Click OK. Examine the Databases panel.

The Databases panel displays the name of your database connection.

8 Expand the database listing.

The listing displays the stored procedures, tables, and views contained within the database.

9 Save all files.

In this lesson, you learned how to work with HTML and XML data. Then, you selected a server model, configured a testing server, and created a database connection. You have developed the foundation for a dynamic website using PHP. In the next lesson, you will use this environment to build dynamic pages.

Review questions

1 What advantage does Ajax/Spry have over traditional data applications?

2 True or False: XML is a method for storing data in a plain-text file for use in web applications.

3 What is a server model?

4 What is a testing server?

5 You have a file compatible with your server model (.asp, .cfm, or .php), but your database doesn’t appear in the Databases panel. How can you make the connection appear in the panel again?

6 True or False: The MySQL database can be used only on Linux/Unix and OS X server platforms.

Review answers

1 Ajax/Spry applications don’t have to reload an entire page; they can update data in real time.

2 True. XML is similar to HTML and is used to identify data.

3 A server model is the basic environment used to build dynamic web applications. It also encompasses specific programming languages and scripting models, such as ASP, ColdFusion, and PHP.

4 A testing server is a server where dynamic pages are tested using a compatible server model. It is set up in the Site Setup dialog box.

5 Examine the Databases panel and the displayed steps for connecting to your data source. Complete any steps that are not checked. The data source should then be displayed again.

6 False. MySQL can be used on any web server.