JavaScript - jQuery - PHP : Display specific time dynamically in my datetimepicker from the database

Question

I have a jQuery datetimepicker using xdsoft plugin. I want to display only specific hours/time that has been stored in my database(using php).

Example if I have values in my database:

'12:00', '13:00', '15:00', 
'17:00', '17:05', '17:20', '19:00', '20:00'

And this is my jQuery for datetimepicker:

$('#datetimepicker1').datetimepicker({
  formatDate:'Y/MMM/d',
  allowTimes:[
    '12:00', '13:00', '15:00', 
    '17:00', '17:05', '17:20', '19:00', '20:00'
  ],
});

My problem is I can't used a technique to get the time values from my database and integrate it to my jQuery. This is what I want:

allowTimes:[my time values in my database],

PLEASE HELP ME :'(

Thanks.,

then you'll need a select statement first

Kevin
– Kevin

2015-05-04 09:39:01 +00:00
Commented May 4, 2015 at 9:39 — Kevin
– Kevin, Commented May 4, 2015 at 9:39

Daan · Accepted Answer · 2015-05-04 09:32:17Z

1

You can wrap the datepicker in an ajax success callback:

$.ajax({
  method: 'GET',
  url: 'gettimes.php'
}).done(function(response){
  $('#datetimepicker1').datetimepicker({
  formatDate:'Y/MMM/d',
  allowTimes:[
     response //JSON STRING with allowed Times
   ]
  });
});

answered May 4, 2015 at 9:32

Daan

12.3k6 gold badges36 silver badges51 bronze badges

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

2 Comments

queen yhen Over a year ago

Problem Solved. You got it. Thanks . Love You :*

Patrick Over a year ago

Hi, and how do you "refresh" the times everytime the user changes the month?

Collectives™ on Stack Overflow

JavaScript - jQuery - PHP : Display specific time dynamically in my datetimepicker from the database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related