Jump to content

Archived

This topic is now archived and is closed to further replies.

pbaker

Search Box

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

 

 

 

 

 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.