Connecting The Dots - PHP

Once you've got your users and groups created, you can begin organizing users into groups, via the addUserToGroup() and removeUserFromGroup() methods.

Given the following users and groups,

mysql> SELECT uid, username FROM users;
+-----+----------+
| uid | username |
+-----+----------+
|   2 | joe      |
|   3 | sarah    |
|   4 | john     |
|   5 | tom      |
+-----+----------+
4 rows in set (0.00 sec)                 
mysql> SELECT gid, name FROM groups;
+-----+-----------------+
| gid | name            |
+-----+-----------------+
|   1 | Accounts        |
|   2 | Administration  |
|   3 | Operations      |
|   4 | Human Resources |
+-----+-----------------+
4 rows in set (0.00 sec)

it's fairly easy to, say, add "joe" and "sarah" to the "Accounts" and "Operations" group,

<?php
// include classes
include("../include/patDbc.php");
include("../include/patUser.php");
// initialize database layer
$db = new patMySqlDbc("localhost", "db211", "us111", "secret");
// initialize patUser
$u = new patUser(true);
// connect patUser to database
$u->setAuthDbc($db);
// set table
$u->setAuthTable("users");
$u->setGroupTable("groups"); $u->setGroupRelTable("usergroups");
// add joe to Accounts
$u->addUserToGroup( array("uid" => 2, "gid" => 1) );
// add joe to Operations
$u->addUserToGroup( array("uid" => 2, "gid" => 3) );
// add sarah to Accounts
$u->addUserToGroup( array("uid" => 3, "gid" => 1) );
// add sarah to Operations
$u->addUserToGroup( array("uid" => 3, "gid" => 3) );
?>

or remove "sarah" from "Operations" and move her into "Human Reources".

<?php
// include classesinclude("../include/patDbc.php");include("../include/patUser.php");// initialize database layer$db = new patMySqlDbc("localhost", "db211", "us111", "secret");// initialize patUser$u = new patUser(true);// connect patUser to database$u->setAuthDbc($db);// set tables$u->setAuthTable("users");$u->setGroupTable("groups"); $u->setGroupRelTable("usergroups");// remove sarah from Operations$u->removeUserFromGroup( array("uid" => 3, "gid" => 3) );// add sarah to Human Resources$u->addUserToGroup( array("uid" => 3, "gid" => 4) );?>

Once you've got your users organized the way you want them, patUser also offers the following three utility functions to help you make sense of all the relationships:

getJoinedGroups() - returns a list of the groups the named user belongs to, accepts user ID as input

getUsersInGroup() - returns a list of all the users in a named group, accepts group ID and list of required user attributes as input

isMemberOfGroup() - returns a Boolean value indicating whether or not the named user belongs to the named group, accepts user ID and group ID as input

The following example illustrates how these work:

<?php
// include classes
include("../include/patDbc.php");
include("../include/patUser.php");
// initialize database layer
$db = new patMySqlDbc("localhost", "db211", "us111", "secret");
// initialize patUser
$u = new patUser(true);
// connect patUser to database
$u->setAuthDbc($db);
// set tables
$u->setAuthTable("users");
$u->setGroupTable("groups"); $u->setGroupRelTable("usergroups");
// add joe to Accounts
$u->addUserToGroup( array("uid" => 2, "gid" => 1) );
// add joe to Operations
$u->addUserToGroup( array("uid" => 2, "gid" => 3) );
// add sarah to Human Resources
$u->addUserToGroup( array("uid" => 3, "gid" => 4) );
// add john to Operations
$u->addUserToGroup( array("uid" => 4, "gid" => 3) );
// which groups is joe a member of?
$foo = $u->getJoinedGroups( array("uid" => 2) );
print_r($foo);
// who belongs to the Operations group?
$foo = $u->getUsersInGroup( array("uid", "username"), array("gid" => 3) );
print_r($foo);
// does joe belong to Operations?
// returns Boolean true (1)
$foo = $u->isMemberOfGroup(2, 3);
print_r($foo);
?>

Here's the output:

Array
( [0] => Array ( [gid] => 1 [name] => Accounts ) [1] => Array ( [gid] => 3 [name] => Operations ))Array( [0] => Array ( [uid] => 2 [username] => joe ) [1] => Array ( [uid] => 4 [username] => john ))1

Needless to say, these utility functions come in very handy when you need to find out which users belong to which groups, or if you need to alter the various user and group configurations. You'll see this in action in the composite example on the next page.

>>> More PHP Articles          >>> More By icarus, (c) Melonfire

blog comments powered by Disqus