How do I get two input fields to get a range of data from the database?

See more:

PHP

MySQL

CSS3

HTML5

I have a database table(eyfstb) containing two fields,

datetable = ",2019-11-04,2019-11-06,2019-11-08"
documenttable = ",first,second,third"

I am trying to use two input fields to get a range of data from the database.


I want the result to be

$datefiles = ",2019-11-04,2019-11-06";
$documentfiles = ",first,second";

What I have tried:

I have a database table(eyfstb) containing two fields,

datetable = ",2019-11-04,2019-11-06,2019-11-08"
documenttable = ",first,second,third"

I am trying to use two input fields to get a range of data from the database.

<form method="POST" action="" id="my_form">
   <small&gt;Start&lt;/small>
   <input type="date" name="datfrm">
   <input type="date" name="datto">
   <small&gt;End Date&lt;/small>
   <input type="submit" name="subdr" value="Display Record"></center>
</form>

i want to get the record "first,second" and the date "2019-11-04,2019-11-06" if the date ranges are 2019-10-01 to 2019-11-07

 $products = $db->query("SELECT datetable,documenttable FROM eyfstb WHERE specialnum='$rollnum'");
while($row = $products->fetch_assoc()){
$datefiles = $row["datetable"]; $documentfiles = $row["documenttable"];

I want the result to be

$datefiles = ",2019-11-04,2019-11-06";
$documentfiles = ",first,second";