1 pjaol 1.1 <?php
 2           include("lib/loader.inc");
 3           
 4           class users {
 5           
 6              private $conf;
 7              private $dbiw;
 8           
 9              function __construct () {
10                 $this->$conf = Conf::instance();
11                 $this->$dbiw = new dbiw();
12              }
13           
14              function getAllGroups () {
15                $sql = "select idGroups,groupName from Groups";
16                return $this->$dbiw->dbSel($sql);
17              }
18           
19              function insGroup ($group) {
20                $sql = "insert into Groups(groupName)
21           		values ('$group');";
22 pjaol 1.1      $this->$dbiw->dbIns($sql);
23              }   
24           

25 pjaol 1.2    function getUser ($name) {

26 pjaol 1.1 

27 pjaol 1.2      $sql = "select g.idGroups,g.groupName,gu.fullName 
28                            from 
29                               Groups g, groupUsers gu
30                            where 
31                              gu.userName='$name' and
32                              gu.Groups_idGroups = g.idGroups";
33           
34                return $this->$dbiw->dbSel($sql);
35              }
36           
37              function getAllUsers () {
38                $sql = "select gu.idGroupUsers, gu.userName, gu.fullName
39                          from groupUsers gu";
40                return $this->$dbiw->dbSel($sql);
41              }

42 pjaol 1.1 }
43           
44           ?>