Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Creating a database recordset

From: Dreamweaver CS3 Beyond the Basics

Video: Creating a database recordset

Now that we have our database defined, let's look at taking advantage of dynamic content. Currently we have one artist page that should list all of our artists. So if you are following along in the example files with me, go ahead and open up the artist.php found in your example files. If I scroll down I see a listing of one artist and we have Aimme's name, we have a short default description text, an image, and then links to her bio page and her gallery page. Well, since we have all of our artists stored within a database, it would be really nice if we could go ahead and populate all of this information from our database without having to do it manually. So our first exercise would be to go ahead and populate this list using our database.

Creating a database recordset

Now that we have our database defined, let's look at taking advantage of dynamic content. Currently we have one artist page that should list all of our artists. So if you are following along in the example files with me, go ahead and open up the artist.php found in your example files. If I scroll down I see a listing of one artist and we have Aimme's name, we have a short default description text, an image, and then links to her bio page and her gallery page. Well, since we have all of our artists stored within a database, it would be really nice if we could go ahead and populate all of this information from our database without having to do it manually. So our first exercise would be to go ahead and populate this list using our database.

To use our database information we'll need to have a recordset and we built our recordset in our Bindings panel in the Application panel group. So if you have your Application panel group open, just click on your Bindings panel. If you don't, you can go to Window and you can choose Bindings right there. So a recordset really is just a SQL query that's going to go out to our database and pull specific information in. This could be every bit of information from our database or we could limit the amount of information that we need for that specific recordset.

So we're going to go to our Bindings panel and click on the plus symbol and we're going to choose from the very top, recordset (Query). So I'll go ahead and choose that. So we have our recordset dialog box up and this is what we use to go ahead and define our recordsets. Now, recordsets are really just SQL queries. So what we are doing here is having Dreamweaver go ahead and write the SQL query for us itself and in this particular version of the recordset dialog box, it can create fairly simple SQL queries. If you need anything more advanced than one table or two tables, you'll click on the Advanced button and you can use some of its more advanced tools or even hand code the SQL query yourself.

So the first thing that we'll need to do is go ahead and establish our recordset name. So I am just gong to call this rsArtists and notice that I am using a prefix of rs. It's not required, but it's a good idea to go ahead and use ds for data sources and rs for recordsets and that sort of thing. So Connection, I am going to go ahead and choose dsArtists and notice that it goes in and populates using the artist table. There is only one table in this database, so if there were multiple tables I would have a pulldown menu and I'd be able to select from multiple tables, but we just have the artists table.

Now next we can choose to bring in all the information from that table or just selected info. I want to filter this out because our artist preview listing that we're going to create doesn't require all the data in the database. So I can go through now and select just the data I need. So I am going to select id and then firstName and lastName, and you might want to hold either the Command or if you're on the PC the Ctrl key down so that you can select non-contiguous items in case you run into something you don't really need. We're also going to need shortName. We will need tagline. We will not need bio. We don't need that, so we're going to leave that alone. We will need the small image, we don't need the large image and we also don't need the image caption.

So we're going to leave behind the bio, the large image and the image caption. Now most of these are pretty self- explanatory except for id. Id is a unique identifier. Each artist has their own unique number in the database and we can use that to identify that artist if we're ever linking to a page where we need to pass in information about just that particular artist. Now, you'll notice that we have another pulldown menu for filtering our information and sorting it. We don't necessarily want to filter our information. We just want to bring in everything. We don't really need to put any conditions on what we bring in, but for sorting we do want to sort.

So I am going to sort this by firstName. Since all of our links in our site sort our artists by first name, we're going to do that and we'll choose ascending. Now we could go ahead and click OK, but it's a good idea to go ahead and test any recordset that you create while you're still in the recordset dialog box. So I am going to choose test and I get to test MySQL statement and I can see that Aimme's name is first and so that is in alphabetical order, exactly the way I was hoping. You can also see their id right over here as it corresponds to their space within the table. There is our lastName, our shortName, our tagline and our small images. So notice that we don't see any bio or large image or caption information. So I am going to click OK and finally OK.

Now it may take a moment. In the Bindings panel you're going to see a new icon for our recordset. I am going to expand that and I can see inside that I have access to the id, the firstName, lastName, shortName, tagline and small image. So now that we have defined our recordset, we can go ahead and display this information on the page and that's what we're going to do in our next exercise.

Show transcript

This video is part of

Image for Dreamweaver CS3 Beyond the Basics
Dreamweaver CS3 Beyond the Basics

102 video lessons · 38691 viewers

James Williamson
Author

 
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

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
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.


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 "Already a member? Log in

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

Your file was successfully uploaded.

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.