如何定义何时应隐藏“显示更多”按钮？

Question

I have a mysql table of products.

I have a product listing page where User has a button "Show more" to load more products on the page. After clicking on this button jQuery calculates how many displayed products are on the page (N) and makes an AJAX request to the table for getting 20 more products (N+20).

Now I should create a trigger when I should hide the button. Which trigger I should choose? What is the best way to define that there are no products.

Please, help.

Answer 1

I have no idea how have you reached that functionality since you are not sharing the code and thus I cannot give you the most accurate help, only this one:

• when loading the page and retrieving the first X rows from DB, retrieve the amount of all rows (matching the search criteria) as well
• make this count visible to the template
• in jQuery, count how many rows have you already loaded
  • this means, that on page start you are displaying X rows, the amount of total rows is Y, and the number of currently displayed rows is Z
  • immediately after the page is loaded you need to compare if Z <= Y then do not display button else display the button
  • if the button was displayed I guess you are listening to click event on this button and then performing your AJAX request, here after the AJAX is successfully completed, you need to do Z += X and again compare if Z > Y then hide the button

That should be your logic, now turn it into your code.