Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Offline
#74 2012-08-02 19:57:40
- progre55
- Member
- Registered: 2006-05-02
- Posts: 668
Re: etc_query: all things Textpattern
Very cool. Looking forward to seeing it.
Offline
Re: etc_query: all things Textpattern
Let’s try this:
- re-download the latest etc_query
- change your inputs like this (note the brackets after Features):
<INPUT NAME="Features[]" TYPE="CHECKBOX" <txp:if_variable name="Features" value="XMRadio">selected</txp:if_variable>value="XMRadio">XMRadio<BR>
<INPUT NAME="Features[]" TYPE="CHECKBOX" <txp:if_variable name="Features" value="Moon Roof">selected</txp:if_variable>value="Moon Roof">Moon Roof<BR>Don’t pass Features through adi_gps, but (without linebreaks)
<txp:variable name="Features"><txp:etc_query globals="_GET" data="{?Features||doarray($,htmlspecialchars).implode(|,$)}" markup="raw" argsep="," /></txp:variable>Then do as before
<txp:etc_query globals="variable" data="{?Model}{?Color}{?Price}{?Features}">
<txp:article_custom
{$?({?Model}|Model='<txp:variable name="Model" />'|)}
{$?({?Color}|Color='<txp:variable name="Color" />'|)}
{$?({?Price}|Price='<txp:variable name="Price" />'|)}
{$?({?Features}|Features='<txp:variable name="Features" />'|)}
/>
<txp:else />
<txp:article />
</txp:etc_query>Offline
#76 2012-08-02 20:26:07
- progre55
- Member
- Registered: 2006-05-02
- Posts: 668
Re: etc_query: all things Textpattern
Ok. Definitely moving in the right direction :)
Now what happens — if I select XMRadio and Moon Roof it returns the articles that have both of them selected in the features field but ONLY those two items can be selected. If another item is also checked, it will not return that article even though it has those two also checked.
FYI, it does appear to be working with a combination of both pull downs and check boxes but for the above issue.
Offline
Re: etc_query: all things Textpattern
Ok, replace
<txp:variable name="Features"><txp:etc_query globals="_GET" data="{?Features||doarray($,htmlspecialchars).implode(|,$)}" markup="raw" argsep="," /></txp:variable>by
<txp:variable name="Features"><txp:etc_query globals="_GET" data="%{?Features||doarray($,htmlspecialchars).implode(%,$)}%" markup="raw" argsep="," /></txp:variable>Offline
#78 2012-08-02 20:46:25
- progre55
- Member
- Registered: 2006-05-02
- Posts: 668
Re: etc_query: all things Textpattern
SUCCESS!
Everything appears to be functioning as expected. Thank you for all of your assistance. I truly appreciate your time and efforts. If you do not mind, so that hopefully what has been done can be used by others — I had planned on creating a “How To” thread so that others will have a road map shhould they also need the ability to filter articles using drop downs and multi-selects —- and also know your skills …
Let me know if you have any type of Amazon Wish List to send something your way —-
progre55
Offline
Re: etc_query: all things Textpattern
Fine! You have helped me in debugging etc_query, so I am rewarded, thank you. Feel free to share, that’s the txp essence.
You may have problems with apostrophized Features like rock'n'roll, then remove doarray($,htmlspecialchars)., it should be safe.
Offline
#80 2012-08-02 21:25:11
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,306
Re: etc_query: all things Textpattern
progre55 wrote:
I had planned on creating a “How To” thread so that others will have a road map shhould they also need the ability to filter articles using drop downs and multi-selects
Yes, please do so. I could follow along to a certain point, hoping that I could trace back what was left out from the beginning once I’d have to build such a monster, but had to throw in the towel pretty soon.
It’ll certainly become a topic that’ll be visited regularly. Try googling this forum for “real estate” ;)
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
#81 2012-08-02 21:26:34
- progre55
- Member
- Registered: 2006-05-02
- Posts: 668
Re: etc_query: all things Textpattern
Uli:
I will do one either tonight or tommorrow so that we can get it up and everyone will be very pleased with its simplicity and results.
progre55
Offline
#82 2012-08-02 21:36:40
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,306
Re: etc_query: all things Textpattern
Cool, thanks!
(I’ll now shovel a heap of posts over to the etc_query topic where they belong to make it easier for the adi_gps readers and to promote etc_query a tad ;)
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
Offline
#84 2012-08-03 21:22:18
- progre55
- Member
- Registered: 2006-05-02
- Posts: 668
Re: etc_query: all things Textpattern
For anyone interested, the tip – Front End Search: Filter Articles With Drop-Down and Multi-Select Menu was posted this morning.
Offline