Location: PHPKode > projects > MyVPN OpenVPN Web Config > http_doc/admin/info_comm.php

$name = $_GET["name"];
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<title>Info page of community <? echo $name; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="style.css">


<div align="center">
	<div id="header-space">
		<div id="header">
			Admin Pages</div>
	<div id="links-space">
		<a href="index.php">Home</a> &middot; <a href="users.php">Users</a> &middot; <a href="comm.php">Community</a> &middot; <a href="logout.php">LogOut</a></div>
	<div id="content-space">
		<div class="news-header">
			This are all user subscribed on <? echo $name; ?>'s community:</div>
		<div class="entry">
			<div align="center">
				<table id="table1" border="0" cellpadding="5" width="600">
	$conn = mysql_connect($dbhost,$dbuser,$dbpass);

	$query ="SELECT USERS.id,USERS.email,USERS.user_name,USERS.name,USERS.surname,USERS.status FROM USERS,MEMB,COMM WHERE USERS.id=MEMB.id AND MEMB.id1=COMM.id AND COMM.name='$name'";
	$result = mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	while ($row = mysql_fetch_array($result)) {
?>					<tr>
						<td colspan="2"><hr></td>
						<td rowspan="3">Id: <? echo $row['id'] ?><br />
				Email: <? echo $row['email'] ?><br />
				User Name: <? echo $row['user_name'] ?><br />
				Name: <? echo $row['name'] ?><br />
				SurName: <? echo $row['surname'] ?><br />
				User status: <?
				if ($row['status'] == "1") echo "Enable";
				else echo "Disable"; ?></td>
						<td><a href="info_user.php?user_name=<? echo $row['user_name'] ?>">
						<img src="img/info.gif" border="0" height="16" width="16"> 
						Which community</a></td>
						<td><a href="status.php?table=USERS&id=<? echo $row['id'] ?>&status=0">
						<img src="img/drop.gif" border="0" height="16" width="16"> 
						<td><a href="status.php?table=USERS&id=<? echo $row['id'] ?>&status=1">
						<img src="img/accept.gif" border="0" height="18" width="18"> 
?>					</table>
	<div id="foot-space"> &copy; MyVPN Admin</div>


Return current item: MyVPN OpenVPN Web Config