Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <blockquote> <p>What I mean is, on a page the user can enter one number or thirty numbers, then he/she presses the OK button and the next page shows the array in the same order as it was entered, one element at a time.</p> </blockquote> <p>Ok, so you need some user input first? There's a couple of methods of how to do that.</p> <ol> <li>First is the <code>prompt()</code> function which displays a popup asking the user for some input. <ul> <li>Pros: easy. Cons: ugly, can't go back to edit easily.</li> </ul></li> <li>Second is using html <code>&lt;input type="text"&gt;</code> fields. <ul> <li>Pros: can be styled, user can easily review and edit. Cons: a bit more coding needed.</li> </ul></li> </ol> <p>For the <code>prompt</code> method, collecting your strings is a doddle:</p> <pre><code>var input = []; // initialise an empty array var temp = ''; do { temp = prompt("Enter a number. Press cancel or leave empty to finish."); if (temp === "" || temp === null) { break; } else { input.push(temp); // the array will dynamically grow } } while (1); </code></pre> <p><sub><em>(Yeah it's not the prettiest loop, but it's late and I'm tired....)</em></sub></p> <p>The other method requires a bit more effort.</p> <ol> <li>Put a single input field on the page.</li> <li>Add an <code>onfocus</code> handler to it. <ol> <li>Check if there is another input element after this one, and if there is, check if it's empty. <ul> <li>If there is, don't do anything.</li> <li>Otherwise, create a new input, put it after this one and apply the same handler to the new input.</li> </ul></li> </ol></li> <li>When the user clicks OK, loop through all the <code>&lt;input&gt;</code>s on the page and store them into an array.</li> </ol> <p>eg:</p> <pre><code>// if you put your dynamic text fields in a container it'll be easier to get them var inputs = document.getElementById('inputArea').getElementsByTagName('input'); var input = []; for (var i = 0, l = inputs.length; i &lt; l; ++i) { if (inputs[i].value.length) { input.push(inputs[i].value); } } </code></pre> <p>After that, regardless of your method of collecting the input, you can print the numbers back on screen in a number of ways. A simple way would be like this:</p> <pre><code>var div = document.createElement('div'); for (var i = 0, l = input.length; i &lt; l; ++i) { div.innerHTML += input[i] + "&lt;br /&gt;"; } document.body.appendChild(div); </code></pre> <p><strong>I've put this together so you can see it work at jsbin</strong><br> Prompt method: <a href="http://jsbin.com/amefu" rel="noreferrer">http://jsbin.com/amefu</a><br> Inputs method: <a href="http://jsbin.com/iyoge" rel="noreferrer">http://jsbin.com/iyoge</a></p>
    singulars
    1. This table or related slice is empty.
    1. POJavascript dynamic array of strings
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USnickf
    1. USnickf
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POJavascript dynamic array of strings
      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. COthanks. I'm not using a prompt(), i think it's a bit annoying, however the second option looks good. How would I show one element at the time? Something like a input[0] then the user clicks a button and shows input[1], and so on...
      singulars
      1. PO
      1. USwonderer
    2. COOk, I've put the inputs one together now. http://jsbin.com/iyoge Click in the first input and then all you have to do is keep tabbing to the next one until you get bored.
      singulars
      1. PO
      1. USnickf
    3. COgreat. I'm still trying to show ONLY one element at the time once I'm done entering them. Basically instead of showing the whole array ideally it would show arrayelemt[0], arrayelemt[1], arrayelemt[n] until i'm out of elements.
      singulars
      1. PO
      1. USwonderer
 

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