PHP get selected value from select box?

Question

This is my code for get database data to select box and i wanna get the seleceted value.I tries many ways but im missing something. help me

<form id="search" action="" method="post" >
   <select name="owner" id="owner">
   <?php 
      $sql = mysql_query("SELECT designation FROM designation");
      while ($row = mysql_fetch_array($sql)){
      echo '<option value="'.$row['designation'].'">'.$row['designation'].'</option>';
      }
      ?>
   </select>
   <input type="submit" value="Search">
</form>

For future reference, you can do this to see all form data sent to the script: `print_r($_POST);`. — Oscar Broman, Sep 03 '13 at 09:09
where do you wish to select the value, at the back-end or at the front-end? — Nikita Gopkalo, Sep 03 '13 at 09:14
possible duplicate of [Using $\_POST to get select option value from HTML](http://stackoverflow.com/questions/17139501/using-post-to-get-select-option-value-from-html) — Iván Rodríguez Torres, Sep 21 '15 at 08:21

score 2 · Accepted Answer · edited May 23 '17 at 12:31

2

As you didn't specify an action for your form, the default will be to send the post values to the same page.

See this for more information about action value.

So, in the same page you have the form, you should add a

if(isset($_POST['owner']))
{
    // Do some stuff
}
else
{
    // Print the form
}

edited May 23 '17 at 12:31

Community

1
1

answered Sep 03 '13 at 09:13

Kethryweryn

639
4
11

score 1 · Answer 2 · answered Sep 03 '13 at 09:11

1

First make sure to include the action. Secondly to get a POST request of a select tag all you have to do is the following:

$_POST["owner"];

answered Sep 03 '13 at 09:11

tabone

172
1
5

Action can be empty, there is no need to fill it. And what you mean by `POST request of a select tag`? Maybe `value of field sent using POST`? – Elon Than Sep 03 '13 at 09:16

score 0 · Answer 3 · answered Sep 03 '13 at 09:09

$_POST['owner'] contains the value of select box once you submit the form.And $_POST contains all the value of input elements you submitted via the form.if you print_r($_POST); it will show you all the values submitted through the form.

If you

echo $_POST['owner'];//Will display the value of your selected value in the select box.

score 0 · Answer 4 · answered Sep 03 '13 at 09:15

<form id="search" action="" method="post" >
            <select name="owner" id="owner">
            <?php 
             $owner="rejayi"
            $sql = mysql_query("SELECT designation FROM designation");
            while ($row = mysql_fetch_array($sql)){
               if($row['designation'] ==  $owner){
     echo '<option value="'.$row['designation'].'" selected="selected">'.$row['designation'].'</option>';
               }else{
           echo '<option value="'.$row['designation'].'">'.$row['designation'].'</option>';
               }
            }
            ?>
            </select>
            <input type="submit" value="Search">
            </form>

score 0 · Answer 5 · answered Sep 03 '13 at 09:33

0

Put Double quotes (") outside and single quotes (') inside

eg:

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

answered Sep 03 '13 at 09:33

PHP get selected value from select box?

5 Answers5