Getting datetime from mysql into php?

Question

I have the following code (a countdown timer using php and javascript) that I am working on. What I am trying to do is to get the datetime ($end_date) from the mysql and place it in the $date ='' inside my code.

This code will work just fine if i enter the date and time manually in the code like this: $date = 'September 17 2013 12:00:00 PM GMT';

but i need it to work some how like this:

$date = echo $dynamicList;

or like this maybe:

$date = echo $end_date;

I'm not sure what I am doing wrong!

here is my full code:

<?php 
error_reporting(E_ALL);
ini_set('display_errors', '1');
?>
<?php date_default_timezone_set('GMT'); ?>
<?php
session_start();
// Run a select query to get my letest 6 items
// Connect to the MySQL database  
include "config/connect.php";
$dynamicList = "";
$sql = "SELECT * FROM item ORDER BY id";
$query = mysqli_query($db_conx, $sql);
$productCount = mysqli_num_rows($query); // count the output amount
if ($productCount > 0) {
    while($row = mysqli_fetch_array($query, MYSQLI_ASSOC)){ 
             $id = $row["id"];
             $product_name = $row["product_name"];
             $date_added = strftime("Y-m-d", strtotime($row["date_added"]));
             $end_date = strftime("Y-m-d H:i:s", strtotime($row["end_date"]));
             $price = $row["price"];
             $dynamicList .= '<div>' . $end_date . '
      </div>';
    }
} else {
    $dynamicList = "No Records";
}
?>

<?php
$date = echo $dynamicList;
$exp_date = strtotime($date);
$now = time();

if ($now < $exp_date) {
?>
<script>
// Count down milliseconds = server_end - server_now = client_end - client_now
var server_end = <?php echo $exp_date; ?> * 1000;
var server_now = <?php echo time(); ?> * 1000;
var client_now = new Date().getTime();
var end = server_end - server_now + client_now; // this is the real end time

var _second = 1000;
var _minute = _second * 60;
var _hour = _minute * 60;
var _day = _hour *24
var timer;

function showRemaining()
{
    var now = new Date();
    var distance = end - now;
    if (distance < 0 ) {
       clearInterval( timer );
       document.getElementById('countdown').innerHTML = 'EXPIRED!';

       return;
    }
    var days = Math.floor(distance / _day);
    var hours = Math.floor( (distance % _day ) / _hour );
    var minutes = Math.floor( (distance % _hour) / _minute );
    var seconds = Math.floor( (distance % _minute) / _second );

    var countdown = document.getElementById('countdown');
    countdown.innerHTML = '';
    if (days) {
        countdown.innerHTML += 'Days: ' + days + '<br />';
    }
    countdown.innerHTML += 'Hours: ' + hours+ '<br />';
    countdown.innerHTML += 'Minutes: ' + minutes+ '<br />';
    countdown.innerHTML += 'Seconds: ' + seconds+ '<br />';
}

timer = setInterval(showRemaining, 1000);
</script>
<?php
} else {
    echo "Times Up";
}
?>
<div id="countdown"></div>

could someone please help me out with this?

I do not get any errors on my page. only a blank page and if I change $date = echo $dynamicList; to $date = '$dynamicList'; i get the Times Up message!

any help would be appreciated.

EDIT My new code:

<?php 
error_reporting(E_ALL);
ini_set('display_errors', '1');
?>
<?php date_default_timezone_set('GMT'); ?>
<?php
session_start();
// Run a select query to get my letest 6 items
// Connect to the MySQL database  
include "config/connect.php";
$dynamicList = "";
$sql = "SELECT * FROM item ORDER BY id";
$query = mysqli_query($db_conx, $sql);
$productCount = mysqli_num_rows($query); // count the output amount
if ($productCount > 0) {
    while($row = mysqli_fetch_array($query, MYSQLI_ASSOC)){ 
             $id = $row["id"];
             $product_name = $row["product_name"];
             $date_added = strftime("%Y-%m-%d", strtotime($row["date_added"]));
             $end_date = strftime("%Y-%m-%d %H:%M:%S", strtotime($row["end_date"]));
             $price = $row["price"];
             $dynamicList .= '<div>' . $end_date . '
      </div>';
    }
} else {
    $dynamicList = "No Records";
}
?>

