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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| <?php
$maDate = date('Y-m-d', strtotime('-1 day'));
$maDate1 = date('Y-m-d', strtotime('-2 day'));
$maDate2 = date('Y-m-d', strtotime('-3 day'));
$maDate3 = date('Y-m-d', strtotime('-4 day'));
$maDate4 = date('Y-m-d', strtotime('-5 day'));
$maDate5 = date('Y-m-d', strtotime('-6 day'));
$maDate6 = date('Y-m-d', strtotime('-7 day'));
$maDate7 = date('Y-m-d', strtotime('-8 day'));
$maDate8 = date('Y-m-d', strtotime('-9 day'));
$maDate9 = date('Y-m-d', strtotime('-10 day'));
$maDate10 = date('Y-m-d', strtotime('-11 day'));
$maDate11 = date('Y-m-d', strtotime('-12 day'));
$maDate12 = date('Y-m-d', strtotime('-13 day'));
$maDate13 = date('Y-m-d', strtotime('-14 day'));
$maDate14 = date('Y-m-d', strtotime('-15 day'));
$sql = "SELECT * FROM `fraude` where dateajout='$maDate' OR dateajout='$maDate1' OR dateajout='$maDate2' OR dateajout='$maDate3' OR dateajout='$maDate4' OR dateajout='$maDate5
OR dateajout='$maDate6' OR dateajout='$maDate7' OR dateajout='$maDate8' OR dateajout='$maDate9' OR dateajout='$maDate10' OR dateajout='$maDate11'
OR dateajout='$maDate12' OR dateajout='$maDate13' OR dateajout='$maDate14' OR dateajout='$maDate15'";
$sql = mysql_db_query($db_name,$sql);
while($dep = mysql_fetch_array($sql)) {
$id_ann=$dep['id'];
$date=$dep['dateajout'];
if ($maDate == $date) {
echo '';
}
else {
$sql = "delete from fraude where dateajout='$date'";
$sql = mysql_db_query($db_name,$sql);
echo '';
}
}
?> |
Partager