1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
<?php
class Users {
public function __construct() {
}
public function tabUsers($f3) {
if (isset($f3->get('GET')['filter'])) {
$filter = '%'.$f3->get('GET')['filter'].'%';
$f3->set('result',$f3->get('DB')->exec('SELECT userid, username, organization, firstname, lastname, email, lastlogin FROM user WHERE username LIKE ?', $filter));
$f3->set('oldFilter', htmlspecialchars($f3->get('GET')['filter']));
} else {
$f3->set('result',$f3->get('DB')->exec('SELECT userid, username, organization, firstname, lastname, email, lastlogin FROM user'));
$f3->set('oldFilter', '');
}
// now render the view
echo Template::instance()->render('views/users.htm');
}
}
?>
|
