..... < Study week > .....
Sunday, May 1, 2011
Week 15 : 15 April 2011 (Reflection)...
Using Delete & Update Behaviors
( appropriate for administrator page where the admin can delete certain users or updating information on users)
Before using Delete and Update behavior, we have to use the RecordSet behavior first.
Steps:
1. Create a page to view back the data of all the registered users. Insert form first OK.
2. Add a Delete and Updating buttons / texts in the page.
3. Use RecordSet and Repeat Region.
4. Create a Delete Page. In the Delete Page, view back the information of the user based on the RecordSet. Add a Delete button.
5. Use a Delete Behavior.
> Name of the form
> Name of the RecordSet
6. Highlight the Delete button / text and use Go To Detail Page or Go To Related Page behavior to link the asp file to the Delete Page to view back the detail information of the user.
For update behavior, continue these steps:
1. Create an Update Page. Insert form first OK.
2. Use RecordSet and Repeat Region.
3. In the Page, insert Text Field for each field.
4. View back the information of the user based on the RecordSet by arranging the behavior from Bindings into the related field:
5. Add an update button.
6. Use update behavior.
7. Highlight the Update button / text and use Go To Detail Page or Go To Related Page behavior to link the asp file to the update Page to view back the detail information of the user.
( appropriate for administrator page where the admin can delete certain users or updating information on users)
Before using Delete and Update behavior, we have to use the RecordSet behavior first.
Steps:
1. Create a page to view back the data of all the registered users. Insert form first OK.
2. Add a Delete and Updating buttons / texts in the page.
3. Use RecordSet and Repeat Region.
4. Create a Delete Page. In the Delete Page, view back the information of the user based on the RecordSet. Add a Delete button.
5. Use a Delete Behavior.
> Name of the form
> Name of the RecordSet
6. Highlight the Delete button / text and use Go To Detail Page or Go To Related Page behavior to link the asp file to the Delete Page to view back the detail information of the user.
For update behavior, continue these steps:
1. Create an Update Page. Insert form first OK.
2. Use RecordSet and Repeat Region.
3. In the Page, insert Text Field for each field.
4. View back the information of the user based on the RecordSet by arranging the behavior from Bindings into the related field:
5. Add an update button.
6. Use update behavior.
7. Highlight the Update button / text and use Go To Detail Page or Go To Related Page behavior to link the asp file to the update Page to view back the detail information of the user.
Week 14 : 8 April 2011 (Reflection)...
Activity 1: Integrating Security into an Application
1. Create a form as following:
2.Create a table in a database file as following:
3. Type. a few username and password for testing.
4. Close your database file and view back your dreamweaver file.
5. Save the file. Make sure your connection is working.
6. Click Server Behavioes > User Authentication > Log In User
7. Select the correct form and connection.
8. Make sure you select the correct table and also the correct fields for username and password.
9. Select also the html or ASP file for If Login Succeeds and If Login Fails.
10. For Restrict Access Based, just select Username and Password.
11. Click OK. Test your application.
12. Try to create the Logout Page.
Activity 2: Integrating Security into an Application with Registration Page
1. Create a table in a database to hold all the data from the registration page. Don't forget to set a Premiary Key to the id variable or username variable.
2. The registration page should ask information such as Name, Username, Password.
3. Text Field for password has to set up as password.
4. Use Insert Record bahavior.
5. No need to view back the registration information. Therefore, don't use RecordSet bahavior.
6. Create another ASP file for login page.
7. Use Login Behavior and please use a same table (that holds registration information) for the username and password.
Activity 3: Go To Related Page and Go To Detail Page
1. Create a page to view back the data of all the registered users.
2. Use RecirdSet and Repeat Region.
3. Highlight one user and Go To Detail Page or Go To Related Page Behavior to link the asp file to the file that view back the detail information of the user.
4. Prepare the detailed file by viewing back the detail information of the user. Create another RecordSet and filter it based on it. Please use this new RecordSet.
Week 13 : 1 April 2011 (Reflection)...
Inserting Security into the System (use either ASP or PHP)
1. Connecting to a database file
2. Creating a register page
3. Inserting text field
4. Inserting data to a database
5. Check username
6. Creating a checkuser.asp file
7. Creating a Login Page
8. Inserting a Flash Button
9. Creating a Login-failed file
10. Restricting Access
11. Creating a Logout Link
12. Creating restricted.asp
1. Connecting to a database file
2. Creating a register page
3. Inserting text field
4. Inserting data to a database
5. Check username
6. Creating a checkuser.asp file
7. Creating a Login Page
8. Inserting a Flash Button
9. Creating a Login-failed file
10. Restricting Access
11. Creating a Logout Link
12. Creating restricted.asp
Week 12 : 25 Mac 2011 (Reflection)...
This week, we learned about how to create Database & Tables using PhpMy Admin.
Step 1: Just enter your database name and click the 'Create' button to create your database.
Step 2: Now to create a new table, enter your table name and the number of fields in the table, then click the 'Go' Button.
Step 3: Next, create the fields, just enter values for each field name, type, length of the field, null option and mention whether it is a primary key or not.
Then, click the 'Save' button.
Step 4: The following figure is displayed upon successful creation of your table.
Saturday, March 19, 2011
Week 11 : 18 Mac 2011 (Reflection)...
This week, we learned about how to create a contact form in Dreamweaver CS3 using ASP.
Step 1: Setup a site
Step 2: Setup the database file in Access
Step 3: Setup the Connection
Step 4: Setup the Contact Form
Step 5: Writing a data into a database using the Insert Record
Step 6: Reading / Viewing a data from a database using the RecordSet
Step 7: Execute the file
Step 1: Setup a site
Step 2: Setup the database file in Access
Step 3: Setup the Connection
Step 4: Setup the Contact Form
Step 5: Writing a data into a database using the Insert Record
Step 6: Reading / Viewing a data from a database using the RecordSet
Step 7: Execute the file
Week 10 : 11 Mac 2011...
Dr Zaida was not feeling very well. The class was called but Dr Zaida asked to complete assignment 1 and update our blogs. Hopefully Dr Zaida will recovered as soon as possible...
Subscribe to:
Posts (Atom)