Using php date as targetdate

[penster1]

1) Script Title: Universal Countdown

2) Script URL (on DD):http://www.dynamicdrive.com/dynamici...lcountdown.htm

3) Describe problem: how to i designate a mysql data field for targetdate, in other words i have end date/time stored in mysql database and would like to have it automatically inserted into targetdate ($targettime).

[Jas]

Try echoing the date to the call

var launchdate=new cdLocalTime("cdcontainer", "server-php", 0, "<?php echo $targettime; ?>", "debugmode")

[ddadmin]

In general, the checklist for using any server side language to dynamically output client side JavaScripts is the same. As long as what gets output to the browser conforms to the syntax/ conventions of the client side script, as if you've manually added it to the page, it should work. In this case, it may look something like this:

var launchdate=new cdLocalTime("cdcontainer", "server-php", 0, <?echo $storedtime ?>, "debugmode")

Assuming your pages are PHP enabled (.php), and $storedtime contains the full date/ time string you wish to count down to.

[ddadmin]

Heh what Jas said in other words.

[Jas]

Heh what Jas said in other words.

It must be right when two people say it

[penster1]

It must be right when two people say it

I have tried both of the examples that where posted prior, but neither works. Script just gives me all NAN NAN etc.

$dateclose is the timestamp from database.

$targetdate = strftime("%A, %B %d, %Y %H:%M:%S %p", $date_close);

var launchdate=new cdLocalTime("cdcontainer", "server-php", -60, "<?php echo $targetdate; ?>", "debugmode")

Any other suggestions???

[ddadmin]

Is your page properly PHP enabled? Please post a link to the page on your site that contains the problematic script so we can check it out.

[Jas]

In addition to having a PHP enabled server, the file also needs a .php extension (not .html) in order for it to go through the PHP parser.

I would test it by just echoing the value of the variable to the body of the page to see if it works. If it does, make sure that it conforms to the date format needed in the JavaScript.

[penster1]

Finally resolved problem!!
Changed the following:
$targetdate = strftime("%A, %B %d, %Y %H:%M:%S %p", $date_close);

To This:
$targetdate = strftime("%B %d, %Y %H:%M:%S", $date_close);

Works Great.

Now just need the page to redirect when timesup.

[Jas]

The script supports a function when the timer hits 0. To redirect, change:

else{ //else if target date/time met
var displaystring="" //Don't display any text
alert("Launch time!") //Instead, perform a custom alert
}

to:

else{
    var displaystring="";
    window.location="http://www.mysite.com";
}