Geocoder Plugin - Seach Capability
3 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: February 17, 2012 (RSS)
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?
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
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.
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/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Geocoder Plugin - Seach Capability
Thanx Jason
I found an alternate way of doing what I want by using the examples provided with Geocoder.
I found an alternate way of doing what I want by using the examples provided with Geocoder.
--
northernpenguin
Northern Penguin Technologies
"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke
northernpenguin
Northern Penguin Technologies
"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke