New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Start learning with our library of video tutorials taught by experts. Get started

Dreamweaver CS3 Beyond the Basics
Illustration by

Filtering database records


From:

Dreamweaver CS3 Beyond the Basics

with James Williamson

Video: Filtering database records

One of the strengths of working with dynamic data is the ability to have the data displaying on the page change based on certain conditions. In this exercise, we'll begin the process of having one page respond to information passed from another. This technique literally lets you build dozens, even hundreds of pages, using just a few pages that respond and change the data on the page based on requests and parameters from other pages. So you can see we have the lynda.com website up; this is a website you have probably seen before.
Expand all | Collapse all
  1. 2m 3s
    1. Welcome
      1m 17s
    2. Using the exercise files
      46s
  2. 1h 23m
    1. Reviewing the Coding toolbar
      8m 42s
    2. Customizing the Coding toolbar
      9m 52s
    3. Taking advantage of Code Hinting
      7m 20s
    4. Using snippets and shortcuts
      11m 10s
    5. Using the Quick Tag Editor
      5m 18s
    6. Using Find and Replace
      9m 50s
    7. Regular expressions
      5m 39s
    8. Using Bridge with Dreamweaver CS3
      8m 28s
    9. Round-trip editing with Photoshop CS3
      3m 40s
    10. Leveraging image variables in Photoshop CS3
      7m 32s
    11. Integrating external variables into your workflow
      6m 16s
  3. 37m 26s
    1. Understanding the CSS Styles panel
      7m 59s
    2. Understanding the Cascade
      5m 50s
    3. Understanding Inheritance
      5m 8s
    4. Understanding Specificity
      7m 5s
    5. Managing CSS styles
      5m 4s
    6. Using Design-Time style sheets
      6m 20s
  4. 2h 19m
    1. Using the new CSS template pages
      5m 59s
    2. Understanding DIV tag structure and layout
      12m 0s
    3. Understanding the CSS box model
      10m 0s
    4. Using absolute and relative positioning
      8m 35s
    5. Understanding floating elements
      7m 9s
    6. Clearing floats
      7m 19s
    7. Using floats to control page layout
      3m 45s
    8. Building structure and assigning IDs
      10m 19s
    9. Applying basic styling to structured content
      11m 14s
    10. Positioning container elements
      11m 4s
    11. Enhancing layouts with background graphics
      11m 48s
    12. Creating faux columns with background graphics
      8m 55s
    13. Creating rounded corners with background graphics
      9m 17s
    14. Building navigation with CSS
      16m 57s
    15. Using Dreamweaver's Browser Check feature
      5m 31s
  5. 53m 22s
    1. Creating properly structured forms
      6m 30s
    2. Creating accessible forms
      6m 41s
    3. Using CSS to lay out form structure
      7m 40s
    4. Creating vertical columns for form elements
      7m 48s
    5. Adding user feedback
      5m 52s
    6. Applying advanced styling to forms
      8m 11s
    7. Client-side form validation
      4m 17s
    8. Validating forms with the Spry Validation tools
      6m 23s
  6. 1h 20m
    1. Understanding the Spry framework
      3m 43s
    2. Defining a data source for use in Spry
      3m 56s
    3. Creating a Spry table
      8m 8s
    4. Using the Spry widgets
      8m 11s
    5. Connecting various data sets
      4m 50s
    6. Understanding Spry widget structures
      7m 1s
    7. Applying custom styles to Spry widgets
      6m 24s
    8. Applying additional custom styles to Spry widgets
      8m 46s
    9. Controlling Spry widget behaviors with JavaScript
      6m 0s
    10. Controlling Spry widget animations with JavaScript
      9m 31s
    11. Creating effects with Spry behaviors
      4m 42s
    12. Hand-coding Spry
      9m 11s
  7. 1h 11m
    1. Creating a base template
      8m 6s
    2. Creating editable attributes
      6m 26s
    3. Creating a new page from a template
      7m 42s
    4. Applying a template to an existing page
      4m 36s
    5. Creating nested templates
      5m 24s
    6. Using repeating regions
      6m 34s
    7. Creating editable and non-editable optional regions
      6m 0s
    8. Using template parameters
      7m 26s
    9. Using template expressions
      9m 59s
    10. Using conditional template expressions
      8m 54s
  8. 54m 40s
    1. Examining XML structure
      2m 44s
    2. Creating an XML document
      9m 9s
    3. Using the CDATA structure
      5m 7s
    4. Creating an XSLT file
      4m 33s
    5. Binding data from an XML to an XSLT document
      5m 6s
    6. Inserting repeating regions into an XSL document
      5m 16s
    7. Creating a client-side XSL transformation
      2m 52s
    8. Styling a remote RSS feed
      7m 29s
    9. Creating a server-side XSL transformation
      5m 31s
    10. Writing XSL expressions
      6m 53s
  9. 1h 2m
    1. Overview of building dynamic websites
      1m 35s
    2. Installing PHP, MySQL, and Apache on Mac
      3m 22s
    3. Installing PHP, MySQL, and Apache on Windows
      3m 54s
    4. Creating a MySQL database
      3m 16s
    5. Defining a testing server and database bindings
      6m 14s
    6. Creating a database recordset
      4m 35s
    7. Adding dynamic content to the page
      5m 14s
    8. Creating repeating regions of dynamic content
      7m 6s
    9. Filtering database records
      7m 39s
    10. Using the Live Preview
      10m 22s
    11. Passing URL parameters
      4m 23s
    12. Dynamically generating links
      5m 18s
  10. 57m 9s
    1. Understanding behaviors
      5m 16s
    2. Installing additional behaviors
      3m 39s
    3. Planning to create a custom behavior
      3m 42s
    4. Examining existing behaviors
      5m 32s
    5. Building a behavior function
      7m 23s
    6. Creating an Action file
      6m 48s
    7. Enabling behavior functions
      9m 1s
    8. Initializing the user interface for a behavior
      3m 9s
    9. Loading behaviors in Dreamweaver
      6m 47s
    10. Testing and debugging behaviors
      5m 52s
  11. 27m 12s
    1. Running reports
      7m 41s
    2. Checking and validating links
      3m 40s
    3. Using cloaking
      5m 42s
    4. Using Check In/Check Out
      4m 3s
    5. Using Design Notes
      6m 6s
  12. 20s
    1. Goodbye
      20s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Dreamweaver CS3 Beyond the Basics
