quick search mod

[juven14]

By items do you mean categories, right?

Dropdown:

Category:
Homes
Cars
Boats


States:
NJ
NY
TX
TN

Also which version are you using, 3.1.5 Developer?

[dankellaway]

sorry, yes you are right.. so a dropdown list for each to search by

[juven14]

Ok, give me about 5 more min

[juven14]

Ok, on the template you want these to be display place this:

<form name="search" id="search" method="get" action="searchresults.php">
<table>
    <tr>
        <td>
            <select name="type" id="type">
                <option value=''>{$smarty.const.LANG_SEARCH_ALLCAT}</option>
                {search_category}
            </select>
        </td>
    </tr>
    <tr>
        <td>
            <select name="state" id="state">
                <option value=''>{$smarty.const.LANG_SEARCH_ALLCAT}</option>
                {search_states}    
            </select>
        </td>
    </tr>
    <tr>
        <td><input type="submit" name="Submit" value="{$smarty.const.LANG_SEARCH_BUTTON}" /></td>
    </tr>
</table>
</form>

Then you need to create these 2 plugins and place them in the plugin folder. For 3.1.5 the path is includes/classes/smarty/plugins

create this file and name it: function.search_category.php

PHP Code:

<?PHP
function smarty_function_search_category(){
    global $db;
    $arr = array();
    $sSQL="SELECT id,parent_id,name FROM ".PREFIX."categories WHERE parent_id='0' ORDER BY cOrder";
    $result=$db->query($sSQL);
    while($row = $result->fetch())
    {
        $row['name'] = $prefix . $row['name'];
        array_push($arr, $row);
        $arr = array_merge($arr, cat_tree(""."  » ", $row['id']));
    }
         
     $loop_count = count($arr);
     for ($x=0; $x<$loop_count; $x++)
         {
            $output.="<option value=". $arr[$x][id] .">". $arr[$x][name] ."</option>\n";
         }
    
    return $output;
}
?>

create this file and name it: function.search_states.php

PHP Code:

<?PHP
function smarty_function_search_states(){
global $db;
  $sSQL="SELECT name FROM ".PREFIX."states ORDER BY name ASC";
  $result=$db->query($sSQL);
  while($rs=$result->fetch()){
    
    $output .= '<option value="'.$rs['name'].'">'.$rs['name'].'</option>\n';
    
  }
  return $output;
}
?>

Then upload the template and the 2 plugins.

[dankellaway]

Thanks for your help John i'll give it a go

[spaceboy]

The search works well; however, I'd like to take it a step further and add some sort of acknowledgement... currently, once the search button is pressed, the text search field goes blank and there is nothing saying what was searched and # of results.

I'd ideally like to do two things:

1. Have the "search text" field remain entact even after someone presses the search button, instead of being erased. Often users will want to slightly alter or add to their search, or search the same text in different categories.

2. Some sort of line acknowledging the text that was searched and the results found, like this example:
128 items found searching "antique furniture"

3. How do I align the search at the top & right of the layout page

Is this doable?

[bgordon]

The link seems to be broken... or has this already been built into the latest version?

[juven14]

I put up a new link in another post in this thread, or are you talking about the deal that I helped spaceboy with? If so all the code needed is also posted in this thread.

Here is a link to the post in this thread with the zip:
http://www.68classifieds.com/forums/...6&postcount=20

Here is the link to the post with the code in this thread:
http://www.68classifieds.com/forums/...8&postcount=34

[dankellaway]

I wonder if you can help me out. I'm try to alter the code to include the total of each item at the end (i.e. dog (4), cat (9), rabbit (3) etc..). Would be very handy for those wanting to see if items were actually available in that section before selecting.

I need help on this. So far i've got:

PHP Code:


<?php
function smarty_function_search_category()
{
    global $db;
    $arr = array();
    $sSQL="SELECT id,parent_id,name,total FROM ".PREFIX."categories WHERE parent_id='0' ORDER BY cOrder DESC";
    $result=$db->query($sSQL);
    while($row = $result->fetch())
    {
    
        $row['name'] = $prefix . $row['name'];
        $row['total'] = $prefix . $row['total'];
        array_push($arr, $row);
        $arr = array_merge($arr, cat_tree(""."  » ", $row['id']));
    }
    
     $output = "<option value=''>Search All</option>\n";
    
    
     $loop_count = count($arr);
     for ($x=0; $x<$loop_count; $x++)
         {
            $output.="<option value=". $arr[$x][id] .">". $arr[$x]['name'] .' ('.total.') '."</option>\n";
         }
        
    return $output;
}
?>

[MADKing]

Hi,

hope you cn help me.
How can I put the extra_search_fields into your little search module on the home.tpl ?

Thank you