当我单击书籍链接时,他重新加载页面并对列进行排序。
我想使用ajax停止重新加载,,,如何?
这是我在这个过程中的职责。
这个 getBook 函数
public function getBooks($start = 0, $limit = 2, $order = "ASC")
{
$sql_start = $start * $limit;
$sql_limit = $limit;
$sql_order_by = $order;
$query = "SELECT Library.nameOfBook, userBook.book_id, userBook.user_id FROM loginUser JOIN userBook JOIN Library ON userBook.user_id = loginUser.id AND userBook.book_id = Library.id WHERE loginUser.username=:username ORDER BY Library.nameOfBook $sql_order_by LIMIT $sql_start, $sql_limit";
$statment = $this->db->prepare($query);
$statment->execute([
':username' => $this->username
]);
$result = $statment->fetchAll();
echo "<table id='myTable' border='1'>
<tr>
<th><a id='sorter' href='#'>Books</a></th>
<th>Action</th>
</tr>";
foreach($result as $row){
echo "<tr>";
echo "<td>" . $row['nameOfBook'] . "</td>";
echo "<td>" ."<input type='submit' id='delete".$row['book_id']."-".$row['user_id']."' onclick='deleteBook(this)' name='delete' value='Delete'>" . "</td>";
echo "</tr>";
}
echo "</table>";
echo "";
return count($result);
}
这个jquery函数
<script>
$(document).ready(function() {
$( "#sorter" ).click(function() {
var order_by_value = $('input[name="order_by"]').val();
if(order_by_value == "ASC"){
$('input[name="order_by"]').val("DESC");
}
else {
$('input[name="order_by"]').val("ASC");
}
$('input[name="current"]').trigger('click');
});
});
</script>
<script>
$(document).ready(function() {
$( "#sorter" ).click(function() {
var order_by_value = $('input[name="order_by"]').val();
$.ajax({
type: 'GET',
url: 'the url link ',
data: {
'order_by_value': order_by_value
},
success: function (res) {
if(res == "ASC"){
$('input[name="order_by"]').val("ASC");
}
else {
$('input[name="order_by"]').val("DSC");
}
$('input[name="current"]').trigger('click');
});
}
});
</script>
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)