DMXzone Calendar Support Product Page

Date from Database

Asked 22 Jan 2009 13:02:16
has this question
22 Jan 2009 13:02:16 Denis Hoffmann posted:
Hi there,

I use the calendar for my small CMS. The Author choose the date from the Calendar. I use the ATOM date format: dateFormat : "yy-mm-dd". So the date is written 2009-01-22 into my database.

Now, i create an edit page where i get the date from the database. 2009-01-22. I did this: defaultDate : new Date('<?php echo $row_AllReviews["ReviewExpire"]; ?>') but that doesnt work the Calendar doesnt show the days. I want the database date to be shown in the inputfield at the calendar.

how does that work?

Please, help it is urgend <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>



Replied 22 Jan 2009 14:03:29
22 Jan 2009 14:03:29 Denis Hoffmann replied:
I hope i got it right.

i just inserted a VALUE="" in the input tag. that works.

Would be cool if it will be in the interface <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>


Replied 22 Jan 2009 22:48:23
22 Jan 2009 22:48:23 George Petrov replied:
Hi Dennis,

You can use the thunder icon next to the initial date to select dynamic data:

<img src="" border=0>

The value attribute also works for the input field indeed.


George Petrov - Founder of the Dynamic Zones,,,,,
Replied 31 Jan 2009 23:22:13
31 Jan 2009 23:22:13 Nicolas Jene replied:
Sorry, but the Thunder does really not work. I have to add manually the value of a field. Please fix that in the next release.

Greets -Nicolas
Replied 12 Feb 2009 18:27:03
12 Feb 2009 18:27:03 Denis Hoffmann replied:
Right that doesnt WORK!

the code seems to ok, but the output is wrong. only NaN-NaN-NaN

<input type="text" id="ReviewDate" name="ReviewDate" readonly="readonly"  value="2009-02-13" />
  <script type="text/javascript">
  // <![CDATA[
  $(function() {$('#ReviewDate').datepicker({
    skin : "dmxCalendar",
    dateFormat : "yy-mm-dd",
    showStatus : true,
    numberOfMonths : [1,1],
    showAnim : "slide",
    showOptions : 
      direction : "up",
      easing : "easeOutBounce"
    duration : "slow",
    showOn : "both",
    buttonImage : "../Styles/dmxCalendar/calendar_icon.gif",
    buttonImageOnly : true,
    defaultDate : new Date('2009-02-13'),
    regional : "de"
  // ]]>

Please FIX it! [!]

Edited by - Denis Hoffmann on 12 Feb 2009  18:28:42
Replied 24 Mar 2009 19:21:47
24 Mar 2009 19:21:47 jose barroso replied:

I'm having the same problem

<img src="" border=0>

Replied 27 Mar 2009 14:36:23
27 Mar 2009 14:36:23 Fabrice Gilbay replied:
Same problem here !!

Can you reply please ?

Thanks in advance.
Replied 27 Mar 2009 14:52:25
27 Mar 2009 14:52:25 Fabrice Gilbay replied:
It seems that it works with only one format :
"M d, yy"

Can you confirm ?
Replied 27 Mar 2009 19:25:03
27 Mar 2009 19:25:03 jose barroso replied:

To solve the problem I had to replace the line:

defaultDate : new Date('<?php echo $row_rs_eventos["data"]; ?>')


defaultDate : '<?php echo $row_rs_eventos['data, yy-mm-dd']; ?>'

Replied 30 Mar 2009 18:06:29
30 Mar 2009 18:06:29 Bob Cox replied:

Well done

I have the same problem.

DMX Zone really ought to have sorted thsi


Replied 12 Oct 2009 12:33:47
12 Oct 2009 12:33:47 Tim Walters replied:
I have just created an update form using PHP, which includes a date field. I used the Thunder Icon on the
To solve the problem I had to replace the line: as per the previous reply

defaultDate : new Date('<?php echo $row_rs_eventos["data"]; ?>')


defaultDate : '<?php echo $row_rs_eventos['data, yy-mm-dd']; ?>'


This however did not work. To get around this I used the Thunder selected a dynamic Date and then I deleted the defaultDate: entry. This worked for me.
Replied 12 Oct 2009 14:00:09
12 Oct 2009 14:00:09 Patrick Julicher replied:
Hi all,

Please also have a look at this FAQ.

Kind regards, Patrick
Replied 19 Jun 2010 12:16:17
19 Jun 2010 12:16:17 Nikki Cade replied:
I cannot believe this still is an issue.

I need to pass a php variable as the initial date.

The only way I can see to get round the issue is to write the variable to the database and then recall it and use the fix described here.

Does anyone have another workround for this?

It would be a lot simpler if this was fixed.

I really like dmxzone extensions and they are better than most around but I really think that not fixing this issue is a mistake.
Replied 02 Dec 2011 12:28:50
02 Dec 2011 12:28:50 Denis Hoffmann replied:
can this be fixed?
thanks a lot,
Replied 08 Dec 2011 17:57:29
08 Dec 2011 17:57:29 Denis Hoffmann replied:
will this be fixed?

please for PHP

Edited by - Denis Hoffmann on 08 Dec 2011  17:59:24

Reply to this topic