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.