Pages

Ads 468x60px

Thursday, April 19, 2012

Week 9 : Completing Assignment 1

بسم الله الرحمن الرحيم


 After mid term break, we come back at Authoring class with Dr Zaida.. Miss her talk.. This week she want to look our assignment 1 outcome and progress. Most of group have done 50% complete and over. The assignment 1 due date is 11 May 2012 @11.59 pm for 100kb.
Posted by at 4:31 PM 0 comments

Saturday, April 7, 2012

Add, Update, Delete and Search Record with PHP & Dreamweaver CS3

Alhamdulillah all task successful done. I would like to share how to Add, Update, Delete and Search Record when working with PHP and Dreamweaver CS3.

Search Record

  1. create file find.php (for search) and find2.php(for result searching).
find.php 
  1. Insert form (Insert > Form > Form)
  2. Insert textfield in the same form (Insert > Form > Textfield > OK). Change properties textfield-->studname.
  3. Insert submit button also in the same form (Insert > Form > Button > OK). 
  4. Click the existing form that we have create. Go to the bottom layout <body><form#form1><label>.
  5. Click <form#form1>. type find2.php at Action in form properties.
  6.  Save
step to set up find.php


find2.php
  1. open file search2.php. create recordset. (server behaviors >+> recordset)
  2. As usual set the database connection. Filter the passing variable as shown figure.
  3. Insert form then table.
  4. Bind the recordset into table using drag and drop.
  5. Select 2nd row of table then set repeat region.(server behavior >+>repeat region)
  6. Save and run.

step to set up find2.php

For more tutorial on add, delete and update please download here or here. All tutorial complete step by step with figure. Good Luck!
Posted by at 9:33 PM 2 comments

Tuesday, April 3, 2012

Week 7 : PHP Go to Detail Page...

بسم الله الرحمن الرحيم

Today class start at 4.45 pm. It's due to our beloved lecturer involved to her PhD student's viva session. But we arrived at lab as usual and exploring website development. We continue our PHP lesson on security. Dr Zaidatun was expose us to add record, view, update, delete and find record in admin page. For update and delete option must use 'Go to detail page' in server behavior. For Update, Delete, Find   Needs 2 file :
  1. page.php – viewing  ,  and Go to Detail page.
  2. page2.php – The details for handling the task
Go to detail page behavior



It's seem like simple but actually it's not easy to do. At the end of the class, success to add record, update and delete. Just can't find user. When i came home, redo the task the problem is reverse huhuhu. I success doing find and add but got problem in update and delete record. I'll find what's the problem of mine.


find.php

find2.php then use go to detail page

find3.php


 
Posted by at 9:20 PM 0 comments
Subscribe to: Posts (Atom)