Ghostflasher
Forum Replies Created
-
Forum: Plugins
In reply to: [Participants Database] accessing fields via phpnever mind, found it.
Forum: Plugins
In reply to: [Participants Database] Custom MySQL queriesHi Powerjob,
sorry for the late reply. I was a bit in a hurry to complete my work on time.
Ok, It is actually pretty easy, when u know how to do it. First you have create your own search form. U have to add brackets to search_field -> search_field[] and value -> value[]Use the pdb_search_custom and build there your form. Leave the
$this->search_sort_form_top(); active and delete the rest. So u can be sure, that the nonce and the start of the form is correct.Then add your fields like that:
<select name='search_field[]' id='pdb-search_field_select' class='search-item' style='display:none;'> <ul><option value='columnName' selected >someValue</option></ul> </select> <input type='checkbox' name='value[]' value='someValue'> someValue</input>Be sure to add the search_field selector before every searchfield. That way you can submit in what field you want to search with the following searchinput.
Don’t forget to add the submit button in the end of the form, that was opened by the search_sort_form_top() function. Close the form properly.
Now u only have to readout the $_POST in the displaying list file. Read out the search_field and the submitted values and hook them up with the [pdb_list filter=”*searchterms*”] shortcode.
e.g.
$filter = "[pdb_list filter='city~london']";then
`echo do_shortcode($filter);’
I guess it’s a pretty dirty walkaround but it seems to work and I didn’t had to alter any file from the plugin. So when there are any updates for the plugin this should still work.
hope u can figure it out.
Forum: Plugins
In reply to: [Participants Database] Custom MySQL queriesThanks xnau!
I found that solution too and was able to finish my multi column search. Next on the list is multilanguage support… Let’s get to work 😉
Thanks for the great plugin… I just donated a couple of bucks.
Forum: Plugins
In reply to: [Participants Database] Search with checkboxesSorry, I get a result but I want only persons who are able to speak both languages. At the moment I get all that have French OR English checked. I want all the people who have French AND English checked.