June 22nd, 2009

Video Tutorials Dreamweaver

Dreamweaver, from the Adobe product suite, is a powerful tool – both for those who can’t write code, and those who can. For those more adept at coding, following is a tutorial that will instruct you on how to connect and display dynamic data using Dreamweaver and MySQL.

PART 1. MAKING THE CONNECTIONS
We primarily deal with creating a database using MYSQLYOG and XAMPP as our server, if you do not yet have these free open source items installed please do so now. It is not 100% necessary that you use these items, if you have something similar installed that will also work.


PART 2. SENDING  THE DATA FROM THE FORM TO THE DATABASE
In this video tutorial we will be building a simple form and using the inbuilt behaviours in Dreamweaver to connect this form to the database, writing an insert statement and checking the data that is inserted into MySQL.

PART 3. WRITING THE QUERY
Here we learn about queries. A query is simply a question we are going to ask the database.

PART 4. REPEATING REGIONS
Repeat region behaviors is simply a new name for the Do – While loop. Repeat region will allow you to display more than 1 record at a time, for example we might want to how the top 10 results; we do this with repeat region.

PART 5. DELETE FROM MYSQL
Delete a record. Learn how to add a delete record link to a specific id number. For example, learn how to delete only a specific record using Dreamweaver behaviors.

Web Toolbox