Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include_once '../include/connections.php';
- $id =$_REQUEST['uid'];
- $result= mysql_query("SELECT * FROM data WHERE uid = '$id'");
- $test = mysql_fetch_array($result);
- echo $test[14];
- echo "<br /><br />";
- $today=time();
- $enddate=strtotime('$test[14]');
- $timediff = $enddate - $today;
- $days=intval($timediff/86400);
- $remaining=$timediff%86400;
- $hours=intval($remaining/3600);
- $remaining=$remaining%3600;
- $mins=intval($remaining/60);
- $secs=$remaining%60;
- echo "<br>".$days.' days '.$hours.' hours '.$mins.' minutes and '.$secs.' seconds.';
- ?>
- $timestamp = '1348381896';
- $date = date('Y-m-d H:i:s', $timestamp);
- echo $date;
- $date = '2012-09-26 00:00:00';
- $timestamp = strtotime($date);
- echo $timestamp;
- $today = new DateTime();
- $mysqlDate = "2012-12-15 13:40:20"; //for example
- // To match your code this would be $mysqlDate = $test[14];
- $mysqlFormat = 'Y-m-d H:i:s';
- $endDate = DateTime::createFromFormat($mysqlFormat, $mysqlDate);
- $diff = $today->diff($endDate);
- echo "You have {$diff->d} days, {$diff->h} hours and {$diff->m} minutes left";
Add Comment
Please, Sign In to add comment