Geocoder Plugin - Seach Capability

3 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: February 17, 2012   (RSS)

By northernpenguin - February 16, 2012

I have Geocoder up and running with CMSB v2.08. It works great, and displays all the locations in the database table.

However, I would like to only display a subset of the total db, based on the content of the "region" field. There are 8 regions and I would like the user to be able to go to the website, and from a dropdown pick a region. This would in turn only display the records in that region.

I can hard code it, but am not sure how to allow a user the option of picking a region.

Help?
--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke

Re: [northernpenguin] Geocoder Plugin - Seach Capability

By Jason - February 17, 2012

Hi,

You can append the WHERE clause that is used to pull out records from the database. You can then see if the user selected a region from the drop down by checking the $_REQUEST array, and using that in the where clause if it exists.

If you could add the region drop down to your page and then attach your .php file, I may be able to give you an example of what this should look like.

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/