I have this code that is working except 1 thing and that is the following:
When I type in the textbox a datepicker shows up, when the date is clicked the date is put in the textbox for example '27-05-2014'. Now this should filter the page with the right AJAX output when using code below. Unfortunately it doesnt. Any help is much apriciated.
JavaScript:
$('#boekingsnummer_1').keyup(function(){
updateEmployeesText($(this).val(),'boekingsnummer');
});
$('#huiscode_1').keyup(function(){
updateEmployeesText($(this).val(),'huiscode');
});
function updateEmployeesText(val,opt){
$.ajax({
type: "POST",
url: "submit.php",
dataType : 'json',
cache: false,
data: {text: val, filterOpts:opt},
success: function(records){
$('#employees tbody').html(makeTable(records));
}
});
}
PHP:
$opts = (isset($_POST['filterOpts']) ? $_POST['filterOpts'] : FALSE);
$val = (isset($_POST['text']) ? $_POST['text'] : FALSE);
if (($val != FALSE) && ($opts == "boekingsnummer")){
$where = " WHERE boekingsnummer LIKE '".$val."%'";
}elseif (($val != FALSE) && ($opts == "huiscode" )){
$where = " WHERE huiscode LIKE '".$val."%'";
}
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…