• 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.