Inserting PHP while in JQuery

Question

I am trying to embed a data picker calendar in my php site. The code, which came off the shelf from DatePicker, allows to select some pre-highlighted dates, which is good as I have a list in a db table with the dates I need.

However, I have had no success in finding a way to include php within the script, or the other way round.

The original calendar script is as follows:

<script type='text/javascript'>

$(function() {
$("#txtDate").datepicker({dateFormat: 'yy-mm-dd'});
});

$(document).ready(function() {

    var SelectedDates = {};
    SelectedDates[new Date('02/24/2014')] = new Date('02/24/2014');
 SelectedDates[new Date('03/10/2014')] = new Date('03/10/2014');

    $('#txtDate').datepicker({
        beforeShowDay: function(date) {
            var Highlight = SelectedDates[date];
            if (Highlight) {
            return [true, "Highlighted", Highlight];
        }
        else {
            return [true, '', ''];
        }
    }
});
});
  </script>

I would like to be able to select a long list of dates to go in SelectedDates[new Date('03/10/2014')] = new Date('03/10/2014');

so my original idea was to do as follows:

$(document).ready(function() {
        var SelectedDates = {};

  <?php 
$query = "SELECT eventDate FROM database.calendar WHERE tag='R' AND competition='1'";
$result = mysql_query($query);
while ($row = mysql_fetch_row($result)) {
    $eventdate = $row[0];

SelectedDates[new Date('$eventdate')] = new Date('$eventdate');
}
?>

Sadly, this doesn't work (and neither do any of the various attempts to re-add tags within the PHP.

Any idea? Thank you so much for your help!

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — Benjamin Gruenbaum
– Benjamin Gruenbaum, Commented Jan 25, 2014 at 22:31
Thank you for the tip! Still learning, but I am going to follow through and try and figure out what's the best for my project. — Will WP
– Will WP, Commented Jan 26, 2014 at 22:44

Eduard Luca · Accepted Answer · 2014-01-25 21:57:12Z

1

You have to close your PHP tags to output JavaScript (or use echo as mentioned in a comment):

$(document).ready(function() {
    var SelectedDates = {};

    <?php 
    $query = "SELECT eventDate FROM database.calendar WHERE tag='R' AND competition='1'";
    $result = mysql_query($query);
    while ($row = mysql_fetch_row($result)) {
        $eventdate = $row[0];
        ?>
        SelectedDates[new Date('<?php echo $eventdate; ?>')] = new Date('<?php echo $eventdate; ?>');
        <?php
    }
    ?>
});

Although I should mention that what you are trying to do is not really ideal. Do the PHP while loop separately, get that into an array, and json_encode that.

edited Jan 25, 2014 at 21:57

answered Jan 25, 2014 at 20:34

Eduard Luca

6,62218 gold badges89 silver badges143 bronze badges

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

1 Comment

Will WP Over a year ago

Thank you for this - I shall try that right away. Still not overly familiar with arrays but they seem to be cropping up more and more - one for the lessons soon!

Collectives™ on Stack Overflow

Inserting PHP while in JQuery

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related