Search in BD with For Repetition

Question

I have the following Table as Example:

data - chave primaria, contendo a data mesmo 2018-01-02.
diasemana - int, contendo o dias das semana tipo 1 para segunda, 2 para terça.
semanaAno - int, contendo o numero de semana do ano tipo 1 primeira semana do ano.

So I have:

<?php
$repetiacao = 3;
 for ($i = 0; $i <= $repetiacao ; $i++) {
    // aqui está o problema
 }
?>

"Here’s the problem": I wanted each repeat loop to pick up the date, for example 2018-01-02 on the first loop after 2018-02-02 on the second and last 2018-03-02, according to the repeat amount

As you see it increases the MONTH in each repetition but still mine echo I need you to be the field semanaAno of my table. Then I arrived at logic more or less that in each loop I make a select in the table showing the semanaAno when data = data. Can you help me?

Answer 1

From the date you can count the number of weeks. For this you can use the class Datetime and the function format(). It is also interesting to know the values used to format.

Your code can stay that way:

for($i = 1; $i <= 3; $i++){
   $data = new Datetime('2018-' . $i . '-02');

   echo '<br><br>';
   echo 'data: ' . $data->format('Y-m-d');
   echo '<br>Semana do ano: ' . $data->format('W');
   echo '<br><br>';
}

This print:

data: 2018-01-02
Semana do ano: 01



data: 2018-02-02
Semana do ano: 05



data: 2018-03-02
Semana do ano: 09

Where W returns the number of weeks. You can check other formatting options here on php.net.

One more detail, if you consult the past documentation, you will see that the first day of the week is Monday, for option W.