+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Including Search Results in a webpage (/thread-4198.html)
Including Search Results in a webpage - drewhack - 2008-12-06
Okay I may be asking for too much on this one.
Is there a way to include search results on a webpage out of zenphoto.
Lets say for example I have a website for a theatre group with zenphoto for the image gallery. I have photos uploaded into ZenPhoto and tagged appropriately by actor. On their Bio page can I put a script in to pull the search results portion of a page. For example on the Bio Page for the Actor "Josh" it would display all the images that are tagged with "Josh." Im not a novice with PHP mysql but I have not made much sense out of the zenphoto descriptions, a code example would be great!
Thanks!
Including Search Results in a webpage - acrylian - 2008-12-06
Take a look at our table setup. We have a table for the images (images), one table that stores all the tags (tags) and one table that stores the connections between the tags and the images (or albums) (obj_to_tag). You need to do the following:
- Get the id of the tag "josh" for example for the
tagstable. - Search the
obj_to_tagtable for the occurances of that id and get theobjectidof those which is theidof the object attached. Since you want the images you need to query for the type "images". - Now get use the array you got to get the images by id from the
imagestable. Now you have the images with the tag "josh".
An alternative would be to do a tag search and create a dynamic album from it and then call that.
I can't give a code example but if you said you are not a novice to PHP and MySQL so that should help.