I have a table associated with a database mysql, All I want is to add a search box by date.

Although I have tried many methods, but unfortunately all of them did not work for me as I should This is my code:

<form action="" method="GET"">
    <input type="date" name="search" class="form-control" placeholder="Start"  >
    <button type="submit" class="btn btn-primary">Search</button>
</form>

function getRecords($params)
{
    $rp = isset($params['rowCount']) ? $params['rowCount'] : 10;

    if (isset($params['current'])) {
        $page = $params['current'];
    } else {
        $page = 1;
    }
    $start_from = ($page - 1) * $rp;

    $sql = $sqlRec = $sqlTot = $where = '';

    if (!empty($params['searchPhrase'])) {
        $where .= " WHERE ";
        $where .= " ( fullname LIKE '" . $params['searchPhrase'] . "%' ";
        $where .= " OR email LIKE '" . $params['searchPhrase'] . "%' ";

        $where .= " OR phone LIKE '" . $params['searchPhrase'] . "%' )";
    }

    if (!empty($params['sort'])) {
        $where .= " ORDER By " . key($params['sort']) . ' ' . current($params['sort']) . " ";
    }
    // getting total number records without any search
    $sql = "SELECT * FROM `api` where  DATE_FORMAT(created_at, '%Y-%m-%d') = DATE_SUB(CURRENT_DATE(),INTERVAL 1 DAY)";
    $sqlTot .= $sql;
    $sqlRec .= $sql;

    //concatenate search sql if value exist
    if (isset($where) && $where != '') {
        $sqlTot .= $where;
        $sqlRec .= $where;
    }
    if ($rp != -1)
        $sqlRec .= " LIMIT " . $start_from . "," . $rp;
}