Drop Down List and PHP

Question

I have a drop down list with Select Option and information written inside are retrieved from the database with a query .

<select name="moto">
      <?php 
        include 'connessione.php';
        $qry = "SELECT NomeOggetto FROM Oggetto";
        $result = mysql_query($qry);
        while($row = mysql_fetch_array($result))
        {
            echo '<option value='.$row["NomeOggetto"].'>'.$row["NomeOggetto"].'</option>';
        }
        ?>
</select>

The problem is that if in the menu i have the name of a motorbike with one space between its name , for example ( Kawasaki Ninja) , when i send it to the PHP page with the POST Method it only displays Kawasaki . How can i show the entire name with the space included ? this is the php page :

<?php  echo $_POST['moto'];  ?>

Doesn't work if i use mysqli . Values won't even show in the drop down list. — Daniela Matteo
– Daniela Matteo, Commented Oct 11, 2014 at 15:13
mysqli_* will work better than mysql_* does. There was probably just a bug in your code - you would have been better off asking about that bug, plus this one. — Brendan
– Brendan, Commented Oct 11, 2014 at 15:14

Duniyadnd · Accepted Answer · 2014-10-11 15:11:56Z

3

You have to put quotes around your attribute values in your HTML

from

echo '<option value='.$row["NomeOggetto"].'>'.$row["NomeOggetto"].'</option>';

to

echo '<option value="'.$row["NomeOggetto"].'">'.$row["NomeOggetto"].'</option>';

answered Oct 11, 2014 at 15:11

Duniyadnd

4,0431 gold badge24 silver badges30 bronze badges

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

Comments

Giacomo1968 · Accepted Answer · 2014-10-11 16:11:48Z

0

Try to send it with urlencode and decode it.

You can also print it as echo " '$_POST['moto']' " will print word1 word2 as 1 string because it is wrapped in quotes:

Try to print_r($_POST); and see if you're posting the entire string.

edited Oct 11, 2014 at 16:11

Giacomo1968

25.3k11 gold badges78 silver badges106 bronze badges

answered Oct 11, 2014 at 15:13

Daniel Krom

10.1k3 gold badges47 silver badges45 bronze badges

1 Comment

Brendan Over a year ago

An HTML select will automatically urlencode the data.

Collectives™ on Stack Overflow

Drop Down List and PHP

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related