Date Search on the DB
-
Hi Michael,
Getting an error
Fatal error: Unknown: Cannot use output buffering in output buffering display handlers in Unknown on line 0
when interrogating the database for a date [Available From] 2018-01-15.
This is the relevant code block
[php/
if (isset($_POST[‘avail’])){
echo(“Date available from – ” . $_POST[‘avail’] .”<br />”);
echo do_shortcode(‘[cfdb-table form=”Initial Application” hide=”acceptance-323,Address,HouseNumberName,StreetRoad,TownCityVillage,CountyStateRegion,Postcode,country,Relationship1,Relationship2,Relationship3,AccompanyingEmail1,AccompanyingEmail2,AccompanyingEmail3,AccompanyingName1,AccompanyingName2,AccompanyingName3,UniversityCollege,g-recaptcha-response,Student,Submitted,confirm_email-425,confirm_email-775,confirm_email-776,confirm_email-777,Submitted Login,Submitted From,submit_time” filter=”strtotime(Available-From)>=strtotime($_POST(avail)) trans=”SortByDateField(Available-From,DESC)]’);
}
[/php]from the form
<div style=”border:1px solid #C0C0C0; margin-top:10px; padding:10px;”>
<h4>Search by Available From</h4>
<form action=”.” method=”POST”>
<label>Date From?<input id=”dav” name=”avail” type=”text”></label>
<input type=”submit”></form>
</div>Interestingly the similar search of Available To also returns the same error, all other search patterns such as email work ok.
Cheers,
Mike
The topic ‘Date Search on the DB’ is closed to new replies.