*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
$config = unserialize(file_get_contents('config.inc'));
require_once 'DB.php';
$number_of_users = 5;
$db = &DB::connect($config['dsn']);
if (DB::isError($db))
die($db->getMessage());
// Show XML dump
if (!empty($_GET['dump']) && !empty($_GET['type']))
{
$query = "SELECT " . ($_GET['type'] == 'user' ? 'user' : 'session') .
$query .= "_dump FROM users WHERE user_id='" . $_GET['dump'] . "'";
$res =& $db->query($query);
if (DB::isError($res))
die($res->getMessage());
$row = $res->fetchRow();
?>
query($query);
if (DB::isError($res))
print $res->getMessage(). "\n";
$query = "DELETE FROM users WHERE user_id='" . $_GET['del'] . "'" ;
$res =& $db->query($query);
if (DB::isError($res))
print $res->getMessage(). "\n";
}
// Count users
$query = "SELECT COUNT(*) FROM users";
$res =& $db->query($query);
if (DB::isError($res))
die($res->getMessage());
$row = $res->fetchRow();
$count = $row[0];
$startUser = ((empty($_GET['startUser'])) ? 0 : $_GET['startUser']);
$query = "SELECT * FROM users";
if (!isset($_GET['show_all']))
$query .= " OFFSET $startUser LIMIT " . ($startUser + $number_of_users);
$res =& $db->query($query);
if (DB::isError($res))
die($res->getMessage());
?>
Lasso Service Provider Example : Users Management
Index
Copyright © 2004 Entr'ouvert
disconnect();
?>