Guest User

Untitled

a guest
Jan 22nd, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. <?php
  2. include_once '../include/connections.php';
  3. $id =$_REQUEST['uid'];
  4. $result= mysql_query("SELECT * FROM data WHERE uid = '$id'");
  5. $test = mysql_fetch_array($result);
  6. echo $test[14];
  7. echo "<br /><br />";
  8. $today=time();
  9. $enddate=strtotime('$test[14]');
  10. $timediff = $enddate - $today;
  11. $days=intval($timediff/86400);
  12. $remaining=$timediff%86400;
  13. $hours=intval($remaining/3600);
  14. $remaining=$remaining%3600;
  15. $mins=intval($remaining/60);
  16. $secs=$remaining%60;
  17. echo "<br>".$days.' days '.$hours.' hours '.$mins.' minutes and '.$secs.' seconds.';
  18. ?>
  19.  
  20. $timestamp = '1348381896';
  21. $date = date('Y-m-d H:i:s', $timestamp);
  22. echo $date;
  23.  
  24. $date = '2012-09-26 00:00:00';
  25. $timestamp = strtotime($date);
  26. echo $timestamp;
  27.  
  28. $today = new DateTime();
  29.  
  30. $mysqlDate = "2012-12-15 13:40:20"; //for example
  31. // To match your code this would be $mysqlDate = $test[14];
  32. $mysqlFormat = 'Y-m-d H:i:s';
  33.  
  34. $endDate = DateTime::createFromFormat($mysqlFormat, $mysqlDate);
  35. $diff = $today->diff($endDate);
  36. echo "You have {$diff->d} days, {$diff->h} hours and {$diff->m} minutes left";
Add Comment
Please, Sign In to add comment