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
– Oscar Broman, Commented Sep 3, 2013 at 9:09
where do you wish to select the value, at the back-end or at the front-end? — Nikita Gopkalo
– Nikita Gopkalo, Commented Sep 3, 2013 at 9:14
possible duplicate of Using $_POST to get select option value from HTML — Iván Rodríguez Torres
– Iván Rodríguez Torres, Commented Sep 21, 2015 at 8:21

Community · Accepted Answer · 2017-05-23 12:31:14Z

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, 2017 at 12:31

CommunityBot

11 silver badge

answered Sep 3, 2013 at 9:13

Kethryweryn

6394 silver badges11 bronze badges

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

Comments

tabone · Accepted Answer · 2013-09-03 09:11:18Z

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 3, 2013 at 9:11

tabone

1721 silver badge5 bronze badges

1 Comment

Elon Than Over a year ago

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?

웃웃웃웃웃 · Accepted Answer · 2013-09-03 09:09:02Z

0

$_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.

answered Sep 3, 2013 at 9:09

웃웃웃웃웃

12k15 gold badges63 silver badges95 bronze badges

Comments

Rejayi CS · Accepted Answer · 2013-09-03 09:15:13Z

0

<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>

answered Sep 3, 2013 at 9:15

Rejayi CS

1,0511 gold badge10 silver badges23 bronze badges

Comments

user1328586 · Accepted Answer · 2013-09-03 09:33:50Z

0

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

eg:

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

answered Sep 3, 2013 at 9:33

user1328586

Collectives™ on Stack Overflow

PHP get selected value from select box?

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related