i have a date entry in yyyy-mm-dd format in mysql database. Using php i could get the date value

$row = $myresult['date'];

now i wish to alert this value in javascript

so i tried

var temp_date = <?php echo($row)?>;
alert (temp_date);

but that didn't work for me. The problem i feel i am facing is to maintain the string format of the datestring, which seems to be getting lost when used in javascript. Any help?

i have a date entry in yyyy-mm-dd format in mysql database. Using php i could get the date value

$row = $myresult['date'];

now i wish to alert this value in javascript

so i tried

var temp_date = <?php echo($row)?>;
alert (temp_date);

but that didn't work for me. The problem i feel i am facing is to maintain the string format of the datestring, which seems to be getting lost when used in javascript. Any help?

• php
• javascript

• As the fifth in a row to provide the very same answer allow me to withdraw mine. – Boldewyn Commented Aug 3, 2009 at 14:36

6 Answers 6

String literals are sorrounded by double or single quotes in JavaScript:

var temp_date = "<?php echo($row)?>";
alert (temp_date);

This answer originally was a quasi exact copy of the other four first.

If you need the date information as such, you could use Unix timestamps:

SELECT UNIX_TIMESTAMP(timefield) AS timestamp WHERE id = 1;

then just echo it in PHP into this JS snippet:

var mydate = new Date(<?php echo $row['timestamp']*1000; ?>);

You don't need quotes here, since you echo a number. This allows for, e.g.,

alert (mydate.getDate());

and the such.

Cheers,

Use json_encode(). This will turn PHP variables into valid javascript, so you don't have to worry about quoting/escaping etc.

var temp_date = <?php echo json_encode($row); ?>;
alert (temp_date);

You have to add quotes to your JavaScript variable assignation:

var temp_date = '<?php echo($row)?>';
alert (temp_date);

var temp_date = '<?php echo($row)?>';
alert (temp_date);

Add quotes. Otherwise it will error because strings without quotes are troublesome.

.php

$smarty->assign("profile_date",date("Y/m/d"));

.tpl

var NowDate=new Date("{/literal}{$profile_date}{literal}");