Databases
StackOverflow2013
Postsdbo
POUnexpected entry in a <select> field! How did this happen?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnexpected entry in a <select> field! How did this happen?
    primarykey
    data
    text
    <p>In one of the forms on my website, I have a <code>&lt;select&gt;</code> field like this:</p> <pre><code>&lt;select name="doorno" required&gt; &lt;option&gt;&lt;/option&gt; &lt;option&gt;01&lt;/option&gt; &lt;option&gt;02&lt;/option&gt; &lt;option&gt;03&lt;/option&gt; &lt;option&gt;04&lt;/option&gt; &lt;option&gt;05&lt;/option&gt; &lt;option&gt;06&lt;/option&gt; &lt;option&gt;07&lt;/option&gt; &lt;option&gt;08&lt;/option&gt; &lt;option&gt;09&lt;/option&gt; &lt;option&gt;10&lt;/option&gt; &lt;option&gt;11&lt;/option&gt; &lt;option&gt;12&lt;/option&gt; &lt;option&gt;13&lt;/option&gt; &lt;option&gt;14&lt;/option&gt; &lt;option&gt;15&lt;/option&gt; &lt;option&gt;16&lt;/option&gt; &lt;option&gt;17&lt;/option&gt; &lt;option&gt;18&lt;/option&gt; &lt;option&gt;19&lt;/option&gt; &lt;option&gt;20&lt;/option&gt; &lt;option&gt;21&lt;/option&gt; &lt;option&gt;22&lt;/option&gt; &lt;option&gt;23&lt;/option&gt; &lt;option&gt;24&lt;/option&gt; &lt;/select&gt;&lt;/p&gt; </code></pre> <p>The user should be able to select numbers between 01 - 24 - right?</p> <p>But in the table where these entries are stored, I see an entry like:</p> <pre><code>01,05 </code></pre> <p>How could this have happened? When I try to type into the field I am not able to it - I can only choose one of the options in the list?</p> <p>Any idea how the user could have managed to enter an option like the one above?</p> <p><strong>EDIT</strong> Based on some of the comments I looked into the backend of the database and found that the user has made multiple selections. So now the question has another related question:</p> <p>If I do not specify the MULTIPLE attribute in the SELECT element, does it mean a user can overcome the default behaviour of single select?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USvinaya
    1. USvinaya
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUnexpected entry in a <select> field! How did this happen?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAre you sure that the user is submitting it that way? Could they be submitting 01 and 05 separately via different form submissions and you are concatenating them?
      singulars
      1. POUnexpected entry in a <select> field! How did this happen?
      1. USBrandon
    2. COYou understand that the HTML you have is ***totally*** unrelated to the PHP script? I mean you use them both together, but technically they are totally unrelated. It is the user who brings them together. And you as developer offer both in the strong hope, the user will understand how to use them together. However, if you take care when scripting, it's still you who needs to introduce the idiot checks.
      singulars
      1. POUnexpected entry in a <select> field! How did this happen?
      1. UShakre
    3. CO@hakre - I like the way you said it - the part about "offer both in the strong hope" and "the idiot checks". However, I am a novice at this - very new to all the scripts and languages involved. As for idiot check - LOL I feel like the idiot here for not realizing that there could be situations where users might NEED to select more than one option! ...But you live and you learn! ....And of course, multiple selects leads me to new questions like how they will behave in SELECT queries!
      singulars
      1. POUnexpected entry in a <select> field! How did this happen?
      1. USvinaya
 

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