Dreamweaver CS3 Online Training - Database Driven Web Site |
| Cost: $550.00 |
Location: Live Online Training Course - you can be anywhere that has high speed internet connection |
|
Contact Keen Perspectives, LLC to set up a custom individual course!
419-318-4657 |
| Limit 5 Attendees |
Instructor Led Online Course:
This is a hands-on course led by a live instructor. KP will use online web tools that allow the attendees to see the instructors desktop during the course. All attendees will be on a conference call. click here to view system requirements.
Listed below are two sites that have been developed by keen perspectives, LLc. With my online class or one-on-one instruction you can learn to do all of these functions and more:
- jonathanperry.tv - on this site the client is able to go in an update all of his own events with an administration form that I created for him. his event results then display on his home page with a limited amount displaying. once the event is selected you are taken to a details page about the event. his events are also displayed in date order and will automatically drop off the list when the date expires.
- vendoronline.com - on this site the client is able to go into an administration area and enter in new vendors. they are also able to view reports of users that have signed up to use his site. once vendors are loaded into the database the site visitors use an html form to enter in search criteria and the data is then displayed. this data is set to show up in random order each time the page is refreshed. this means that all of his vendors will have a chance to be listed at the top.
|
Target Audience:
This course will target individuals who know the basics of using Dreamweaver CS3 to develop their html web site. We will not spend time on design in this course it is strictly for the dynamic features of Dreamweaver CS3 using mysql and php. No knowledge of Mysql or PHP is required. |
Requirements:
- Own Dreamweaver CS3
- High Speed Internet Connection
- If you want to follow along you must have a hosting account set up that supports a mysql database. (You do not need to have the database set up but you must have the hosting set up). To follow along with my steps exactly I suggest setting up at least a one month hosting subscription on my site and a domain name The cost is cheap (about $14.00 for both) and you will be able to perform exactly the same actions as me.
|
Dreamweaver CS3 Course Outline: |
Day One:
Setting up your site (local, remote, and testing server)
Planning your site
Creating a mysql database (the basics of different field types and how to choose)
Entering information into the mysql database
Connecting to your database |
Day TWO:
creating a recordset to display data
displaying individual records
displaying multiple records
advanced recordset options
clear rows if record is empty
show if commands |
Day Three:
query a database and display the results using a form
create an input form
validate the form
modify a record |
Day Four:
creating a user registration system
create required fields and show error messages
security
sticky text
|
