Search Box

[pbaker]

I want to create a search box in dreamweaver where it querys the database buy say ID field an dthen displays the results below how do i do this.

[ShiVer]

There are tutorials all over the place for searching databases... just look around.

[olliee]

Ok first you need to create search form. It will need a text box and submit button in the form section.

 

Then you will need to set these properties.

 

text box: textfield

button: submit

form name: test

 

(The object names can be be anything you want them to be, I'm just using what i've used in my code)

 

So the code will look like this now.

<form  name="test" method="post" action="search_result.php">
  <label>
  <input name="textfield" type="text" id="textfield"  />
  </label>
  <label>
  <input type="submit" name="Submit" value="Submit" />
  </label>
</form>

 

Now click on the form properties. Now set those properties.

 

Method: post

Action: search_results.php (This name should be whatever the name of your search results page is)

 

This page is now done.

 

 

For the next page

 

You need to create a recordset. Select the appropriate table and database.

 

then you need to set these values.

 

Filter: first (The field name in the database your searching in)

 

Now change 'URL Parameter' to 'Form Variable' - then with the adjacent combo-box change it to the name of the textfield in the search page. In this cases its 'textfield'

 

Now you can add your dynamictext recordset (if you want a repeat region

 

<table width="400" border="1">
  <?php do { ?>
  <tr>
    
    <td><?php echo $row_Recordset1['first']; ?></td>
    <td><?php echo $row_Recordset1['last']; ?></td>
    <td><?php echo $row_Recordset1['pay']; ?></td>
   </tr>
    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>

 

The rest of the code will be generated by dreamweaver.

 

 

Is this what you wanted?

 

 

 

 

 

[philgreg]

nice reply there, thanks for taking the time...there arent many decent tutorials out there actually!

 

I need to create a more advanced search box....can you help me out on this.

 

I want to search surnames and towns...

 

So, for example my users might search for "Thompson" in the Town of "Buxton"

 

How do I set up the variables and the run -time values?

[moberemk]

You'll need a more complex SQL query for something like that. Unless you want to learn SQL, then I'd go with [a href=\"http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXSiteSearch/Overview/\" target=\"_blank\"]InterAKT[/a]'s site search extension.

[philgreg]

Can anybody help me with this?

[philgreg]

?