在PHP中按组名回显用户

Question

我要做的是单击组(我创建的除poweruser和admin组之外的每个组)的名称，这将从数据库中返回该组中的所有用户。到目前为止，我已经弄清楚了代码，但现在我的问题是，当点击组的名称时，我将如何打印出来?

目前为止我的代码是:

<h3>Groups</h3>
<?php
include('db.php');
if (isset($_GET["groupID"])) {
$sql="SELECT `group`.*, `user`.* FROM `user` inner join `group` on group.groupID=user.groupID where group.groupID= " . mysql_real_escape_string($_GET["groupID"]) ;
} else {
$sql="SELECT * FROM `group` WHERE groupName <> 'admin' AND groupName <> 'poweruser'"  ;
}
$result=mysql_query($sql,$connection);
while($line=mysql_fetch_array($result)){
echo "<a href='index.php?page=groups&group=".$line['groupID']."'>".$line['groupName'].'</a><br />';
}
mysql_free_result($result);
mysql_close($connection);
?>

Answer 1

在$_GET["group"]问题之上，它看起来不像您在任何地方打印用户。

您应该将输出移到if块中，并为第一个条件创建新的输出。

<?php
include('db.php');
if (isset($_GET["groupID"])) {
$sql="SELECT `group`.*, `user`.* FROM `user` inner join `group` on group.groupID=user.groupID where group.groupID= " . mysql_real_escape_string($_GET["groupID"]) ;
$result=mysql_query($sql,$connection);
//Output users after Group Selected
//Could be placed outside the if block to allow user to select a different group
echo("<h3>Users</h3>");
while($line=mysql_fetch_array($result)){
    //echo out the user data here
}
} else {
$sql="SELECT * FROM `group` WHERE groupName <> 'admin' AND groupName <> 'poweruser'"  ;
$result=mysql_query($sql,$connection);
//Output to let user select group.
echo("<h3>Groups</h3>");
while($line=mysql_fetch_array($result)){
echo "<a href='index.php?page=groups&group=".$line['groupID']."'>".$line['groupName'].'</a><br />';
}
}
mysql_free_result($result);
mysql_close($connection);
?>

Answer 2

if (isset($_GET["groupID"])) {

应该不是

if (isset($_GET["group"])) {

也将$_GET["groupID"]更改为$_GET["group"]在$sql查询

Answer 3

下面的代码是如何做到这一点的示例。把它放在你已经有的代码下面:

if ($_GET['page'] == 'groups'):
$groupID = $_GET['groupID'];
$sql = "SELECT * FROM users WHERE groupID = '$groupID'"; 
$res = mysql_query($sql); //MySQL query
$count = mysql_num_rows($res); //This counts our results
if($count != 0): //This makes sure we have at least 1 result
   while($user = mysql_fetch_assoc($res)):
     echo $user['name'];
   endwhile;
endif;
endif;

Answer 4

将Peter Stuart的代码添加到您的文件中并更改<a href='index.php?page ... >到<a href='groups.php?page ... >