close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

How to get database to populate page template?

Thread began 7/22/2010 4:41 pm by dev396590 | Last modified 7/23/2010 2:45 pm by dev396590 | 1007 views | 7 replies

CraigRBeta Tester

OK. you have your recordsets.

There are many ways of achieving this, both using just dreamweaver and also using dataassist.

Dataassist is useful in a number of ways, especially in creating groups of pages with interrelated data and with some repeating table layouts.

How you approach this depends on how you want to learn, i love the fact that extensions can do a lot for you in just a few clicks, but i find it even more useful if i know what they are doing.

Anyway, lets take a product page for starters, with a recordset from a single table.

create a new page product.php or whatever, based on your template, and place this in the root folder.

Lets say you have a table called tblproducts.

one way to retrieve all the data from this table is SELECT .... FROM tblproducts, where ... is * or a list of field names.

once this is done, you can simply drag the fields you require on your page, from the bindings panel, and drop them on your page.

this will give you (only) the first row from the recordset.

in order to show more rows, you would need to add a repeat region server behavior.

all of this stuff should be in the dreamweaver help files, and it is good practice to understand the principles, so when you analyse the code that dataassist produces, you understand what is going on

using dataassist, this is quite easy.

insert-->Webassist-->DataAssist-->Repeating table.

choose your recorset, number of rows and columns etc, and select the data you want to insert into the table.

Have a play with it and you'll soon get the hang of it.

Once this is done to your satisfaction, create another page for productdetail using the relevant recordset, which would be filtered by the url variable passed from the product page, so only the relevant product detail can be displayed.

if it helps, here is a link to a visual example of something i am working on.

the product page has a recordset filtered, according to the menu item chosen from 'products', which passes a url variable to the page.

the repeating table is a 3x4 table created using the dataassist repeating table wizard.

if you hover over any item , you will see it is a link to the product detail page, with the relevant itemid (and categoryid) passed as a url parameter.

hope this helps

http://www.test.stonepits.com/

click a submenu item under 'products'

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...