11h 10m Intermediate Sep 21, 2007

Viewers: in countries Watching now:

Covering diverse topics such as improving workflow and managing CSS styles, Dreamweaver CS3 Beyond the Basics is a hands-on course that teaches users how to move beyond standard, static websites. Instructor James Williamson explores how to increase productivity, interactivity, and accessibility with Dreamweaver. He also discusses how to extend the application's capabilities with XML and XSL. Exercise files accompany the tutorials.

Topics include:
  • Reviewing and customizing the coding toolbar
  • Understanding the CSS Styles panel
  • Using absolute and relative positioning
  • Creating accessible forms
  • Building AJAX pages with the Spry framework
  • Extending templates
  • Working with XML and XSL
  • Building dynamic content
  • Creating custom behaviors in Dreamweaver
  • Running reports
Subject:
Web
Software:
Dreamweaver
Author:
James Williamson

Filtering database records

One of the strengths of working with dynamic data is the ability to have the data displaying on the page change based on certain conditions. In this exercise, we'll begin the process of having one page respond to information passed from another. This technique literally lets you build dozens, even hundreds of pages, using just a few pages that respond and change the data on the page based on requests and parameters from other pages. So you can see we have the lynda.com website up; this is a website you have probably seen before.

I'm just going to browse to Lynda's class listings. Now I want to point out the page that we are on right now. We are on a page called modlisting.asp. So we are going to browse through the rather extensive library at lynda.com and as we scroll down, we can see here some Dreamweaver training. Here is Dreamweaver CS3 Dynamic Development as a matter of fact, so I am going to click on that. And when I do I go to the page called modPage and I notice there is something on the tail end of the URL. It says ID=424, okay.

So I am going to hit the Back button and maybe I am also interested in the Essential Training title. So I click on that. And once again I find myself on the modPage.asp. So we haven't gone to another page; we are still on the modPage. But we've passed a new ID, this one is 410. So the modlisting page is passing what's known as a URL parameter, and this parameter is ID=410. So several areas on this page are setup to respond to the data based on the parameter that's being passed. One of those parameters for example is the description of the title, right there.

So that's what we are going to do with our Artists page and our Bio page. So I am going to close out of Firefox and jump back into our artists.php file. So if you are following along the exercise list, let's go back and open up the Artists page. Now we have our Artists page pretty much finished up. So we need to work on the other page, the one that's going to be receiving these parameters, and we don't really have a bio's page yet so we are just going to go ahead and open up one of the existing bio pages and just sort of use it as a template more or less. So since Aimee's name comes first, we'll go ahead and open up her file again.

So here is the bio's page. And the bio's page has several elements that change with each artist and we need to be aware of what those elements are. We have the banner graphic and we have her name again, we have her head shot one more time. And we have some dummy text here to indicate where the bio is going to go, and as I scroll down we have a link to Aimee's Gallery. We have made another decision too. Even though we have a Gallery page, we'd like to showcase at least one painting here on this page. So we are going to modify this page a little bit. We are going to go ahead and modify this page a little bit and place a larger image on the page as well.

