admin/backdate_sessions.php

   1 <?PHP
   2 include_once('/var/www/secure.php');
   3 $q = "select * from presign where only_date = '0000-00-00' ";
   4 $r = $petition->query($q);
   5 while($d = mysqli_fetch_array($r)){
   6   $id = $d['id'];
   7   $action_on = $d['action_on'];
   8   $only_date = date('Y-m-d',strtotime($action_on));
   9   $petition->query("update presign set only_date = '$only_date' where id = '$id' ");
  10   echo "[ $id $action_on $only_date ]";
  11 }
  12 ?>