Jquery Datepicker - Enabled dates from mysql database

Question

In my application I want to show a datepicker (jquery) where only some dates are enabled. I get those dates from MySql DB. How can I send these paramemeters to datepicker through ajax?

<input type="text" name="t_Date" id="t_Date">
<script>
    $("#t_Date").datepicker({ 
       datesEnabled : ajax_getDates.php // Here what I need help 
    });
</script>

I don't know whether the getDates methode exists or not.

<input type="text" name="t_Date" id="t_Date"> <script>$("#t_Date").datepicker({ datesEnabled : ajax_getDates.php // Here what I need help })</script>. Dont know whether the getDates methode exists or not. — Priyamanu
– Priyamanu, Commented Dec 22, 2015 at 7:51
please add your code in description instead of comment so that it is easy to read and so that it is useful to everyone. — phoenix
– phoenix, Commented Dec 22, 2015 at 7:55

Mihai Matei · Accepted Answer · 2015-12-22 07:57:36Z

1

Do an ajax request and create the date picker on success callback:

<input type="text" name="t_Date" id="t_Date">
<script type="text/javascript">

    $(document).ready(function() {

        $.post('ajax_getDates.php', {}, function(data){
            $("#t_Date").datepicker({ datesEnabled : data.datesEnabled });
        }, 'json');

    });

</script>

The ajax_getDates.php file should look like:

<?php

    $datesEnabled = array('date1', 'date2', 'date3');
    echo json_encode('datesEnabled' => $datesEnabled);

answered Dec 22, 2015 at 7:57

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

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

3 Comments

Priyamanu Over a year ago

Thank you. Other than document.ready function1, can I call 1datesEnabled : data.datesEnabled on other events? like button onClick?

Mihai Matei Over a year ago

you can do it inside the callback.. you can do whatever you like with that variable

Priyamanu Over a year ago

Oh yes... I got now. Thanks a lot.

Collectives™ on Stack Overflow

Jquery Datepicker - Enabled dates from mysql database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related