Search jQuery

jQuery Forum

Using jQuery UI

James Par..

blocking dates with datepicker and php/mysql

in Using jQuery UI • 8 years ago

i am having a problems using a function block dates from a php array iv converted via jsons

it displays the correct dates but isn't disabling the dates

here is my generated jQuery

$(function() {

	var excludedDates = [{"BlckedDate":"24-05-2014"},{"BlckedDate":"30-06-2014"},{"BlckedDate":"31-05-2014"}]; // Converted from PHP using json encode
	$.datepicker.setDefaults({defaultDate: '+1w', changeMonth: false,dateFormat: "dd-mm-yy",
	numberOfMonths: 2, minDate: 0, beforeShowDay: function(date) {
	date = $.datepicker.formatDate('dd-mm-yy', date);
	var excluded = $.inArray(date, excludedDates) > -1;
	return [!excluded, ''];
	}});
	$('#from').datepicker({onSelect: function(selectedDate) {
	$('#to').datepicker('option', 'minDate', selectedDate \|\| 0);
	}});
	$('#to').datepicker({onSelect: function(selectedDate) {
	$('#from').datepicker('option', 'maxDate', selectedDate);
	}});
	});

and my source

<?php
$blacklist = blacklist();
?>
<script>
$(function() {
var excludedDates = <? echo json_encode($blacklist)?>; // Converted from PHP using json encode
$.datepicker.setDefaults({defaultDate: '+1w', changeMonth: false,dateFormat: "dd-mm-yy",
numberOfMonths: 2, minDate: 0, beforeShowDay: function(date) {
date = $.datepicker.formatDate('dd-mm-yy', date);
var excluded = $.inArray(date, excludedDates) > -1;
return [!excluded, ''];
}});
$('#from').datepicker({onSelect: function(selectedDate) {
$('#to').datepicker('option', 'minDate', selectedDate || 0);
}});
$('#to').datepicker({onSelect: function(selectedDate) {
$('#from').datepicker('option', 'maxDate', selectedDate);
}});
});

and finnaly my php function

function blacklist()
{
global $mysqli,$loggedInUser;
$Blocked = 'Blocked';
$stmt = $mysqli->prepare("SELECT
BlckedDate
from
BlockHols
Where
Status = ?
order by BlckedDate asc");
$stmt->bind_param("s", $Blocked);
$stmt->execute();
$stmt->bind_result($BlockedHols);
while ($stmt->fetch()){
$row[] = array('BlckedDate'=>$BlockedHols);
}
$stmt->close;
return ($row);
}

if anyone could help and point my error out i would be extremely great-full i feel like i'm extremely close its infuriating!!

Replies(5)

jakecigar

Re: blocking dates with datepicker and php/mysql

8 years ago

var excludedDates = [{"BlckedDate":"24-05-2014"},{"BlckedDate":"30-06-2014"},{"BlckedDate":"31-05-2014"}];

is not the array that you require for $.inArray.

You need to generate an array, like
var excludedDates = ["24-05-2014" , "30-06-2014" , "31-05-2014" ];

JΛ̊KE

James Par..

Re: blocking dates with datepicker and php/mysql

8 years ago

Thanks Jake, do you know how i would do that?

“Try not. Do, or do not. There is no try.” – Yoda,

jakecigar

Re: blocking dates with datepicker and php/mysql

8 years ago

That’s PHP. I could only guess.

change

$row[] = array('BlckedDate'=>$BlockedHols);

$row[] = $BlockedHols ;

JΛ̊KE

James Par..

Re: blocking dates with datepicker and php/mysql

8 years ago

Thanks at least i know i'm on the right tracks i'm sure ill get the rest ill let you know the answer!

“Try not. Do, or do not. There is no try.” – Yoda,

James Par..