Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<?php $base = mysql_connect ('localhost', 'Login', 'Motdepasse'); mysql_select_db ('Nom_de_la_base', $base); $sql1="DELETE FROM table_1 WHERE Date NOT BETWEEN (NOW( ) - INTERVAL 1 DAY) AND NOW()"; $sql2="DELETE FROM table_2 WHERE Date NOT BETWEEN (NOW( ) - INTERVAL 1 DAY) AND NOW()"; $req1 = mysql_query($sql1); $req2 = mysql_query($sql2); mysql_close(); ?>
<?php $base = mysql_connect ('localhost', 'Login', 'Motdepasse'); mysql_select_db ('Nom_base', $base); $sql001='UPDATE table_3 SET Champ1=Champ1-1, Champ2=Champ2-1'; $req001 = mysql_query($sql001); mysql_close(); ?>
<?php set_time_limit(0); ignore_user_abort(1); while(1){$base = mysql_connect ('localhost', 'login', 'mdp'); mysql_select_db ('mabase', $base); $sql1="DELETE FROM table1 WHERE Date NOT BETWEEN (NOW( ) - INTERVAL 1 DAY) AND NOW()"; $sql2="DELETE FROM table2 WHERE Date NOT BETWEEN (NOW( ) - INTERVAL 1 DAY) AND NOW()"; $req1 = mysql_query($sql1); $req2 = mysql_query($sql2); mysql_close(); sleep(86400);} ?>
<?php set_time_limit(0); ignore_user_abort(1); while(1){$base = mysql_connect ('localhost', 'login', 'mdp'); mysql_select_db ('mabase', $base); $sql001='UPDATE table3 SET Champ1=Champ1-1, Champ2=Champ2-1'; $req001 = mysql_query($sql001); mysql_close(); sleep(86400);}?>