Tengo una tabla asociada a una base de datos mysql, lo único que quiero es agregar un cuadro de búsqueda por fecha.

Aunque he probado muchos métodos, pero desafortunadamente todos no me funcionaron como debería. Este es mi código:

 <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; }