Databases
StackOverflow2013
Postsdbo
POCreate an HTML Dropdown From a Javascript Array Without Duplicates
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreate an HTML Dropdown From a Javascript Array Without Duplicates
    primarykey
    data
    text
    <p>Using a <a href="https://stackoverflow.com/questions/11255219/use-a-javascript-array-to-fill-up-a-drop-down-select-box">previously answered SO question</a> as a reference, I created a function that populates a dropdown list in my HTML doc from an existing javascript array.</p> <p>Here's the HTML:</p> <pre><code>&lt;fieldset&gt; &lt;legend&gt;Choose action&lt;/legend&gt; &lt;p&gt;Choose your action and click next&lt;/p&gt;&lt;br /&gt; &lt;select id="trigger"&gt;&lt;/select&gt; &lt;/fieldset&gt; </code></pre> <p>Here's the Javascript:</p> <pre><code>var guns = [ ["Smith and Wesson 500", "Revolver", "Full Frame", 50, "sada"], //model, type, frame, cal, trigger ["Glock 19", "Semi", "Compact", 9, "striker"], ["Smith and Wesson M and P Shield 9", "Semi", "Compact", 9, "striker"], ["Ruger Alaskan", "Revolver", "Full Frame", 44, "dao"], ["Ruger SR9", "Semi", "Compact", 9, "striker"], ["Desert Eagle", "Semi", "Full Frame", 50, "sada"], ["Smith and Wesson M and P Shield 40", "Semi", "Compact", 40, "striker"] ] var triggerDropdown = function(){ var sel = document.getElementById('trigger'); for (var i = 0; i &lt; guns.length; i++) { var opt = document.createElement('option'); opt.innerHTML = guns[i][4]; opt.value = guns[i][4]; sel.appendChild(opt); } }; </code></pre> <p><strong>My challenge:</strong></p> <p>Populate <code>trigger</code> <em>without duplicates</em>. Also, the solution must not require me to permanently change <code>guns</code> (I found a few other helpful SO posts, but most of them involve first removing duplicates from the array...in this case, I don't have the option).</p> <p>Thank you!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USRemo Williams
    plurals
    1. PL
      singulars
      1. LTLinked
    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. POCreate an HTML Dropdown From a Javascript Array Without Duplicates
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou say you can't change `guns`, but you can change a copy of it: `var gunsCopy = guns.slice(0)` (just don't modify any of the inner arrays, or you'll be changing `guns` too). Remove the duplicates from the copy, and use that to populate the dropdown.
      singulars
      1. POCreate an HTML Dropdown From a Javascript Array Without Duplicates
      1. USbfavaretto
 

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