Insert, Update, Delete in PHP using Dreamweaver CS5

Adding data to database using input in Forms

We often need to insert data into database. We use forms to post the Data. This process is often lengthy and tiresome. You can easily insert data to Database Using Dreamweaver with almost no hand coding. If you are already familiar with DreamweaverCS5, just need to follow the steps below:

• Insert a form

• You can use tables to show the labels and Text fields and Lists for input

• If you want to use a list Dynamic (that will show data in list items fetching somewhere from database), you need to do 2 things:

1. If menu items are from other table, create a Record set using SQL queries that will select the List Items.
2. Select the expected menu list in the form, go to: Properties > Dynamic
§ Dynamic List: Options from recordset (select your Recordset)
§ Select the Values (it is ID in most cases, you chose yours)
§ Label (selects the label of the Menu List)
§ As the value need to match any column of your existing Main recordset ( the main table where you want to insert data), select the SELECT EQUAL VALUE TO for the option.

• Server Behavior > Insert Records > Select Tables (chose in which table you want to insert data)

o Try to select the primary key of that Table in the ID section that is to select
o You can select where to go back after inserting data.
Tips: If you create the names of fields of Form according to the names of DB columns, DW (Dreamweaver) finds and matches those fields automatically during Insert Options, including their datatypes

Making List of Expected Data Using Dreamweaver

Suppose I want to show a list that includes the information about the students of the class. You need to have a database.

• Connect to database
• Creating a record set using BINDINGS PANEL (I need to use the perfect SQL here. There are ‘Simple’ and ‘Advanced’ options)
• Go To : Insert > Data Objects > Dynamic Data > Dynamic Table

o Thus a list is generated. You can select how many rows you want to show in the list.
o You can set First, Previous , Next, Last links about the list
o Write FIRST anywhere, select this text, go to: Server Behavior > Recordset Paging > First/Previous/Next/Last
o If you don’t want to show ‘First’ link in first page, go to: Server Behavior > Show Region

Updating data using input in Forms

• Binding > Recordset (new) which table of data I am going to update

o Default SQL filtered by Primary Key
o Filter = URL parameter = ID **

• Create the Form with text fields and lists…

o Click on the field > Properties > init value
o For list à dynamic > ID label fix > init value

• In action, need to pass ‘’hidden data entry form’’

o Put cursor inside FORM.
o Insert > form > hidden field
o Click on design panel’s Hidden value à Id (which is PK ) as init value

• Find the hidden value, if not there, go to FIND ALL à ID = PK

o If this is ‘’-1’’ then make it 1

• Go to Server Behavior à Update Record <value> FORM.pk as id

• When you make link to EDIT page:

o List page where id of specific entry is available
o Make anyplace linked for ‘’update now’’ à properties > link >update.php
o Go to Code view à <a href = “update.php?id=**here is binding panel >recordset > id**>

Deleting data list in DW

• Blank page, clear everything:

• Server behavior > Delete records > primary key value > id

• Fist where to go after deletion

• Now run the page.

o If nothing is there, go to CODE
o Find “delete go to{ …..} “ this portion out of the logical if segment and before the last brace.

• Link this file where to DELETE. In this linking, the link alphabetical case is factor, so need to be careful.