Jump to content

drop down search only or mulit selection search?

starhawk85

By starhawk85
in MySQL Help

 Share

Recommended Posts

starhawk85 Newbie

starhawk85

Posted
Posted

NEW HERE, New to Mysql, I know little PHP

 

okay so i have been searching like crazy, Really need help or an solution.

 

I really want to take a general search like the following

 

__________________________  ________

| TYPE HER TO SEARCH              |  | SEARCH |      Example http://www.google.com 

__________________________  ________

 

 

to search in these means

 

_________      ________      ________

| STATE | V |    | CITY | V |    | SEARCH |        Example http://www.carquotes.com/used_cars/

_________      ________      ________

 

 

How do I go about starting on this?

 

also what is this type of search called?

Link to comment
Share on other sites
starhawk85 Newbie

starhawk85

Posted
  • Author
Posted

Here is what I'm working with.

 

Here is my code

 

<center>

<table cellpadding="5" cellspacing="1" class="searchBox">

<tr>

   <td align="center">

 

   <form action="search.php" method="get">

 

<table><tr><td>

   <div align="left">

<input type="text" name="query" id="query" size="40" value="<?php   print quote_replace($query);?>" action="include/js_suggest/suggest.php" columns="2" autocomplete="off" delay="1500">   

<form action="" method ="post">

  <p>

    <select name="state" onchange="document.getElementById('query').value=this.value;">

      <option value="Nation Wide"> Nation Wide </option>

      <option value="Nation Wide ex AK/HI"> Nation Wide ex AK & HI </option>

      <option value="Alabama"> Alabama </option>

      <option value="Alaska"> Alaska </option>

      <option value="Arizona"> Arizona </option>

      <option value="Arkansas"> Arkansas </option>

      <option value="California"> California </option>

      <option value="Colorado"> Colorado </option>

      <option value="Connecticut"> Connecticut </option>

      <option value="Deleware"> Deleware </option>

      <option value="Florida"> Florida </option>

      <option value="Georgia"> Georgia </option>

      <option value="Hawaii"> Hawaii </option>

      <option value="Idaho"> Idaho </option>

      <option value="Illinois"> Illinois </option>

      <option value="Indiana"> Indiana </option>

      <option value="Iowa"> Iowa </option>

      <option value="Kansas"> Kansas </option>

      <option value="Kentucky"> Kentucky </option>

      <option value="Louisiana"> Louisiana </option>

      <option value="Maine"> Maine </option>

      <option value="Maryland"> Maryland </option>

      <option value="Massachusetts"> Massachusetts </option>

      <option value="Michigan"> Michigan </option>

      <option value="Minnesota"> Minnesota </option>

      <option value="Mississippi"> Mississippi </option>

      <option value="Missouri"> Missouri </option>

      <option value="Montana"> Montana </option>

      <option value="Nebraska"> Nebraska </option>

      <option value="Nevada"> Nevada </option>

      <option value="New Hampshire"> New Hampshire </option>

      <option value="New Jersey"> New Jersey </option>

      <option value="New Mexico"> New Mexico </option>

      <option value="New York"> New York </option>

      <option value="North Carolina"> North Carolina </option>

      <option value="North Dakota"> North Dakota </option>

      <option value="Ohio"> Ohio </option>

      <option value="Oklahoma"> Oklahoma </option>

      <option value="Oregon"> Oregon </option>

      <option value="Pennsylvania"> Pennsylvania </option>

      <option value="Rhode Island"> Rhode Island </option>

      <option value="South Carolina"> South Carolina </option>

      <option value="South Dakota"> South Dakota </option>

      <option value="Tennessee"> Tennessee </option>

      <option value="Texas"> Texas </option>

      <option value="Utah"> Utah </option>

      <option value="Vermont"> Vermont </option>

      <option value="Virginia"> Virginia </option>

      <option value="Washington"> Washington </option>

      <option value="West Virginia"> West Virginia </option>

      <option value="Wisconsin"> Wisconsin </option>

      <option value="Wyoming"> Wyoming </option>

    </select>

   

    <select name="prop" onchange="document.getElementById('query').value=this.value;">

      <option value="Downtown or Streetfront"> Downtown or Streetfront </option>

      <option value="Freestanding Pad"> Freestanding Pad </option>

      <option value="Lifestyle Center"> Lifestyle Center </option>

      <option value="Mall or Food Court"> Mall or Food Court </option>

      <option value="Nontraditional Units"> Nontraditional Units </option>

      <option value="Power Center"> Power Center </option>

      <option value="Shopping Center"> Shopping Center </option>

      <option value="Entertainment Center"> Entertainment Center </option>

      <option value="Manufacturer Outlet Center"> Manafacturer Outlet Center </option>

      <option value="Regional Mall"> Regional Mall </option>

    </select>

   

  <input type="submit" name="submit" value="search">

  </p>

