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

Defining a testing server and database bindings

From: Dreamweaver CS3 Beyond the Basics

Video: Defining a testing server and database bindings

To begin creating dynamic pages in Dreamweaver, we will need to modify our site with a proper remote folder information and specify the location of our testing server. So we are back in Dreamweaver, and we are going to go ahead and take care of all that by editing our newly defined Chapter 8 site. So I am going to go up to the menu, to Site, and choose Manage Sites. I will choose our Chapter 8 site, and I am going to click on the Edit button. So the first thing I want to do is go to my Remote Info, and on my Remote Info instead of Access being None, I am going to change that to Local/Network, because we are going to be developing locally. Depending upon whether you are developing on a Mac or a PC, we are going to have a slight difference here. We are on a Mac, so when I click on the Browse for Remote Folder, I am going to go to my Applications, and I am going to scroll down and find the MAMP folder, and remember we are going to be uploading our files directly into the htdocs folder. In some cases you might want to put in a subdirectory that's project based, but at this point we are just going to go ahead and upload files directly to the root server. So we are going to click Choose.

Defining a testing server and database bindings

To begin creating dynamic pages in Dreamweaver, we will need to modify our site with a proper remote folder information and specify the location of our testing server. So we are back in Dreamweaver, and we are going to go ahead and take care of all that by editing our newly defined Chapter 8 site. So I am going to go up to the menu, to Site, and choose Manage Sites. I will choose our Chapter 8 site, and I am going to click on the Edit button. So the first thing I want to do is go to my Remote Info, and on my Remote Info instead of Access being None, I am going to change that to Local/Network, because we are going to be developing locally. Depending upon whether you are developing on a Mac or a PC, we are going to have a slight difference here. We are on a Mac, so when I click on the Browse for Remote Folder, I am going to go to my Applications, and I am going to scroll down and find the MAMP folder, and remember we are going to be uploading our files directly into the htdocs folder. In some cases you might want to put in a subdirectory that's project based, but at this point we are just going to go ahead and upload files directly to the root server. So we are going to click Choose.

If you are on the PC, you are going to browse to the C drive and you are going to need to find the WAMP directory; and it should be right on this root of C. Inside of that you will find a folder called www. That folder serves the same purpose as the htdocs folder, and that's what you are going to want to specify as your remote folder. So we will go ahead and click Choose. I am not going to select the Automatically upload files to server on save. That's actually a fairly bad idea, because you could overwrite some files that you don't really want to overwrite. For testing purposes, it's not that big of a deal, but I usually just leave that off as a general rule.

I am also not going to turn on check in and check out, and that way we can upload files and download files as we are testing without really having to worry about following the check in and check out procedures. Now, that's half the battle. I also need to go and specify a Testing Server. So when I click on the Testing Server category, its going to ask me for a Server Model, and you can see that Dreamweaver supports a lot of different server models. I am going to go down and choose PHP MySQL, because that is the one that we are developing with. Again, for Access, I am going to choose Local/Network. A lot of this will go ahead and populate, because we have already specified the Remote Info. So you can see for the Testing Server, it goes in and fills that information in from wherever the location of your remote folder is.

Now, the URL prefix is something that we are going to have to change here on the Mac. If you remember earlier in the Mac Setup movie, our localhost port is: 8888. On a PC, you should just see localhost. I am going to go ahead and click OK, and it's going to recreate my cache, and I will click Done. Now, one of the first things I want to do is go ahead and upload my entire site to the remote server. One of the reason I want to do that is because when I am developing in Dreamweaver with an application server, every time I preview the page in the browser, it's going to upload that file through remote using the testing server to preview it. Dreamweaver is going to prompt you and say do you want me to upload independent files, and that generally works, but sometimes you will have links to external scripts or other files that are necessarily for previewing, and it won't upload those.

So I am going to go ahead and upload the entire site and I will click on the Site Files Expand button, and I will just make sure that my root folder is selected and I am going to choose the Put Files icon; it's going to ask me, are you sure? I am, so I am going to click OK, and it will go ahead and upload that. So our site has finished uploading, and the next thing we want to do is go ahead and establish a data source. So I am going to minimize my Site Files panel, and a panel that we are going to be working with a lot in this chapter is the Application panel group. So you want to open that up.

The Application panel group contains four panels: you have got your Databases. Your Bindings, where we will create recordsets. Server Behaviors, where we will generate a lot of our server site code. The Components panel, where if we have some server-based components, that's especially prevalent with ColdFusion, we will be able to access those. So I am going to click on the Database panel. In order for us to define a data source, we first need to have a page open. So I am just going to go ahead and open up my index.php page. You might notice that we are using a different extension for this chapter.

Instead of using an .htm extension, we are using a .php extension, and of course that correlates to this being a PHP page. So our Database panel now is highlighted and we are able to select items on the page. What's really nice about this is Dreamweaver gives us a step-by-step instruction, and if one of these does not have a checkmark beside them yet, we need to go back and complete that step. So you notice that we have created a site, we have chosen a document type, and we have set up a site testing server. So I am going to go up and click on the + button, and I can see my SQL connection is set up. Now, if I have defined other DSNs or Data Source Names through ASP or .NET or ColdFusion, I would actually see those connections available to me here as well. So I am going to go ahead and click the MySQL Connection and its going to bring up a fairly intimidating looking dialog box, but don't let it intimidate you.

The first thing we need to define is a Connection name, and this Connection name can be anything that you want it to be, it just needs to be very descriptive as to what database you are connecting to. I am just going to go ahead and type in dsArtists. So I usually prefix that with a ds and that means data source. So next we would need to specify the SQL Server, and at this point its just localhost for all of us, and a User name and a Password. So on the Mac, the user name is going to be root and the password is going be root. On the PC, the default user name is root, but the default password is blank. So unless you have changed any of those on the PC, your user name will be root, your password will be empty. On the Mac, your user name will be root and your password will also be root.

So we need to go ahead and choose which Database we want to use from this connection. So I will go ahead and hit Select, and it populates with the list of available databases. We want to use the artist database that we defined earlier. So I will click OK and then click OK again, and now our Database panel shows our dsArtists. If I open that up, I would be able to browse through any Stored procedures, I can browse through any tables; in this case of course we just have the artist table, and that populates out. So that information being displayed means that we have access to this database and we can begin writing recordset queries, which we will 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 · 38726 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.