Adding name to input field using SQL database field

Question

So what I'm trying to do is add a name='' value to an option in a drop down list. This all is pretty simple using just HTML. But I would like to have the name value be from the database I'm queuing. But the database string has spaces in between the words, and this causes a problem. I need the string to be Eten & drinken and not the way it outputs now, see example below.

Right now, I've got this:

   <?php $q = $row["Categorie"];
        echo    "   
            <option value=".$q." name=".$q.">
               ".$row["Categorie"]."&nbsp;&nbsp;
                   <span style='font-size:1.2rem;color:#F8F8F8;'>(" . $row['x'] .  ")
                   </span>
            </option>
    ";?>

Which outputs the following if I look at the source:

<option value="eten-en-drinken" name="Eten" &amp;="" drinken="">
    Eten &amp; drinken&nbsp;&nbsp;(19)
</option>

I've tried searching google and str_replace, htmlspecialchars, utf8_encode and changed name to data-type but noting works. I just want it to be Eten en drinken. I need this exact value for use in a second drop down menu. Any thoughts, documentation or help?

Sorry, forgot the PHP tags... updated my question. The SELECT * etc is outside this file, but that all works correct. The $row's are shown correct and the data is queued, only the name='' part is the problem here. — Jay-oh
– Jay-oh, Commented Apr 19, 2017 at 12:47
this is weird. in your php, you do not have name and value attributes — Rotimi
– Rotimi, Commented Apr 19, 2017 at 12:49
@Akin What do you mean? (I just made an other update, forgot to change the name value back, oops). How about now? The $stub value was the same as the name value. So I changed that, hope this is better and clearer. — Jay-oh
– Jay-oh, Commented Apr 19, 2017 at 12:54

Bojan Radaković · Accepted Answer · 2017-04-19 13:52:58Z

1

Your problem migh be solved by adding missing quotes for name attribute.

echo    "   
        <option value=".$q." name='".$q."'>..."

answered Apr 19, 2017 at 13:52

Bojan Radaković

4403 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jay-oh Over a year ago

Riiiiightttttt. Now I feel kind of stupid. But this was it. Thank man!

Bojan Radaković Over a year ago

No problem, it can be confusing with all the quotes :)

Sachin K · Accepted Answer · 2017-04-19 12:44:54Z

0

Try this code

$q = $row["Categorie"];

echo "< option value=".$stub." name=".$q." > ".$row["Categorie"]." < span style='font-size:1.2rem;color:#F8F8F8;'>(" . $row['x'] . ")< /span>< /option>";

answered Apr 19, 2017 at 12:44

Sachin K

415 bronze badges

Comments

Netanel Perez · Accepted Answer · 2017-04-19 13:03:54Z

0

You should try using htmlspecialchars() when saving your data to mySQL and not when retrieving it-

<?php
  $new = htmlspecialchars("<a href='test'>Test</a>", ENT_QUOTES);
  echo $new; // &lt;a href=&#039;test&#039;&gt;Test&lt;/a&gt;
?>

When retrieving your data, try using htmlspecialchars_decode()-

<?php
  $str = "<p>this -&gt; &quot;</p>\n";
  echo htmlspecialchars_decode($str);

  // note that here the quotes aren't converted
  echo htmlspecialchars_decode($str, ENT_NOQUOTES);
?>

answered Apr 19, 2017 at 13:03

Netanel Perez

936 bronze badges

Collectives™ on Stack Overflow

Adding name to input field using SQL database field

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related