IMPORTANT - How to Have a really funcional Search

[tims]

Amazing Thank you.

[tims]

Hello teseo,

I would like to ask how can I limit the result? example I will only display the first 1000 result instead of showing all result.

I read something in sql to limit the result but I don't know how to apply it.

http://www.w3schools.com/sql/sql_top.asp


Thank you in advance

[teseo]

Hi,

Are you still talking about my solutions here in this thread? They don't change nor include LIMIT, that is set in the original search query that this code modifies. That original query usually takes the value you have set on Admin Dashboard / General ("Search page shows X listings at most").

Regards
 

[tims]

Yes. Sorry I thought it can be modified so it will only show number of search result so let us say I have 10,000 search result it will only give the user the first 1000. Is that possible? I check the dashboard->general settings but that is "Search page shows X listings at most" is only limiting per page... example the page result is 10,000 it will be divide into pages that have 12 listing per page. What I want is to really limit the result 1000 only...

Thank you

[teseo]

The vanilla mechanism already does something like that. Total results are 10*X in "Search page shows X listings at most", so if your "X" is 10 you'll have a total limited to 1000 results max.

Changing that default behaviour and having a fixed total independent of results per page, that you can't do it without modifying a core file. For instance, here there is info on how to get real total of ads (no limit), that should give you an idea:

http://forums.osclass.org/3-2-x/total-search-results/msg98573/#msg98573

Regards

[misa22]

Hi i have another question too Sory for my english...
For real esteta full functional search is to have one autocomplete search with citis regions and  specific custom fields like "near the sea" etc. And with number of ads in this search resoults.
Off course another custom atributes are in search results like number of bedrooms etc.
Is this option possible in ossclass?

[teseo]

@misa22

That has nothing to do with the real subject of this thread, please open a new one.

Regards

[misa22]

@teseo
ok sorry ;/

[Adyyda]

Hi,

Sorry for the delay, but my computer had a major accident,  still recovering, but I'm back...

In the end this was no big issue, just tested this on latest Osclass 3.5.3.

Add this at the very bottom of your theme functions.php (take care not to leave blank lines after this):

Code: [Select]

<?php
function cust_search_keyword_wildcard($params) {

    if ($params['sPattern']) {
        $mSearch =  Search::newInstance();
        $query_elements = (array) json_decode($mSearch->toJson());
    
        $query_elements['sPattern'] = str_replace(' ', '* ', $query_elements['sPattern']) . '*';
    
        $mSearch->setJsonAlert($query_elements);
    }
}

osc_add_hook('search_conditions', 'cust_search_keyword_wildcard', 10);  
?>

Regards

Hello Teseo

I have added your code in functions.php, works ok but i have found via debug this error message
PHP Notice:  Undefined index: sPattern in /xxx/functions.php on line 261
and the line is

Code: [Select]

if ($params['sPattern']) {Can you fix this? Thanks

[teseo]

Hi,

Yes, any variable that might or not might exist must be preceded with "@" to avoid a Warning appearing in error log:

Code: [Select]

if (@$params['sPattern']) {
Regards

[Adyyda]

Issue fixed. Thanks

[Pirulina]

Thanks a lot teseo, search box working like a charm!

[gaissa]

I added a % -prefix to the username-search so I am able to search 'sername' (and also 'usernam') instead of full username like: 'username'.

Code: [Select]

if ($word) $userNameCond .= sprintf(" || %st_item.s_contact_name LIKE '%s%%'", DB_TABLE_PREFIX, '%' . $word);
How to do the same for the Titles (and the other stuff like Description)? Any "simple" solution to this?

[jericcarino]

Well, first I have to warn you that this will be expensive in terms of time, because it adds to the normal query (made over a table built for that -t_description) a search over t_item table that it's not optimized for that kind on use. If there are many search terms, each one must be processed independently. So, I wouldn't recommend this unless you don't have a lot of ads or your server is rather powerful.

Anyway, here it is:

Add this at the very bottom of your theme functions.php (take care not to leave blank lines after this):

Code: [Select]

<?php
function cust_search_keyword_wildcard_with_username($params) {

    if ($params['sPattern']) {
        $mSearch =  Search::newInstance();
        $query_elements = (array) json_decode($mSearch->toJson());
        $pattern = $query_elements['sPattern'];


        $query_elements['sPattern'] = str_replace(' ', '* ', $pattern) . '*';

        $mSearch->setJsonAlert($query_elements);

        // Search by Username too
        $aPattern = explode(' ', $pattern);
        $userNameCond = '';

        foreach ($aPattern as $word) {
            if ($word) $userNameCond .= sprintf(" || %st_item.s_contact_name LIKE '%s%%'", DB_TABLE_PREFIX, $word);
        }

        $mSearch->addConditions("1 = 1 " . $userNameCond);
        $mSearch->addGroupBy(DB_TABLE_PREFIX.'t_item.pk_i_id'); 
    }
}

osc_add_hook('search_conditions', 'cust_search_keyword_wildcard_with_username', 1); 
?>

Regards

First of all, YOU SIR ARE A GENIUS!
A million thank yous to you.
When I search
SEARCH: PS
RESULT: PS4
Which is so freaking awesome and I love it!

But I have a problem when I'm searching for keywords with numbers.
Example:
SEARCH: S6
RESULT: Nothing
SEARCH: Galaxy
RESULT: Galaxy S6

I don't know what's wrong. Please help me out.

[teseo]

Hi,

MySQL Fulltext search will discard keywords having less than X characters (on shared hosting that X is usually 4). Nothing you can do about it unless you have a VPS or dedicated server where you may change the value of that MySQL setting.

Regards