Creating a Drop Down Menu in PHP from MySQL?

Question

I'm sort of experienced with PHP and MySQL so I kind of get the hang of things, however I'm sort of trying to get something that may be over my level (not really sure the difficulty level on this). Basically, I am looking to create 2 drop down menus to remove access from a user within the MySQL table. So the first drop down menu will be for the list of users I have, and the the second drop down menu will be for the access they have. I'd like for it to when I select a user, the second drop down menu only shows the options that the user has access to such as;

    <form name="form" method="post" action="access.php">
    <select name='user'>
    <?php 
require "sqlconfig.php"; // My SQL Configuration
$conn=mysql_connect($host, $user, $pass); // The Connection
$selectdb=mysql_select_db("$db"); // The Database
    $userlist1 = mysql_query("SELECT `Username` FROM `accounts` ORDER BY Username ASC");
        while ($userlist = mysql_fetch_array($userlist1)) {
        print "<option value='username'>$userlist[Username]</option>";
        }
    ?>
    </select>
<select name='task'>
<option value="notask" <?php if($_GET['task'] == notask) { echo "selected"; } ?>>Select a Task</option>
<option value="admin" <?php if($_GET['task'] == admin) { echo "selected"; } ?>>Administrator</option>
<option value="user" <?php if($_GET['task'] == user) { echo "selected"; } ?>>user</option>
<option value="guest" <?php if($_GET['task'] == guest) { echo "selected"; } ?>>Guest</option>
</select>
<input type="submit" value="Remove" />
    </form>

I already have the permissions in a table, each value is as integer 0 for false, and 1 for true. So basically when the user is selected from the first menu, I want the second menu to refresh, and only show the values they have that are = to 1 (which means they have it), and then of course, when the form is submitted, it will change whichever task was selected from 1 to 0, meaning it removes itself.

Basically, when the user is selected (ex; Joe), the second menu will refresh with the tasks that Joe has (ex; Admin, User). Once I select a task then click remove, the script should post the username menu, and get whatever task that was selected before submit, then run the script to UPDATE the users field of like 'Admin' from 1(true) to 0(false)

Can anyone help me set it up with code, or at least give me the direction to set it up myself?

Please don't use mysql_* functions in new code. They were removed from PHP 7.0.0 in 2015. Instead, use prepared statements via PDO or MySQLi. See Why shouldn't I use mysql_* functions in PHP? for more information. — Madara's Ghost
– Madara's Ghost, Commented Jul 21, 2012 at 8:23
You'll have to either use Javascript or jQuery + Ajax to achieve what you want. You will have to fire a function on the onchange event of the first drop down either using javacript or jquery. In that function connect to the database, query the database, and return the result as a drop down element. — asprin
– asprin, Commented Jul 21, 2012 at 8:28

asprin · Accepted Answer · 2012-07-21 08:51:57Z

1

Create a div and give it a id="result" and put an empty select tag in that div.

Then using jQuery + Ajax, get the second dropdown using:

$('select[name="user"]').change(function(){
   var user = $(this).val();

   $.ajax({
      type:'post',
      url:'getSecondDropDown.php',
      data:'user='+user,
      success:function(result){
         $('div#result').html(result);
      }
   });

});

In your 'getSecondDropDown.php' file, include this:

<select name="task">
<?php
$user = $_POST['user'];
$q = mysql_query("SELECT task FROM tablename WHERE user=".$user.") or die();
while($r = mysql_fetch_array($q))
{ ?>
  <option value="<?php echo $r['task]; ?>"><?php echo $r['task]; ?></option>

<?php
}
?>
</select>

answered Jul 21, 2012 at 8:51

asprin

9,85312 gold badges72 silver badges127 bronze badges

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

Comments

Madara's Ghost · Accepted Answer · 2012-07-21 08:25:40Z

0

You'll need to use JavaScript to do it. Send an AJAX request to a page in the server which will fetch the details of a user for you, then return the results to JavaScript.

Once you have the data in your JavaScript, use DOM manipulation to populate the second <select> with the results.

answered Jul 21, 2012 at 8:25

Madara's Ghost

176k52 gold badges274 silver badges314 bronze badges

1 Comment

Cody Brantley Over a year ago

I'd still need to know which way to code to get the results from my form, then remove the access depending on the user and the access I selected.

Collectives™ on Stack Overflow

Creating a Drop Down Menu in PHP from MySQL?

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