Databases
StackOverflow2013
Postsdbo
POPassing a <tr> id to jQuery
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPassing a <tr> id to jQuery
    primarykey
    data
    text
    <p>I'm still learning jQuery and I ran into a problem. I have a table with 50+ rows. Each is labeled with an id.</p> <pre><code>&lt;tr id="51"&gt; </code></pre> <p>This id is the database id and I need to pass it to jQuery and submit it along with an AJAX request.</p> <pre><code> $($location).click(function () { var $currentSelection = $(this); // if there is already an input-field in this TD, return... if($currentSelection.find('select').length &gt; 0) return; $currentSelection.html(''); $('&lt;select id="selectLocation" onChange="locationSubmit()"/&gt;') .attr('name', 'location') .append('&lt;option&gt;Location 1&lt;/option&gt;', '&lt;option&gt;Location 2&lt;/option&gt;', '&lt;option&gt;Location 3&lt;/option&gt;') .appendTo(this); }); </code></pre> <p><code>locationSubmit()</code></p> <pre><code>function locationSubmit(){ var $selectLocation = $('#selectLocation').val(); var $selectId = $(this).val('tr#id'); //stuck here alert($selectId); $.ajax({ url: '/ajax/training-update.php', data: { action: $selectLocation, courseid: $selectId }, type: 'POST', success: function(output) { alert(output); } }); } </code></pre> <p>the alert in <code>locationSubmit()</code> is returning [object Object]. How do I pass the value of <code>tr#id</code> to <code>locationSubmit()</code> and send it via AJAX?</p> <p>EDIT - HTML</p> <pre><code>&lt;tr id="51"&gt; &lt;td&gt;&lt;a href="/link/goes/here.php?course_id=5&amp;id=51"&gt;course name&lt;/a&gt;&lt;/td&gt; &lt;td&gt; &lt;span class="rowStartDate" id="rowStartDate151"&gt;09/10/12&lt;/span&gt; - &lt;span class="rowEndDate" id="rowEndDate151"&gt;09/14/12&lt;/span&gt; &lt;/td&gt; &lt;td class="location"&gt;Location 2&lt;/td&gt; &lt;td class="status"&gt;open&lt;/td&gt; &lt;/tr&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPaul Dessert
    1. USPaul Dessert
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPassing a <tr> id to jQuery
      1. This table or related slice is empty.
      1. VTUpMod
    1. COStarting an `id` with a numeral is technically invalid unless you're using HTML5. For HTML4, [HERE](http://www.w3.org/TR/html4/types.html#type-id) are the naming rules. Run your HTML page through the [W3C Validator](http://validator.w3.org/) to be sure.
      singulars
      1. POPassing a <tr> id to jQuery
      1. USSparky
    2. COcheck my new edit, it maybe could be right or a step on the ladder?
      singulars
      1. POPassing a <tr> id to jQuery
      1. USMax Allan
    3. COCould you post a link?
      singulars
      1. POPassing a <tr> id to jQuery
      1. UShowderek
 

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