The Joomla! Forum ™

How can I have image thumbnails show in site search results?
Thanks in advance for any info.

I'm not sure if there are any plugins to do this, but I needed this for my site, and hacked it in (in my typical way).
It was a fair amount of work, both because I needed to extend the search through an indirection, then needed to classify the results depending on the section.
You can see the results by doing a search on my website (it's in my profile). Search results are broken down into 3 areas: Artworks/Artist Profiles/Documents
the output from the search is generated by
components/com_search/views/search/tmpl/default_results.php

I'm sure this can be overridden through the template, but I didn't do that.
I had to store the article id in the search results so I could get the actual article with all the info I needed.
The search plugin for the content is here:
plugins/search/content.php
I modified the sql query to include the extra fields I needed (id and catid without the :textindentifier).

Hi,

slysmiles - your site search page looks great, that's what I'm in the process of trying to do but slightly differently. If I can't get what I want then your way is the way forward for me too...

I've got three components (hot property, virtuemart and auction factory) and I want a search page that brings up all three sets of results with thumbnails (and prices). Fairly straightforward stuff, but the sorting doesn't work globally (sorting is at sql level so the three queries will always be presented independently). The only option I can put forward at the moment is to use merge_array or similar after the queries are completed, then throw in a PHP based sort instead of the sql method - the php sort is looking tricky at the moment unless you have any other suggestions?

Failing that then yes the three tabbed approach is the next best solution for me, it's a good workaround that I hadn't considered so thanks for that!

This kind of search would be great for sites in the Amazon style, where you've got new products (VM) alongside user-owned products (HP), sorted price descending, so if anyone else is looking for this kind of function drop me a pm in a couple of weeks to give me time to get it working.

cecilbadlands - the files that slysmiles suggests are where you want to be looking at for sure. Worth mentioning that if the image url is stored in a database anywhere, this task is fairly straightforward with some basic php and mysql skills, but if the image you want to show is just held within the article text then you'd need some kind of routine to pull this from the data which would be more involved.

EDIT - recent Joomlart templates tend to include a latest news module which pull the first image from your article text, this would be a good place to start looking to see how to do that if that is the case with your situation.

Hi Chris, I got around my problem with Phoca(gallery & downloads). Since my site deals with images but the downloads are zip files, I display(and search) the images but the download link is to the zip file which contains several vector image files. I couldn't do this before because of software limitations on the host's servers.

Hi,

I've used Phoca a few times and it's my preference for when I need a gallery, that sounds like a neat workaround for what you needed to do.

That's the best thing about Joomla, no matter what you try to throw at it there always seems to be an extension that provides the answer, it's just a question of how close the extension is to your requirements and how much you need to modify it.

Glad you got it sorted anyway!

Thanks
Sometimes you need to make some changes to get what you want, the beauty of open source


The sort should be quite trivial in php. Just get the queries from the different tables, and loop through them and pop them into an output array. I've not played too much much with php sorting, but if it's anything like other sort functions there's a callback function where you put your test code in (price, date, whatever)


I needed a clear separation of information, so it was ideal for me. I used the tabs and sliders in content, and had to do a bit of magic to get it working in the search results (not pretty)...

hi. I've finally found a way to view product thumbnails in joomla search results.
The only condition is to have Virtuemart Extended search plugin which you can find in VM package.

These text is translated by Google, cause it was previously written by me in polish language.
I hope its not so bad to understand:

Here's how to make the search results to see thumbnails of Joomla Virtuemart products:

0th For we have worked Virtuemart plug-in installed Extended Search plugin, which is located by default in the package with the installation of VM!

1st We go to COMPONENTS \ COM_SEARCH \ views \ SEARCH \ tmpl \ default_results.php.

2nd We find a line number. 34 which looks like this:

<? Php echo $ result-> text;?>

and we add to it:

address to the folder thumbnails + call. At my call variable thumbs:

3rd<img src = "http://www.ADRESSKLEPU.pl/components/com_virtuemart/shop_image/product/<? php echo $ result-> thumb;?>">

$ Result-> thumb invented himself. They just have to cover with what type of call.

We now move to the file:

Plugins \ SEARCH \ vmxsearch.plugin.php

and find the line 149 by adding to it the text that pogrubiłem:

p.product_s_desc AS text, p.product_thumb_image AS thumb,

If everything came out correctly, you'll see thumbnails of the product description below for search results! Setting the thumbnails to the text will leave for you

-----

Added 10 later:
And how to make thumbnails link back to the original size of images?
How to add a link to product thumbnail of virtuemart in joomla search results?

<Img src = "http://www.ADRESSKLEPU.pl/components/com_virtuemart/shop_image/product/<? php echo $ result-> thumb;?>">

<A> add a link to the parameter $ result-> twojanazwaparametru, which must match the file vmxsearch.plugin.php; I called FULLIMG variable, ie I have:

namely:

4th

<A href = "http://www.ADRESSKLEPU.pl/components/com_virtuemart/shop_image/product/ <? Php echo $ result-> fullimg ;?>">

<Img src = "http://www.ADRESSKLEPU.pl/components/com_virtuemart/shop_image/product/<? php echo $ result-> thumb;?>">

</ A>

vmxsearch.plugin.php file in the code I added (blue):

5th p.product_s_desc AS text, p.product_thumb_image AS thumb, AS p.product_full_image fullimg,

Here's the post on my blog ; please visit it just to say thanks in comments
http://www.vsx.pl/virtuemart-miniaturki-w-wynikach-wyszukiwania-virtuemart-search-thumbs-thumbnails/

This certainly looks like an interesting idea, but I am looking for a way to display thumbnails in search results for Phocagallery and Phocadownload.
Thanks for the info, I'll set this aside in case I need it.

maybe its possible to follow similar way to get thumbs from Phoca? Is there a system plugin for phoca search? have you tried to analyze it?

I'm not a programmer, so beyond copy and paste I'm not much good. I can copy the excellent work of others more capable than I.

Regards,
cecilbadlands

Thank you so much pyby! Your solution worked perfectly. To anyone who stumbled upon this thread looking for a way to display thumbnails in the search results, pyby's solution is the only one I found that will display Virtuemart product thumbnails in the search results.

I have also solution for product prices in search results. Its a bit more difficult, cause the prices are not in the product table. If you want me to write down a solution, please reply to this post.
greets
pyby

Try this:
http://www.solidsystem.it/index.php/eng ... roperties/

Can anyone please clarify this solution. I'm having a bit of an issue with the plugin part of the fix.
"'p.product_s_desc AS text, p.product_thumb_image AS thumb,';"
What should that line 149 look like?

Thanks!

=-s-=

yaeh No luck for me too please any one can explain this in detail

Thanks

This is for pyby
Pyby can you please help me in this

Hi,

I managed to resolve this after some fooling around. inserting that at line 276 worked for me.
So it should read "
$query = "SELECT DISTINCT p.product_id, p.product_name as title,

FROM_UNIXTIME( p.cdate, '%Y-%m-%d %H:%i:%s' ) AS created,

p.product_s_desc AS text, p.product_thumb_image AS thumb,
"

=-s-=

hi all,

I think there is a syntax error on this line below, but I dont know what;

<img src = "http://www.my-address.com/components/com_virtuemart/shop_image/product/<? php echo $ result-> thumb;?>">

EDIT: figured out, should be $result, but I still cant get thumbnails displayed. Im using VM 1.1.4 and Joomla 1.5.15, search module is mod_search with vmx plugin enabled. There are no errors displayed. Can you please help me? I did everything other than step 10 for giving links.

_________________
http://www.conceptchameleon.com/

I was able to get this to work properly, after some jiggering around with it.

The code that's already been mentioned above for vmxsearch.plugin.php is correct.

Where my code was going wrong was in the default_results.php page. Here's how it should look:

Lines 34 - 37 (roughly):


Mine was getting thrown off by the "www" at the beginning of my address, and a space between <? and php. Hope this helps!

On a related note... does anyone know how to get prices to show in the search results? I like the search logic much better with the Virtuemart Plugin, but having search results without a single price showing is extremely unpalatable for my clients.

Any help would be appreciated!

There are 2 steps:

1# force the script to fetch a price.

You need to edit plugings\search\vmxsearch.plugin.php

about line 147 add the bolded code:

$query = "SELECT DISTINCT p.product_id, p.product_name as title, pri.product_price AS cenka,
FROM_UNIXTIME( p.cdate, '%Y-%m-%d %H:%i:%s' ) AS created,
p.product_s_desc AS text, p.product_thumb_image AS thumb, p.product_full_image AS fullimg,
CONCAT('$ItemName/',c.category_name) as section,

cenka is "price" in polish, so you can change it to: pri.product AS prodprice for example ...

2# display the result of this operation

Go to components\com_search\views\search\tmpl\default_results.php

Add this code wherever you want (i've pasted it about line 33)

<?php $netto=$result->cenka; $brutto=round($netto*1.22,2);?>
<?php echo $result->text; ?><br>
<?php echo $brutto.' EUR ';?></span></div>



where 1,22 is the tax value which may be different in your country.
and cenka is the variable name defined in step #1 (it can be for example prodprice, ...)

hope it helps.

Hi
i'm trying to do the same but with joomshopping search plugin instead of virtuemart, I think I went correctly into the first step that pyby suggested, inserting in code:
<img src = "http://www.mysite/components/com_joomshopping...../product/<? php echo $result-> thumb;?>
Now I can see search is looking for pictures (and doesn't find it)

So I tried to figure out how to apply step two to joomshopping plugin search
But I guess p.product_s_desc AS text, p.product_thumb_image AS thumb, is not right for joomshopping. I think that "jshopping_products_images" are the variable images I have in the database

in plugins/search/joomshopping/joomshopping.php I have this code:



I tried to edit the file by adding "jshopping_products_images AS thumb," but then I commented it because it didn't work.
Now I'm wonder if I'm doing something correct and where I'm mistaking

You are using the wrong column name. Go to your database (using MySQL my admin or a similar tool) and find the jshopping_products table. Then you will change the line you have above to something like prod.image_url AS thumb. You may need to join another table depending on the database schema jshopping uses.