Select menu question

[zoliky]

I have a select menu with 2 options:

• Show users
• Delete group

I want to show something if user select option 1 and something if user select option 2.

the following code don't do exactly what I need. (The IF statements) :

if (isset($_POST['submit']) && ($_POST['select'] == 1)) {
  print "1";
}

if (isset($_POST['submit']) && ($_POST['select'] == 2)) {
   print "2";
}

print "<TABLE BORDER=2 CELLPADDING=2>\n";
print "<table width=\"500\" border=\"1\">";
print "<tr>\n";
print "<td>Group Name</td>\n";
print "<td>Users in group</td>\n";
print "<td>Options</td>\n";
print "</tr>\n";

print "<form action=\"groups.php\" method=\"post\">";

while ($row = mysql_fetch_array($groups)) {
print "<tr>\n";
print "\t<td>".$row['name']."</td>\n";
print "\t<td><center>".$row['nr_useri']."</center></td>\n";
print "<td><select name=\"select\">";
print "<option value=\"1\">Show users</option>";
print "<option value=\"2\">Delete Group</option></select>";
print "<input type=\"submit\" name=\"submit\" value=\"go\" /></td>";
print "</tr>\n";

}

[jsim]

You have many selects with the same name and when press submit button the script do not know what submit in what row pressed.
And you forgot about closing the form.

[zoliky]

Ok, and exist a way to solve this problem ?

[jsim]

A way always exists 🙂
If I get you right you need to print some rows from the database with one group in each line
and want to do some processing to groups separately.
You can use separate form for each row and use some hidden value within it that indicate which row is used.
Example of HTML below (without table tags - just to show the way):

<form action="groups.php" method="post">
Row1
Group Name
Users in group
<input type=hidden name="rowid" value="1">
<select name="select">
<option value="1">Show users</option>
<option value="2">Delete Group</option>
</select>
<input type="submit" name="submit" value="go">
</form>

<form action="groups.php" method="post">
Row2
Group Name
Users in group
<input type=hidden name="rowid" value="2">
<select name="select">
<option value="1">Show users</option>
<option value="2">Delete Group</option>
</select>
<input type="submit" name="submit" value="go">
</form>

And PHP code is:

if( $_POST['submit'] ) {
  $rowid = (int)$_POST['rowid'];
  if( $_POST['select'] == 1 ) {
    echo 'Show all users selected for row'.$rowid;
  } elseif( $_POST['select'] == 2 ) {
     echo 'Delete group selected for row'.$rowid;
  }
}

Hope you got the idea

[jsim]

BTW, use group ID from the database as rowid - it's simplify data processing in db.

[zoliky]

Ok I don't understand a thing :

<input type=hidden name="rowid" value="2">

"rowid" is a simple name ? or I need to replace "rowid" with $row['id'] ?
$row['id'] get the group ID from mySQL.

I need to specify a separate value for each hidden input ?

[jsim]

Yes, rowid is a name of hidden variable.
Ok, here is complete code.

<?php

if( $_POST['submit'] ) { 
  $group_id = (int)$_POST['group_id']; 
  if( $_POST['select'] == 1 ) {
    echo 'Show all users in group with id '.$group_id; 
  } elseif( $_POST['select'] == 2 ) {
     echo 'Delete group with id '.$group_id;
  } 
}

print "<TABLE BORDER=2 CELLPADDING=2>\n"; 
print "<table width=\"500\" border=\"1\">"; 
print "<tr>\n"; 
print "<td>Group Name</td>\n"; 
print "<td>Users in group</td>\n"; 
print "<td>Options</td>\n"; 
print "</tr>\n"; 

while ($row = mysql_fetch_array($groups)) {
  print "<tr>\n"; 
  print "\t<td>".$row['name']."</td>\n"; 
  print "\t<td><center>".$row['nr_useri']."</center></td>\n";
  print "\t<td><form action=\"groups.php\" method=\"post\">";
  print "<input type=\"hidden\" name=\"group_id\" value=\"".$row['id']."\"></td>\n";
  print "\t<td><select name=\"select\">";
  print "<option value=\"1\">Show users</option>"; 
  print "<option value=\"2\">Delete Group</option></select></td>\n";
  print "\t<td><input type=\"submit\" name=\"submit\" value=\"go\" /></td>";
  print "\t<td></form></td>\n";
  print "</tr>\n"; 
}

?>

I not check it but seems to be working...