Part1: What do I need to get started?
Since I am doing this locally on my machine For this to work you will need to have the software below installed. Also if you want to apply this to your live web site, your hosting company need to run PHP MYSQL

1. WAMP5 : http://www.wampserver.com/en/index.php

2. EMS SQL Manager for MySQL (WAMP5 comes with a sql manager, you can use it, or which ever one you are familiar with. 

Download and install both software, if you installed wamp5, by default it would create a folder located in C:\wamp\www\, create two more folders inside the www\ directory called localroot and the other webroot. Click here to view Demo

Part2: Creating the database and tables.

Well we are finished with the database part.

Part3: Setting up Dreamweaver and creating the form.
Start up Dreamweaver and click New Site Manage Sites..

and click New Site. Click on the Advanced Tab and you will see the window below. Click on Local Info and fill in the information shown.

Local Info

Remote Info

Testing Server

When you are finished click ok, Done

Create a new php page and name it index.php

We will need to create the table below. Copy and paste the code into dreamweaver.

This will create the table below.

Part4: Connecting to the database.

Click on the Shown in the databases tab and click on MySQL Connection.

With that the window below will come up. Fill in the information shown below.

This information has to match up with what you created using EMS, The password I used is user.

Next click on Select, select the user_db database and click ok twice.

At this point we will create how the master page info will be displayed.  Click on Bindings and create a new Recordset by clicking on the . Create the Recordset according to the image.

Click on the (+) next Recordset, you will see the fields shown above.

Now just drag the names over to the table from the recordset.

Click on rs1.F_name and to select it and enter more_info.php?id=<?php echo $row_rs1['id']; ?> in the link window. This will link you to the more details page.

Click and select the botton half of the table, if you click inside one of the tables and look at the window bottom bar you should see <tr> click on it and this will select the table.

When you click on the table tag it will select your table. With the table selected click on Server behavior located in the Application window. From there click on the and select Repeat Region

When the window above comes up click on show enter 10 and press ok. This limits the content number to 10 items per page.With that your table should change a little, the Item Template should come around it. If you have a large number of records you will need to set the number of record to display at a time.

Step5: Creating the details page
Create a new page called details.php, Same as before copy the code below and paste it into your page.

Doing this will give you the table below.

Create a record set same as before. Now just drag the names over to the table from the recordset.

When you are finished you should have the table shown below.

Double click on the record ser name and fill in the information shown below. This will filter your content based on the id in the database.

Finished:
Well that is it, hope it came out to what you expected. If you have any question or comment about this tutorial, feel free to post a message on the forum. I also created a video tutorial for this example click here you will have to register to view it.

This Tutorial was Created By Mark
© 2009 pixeldigest.com. All Rights Reserved.