CMS Made Simple Forums

Posted: **Fri Feb 13, 2009 5:06 pm**

Hi,
I'm building a custom search for a site the displays results from the cataloger module. The search itself is basically a form and based what the user submits, I show predefined results. What I'm trying to do though is show the thumbnail image associated with the results and I'm having a really hard time understanding how to grab those.

Here's what I've got so far. I've hard coded a url for the image but it's not accurate always

Code: Select all

global $gCms;
$db =& $gCms->GetDB();

	$query = "SELECT * FROM cms_content WHERE menu_text IN(".$cleanpianos.")";
	$result = $db->Execute($query);
	
	//$resultImage = '/images/catalog_src/'.$row['content_alias'].'_src_1.jpg';
	
	if ($result->RecordCount() > 0)
	{
		echo "<ul class=\"listItems\"> \n";
		while ($result && !$result->EOF)
		{
			$row = $result->FetchRow();
			
				echo "<li><a href=\"".$row['hierarchy_path']."\"><img src=\"/uploads/images/catalog/".$row['content_alias']."_t_1_100_1.jpg\" title=\"".$row['content_name']."\" />".$row['content_name']."</a></li> \n";
		}
		echo "</ul> \n";
		
		echo $cleanpianos;

	}
	else
	{
		echo "<p class=\"error\">There were no search results in the database";
	}

You can see my path to the image is /uploads/images/catalog/".$row['content_alias']."_s_1_100_0.jpg and what I'm wondering is how to get the image path so it's accurate if it changes. I'm not sure how to get that last part of the filename _s_1_100_0.jpg.

Anyone able to help here?

Thanks!

Posted: **Fri Feb 13, 2009 10:38 pm**

You'd want to start by doing a search for this... look for my name and cataloger .. I have posted on this, and how to get the img file src path...

Hope this helps

jeremyBass

PS... you don't need a custom query for this... for what it's worth

Posted: **Sat Feb 14, 2009 4:24 am**

Thanks for your reply. I have searched and went back to your other posts and what I found was good except it's still being called inside a cataloger template from what I could tell and what I think is different here is that I'm accessing the images from outside of the module and cataloger templates. It's just in a plain template. I've created a custom search and thrown that into a UDT and then results spit out predetermined catalog items. It works fine, I just am trying to find a solution that won't break if the client changes an image later on.

Posted: **Sat Feb 14, 2009 5:21 am**

well.. I was thinking for you it'd be a Catalog Category Sub-template... so you would just have the list of the images, products and what have you... then use formbuilder with submation template useing a capture tag for the catalog tag.

some thing like this but with Cataloger instead of FEU
http://www.corbensproducts.com/examples ... rcher.html

Just throwing out another way to handle what your asking to do.

Cheers
jeremyBass

CMS Made Simple Forums

Query to get cataloger images

Query to get cataloger images

Re: Query to get cataloger images

Re: Query to get cataloger images

Re: Query to get cataloger images