So in order for us to use this file in our server-side workflow it needs to be a PHP file. Right now I notice that this is aimee.htm. We are just going to use this as a template for Bio page anyway. So we are going to go up to File and do a Save As, and I am going to save this in my root directory. So I'll save it in our root directory and I am going to save it as bio.php. So remember to add the PHP extension and we'll click Save. It's going to ask me if I want to update links, and I am going to go ahead and just click Yes. All the links in it are now relative to the root directory and we're going in good shape.

So we have a file here to use as a template. In our next exercise we'll replace the placeholder data, but we still have one more thing we have to do here and we'll need another recordset. If you'll notice, the recordset that we defined in our artists.php page isn't in the Bindings panel anymore, and the reason for that is the recordset really is just a SQL query on the Artists page. So we don't have that SQL query on the Bio page. So our Bindings panel doesn't display our recordset. Now, you can copy and paste recordsets from one page to another. There is nothing wrong with doing that, but the recordset on the Artists page does not contain the information that we need on the Bio page.

As a matter of fact, the Bio page needs to be very selective about which information displays because we only want to display information from one artist and not all of them. So we are going to do a brand new recordset and as we create the recordset, we'll talk about filtering data. So I am going to go up to the Bindings panel, and click on the plus symbol and you will notice that I have recordset available to me so I am going to click on that. I have to give this another name and this time I am going to go ahead and call this rsArtistDetail.

So I like to be descriptive in my recordsets because this is the name of the query and if you are looking in Code view you really would like to know what type of data this query is collecting. So I am going to go ahead in Connection and choose dsArtists from our data source and once again we see artists come up as the selected table. Now again I could select all of my data, which I don't want, or I could just do Selected. That's what I need here. So we're going to choose id. We want that because that's going to help us identify which Chris we are dealing with. We will need our firstName and our lastName, and again you may want to hold down the Ctrl or the Command key, so you can select non-contiguous items.

We need shortName. We don't need tagLine, however, but we do need bio, we need smImg because that's our headshot, we need lgImg and we need imageCaption. So you can see we need the majority of the data. The only thing we're sort of leaving behind is the tagLine. Now here's where we need to understand what filtering can do for us. I am going to grab the Filter pulldown menu and notice that I can filter by any of the items in the table. The item that does the best job of identifying which record it is, is the id and that is a unique identifier for each of the items in our table.

So I'll choose id and I can make the value Equal To or Greater Than so I can filter out by any of these compound operators. So I am going to choose Equal To. We've got different types of parameters and variables that we can search for. A URL Parameter is what we saw in the example at lynda.com where it's attached in the query string. We also have a Form Variable and that might be like form data that sent using the post method and we've got session variables, server variables that you can go ahead and set. So we have lots of different ways to get information onto the page.

Well, we are going to stick with the URL Parameter. Now I am free to go ahead and name this anything that I'd like. A lot of people just go ahead and leave at the generic id, but I also like to be very descriptive in my variable name. So I am going to go ahead and call this artistID and I am going to use a capital I and a capital D on the end. Just call it artistID. And we can sort these but it's not going to make a lot of sense to sort them because we are just going to return one record and that record is going to be whichever artist we're asking for. Now once again you always want to test your query before you click OK, so I am going to choose Test and this time Dreamweaver is going to prompt me for something because Dreamweaver is going to say okay, you are filtering this data out.

What value do you want to test against? So I can just go ahead and type in say number 4 and if I click OK, I get the artist Dan Keys because he is the fourth record. I click OK again, I could click Test again, pass in a different parameter. This time may be I am going to pass in say 10. Click OK. Now I'll get William Everhart. So by passing in that parameter, that variable, that ID value, I am getting just that particular recordset back and that's exactly what we are looking for.

So I am going to click OK. Click OK one more time. My Bindings panel is now displaying my recordset and we are ready on our next exercise to replace the placeholder data and then add the interactivity between the Artists page and the Bio page.

Find answers to the most frequently asked questions about Dreamweaver CS3 Beyond the Basics.


Expand all | Collapse all
please wait ...
Q: In the Chapter 3 movie “Creating rounded corners with background graphics”, the instructor uses a .last class selector. What are the CSS properties of this selector?
A: The .last selector is as follows:
#current p.last{
background: url(../_images/current_btm_bg.gif) no-repeat bottom
left;
padding-bottom: 2em;
margin: 0;
}
The background is the bottom rounded corner graphic, the bottom padding keeps the type away from the bottom of the box and thus the rounded corners, and the margin ensures that the box elements fit seamlessly with each other.
 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Dreamweaver CS3 Beyond the Basics.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.