<?php
$date = "'".$end_date."'";
$exp_date = strtotime($date);
$now = time();

if ($now < $exp_date) {
?>
<script>
// Count down milliseconds = server_end - server_now = client_end - client_now
var server_end = <?php echo $exp_date; ?> * 1000;
var server_now = <?php echo time(); ?> * 1000;
var client_now = new Date().getTime();
var end = server_end - server_now + client_now; // this is the real end time

var _second = 1000;
var _minute = _second * 60;
var _hour = _minute * 60;
var _day = _hour *24
var timer;

function showRemaining()
{
    var now = new Date();
    var distance = end - now;
    if (distance < 0 ) {
       clearInterval( timer );
       document.getElementById('countdown').innerHTML = 'EXPIRED!';

       return;
    }
    var days = Math.floor(distance / _day);
    var hours = Math.floor( (distance % _day ) / _hour );
    var minutes = Math.floor( (distance % _hour) / _minute );
    var seconds = Math.floor( (distance % _minute) / _second );

    var countdown = document.getElementById('countdown');
    countdown.innerHTML = '';
    if (days) {
        countdown.innerHTML += 'Days: ' + days + '<br />';
    }
    countdown.innerHTML += 'Hours: ' + hours+ '<br />';
    countdown.innerHTML += 'Minutes: ' + minutes+ '<br />';
    countdown.innerHTML += 'Seconds: ' + seconds+ '<br />';
}

timer = setInterval(showRemaining, 1000);
</script>
<?php
} else {
    echo "Times Up";
}
?>
<div id="countdown"></div>

@Richie, this will only echo Y-m-d H:i:s on the page. absolutely wrong — EnergyLynx EnergyLynx
– EnergyLynx EnergyLynx, Commented Sep 17, 2013 at 13:14
you are storing html tags in your $dynamicList variable and then strtotime($data). thas not the correct way to store and change in timestamp. — Ravi Kant Mishra
– Ravi Kant Mishra, Commented Sep 17, 2013 at 13:17

Code Lღver · Accepted Answer · 2013-09-17 13:32:07Z

1

Change these lines:

$date = echo $dynamicList;

With the following code:

$date = "'".$end_date."'";

And define the $end_date as a global variable.

And also add the some more parameter in the following for timezone:

$end_date = strftime("Y-m-d H:i:s A T", strtotime($row["end_date"]));
                                 ^^^ add these

You are getting the timesup message because of your if condition is not correct:

if ($now < $exp_date) {

As you are comparing the unixtimestap with the timeformat.

Use this code:

$date = "'".$end_date."'";
$exp_date = strtotime($date);
$now = strtotime(date("Y-m-d H:i:s A T"));

Then compare these time. You need to change the $now also.

edited Sep 17, 2013 at 13:32

answered Sep 17, 2013 at 13:16

Code Lღver

15.6k16 gold badges61 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

Trenton Trama Over a year ago

Also, note that the user is using strftime. To use the date format they gave, switch strftime to date or change the time format to %Y-%m-%d %H:%M:%S %p %Z

EnergyLynx EnergyLynx Over a year ago

nope, still i get Times Up message! the $end_date is set for the next 5 days in mysql as well. but i still get Times Up message.

EnergyLynx EnergyLynx Over a year ago

I have edited my question with my new code. still doesn't work though.

EnergyLynx EnergyLynx Over a year ago

Sorry but I am still getting the same Times Up message on the page! nothing seem to work.

Code Lღver Over a year ago

@EnergyLynxEnergyLynx check the code by echoing the value of both variables: $now and $end_date.

|

Collectives™ on Stack Overflow

Getting datetime from mysql into php?

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related