Display conference information

In this section of the tutorial you will learn how to display conference information from the database. Before starting to work, make sure you have followed the steps in the previous topic, and that you have a correctly configured Dreamweaver site and database connection.

This page will contain a simple dynamic table that shows conference information, and a link to add new entries.

The steps to create this page are:

1. Open the index page in the site root.

2. Create a new recordset that retrieves all records and information from the conferences_con table. To add a new recordset, go to the Bindings tab > Plus (+) > Recordset (Query). Configure the user interface as shown below:

• For the Name enter rsConferences.

• In the Connection drop-down menu select the database connection created earlier.

• In the Table drop-down menu select the conference_con table

• In the Sort drop-down menu select start_date_con, and for the method select Descending. This is done in order to retrieve conferences ordered by their start date.
  
  
   

• After you have configured the user interface, click OK to close it and apply the changes.

3. Next you have to add the Dynamic Table that will display the information. Go to the Insert bar > Application tab and click on the Dynamic Table icon. In the user interface that opens, select the recordset you've created at step 2 and select to display all records:
   
   
    

4. From the table inserted into the page select and remove the first column entirely. It displays the id_con table column, which is not needed. Also replace all of the default column titles (which are in fact the table column names) with more suggestive names:

• title_con > Title

• start_date_con > Start date

• end_date_con > End date

• building_con > Conference center

• address_con > Address

5. Save the page and preview it in a browser. If using the provided script, some entries will be displayed:
   
   
    

6. Next you have to create a link that will allow users to add new conferences to the list:

• Create a  new paragraph below the dynamic table and enter Add conference.

• Select the entered text and click on the folder icon in the Property Inspector. In the dialog box that opens select the add file.

• Click OK to complete creating the link.

In the next topic you will learn how to create the form that allows adding new conferences, while enforcing some rules on dates and buildings.