php - Retrieving data (dates) from mysql to disable days from datapicker -

i'm still new php/script , know on what's process on how retrieve dates mysql , implementing on jquery datapicker.

my goal highlight , disable dates based inside database within datepicker. i'm not entirely sure on how it, i've searched everywhere nothing wanted. thank much!

the current system i'm developing right event scheduling, want clients have ability check reserved schedules or availability website. have data in mysql, need retrieve it.

so far i've came have disabled dates before present time using data picker.

html

<link href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css" rel="stylesheet" /> <script type="text/javascript" src="https://code.jquery.com/jquery-1.12.4.min.js"></script> <script type="text/javascript" src="http://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script> <label for="job">day of event</label> <input type="text" name="d_event" id="mydate"/> 

script

<script>  var datetoday = new date();  $(function() {     $( "#mydate" ).datepicker({             dateformat: 'yy-mm-dd',         numberofmonths: 3,         showbuttonpanel: true,         mindate: datetoday      }); });  </script>