julesmd

Hi Michael, Since my last post I have tried changing the order of constraints in the shortcode and leaving constraints out and still can’t get it to work. Please can you tell me if searching between dates is possible, if not I will have to try something else.
Regards
Julie

Thank you for spending your time on this to help, it is very much appreciated. I have spent hours trying to get this to work and have followed your instructions to the letter (even going so far as to get someone to check it with me!), but to no avail.
I stripped the page down to the bare minimum with the following code (removing all reference to ‘filter’):

<form action="" method="POST">
Start: <input type="text" name="start" />
End: <input type="text" name="end" />
<input type="submit" />
</form>

[cfdb-table form="start_end" show="start,end"]
[/cfdb-table]

You can see the output here:

I then created my own shortcode, start_end_wrapper, as directed. This is the generated code containing the code you supplied:

require_once(ABSPATH . 'wp-content/plugins/contact-form-7-to-database-extension/CFDBFormIterator.php');
$exp = new CFDBFormIterator();
$exp->export($atts['form'], $atts);
while ($row = $exp->nextRow()) {
 $tmp = array();
if (isset($_REQUEST['start']) && $_REQUEST['start']) {
    $tmp[] = "strtotime(start)>=strtotime({$_REQUEST['start']})";
}
if (isset($_REQUEST['end']) && $_REQUEST['end']) {
    $tmp[] = "strtotime(end)<=strtotime({$_REQUEST['end']})";
}
$startEndFilters = implode('&&', $tmp);

if (isset($atts['filter'])) {
    $atts['filter'] = $atts['filter'] . '&&' . $startEndFilters;
} else {
    $atts['filter'] = $startEndFilters;
}

$sc =  $atts['shortcode'];
$shortCodeString = '[' . $sc;
unset($atts['shortcode']);

foreach ($atts as $name => $value) {
    $shortCodeString .= " $name=\"$value\"";
}
$shortCodeString .= ']';
if ($content) {
    $shortCodeString .=  $content . '[/' .  $sc . ']';
}
echo $shortCodeString;
}

I then changed cfdb-table to start_end_wrapper and inserted shortcode=”cfdb-table” in the code as you suggested.
The code on my page is:

<form action="" method="POST">
Start: <input type="text" name="start" />
End: <input type="text" name="end" />
<input type="submit" />
</form>

[start_end_wrapper form="start_end" shortcode="cfdb-table" show="start,end"]
[/cfdb-table]

This was the result:

Please can you tell me what I am doing wrong? Am I missing something? I have checked for line breaks etc.
Many thanks
Julie

Hi Michael,
Thanks for your continuing support with this. I have now stripped the filtering down so that the only fields the user can search on are the ‘from’ and ‘to’ dates.
The dates are formatted as dd-mm-yy in both contact form 7 and cfdb. Dates are input in cfdb with the jquery datepicker.
I found a previous support question (http//:cfdbplugin/?page_id=116) which describes exactly what I am trying to achieve:

July 9th, 2014 at 13:21 | #12 Reply | Quote
I created a form with a Date field and a Time field that get populated on submit.
Is there a way to filter between two dates based on user input?
Thanks

Here’s your answer:

July 10th, 2014 at 00:38 | #13 Reply | Quote
@seanw
In a short code you can call the PHP strtotime function to covert the string date to a number and compare it. User input can be passed in as GET or POST parameters. The short code would look something like:
[cfdb-table form="myform" filter="strtotime(date_field)>=$_GET(min_date)&&strtotime(date_field)< =$_GET(max_date)]

Using your example my code is as follows, but it still doesn’t work:

<form action="" method="GET">
<label for="from">Available From:</label> <input id="from" class="datepicker" name="from" type="text" />
<label for="to">Available To:</label> <input id="to" class="datepicker" name="to" type="text" />
<input alt="Submit" src="http://freestayexchange.com/wp-content/uploads/2014/12/search_button.png" type="image" /></form>
[cfdb-html form="Sign Up" show="Country,City,AccommType,From,To,Event,Interests,MainImage,submit_time" role="Anyone" filelinks="url" filter="strtotime(from)>=$_GET(min_date)&&strtotime(to)<=$_GET(max_date)"]

Can you tell me what I am doing wrong? Where do max_date and min_date come from? I’m at my wits end with trying to work this out and have tried every example I can find but still can’t get it right.
Thanks for your patience!

Thanks Michael
Unfortunately that didn’t work either. I’m now trying a different approach due to the importance of date searching on my website. I’ve created more fields in Contact Form 7: Day, Month, Year. I’ve managed to get the fields on the search form (as drop downs).
I’m now struggling with the filter syntax – can you help please?
I need the filter to be as before except for the dates (Day, Month, Year). As it stands if someone searches for 21 Jul 2015 they could get results for all 21’s, all July’s and all Years. They may also want to search on just Month and Year. To make things more complicated there will be two sets of dates From and To, each with Day, Month and Year. This allows users to find listings within dates.
I did find a post on the forum that used this structure:
filter="City~~/$_POST(city)/i&&Blood-Group~~/$_POST(bloodgroup)/i"
but I couldn’t get it to work.
If the filter syntax for dates is not compatible with the straight text searching would a separate form work? I would still need some help with the syntax though…
Many thanks in advance

Michael,
Thank you so much for your lightening response – it works like a dream!
I’ll be sure to double check for any syntax errors in the future (I ended up changing some of the syntax by hand when I couldn’t get the correct code by using the generator).
Off to work on Search form now!
Thank you – resolved!