← Back to branch summary

~coffeepot/coffeepot/coffeetray

« back to all changes in this revision

Viewing changes to server/www/usermanager.php

  • Committer: Miika Komu
  • Date: 2010-08-11 12:59:34 UTC
  • Revision ID: miika@iki.fi-20100811125934-ya1bz1geskj3gvfq
Initial import from Niko Vähäsarja.

I hope the debian directory does not have too many generatable files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
server/www/usermanager.php
 
1
<?PHP
 
2
include "inc/db.inc";
 
3
 
 
4
function db_new_user($id, $name, $room) {
 
5
        $mdb2=MDB2::singleton();
 
6
        $query=$mdb2->prepare("INSERT INTO users (id, name, room) VALUES (?,?,?) ON DUPLICATE KEY UPDATE name=COALESCE(VALUES(name),name), room=COALESCE(VALUES(room),room)");
 
7
        $ret=$query->execute(array($id, $name, $room));
 
8
        return !PEAR::IsError($ret);
 
9
}
 
10
 
 
11
function db_delete_user($id) {
 
12
        $mdb2=MDB2::singleton();
 
13
        $query=$mdb2->prepare("DELETE FROM users WHERE id=?");
 
14
        $ret=$query->execute($id);
 
15
        return !PEAR::IsError($ret);
 
16
}
 
17
 
 
18
$error="";
 
19
 
 
20
// Command handler:
 
21
if ($_SERVER['REQUEST_METHOD']=='POST') {
 
22
        if($_POST["create"]) {
 
23
                $val=db_new_user($_POST['id'], $_POST['name'], $_POST['room']);
 
24
                if (!$val) {
 
25
                        $error="Can not create user, Invalid ID";
 
26
                }
 
27
        }
 
28
        elseif($_POST["delete"]) {
 
29
                $val=db_delete_user($_POST['id']);
 
30
                if (!$val) {
 
31
                        $error="Can not delete, account not empty";
 
32
                }
 
33
        }
 
34
        // Prevent accidental refresh:
 
35
        if(!$error) {
 
36
                //header('Location: '.$_SERVER['REQUEST_URI']);
 
37
                //exit;
 
38
        }
 
39
}
 
40
 
 
41
 
 
42
?>
 
43
<html>
 
44
<head>
 
45
<title>CCI: User Manager</title>
 
46
<link rel="stylesheet" href="inc/styles.css">
 
47
</head>
 
48
<body>
 
49
<? 
 
50
include_once "inc/head.inc";
 
51
if ($error) echo "<p id=error>$error</p>";
 
52
?>
 
53
<table border=1>
 
54
<tr><th>User ID</th><th>Real name</th><th>Room</th><th>Action</th></tr>
 
55
<tr>
 
56
 
 
57
<? 
 
58
 
 
59
 
 
60
$res =& $mdb2->query('SELECT id, name, room FROM users');
 
61
while (($row = $res->fetchRow())) {
 
62
        echo '<form action="" method="post">';
 
63
        echo '<input type="hidden" name="id" value="'.$row['id'].'">';
 
64
    echo "<tr><td>{$row['id']}</td><td>{$row['name']}</td><td>{$row['room']}</td>".
 
65
                '<td><input type="submit" name="delete" value="Delete"></td></tr>';
 
66
        echo '</form>';
 
67
}
 
68
?>
 
69
</tr>
 
70
<tr>
 
71
 
 
72
<form action="" method="post">
 
73
<td><input type="text" name="id" size=16></td>
 
74
<td><input type="text" name="name" size=30></td>
 
75
<td><input type="text" name="room" size=10></td>
 
76
<td><input type="submit" name="create" value="Create/Update"></td>
 
77
</form>
 
78
 
 
79
</tr>
 
80
<tr><th>User ID</th><th>Real name</th><th>Room</th><th>Action</th></tr>
 
81
<? // CLOSE DB LINK:
 
82
$mdb2 =& MDB2::singleton();
 
83
$mdb2->disconnect();
 
84
?>
 
85
</body>
 
86
</html>