DreamWeaver MySQL Dynamic Tables PDF Print E-mail

This tutorial is a continuation of the "Record Insertion" tutorial and will create what is called the "whoswho.php" page. This page will display the member's information that gets entered into our database from "insert.php." If you haven't done that tutorial first click here

In order for the "Dynamic Table" that we place in whoswho.php to work properly we have to install a "recordset" on the page. This tutorial will include the "recordset" instructions.

  1. Create a new php page and call it whoswho.php
  2. Make sure you have a database connection. If you have not closed your insert.php page in DreamWeaver, then you will still see it showing "inserting"
Recordset Icon Select the "Recordset" icon.

The recordset applet will appear. Fill out the form entries as in this image:

Recordset Insertion Applet

Recordset has been added to the page:
Recordset Bindings Panel

Adding the Dynamic Table

Place your cursor anywhere on the design area of whoswho.php

 

Click the "Dynamic Table" dropdown icon: Dynamic Table Dropdown

Dynamic Table Applet - Set the parameters the same as the image:

 

The recordset name is the same as the default name. We are also setting it to show a table that will only provide 10 records at a time. If our Members goes higher than 10, then another page link will be provided so that you can navigate through your members.

Dynamic Table Applet

 

 

 

Click OK

Resulting Page:

 

Don't forget to save this as "whoswho.php"

The result page

 

Upload and test:

At this point you will need to upload the following files and directories:

  • insert.php
  • whoswho.php
  • Connections folder

DreamWeaver is set up to include files that are linked to other files when you use their FTP client. A warning that states "Include dependant files" pops up when you upload a page or directory. If this is the case, select "YES" if this pop up should appear.

If it does not, make sure that you have uploaded all of the files listed above in your web root directory.

 

Once you have done this, open a Browser and go to www.yoursite.com/insert.php

and submit a username, password and enter your e-mail.

If all goes well, the whoswho.php page will show up next and show you your information. You can look at whoswho.php without having to insert info as well. This makes for a great inventory control page.

Whoswho.php page

Also, you can apply CSS to change the style of your HTML tables so that it mirrors the design of your site. This applications can introduced into fully designed pages.

  • Check out PHPMyAdmin on your server and you'll see in the "members" table that "Browse" is now active. Select it and you'll see the structure of your database table and the same information you entered into insert.php