Advertisement
Guest User

Untitled

a guest
Sep 21st, 2014
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. <?php include "config.php"; ?>
  2. <?php
  3.  
  4. // Connect to database
  5. $query = mysqli_query($con,"SELECT * FROM reservations WHERE reserved='yes' AND confirmed='no'");
  6. $row = mysqli_fetch_array($query);
  7.  
  8. // set reservation time
  9. $datetime = $row['datetime'];
  10. $datetime -> modify('+3 days');
  11.  
  12. $now = date("Y-m-d H:i:s");
  13.  
  14. foreach $query as $row {
  15. if ($datetime > $now) {
  16. //it still has time. sent reminder if less than 24 hours left.
  17. } else {
  18. //time has passed, set registration inactive.
  19. }
  20. }
  21. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement