如何在Javascript数组中存储MySQL日期？

Question

I have searched over the Internet, there is a lot of way to store MySQL records into Javascript array though PHP, like this one. However I can't really store the date record in Javascript.

Let say,

My MySQL date record rows in column called holiday_date: 2017-06-25, 2017-06-26, 2017-06-27.

How can I store in Javascript after I converted them into json by

<?php
    $sql = "SELECT public_holiday.holiday_date 
            FROM public_holiday";
    $result = mysqli_query($conn, $sql);

    $result_array = Array();

    while($row = mysqli_fetch_assoc($result))
    {
         $result_array[] = $row;
    }

    $json_array = json_encode($result_array);

    echo $json_array;
  ?>

?

I have tried to store them into a javascript date array like

var holidays = [<?php //sample array for example 
        $loop_one = true;
        foreach ($result_array as $date) 
        {
            if ($loop_one) 
            {
                echo "'new Date(\'$date\')'";
                $loop_one=false;
            } 
            else 
            {
                echo ", 'new Date(\'$date\')'";
            }
        }
?>];

but all of these are invalid.

I need your help, much appreciated.

Answer 1

To get a javaScript date object array you need to change your script code only no need to change the PHP code.
You can use JSON.parse and forEach loop.

Try like this

<script>
    var holidays = '<?php  echo $json_array;?>';
    holidays=JSON.parse(holidays);
    var holidayArray=[];
    holidays.forEach(function (key) {
        holidayArray.push(new Date(key));
    });
    console.log(holidays);
    console.log(holidayArray);
</script>

It will produce an out put as

I thing it will help you.