I encountered an issue with searching multiple columns in my serverside datatables. Individual column searches work fine, but when trying to search on more than one column simultaneously, the filter does not function as expected. For example, searching by "name" or "start_date" individually works, but a search for both at the same time does not yield the correct results. Here is the code snippet I am working with:
//my script:
var table = $('#dataTables');
// begin first table
table.dataTable({
"ajax": {
"url": "<?php echo site_url('leader') ?>",
"type": "POST",
"data": function(d) {
d.full_name = $('#full_name').val();
d.start_date = $('#start_date').val(); //what is the correct code?
d.end_date = $('#end_date').val(); //what is the correct code?
},
},
......
......
$('#btn-search').click(function(){
var data_tables = $('#dataTables').DataTable();
data_tables
.search( this.value )
.draw();
})<!-- my view: -->
<div class="form-inline">
<div class="form-group">
<input type="text" name="full_name" class="form-control" id="full_name" placeholder="Name"/>
</div>
<div class="form-group">
<div class="input-group date date-picker" data-date-format="dd-mm-yyyy">
<input type="text" name="start_date" class="form-control" readonly id="start_date" size="8">
<span class="input-group-btn">
<button class="btn default" type="button">
<i class="fa fa-calendar"></i>
</button>
</span>
</div>
</div>
<div class="form-group">
<div class="input-group date date-picker" data-date-format="dd-mm-yyyy">
<input type="text" name="end_date" class="form-control" readonly id="end_date" size="8">
<span class="input-group-btn">
<button class="btn default" type="button">
<i class="fa fa-calendar"></i>
</button>
</span>
</div>
</div>
<button class="btn btn-warning" id="btn-search">Search</button>
</div>serverside:
if ($full_name)
{
$where = "And full_name = '$full_name'";
}
else if($start_date)
{
$where = "And start_date >= to_date('$start_date','DD-MM-YYYY') ";
}
else if($end_date)
{
$where = "And end_date <= to_date('$end_date','DD-MM-YYYY') ";
}
else
{
$where = " "; //how to combine 3 above
}How can I create conditions for multi-column searching in datatables?