How to use assign html select value to a php variable

Question

 <select name="parentgroup" type="text" id="select2" onchange="this.form.submit();">
 <?php
 echo "<option value=\"0\">All Users</option>";
 $result = mysql_query("select * from login WHERE stato=1");
 while ($myresults = mysql_fetch_array($result))
 {

      $username = $myresults['user_name'];
      echo "<option value=\"".$username."\" "; 
      echo $username== $parentgroupid ? " selected" : ""; 
      echo ">".$username."</option>";
 }
 ?>
 </select>

Hi...am supposed to use the first element in <select> which is <option value=\"0\">All Users</option> to fetch values from a mysql database.

I want to now how you can assign this to a variable and use it just like $parentgroupid

i already have a form......i need to assignthe first entry to a variable — Julius Gitonga
– Julius Gitonga, Commented Aug 27, 2013 at 13:14

Quentin · Accepted Answer · 2013-08-27 12:50:38Z

1

When you submit the form (which presumably exists since you are referencing it from your JavaScript): Get the value from $_GET['name_of_form_control'] in the document referenced by the action attribute of the form.

answered Aug 27, 2013 at 12:50

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

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

1 Comment

Julius Gitonga Over a year ago

The first element in the droplist is just assigned as 'All Users' while the rest of the users are populated from the database....ihave already assigned the database entries to the variable $parentgroupid but i also need to assign the first element which is used to later to query the database and fetch diffrent values from the rest

Cᴏʀʏ · Accepted Answer · 2013-08-27 12:57:25Z

1

When you submit the form, depending on the method specified in the form ("GET" or "POST"), the value will be in either the $_GET or $_POST arrays on the page to which you are submitting. You can retrieve the value by name (the name of the control):

$parentgroupid = $_GET['parentgroup'];

or

$parentgroupid = $_POST['parentgroup'];

edited Aug 27, 2013 at 12:57

answered Aug 27, 2013 at 12:51

Cᴏʀʏ

108k20 gold badges169 silver badges201 bronze badges

6 Comments

rink.attendant.6 Over a year ago

Or $_REQUEST['parentgroup']

Cᴏʀʏ Over a year ago

@rink.attendant.6: Yes, although using $_REQUEST as a catch-all is generally frowned upon due to security issues.

rink.attendant.6 Over a year ago

I agree, but in this case we don't know if they're using GET or POST.

Daryl Gill Over a year ago

@rink.attendant.6 Cory has compensated for this by including an example for both of the global scoped arrays

Julius Gitonga Over a year ago

The first element in the droplist is just assigned as 'All Users' while the rest of the users are populated from the database....ihave already assigned the database entries to the variable $parentgroupid but i also need to assign the first element which is used to later to query the database and fetch diffrent values from the rest

|

Collectives™ on Stack Overflow

How to use assign html select value to a php variable

2 Answers 2

1 Comment

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related