1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
switch(date('w')) { // numéro de jour dans la semaine
case 1: $today = date('Y-m-d');
$finDeSemaine = date('Y-m-d',mktime(0,0,0,date('m'),date('d')+4,date('Y')));
break;
case 2: $today = date('Y-m-d',mktime(0,0,0,date('m'),date('d')-1,date('Y')));
$finDeSemaine = date('Y-m-d',mktime(0,0,0,date('m'),date('d')+3,date('Y')));
break;
case 3: $today = date('Y-m-d',mktime(0,0,0,date('m'),date('d')-2,date('Y')));
$finDeSemaine = date('Y-m-d',mktime(0,0,0,date('m'),date('d')+2,date('Y')));
break;
case 4: $today = date('Y-m-d',mktime(0,0,0,date('m'),date('d')-3,date('Y')));
$finDeSemaine = date('Y-m-d',mktime(0,0,0,date('m'),date('d')+1,date('Y')));
break;
case 5: $today = date('Y-m-d',mktime(0,0,0,date('m'),date('d')-4,date('Y')));
$finDeSemaine = date('Y-m-d');
break;
default:
break;
}
$query = "SELECT prenomTable FROM table WHERE dateTable BETWEEN '".$today."' AND '".$finDeSemaine."'; |
Partager