StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMultiple Chained SELECT Tag JavaScript and jQuery
primarykey
Id
19207770
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2013-10-06T10:24:13.147
FavoriteCount
1
LastActivityDate
2015-06-20T02:23:29.230
LastEditDate
2013-10-06T16:51:57.203
LastEditorUserId
1438108
OwnerUserId
2643667
ParentId
0
PostTypeId
1
Score
1
ViewCount
1278
LastEditorDisplayName
text
Body
<p>Good Day! :) </p> <p>I created a chained select using php and jQuery like on this page <a href="http://www.yourinspirationweb.com/en/how-to-create-chained-select-with-php-and-jquery/" rel="nofollow">http://www.yourinspirationweb.com/en/how-to-create-chained-select-with-php-and-jquery/</a> and I created a javascript to add and delete select tags I get it somewhere on the internet but what happening is when I choose a category on the first line everything on the subcategory will be enabled and also on the product description. Just like this <a href="http://i.stack.imgur.com/H9nfb.jpg" rel="nofollow">http://i.stack.imgur.com/H9nfb.jpg</a> </p> <p><strong>this is my code:</strong></p> <pre><code><html> <head> <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function() { $("select#type").attr("disabled", "disabled"); $("select#category").change(function() { $("select#type").attr("disabled", "disabled"); $("select#type").html("<option>wait...</option>"); var id = $("select#category option:selected").attr('value'); $.post("select_type.php", { id: id }, function(data) { $("select#type").removeAttr("disabled"); $("select#type").html(data); }); }); $("select#desc").attr("disabled", "disabled"); $("select#type").change(function() { $("select#desc").attr("disabled", "disabled"); $("select#desc").html("<option>wait...</option>"); var id = $("select#type option:selected").attr('value'); $.post("select_desc.php", { id: id }, function(data) { $("select#desc").removeAttr("disabled"); $("select#desc").html(data); }); }); $("form#select_form").submit(function() { var cat = $("select#category option:selected").attr('value'); var type = $("select#type option:selected").attr('value'); var descr = $("select#desc option:selected").attr('value'); if (cat > 0 && type > 0 && descr > 0) { var result = $("select#desc option:selected").html(); $("#result").html('your choice: ' + result); } else { $("#result").html("you must choose two options!"); } return false; }); }); </script> <script type="text/javascript"> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; var row = table.insertRow(rowCount); var colCount = table.rows[0].cells.length; for (var i = 0; i < colCount; i++) { var newcell = row.insertCell(i); newcell.innerHTML = table.rows[1].cells[i].innerHTML; //alert(newcell.childNodes); switch (newcell.childNodes[0].type) { case "text": newcell.childNodes[0].value = ""; break; case "checkbox": newcell.childNodes[0].checked = false; break; case "select-one": newcell.childNodes[0].selectedIndex = 0; break; } } } function deleteRow(tableID) { try { var table = document.getElementById(tableID); var rowCount = table.rows.length; for (var i = 0; i < rowCount; i++) { var row = table.rows[i]; var chkbox = row.cells[0].childNodes[0]; if (null != chkbox && true == chkbox.checked) { if (rowCount <= 2) { alert("Cannot delete all the rows."); break; } table.deleteRow(i); rowCount--; i--; } } } catch (e) { alert(e); } } </script> </head> <body> <?php include "select.class.php"; ?> <form id="select_form"> <input type="button" value="Add" onclick="addRow('tableID')" /> <input type="button" value="Delete" onclick="deleteRow('tableID')" /> <table id="tableID"> <tr> <td></td> <td>Category</td> <td>SubCategory</td> <td>Product Description</td> </tr> <tr> <td> <input type="checkbox" name="chkbox[]" /> </td> <td> <select id="category" name="category[]"> <?php echo $opt->ShowCategory(); ?></select> </td> <td> <select id="type" name="type[]"> <option value="0">choose...</option> </select> </td> <td> <select id="desc" name="desc[]"> <option value="0">choose...</option> </select> </td> </tr> </table> <input type="submit" value="confirm" /> </form> <div id="result" name="result[]"></div> </body> </html> </code></pre> <p>Hope anyone could help me. :)</p>
Tags
<javascript><php><jquery><html><select>
Title
Multiple Chained SELECT Tag JavaScript and jQuery
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USmanishie
UserOwnerUserId
1. USJill Rose
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POMultiple Chained SELECT Tag JavaScript and jQuery
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
CommentsPostId

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.