Getting databases on the screen using Dreamweaver    

 <Database Index


Building the Database Page

The database connection and recordset will not produce output on the screen. To see your database you must build a page to view it.

 

  • The page you make must be a dynamic page at outset. (in this case a PHP page)
  • The page can be treated as a normal web page in the editor. It can be formatted and laid out using tables etc exactly as on an HTML page

 

A number of elements can be added from the Application tab on the Insert Bar (MX 2004)

(1) Dynamic Table dynamic table

This will allow you to see the database.

    The dialogue box below gives you the choice of how many records you can see on the screen.
    You need to input which Recordset the page is using.

 

dynamic table input screen

 


See an Example of this from a live database Attractions mySQL Database - all records

(2) Recordset Navigation recordsetnavigation icon

 

This will add a navigation bar to your database. It will need to be customised.
    Open up Server Behaviours in the Applications group of panels
  • Select each of the options you want to use and click on the appropriate behaviour.
    You may need to delete any existing behaviour that are preloaded. (see the code)

 

(3) Recordset Statisics

This displays a counter showing which record is displaying and how many records there are in the Recordset You can insert this two ways:

  • Select the icon Recordset Statistics on the Isert Bar/Application tab
  • Choose Insert > Application Objects > Recordset Navigation Status.


The Recordset Navigation Status server object inserts a text record counter You can use Dreamweaver’s page-design tools to customize the record counter.

When viewed in the Live Data window or a browser the counter will appear similar to the one shown below:

Records 1 to 1 of 10

Now find out how to manipulate your MYSQL database on line including how to make it searchable