</form>

</div>

<td> </td></tr></table>

 

      

<?php  if ($adv==1 || $advanced_search==1) {

?>

   <table width = "100%">

   <tr>

      <td width="40%"><input type="radio" name="type" value="and" <?php print $type=='and'?'checked':''?>><?php print $sph_messages['andSearch']?></td>

      <td><input type="radio" name="type" value="or" <?php print $_REQUEST['type']=='or'?'checked':''?>><?php print $sph_messages['orSearch']?></td></tr>

   <tr>

      <td><input type="radio" name="type" value="phrase" <?php print $_REQUEST['type']=='phrase'?'checked':''?>><?php print $sph_messages['phraseSearch']?></td>

      <td><?php print $sph_messages['show']?>

         <select name='results'>

            <option <?php  if ($results_per_page==10) echo "selected";?>>10</option>

           <option <?php  if ($results_per_page==20) echo "selected";?>>20</option>

            <option <?php  if ($results_per_page==50) echo "selected";?>>50</option>

            <option <?php  if ($results_per_page==100) echo "selected";?>>100</option>

         </select>

            

           <?php print $sph_messages['resultsPerPage']?>   

        </td>

   </tr>

   </table>

<?php }?>

 

 

   

<?php if ($catid<>0){?>     

   <center><b><?php print $sph_messages['Search']?></b>: <input type="radio" name="category" value="<?php print $catid?>"><?php print $sph_messages['Only in category']?> "<?php print $tpl_['category'][0]['category']?>'" <input type="radio" name="category" value="-1" checked><?php print $sph_messages['All sites']?></center>

<?php  }?>

   <input type="hidden" name="search" value="1">

   </form>

      <?php if ($has_categories && $search==1 && $show_categories){?>

      <a href="search.php"><?php print $sph_messages['Categories']?></a>

      <?php  }?>      

   </td>

 

</tr>

</table>

</center>

 

 

 

i am still unable to apply both drop downs to the search and seperate by ( ) A SPACE

Any ideas and or help would be great.

Thanks again.

Link to comment
Share on other sites
starhawk85 Newbie

starhawk85

Posted
  • Author
Posted

My code here is the user interface, the bold red is what is taking the selection from the drop down to insert into the search field. it is working so far..

 

I just need to get both drop downs to go into the search text box and have a space between them...

 

<center>

<table cellpadding="5" cellspacing="1" class="searchBox">

<tr>

<td align="center">

 

<form action="search.php" method="get">

 

<table><tr><td>

<div align="left">

<input type="text" name="query" id="query" size="40" value="<?php  print quote_replace($query);?>" action="include/js_suggest/suggest.php" columns="2" autocomplete="off" delay="1500">

<form action="" method ="post">

  <p>

    <select name="state" onchange="document.getElementById('query').value=this.value;">

      <option value="Choose State"> Choose State </option>

      <option value="Dir"> Nationwide </option>

      <option value="Nationwide Ex AK and HI"> Nationwide Ex AK and HI </option>

      <option value="Alabama"> Alabama </option>

      <option value="Alaska"> Alaska </option>

      <option value="Arizona"> Arizona </option>

      <option value="Arkansas"> Arkansas </option>

      <option value="California"> California </option>

      <option value="Colorado"> Colorado </option>

      <option value="Connecticut"> Connecticut </option>

      <option value="Deleware"> Deleware </option>

      <option value="Florida"> Florida </option>

      <option value="Georgia"> Georgia </option>

      <option value="Hawaii"> Hawaii </option>

      <option value="Idaho"> Idaho </option>

      <option value="Illinois"> Illinois </option>

      <option value="Indiana"> Indiana </option>

      <option value="Iowa"> Iowa </option>

      <option value="Kansas"> Kansas </option>

      <option value="Kentucky"> Kentucky </option>

      <option value="Louisiana"> Louisiana </option>

      <option value="Maine"> Maine </option>

      <option value="Maryland"> Maryland </option>

      <option value="Massachusetts"> Massachusetts </option>

      <option value="Michigan"> Michigan </option>

      <option value="Minnesota"> Minnesota </option>

      <option value="Mississippi"> Mississippi </option>

      <option value="Missouri"> Missouri </option>

      <option value="Montana"> Montana </option>

      <option value="Nebraska"> Nebraska </option>

      <option value="Nevada"> Nevada </option>

      <option value="New Hampshire"> New Hampshire </option>

      <option value="New Jersey"> New Jersey </option>

      <option value="New Mexico"> New Mexico </option>

      <option value="New York"> New York </option>

      <option value="North Carolina"> North Carolina </option>

      <option value="North Dakota"> North Dakota </option>

      <option value="Ohio"> Ohio </option>

      <option value="Oklahoma"> Oklahoma </option>

      <option value="Oregon"> Oregon </option>

      <option value="Pennsylvania"> Pennsylvania </option>

      <option value="Rhode Island"> Rhode Island </option>

      <option value="South Carolina"> South Carolina </option>

      <option value="South Dakota"> South Dakota </option>

      <option value="Tennessee"> Tennessee </option>

      <option value="Texas"> Texas </option>

      <option value="Utah"> Utah </option>

      <option value="Vermont"> Vermont </option>

      <option value="Virginia"> Virginia </option>

      <option value="Washington"> Washington </option>

      <option value="West Virginia"> West Virginia </option>

      <option value="Wisconsin"> Wisconsin </option>

      <option value="Wyoming"> Wyoming </option>

    </select>

   

    <select name="prop" onchange="document.getElementById('query').value=this.value;">

    <option value="Choose Property Type"> Choose Property Type </option>

      <option value="Downtown or Streetfront"> Downtown or Streetfront </option>

      <option value="Freestanding Pad"> Freestanding Pad </option>

      <option value="Lifestyle Center"> Lifestyle Center </option>

      <option value="Mall or Food Court"> Mall or Food Court </option>

      <option value="Nontraditional Units"> Nontraditional Units </option>

      <option value="Power Center"> Power Center </option>

      <option value="Shopping Center"> Shopping Center </option>

      <option value="Entertainment Center"> Entertainment Center </option>

      <option value="Manufacturer Outlet Center"> Manafacturer Outlet Center </option>

      <option value="Regional Mall"> Regional Mall </option>

    </select>

   

  <input type="submit" name="submit" value="search">

  </p>

