Insert a Date Range

Question

Good morning, I am making a system that I need to register the presence of users at an event, separating by period of day and date. The part of the period was simple, however the date comes to me a problem, I need to take the date of the form that inserts the Initial Date/Final Date and insert all dates in this range (besides the dates already inserted), to register the presence of the user in each of the days for example. It would look like this:

   idevento  |        datainicial     |          datafinal
       1     | $_POST["datainicial"]  | $_POST["datafinal"]
       1     |         20/02/2016     |        25/02/2016

That’s how it would look in the bank:

       |idevento|   datas  |   
       |   1    |20/02/2016|
       |   1    |21/02/2016| 
       |   1    |22/02/2016|
       |   1    |23/02/2016|
       |   1    |24/02/2016|
       |   1    |25/02/2016|

I found in some questions something similar but it was only the select, what would advance me in time to take the dates of the bank to register the presence, however I needed to have the dates inserted in the bank to be able to register the presence in each separate and generate a final report of presence, so I tried to adapt, however I did not obtain result.

EDIT 1: @Gabriel Herning I did the code this way, but I don’t know if I’m sending the bank the wrong way or something. Should I create a new column to store the value of the right dates? In addition to the start date and end date

$dataInicial = $_POST['data'];
$dataFinal = $_POST['datafinal'];
$start = new DateTime($dataInicial);
$end = new DateTime($dataFinal);

$periodArr = new DatePeriod($start , new DateInterval('P1D') , $end);

foreach($periodArr as $period) {
    $end = $period->format('d/m/Y');
    $sql = mysqli_query($conn, "INSERT INTO evento (id, datas) VALUES('$id', '$end); 
}

The table has the idevento fields, initial date, final date, and dates, I need to pass which of them in the Insert?

EDIT2: That’s the current code

function presenca($datas){ 
        include "conectar.php";    
        $dataInicial = $_POST['data'];
        $dataFinal = $_POST['datafinal'];
        $start = new DateTime($dataInicial);
        $end = new DateTime($dataFinal);
        $periodArr = new DatePeriod($start , new DateInterval('P1D') , $end);
        foreach($periodArr as $period) {
            $period->format('d/m/Y');
            $sql = mysqli_query($conn, "INSERT INTO datas (datas) VALUES('$period')"); 
        }
        $conn = null;

}

if($_POST["pagina"] == "inserirEve"){   
    presenca($_POST['data'], $_POST['datafinal']);
}

<form method="POST" action="input.php">
<input type="hidden" name="pagina" value="inserirEve"/>
Data Inicial: <input type="date" name="data">
Data Final: <input type="date" name="datafinal">
<br>
<br>
<input type="submit" name="Inserir" value="Cadastrar">
</form>

And this error occurs here:

Catchable fatal error: Object of class Datetime could not be converted to string in C: xampp htdocs semana input.php on line 53

EDIT3:

function presenca($datas){ 
            include "conectar.php";    
            $start = new DateTime($_POST['data']);
            $end = new DateTime($_POST['datafinal']);
            $periodArr = new DatePeriod($start , new DateInterval('P1D') , $end);
            foreach($periodArr as $period) {
                $period = $period->format('d/m/Y');
                $sql = mysqli_query($conn, "INSERT INTO datas (datas) VALUES('$period')"); 
            }
            $conn = null;
}

Answer 1

Use the library Date Time for this. Date Time is a native PHP library that offers you everything you need to work with dates. In it you will find the class Dateperiod.

With Dateperiod, you can calculate all dates within a period:

$start = new \DateTime('2016-02-20');
$end = new \DateTime('2016-02-25');
$periodArr = new \DatePeriod($start , new \DateInterval('P1D') , $end);

foreach($periodArr as $period) {
    echo $period->format('d/m/Y H:i:s').'<br />';
}

//data de término
echo $end->format('d/m/Y H:i:s');

Exit:

20/02/2016 00:00:00
21/02/2016 00:00:00
22/02/2016 00:00:00
23/02/2016 00:00:00
24/02/2016 00:00:00
25/02/2016 00:00:00

One detail is about the end date, it should be consider as "cut date", ie it is not considered "within a period". Therefore, it is printed separately

If you only need to use the internal period, since it already has start and end, you can remove the start date via Dateperiod::EXCLUDE_START_DATE:

$start = new \DateTime('2016-02-20');
$end = new \DateTime('2016-02-25');
$periodArr = new \DatePeriod($start , new \DateInterval('P1D') , $end , DatePeriod::EXCLUDE_START_DATE);

foreach($periodArr as $period) {
    echo $period->format('d/m/Y H:i:s').'<br />';
}

Exit:

21/02/2016 00:00:00
22/02/2016 00:00:00
23/02/2016 00:00:00
24/02/2016 00:00:00

Answer 2

You can use a function to return all dates between start and end before entering in the database:

function createDateRangeArray($strDateFrom,$strDateTo) {
    // formato esperado: YYYY-MM-DD
    $aryRange=array();

    $iDateFrom=mktime(1,0,0,substr($strDateFrom,5,2), substr($strDateFrom,8,2),substr($strDateFrom,0,4));
    $iDateTo=mktime(1,0,0,substr($strDateTo,5,2), substr($strDateTo,8,2),substr($strDateTo,0,4));

    if ($iDateTo>=$iDateFrom)
    {
        array_push($aryRange,date('Y-m-d',$iDateFrom));
        while ($iDateFrom<$iDateTo)
        {
            $iDateFrom+=86400;
            array_push($aryRange,date('Y-m-d',$iDateFrom));
        }
    }
    return $aryRange;
}

//chamando a função da seguinte forma
$dt_inicial = date('Y-m-d', strtotime($_POST["datainicial"]));
$dt_final = date('Y-m-d', strtotime($_POST["datafinal"]));
$array_datas = createDateRangeArray($dt_inicial , $dt_final);

foreach($array_datas as $data){
    //insere os dados no banco
}

Reference