Using tablesorter with an ajax query not working

I am trying to get the tablesorter plugin to work with an ajax query to php mysql.

I am calling the plugin as such:
src='custom/warning_list/tablesort/jquery.tablesorter.js type='text/javascript
href=“custom/warning_list/tablesort/themes/blue/style.css” rel=“stylesheet”

Jquery/Ajax

//SEARCH WARNINGS - DEFAULT
$(document).off("click", "#search_warning");
$(document).on("click", "#search_warning", function() {
  var comp_name_search    = $("#comp_name_search").val();
  var comp_city_search    = $("#comp_city_search").val();
  var comp_state_search   = $("#comp_state_search").val();
  var comp_contact_search = $("#comp_contact_search").val();
  var comp_sortby_search  = $("#comp_sortby_search").val();
  var action              = 'warn_search_default';
  //alert(comp_sortby_search);
  var dataString    = 'comp_name_search=' + comp_name_search + '&comp_city_search=' + comp_city_search + '&comp_state_search=' + comp_state_search + '&comp_contact_search=' + comp_contact_search + '&comp_orderby_search=' + comp_sortby_search + '&action=' + action;
  //alert(dataString);
  $.ajax({
  type: "POST",
  url: "custom/warning_list/warn-action.php",
  cache: false,
  data: dataString,
  success: function(response){
      $("#warn-search-results").html(response);
      $("#warn-data").tablesorter({theme: 'blue'});
      $("#warn-data").trigger("sortupdate"); 
      $("#warn-data").append(response);
      $("#warn-data").trigger("appendCache");
   },
   error: function(err) {
        alert(err);
    }
  });
return false;
});

The php page…

    $comp_name_search    = $_POST['comp_name_search'];
    $comp_city_search    = $_POST['comp_city_search'];
    $comp_state_search   = $_POST['comp_state_search'];
    $comp_contact_search = $_POST['comp_contact_search'];
    $order_by            = $_POST['comp_orderby_search']; 

    $wheres = array();
    $params = array();
    if (!empty($comp_name_search)) {
        $wheres[] = 'comp_name LIKE :comp_name';
        $params[':comp_name'] = '%'.$comp_name_search.'%';
    }
    if (!empty($comp_city_search)) {
        $wheres[] = 'comp_city LIKE :comp_city';
        $params[':comp_city'] = '%'.$comp_city_search.'%';
    }
    if (!empty($comp_state_search)) {
        $wheres[] = 'comp_state LIKE :comp_state';
        $params[':comp_state'] = '%'.$comp_state_search.'%';
    }
    if (!empty($comp_contact_search)) {
        $wheres[] = 'comp_contact LIKE :comp_contact';
        $params[':comp_contact'] = '%'.$comp_contact_search.'%';
    }

    $sql = "SELECT * FROM warning_list";
    if (!empty($wheres)) {
        $sql .= " WHERE " . implode(' OR ', $wheres);
    }
    $sql .= " ORDER BY ".$order_by." ASC";
    $stmt = $pdo->prepare($sql);
    $stmt->execute($params);        

    if ($stmt->rowCount() > 0) {
      $stmt->setFetchMode(PDO::FETCH_ASSOC);

    echo "<table name='warn-data' id='warn-data' class='tablesorter sortable'><thead><tr><th>Company Name</th><th>Reference Number</th><th>City</th><th>State</th><th>Zip</th><th>Contact</th><th>Sumbit Date</th><th>Category</th><th>Rebuttals</th><th>Notify</th><th>Edit</th><th>Remove</th></tr></thead><tbody>";

        $iterator2 = new IteratorIterator($stmt);
        foreach($iterator2 as $row ) {
        $warn_id       = $row['warn_id'];
        $comp_name     = $row['comp_name'];
        $comp_acct_num = $row['comp_acct_num'];
        $comp_contact  = $row['comp_contact'];
        $comp_city     = $row['comp_city'];
        $comp_state    = $row['comp_state'];
        $comp_zip      = $row['comp_zip'];
        $submit_date   = $row['submit_date']; 
        $warn_category = $row['comp_status'];   
        $warn_active   = $row['warn_active'];

        if ($warn_category == 'FU') {$warn_category = 'Financial Unsettled';}
        if ($warn_category == 'FS') {$warn_category = 'Financial Settled';}
        if ($warn_category == 'NF') {$warn_category = 'Non-Financial';}
        if ($warn_category == 'RTS-ATTEMPTED') {$warn_category = 'RTS-Attempted, unable to forward';}

        if ($warn_active == '1') {$warn_active = 'Active';}
        else {$warn_active = 'Inactive';}

        echo "<tr>";
        echo "<td>".$comp_name."</td>";
        echo "<td>".$comp_acct_num."</td>";
        echo "<td>".$comp_city."</td>";
        echo "<td>".$comp_state."</td>";
        echo "<td>".$comp_zip."</td>";
        echo "<td>".$comp_contact."</td>";
        echo "<td>".$submit_date."</td>";
        echo "<td>".$warn_category."</td>";
        echo "<td><a class='rebuttals' rebutID=".$warn_id.">Rebuttals</a></td>";
        echo "<td><a class='notify' notifyID=".$warn_id.">Notify</a></td>";
        echo "<td><a class='edit-warn-modal' editID=".$warn_id.">Edit</a></td>";
        echo "<td><a class='remove-warn' removeID=".$warn_id.">Delete</a></td>";
        echo "</tr>";
    }
    echo "</tbody></table>";
   }
   else{echo "No Results.";}

Any help would be greatly appreciated… I am at a complete stop and no where to go… No errors either.

Thanks!

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.