Week 13 - How to make a guestbook to using Dreamweaver...

Please click below address for the tutorial..


http://version2.andrewkendall.com/pages/learning/tutorials/phpandmysql/guestbook/2.setup_dreamweaver_site.php


1. Create new databases using Ms.Access (asp) or phpmyadmin (php).


2. Make a new site in dreamweaver.
- go to site > new site > name your site > choose server technology (ASP vbscript/php mysql)
- choose folder to store your files
- test URL


3. Connecting to a database file.
- Click on the plus (+) and select custom connection string at database tab in application
property.
- type connection name and string.
- testing server


4. Create a register page



5. Inserting data to a database (using recordset)

Open the "MySQL Connection" window

• Configure the MySQL Connection window by giving the connection name of your choice, the MySQL server name, user name and password (if available) and then select a database existent on the server; as the server I am using runs on the local machine I inserted localhost with the default user root and no password. Also, I have previously created a database entitled test with a table inside.

Configure the "MySQL Connection" window

Select the desired database

• By accessing Window>Bindings or by pressing Ctrl+F10, open the Bindings panel. By using the plus-like icon, create a Recordset (Query).

Open the "Recordset" window

• Configure the recordset in the Recordset window; you have to give it a name, to select a connection with a database (or click on Define to create a new one), to select a table from the database and define a query. Click on Test to see how the table content is displayed.

Configure the "Recordset" window