</form>

</div>

<td> </td></tr></table>

 

 

<?php  if ($adv==1 || $advanced_search==1) {

?>

<table width = "100%">

<tr>

<td width="40%"><input type="radio" name="type" value="and" <?php print $type=='and'?'checked':''?>><?php print $sph_messages['andSearch']?></td>

<td><input type="radio" name="type" value="or" <?php print $_REQUEST['type']=='or'?'checked':''?>><?php print $sph_messages['orSearch']?></td></tr>

<tr>

<td><input type="radio" name="type" value="phrase" <?php print $_REQUEST['type']=='phrase'?'checked':''?>><?php print $sph_messages['phraseSearch']?></td>

<td><?php print $sph_messages['show']?>

<select name='results'>

      <option <?php  if ($results_per_page==10) echo "selected";?>>10</option>

  <option <?php  if ($results_per_page==20) echo "selected";?>>20</option>

      <option <?php  if ($results_per_page==50) echo "selected";?>>50</option>

      <option <?php  if ($results_per_page==100) echo "selected";?>>100</option>

</select>

 

  <?php print $sph_messages['resultsPerPage']?> 

  </td>

</tr>

</table>

<?php }?>

 

 

 

<?php if ($catid<>0){?>   

<center><b><?php print $sph_messages['Search']?></b>: <input type="radio" name="category" value="<?php print $catid?>"><?php print $sph_messages['Only in category']?> "<?php print $tpl_['category'][0]['category']?>'" <input type="radio" name="category" value="-1" checked><?php print $sph_messages['All sites']?></center>

<?php  }?>

<input type="hidden" name="search" value="1">

</form>

<?php if ($has_categories && $search==1 && $show_categories){?>

<a href="search.php"><?php print $sph_messages['Categories']?></a>

<?php  }?>  

</td>

 

</tr>

</table>

</center>

Link to comment
Share on other sites
Jessica Advanced Member

Jessica

Posted
Posted

USE CODE TAGS

 

Based on your further clarification, this is a javascript question. You'll need to create a js function that gets both values and concats them, and assign that to each of the drop down's change events.

Link to comment
Share on other sites
Psycho Prolific Member

Psycho

Posted
Posted

1. Add the following JavaScript function to the HEAD of your HTML page

<script type="text/javascript">
function updateQuery()
{
    var state = document.getElementById('state').value;
    var prop  = document.getElementById('prop').value;
    document.getElementById('query').value = state + ' ' + prop;
}
</script>

 

2. Modify the two SELECT opening tags so they have the appropriate IDs and call the above function onchange  instead of hard coding.

<select name="state" id="state" onchange="updateQuery();">

<select name="prop" id="prop" onchange="updateQuery()">

 

3. Change the first options of those two select statements so the VALUES are empty strings. The label/text can still be what you have

<option value=""> Choose State </option>

<option value=""> Choose Property Type </option>

 

Done.

Link to comment
Share on other sites
Psycho Prolific Member

Psycho

Posted
Posted

found simpler SOLUTION:

 

added + to onchange="document.getElementById('query').value=this.value;"

 

onchange="document.getElementById('query').value+=this.value;"

 

Problem fixed

 

Thank you all for your efforts! :)

 

Um, no that will not work. Did you even test it? Try changing one of those select list more than once.

 

Besides, you should never hard-code functionality into event triggers.

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

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.