Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>So it sounds like each element should have its own <code>page</code> variable.</p> <p>An easy solution is to use <code>.each()</code> to assign the handlers, and create the <code>page</code> variable inside the <code>each</code> callback.</p> <pre><code>$('.loadMore').each(function() { var page = 1; $(this).click(function() { page++; var subcategoryId = $(this).parent().attr('data-subcategoryId'); var url = 'http://www.domain.com/request.php?subcategoryId='+subcategoryId+'&amp;page='+page; console.log(url); }); }); </code></pre> <p>Because JavaScript functions are closures, each <code>.click</code> handler has been created in its own fresh variable environment, and each handler will always have reference to the variables that were in scope at the time of creation.</p> <p>This means that each handler has its own personal <code>page</code> variable to increment.</p> <p>Another solution would be to use "event data". You can associate data with a particular element via the <code>event</code> object.</p> <pre><code>$('.loadMore').each(function() { $(this).bind("click", {page:1}, loadMoreHandler); }); function loadMoreHandler(e) { e.data.page++; var subcategoryId = $(this).parent().attr('data-subcategoryId'); var url = 'http://www.domain.com/request.php?subcategoryId='+subcategoryId+'&amp;page='+e.data.page; console.log(url); } </code></pre> <p>Since a closure is no longer taken advantage of, I used a named function for the handler for the sake of function object reuse. You can change it back to an anonymous function if it doesn't matter to you.</p>
    singulars
    1. This table or related slice is empty.
    1. POJavaScript: Increment Variable value on click relative to parent
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USgray state is coming
    1. USgray state is coming
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POJavaScript: Increment Variable value on click relative to parent
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COExcellent response! Thorough explanation, as well as the alternative solution make this my accepted answer. I also like that I don't have to modify my HTML. +1
      singulars
      1. PO
      1. USrobabby
    2. COIt has come to my attention that although this works great in desktop, it is not collecting the `click()` event on my touch device. Any thoughts?
      singulars
      1. PO
      1. USrobabby
    3. CO@stat30fbliss: I haven't programmed for touch devices, but I've heard that the click event takes longer to register. I think there are workarounds using other event types. You'll want to do a bit of research on touch based event handling.
      singulars
      1. PO
      1. USgray state is coming
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload