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!