Multi-field search? « Gravity Support Forums

Gravity Support Forums » General » Pre-Purchase Questions

maharzan
Member

Hi all,

I am trying to do this..

First, I want to use Gravity Forms to do a simple search on the database saved. But if I use it, each search is just saved in the database and I cannot search the database. How do we not saved those search text but then grab that search text such as $_POST["searchtext"] ? Is that even possible currently? If it is, please suggest how to achieve this?

Second, I have another form that has multiple category fields and text fields. Here is what I want to do. I want to have another form that is basically a search again but more like Advanced search. I want to have 3-4 fields so user can select each field and then we need to send those options to query. I only see the search has 1 field and search like %searchtext% in the sql. Do we have to add another function that specifically might do this?

Thanks so much.

Posted 14 years ago on Sunday August 1, 2010 | Permalink
Carl Hancock
Administrator
Gravity Forms is designed to store data, not to be used as a search form as it posts the data you submit via the form. It sounds like for a search form you would need some sort of custom application as GF doesn't do searches on the front end.

There is an API hook you can use to override the form action url and point it to any action, however you would have to point it to a PHP form handler that does the search and write that functionality yourself. Gravity Forms itself doesn't act as a search engine.
```
<?php
add_filter("gform_form_tag", "form_tag", 10, 2);
function form_tag($form_tag, $form){
$form_tag = preg_replace("|action='(.*?)'|", "action='custom_handler.php'", $form_tag);
return $form_tag;
}
?>
```
That is an example of using the gform_form_tag filter to change the form action for the form.
Posted 14 years ago on Sunday August 1, 2010 | Permalink
maharzan
Member

Thank you Carl. I will try that. I did find a way to search multiple data so I can use gravity forms as an advanced search engine. It can be a good addition to gravity forms and not limiting it to just saving data. I see very good chances of this becoming a full application for huge databases as well. :)

Posted 14 years ago on Monday August 2, 2010 | Permalink
koeleman
Member

Hello Maharzan,

You mention above you found a way to search multiple data, are you willing to share that? I've been looking for such functionality for some time, I couldn't find a good solution yet.

thanks in advance.

Posted 14 years ago on Monday August 2, 2010 | Permalink
maharzan
Member

Hi Koeleman,

I will post that a bit later. I have been successful but I am testing all the functionality and trying to integrate it into GF function so we have minimum code changes.

Thanks for asking!

Posted 14 years ago on Wednesday August 4, 2010 | Permalink
anointed
Member

I was thinking about the same concept a few weeks back, but the task was way to advanced for my current abilities. This could actually open up a huge amount of new possible case uses for gravity. Great job.

+1 on this plugin concept

Posted 14 years ago on Wednesday August 4, 2010 | Permalink
spotmouse
Member

don't forget me to ;-)

Posted 14 years ago on Monday December 13, 2010 | Permalink
milehigh
Member

Add me to the list. Being able to use GF to search on specific custom fields would be great.

Posted 14 years ago on Friday December 24, 2010 | Permalink
Surena
Member

Add me to the list as well, please.

I am creating a directory. It needs an advanced search plus an alphabetical listing of the submitted directory items.Has anyone any solution for that?

Posted 13 years ago on Friday January 7, 2011 | Permalink
milehigh
Member

@Surena:

For Custom Fields Search I'm using 'wp custom field search', does the job.

For alphabetical listing of posts try 'AZIndex'.

Posted 13 years ago on Friday January 7, 2011 | Permalink
Carl Hancock
Administrator

@Surena The only solution I am aware of is the Gravity Forms Directory Add-On that is in the WordPress.org repository. We did not create it, a Gravity Forms user did, but I believe it has some sort of search functionality for the frontend.

Posted 13 years ago on Friday January 7, 2011 | Permalink
mcmito
Member

I would looooove such an add-on. The Wordpress search function is so freaking limited.
The hability to create different forms with different drop-down form fields (one could be for custom fields, one for category a.s.o) and display all posts that match that criteria... that would be amazing.
I had four clients with travel and real estate related websites. For the advanced search part I had to pass everytime (not much of a programmer).
I already have a developer license but wouldn´t even mind paying a bit extra for that add-on :)

Posted 13 years ago on Wednesday April 6, 2011 | Permalink
Dag
Member

Yes, I would like to know if a multiple data search query is possible...
For example find the words "female + united states + singer + jazz"
Hope you have something like this in the near future.

Posted 13 years ago on Thursday September 29, 2011 | Permalink