Advertisement
Guest User

Untitled

a guest
May 23rd, 2018
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.80 KB | None | 0 0
  1. public function getBooks($start = 0, $limit = 2, $order = "ASC")
  2. {
  3. $sql_start = $start * $limit;
  4. $sql_limit = $limit;
  5. $sql_order_by = $order;
  6.  
  7. $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";
  8. $statment = $this->db->prepare($query);
  9. $statment->execute([
  10. ':username' => $this->username
  11. ]);
  12. $result = $statment->fetchAll();
  13.  
  14. echo "<table id='myTable' border='1'>
  15.  
  16. <tr>
  17. <th><a id='sorter' href='#'>Books</a></th>
  18. <th>Action</th>
  19. </tr>";
  20. foreach($result as $row){
  21. echo "<tr>";
  22. echo "<td>" . $row['nameOfBook'] . "</td>";
  23. echo "<td>" ."<input type='submit' id='delete".$row['book_id']."-".$row['user_id']."' onclick='deleteBook(this)' name='delete' value='Delete'>" . "</td>";
  24. echo "</tr>";
  25. }
  26.  
  27. echo "</table>";
  28. echo "";
  29. return count($result);
  30. }
  31.  
  32. <script>
  33. $(document).ready(function() {
  34. $( "#sorter" ).click(function() {
  35. var order_by_value = $('input[name="order_by"]').val();
  36. if(order_by_value == "ASC"){
  37. $('input[name="order_by"]').val("DESC");
  38. }
  39. else {
  40. $('input[name="order_by"]').val("ASC");
  41. }
  42. $('input[name="current"]').trigger('click');
  43. });
  44.  
  45. });
  46. </script>
  47.  
  48. <script>
  49. $(document).ready(function() {
  50. $( "#sorter" ).click(function() {
  51. var order_by_value = $('input[name="order_by"]').val();
  52.  
  53. $.ajax({
  54. type: 'GET',
  55. url: 'the url link ',
  56. data: {
  57. 'order_by_value': order_by_value
  58. },
  59. success: function (res) {
  60. if(res == "ASC"){
  61. $('input[name="order_by"]').val("ASC");
  62. }
  63. else {
  64. $('input[name="order_by"]').val("DSC");
  65. }
  66. $('input[name="current"]').trigger('click');
  67. });
  68. }
  69. });
  70.  
  71. </script>
  72.  
  73. $.ajax({
  74. type: 'GET',
  75. url: 'your_page_link.php',//this will be url of your backend page
  76. data: {
  77. 'name':name
  78. 'email':email
  79. },// if you are using form then just use .serialize() to submit the form instead of preparing data like this use $("#form_id").serialize()
  80. success: function (msg) {
  81. resp = msg;
  82. }
  83. }).done(function(){
  84. if(resp == your_expected_response){
  85. window.location.href = "http://stackoverflow.com";
  86. }else{
  87. //your error handler
  88. }
  89. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement