Pages

Ads 468x60px

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!

2 comments:

  1. Sorry Ako, this is another link : http://www.slideshare.net/hailiz/tutorial-php-and-dreamweaver-cs3

    ReplyDelete