How can I make multiple search fields with AJAX Datatables?
<p>I have a Datatables table with AJAX:
<a href="https://datatables.net/examples/data_sources/ajax.html" rel="nofollow">https://datatables.net/examples/data_sources/ajax.html</a>
Using this class:
<a href="https://github.com/DataTables/DataTables/blob/master/examples/server_side/scripts/ssp.class.php" rel="nofollow">https://github.com/DataTables/DataTables/blob/master/examples/server_side/scripts/ssp.class.php</a></p>

<p>This is my Controller:</p>

<pre><code>$whereResult = "";
        if(isset($_POST['provider_id'])) {
            $whereResult.= "provider = ".$_POST['provider_id']['value'];
        }

        $table = 'providers_catalog';
        $primaryKey = 'id';
        $columns = array(
            array( 'db' =&gt; 'product_id', 'dt' =&gt; 0 ),
            array( 'db' =&gt; 'provider',   'dt' =&gt; 1 ),
            array( 'db' =&gt; 'sku',     'dt' =&gt; 2 ),
            array( 'db' =&gt; 'description',     'dt' =&gt; 3 )
        );

        echo json_encode(
            SSP::complex( $_GET, $table, $primaryKey, $columns, $whereResult, $whereAll = null )
        );
</code></pre>

<p>And in my view I try to make another AJAX call, but it doesn't recharge the table:</p>

<pre><code>$('#provider_id').change(function () {
                            var txt = {value: $(this).val(), column: "" + $(this).attr('id') + "" };
                            if(txt != '') {
                                $.ajax({
                                    url: "Catalog/paginate",
                                    method:"post",
                                    data:{provider_id:txt},
                                    dataType:"text",
                                    success:function(data) {

                                    },error:function () {
                                        alert("Error");
                                    }
                                });
                            }
                        });
</code></pre>

<p>The default AJAX Datatables have the input Search that find in any column and then recharge the table, but is integrated with all the components. How can I make custom search fields for each column of my DB?</p>