----- Original Message -----
From: "Jason Barnett" <juzamjedi@xxxxxxxxx>
Cc: <php-general@xxxxxxxxxxxxx>
Sent: Tuesday, September 13, 2005 11:25 PM
Subject: Re: trying to figure out the best/efficient way to tell who
is logged into a site..
Close: You mix both of these ideas.
Create a custom session handler. This handler creates user entries in a
database. Then when you want to know how many are online you do a count on
the number of user entries in the table. Play around with different
gc_probability values to tune the efficiency.
On 9/13/05, bruce <bedouglas@xxxxxxxxxxxxx> wrote:
hi...
anybody have pointers to trying to tell who/how long someone is logged
into
a system/site. i've thought about setting a session var, but i'm not sure
how to read/tabulate this var across the entire group of people who'd be
logged in. i've also thought about keeping track in a db tbl.. however,
i'm
still not sure that i've got a good way of tracking who's logged in, and
still on...
a possible approach would be to have the app periodically update the
system
whenever a logged in user goes from page to page...
so, any thoughts/ideas/etc...
-thanks
bruce
bedouglas@xxxxxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.23/99 - Release Date: 2005-09-12
Hi there!
Giving you a bit code... It might come in handy... :-)
I don't have time to explain it, but it may be good for experimenting...
All you guys, please comment if the code is well or bad written and why...
:-)
<?php
function chkIfPasswordTrue($un, $pw, $typeUser) {
//Make username and password in-casesensitive
//
$un = strtolower($un);
$pw = strtolower($pw);
$typeUser = strtolower($typeUser);
require("phpfunctions/opendb.php");
//Get ID for user based on username and password from database
//
$sql = "";
$sql = $sql . "SELECT IDAnvandare FROM tbanvandare WHERE";
$sql = $sql . " Anvandarnamn=" . safeQuote($un) . " AND";
$sql = $sql . " Losenord=" . safeQuote($pw) . " AND";
if ($typeUser == "customer") {
$sql = $sql . " Kund='Y'";
}
else if ($typeUser == "reseller") {
$sql = $sql . " Af='Y'";
}
else {
$sql = $sql . " Kund='Y'";
}
//echo "SQL = $sql";
$querys = mysql_query($sql);
$toarray = mysql_fetch_array($querys);
$id = $toarray["IDAnvandare"];
if ($id == Null or strlen($id)==0) {$id = 0;}
mysql_close();
//Return id for user, zero if incorrect login
//
return $id;
}
function getusername() {
//Get username from form if form have sent anything
//if there is an active usernamesession, then use session-variable
//to identifiy user
//
$un = "";
if (isset($_REQUEST["frmUsername"])) {
$un = $_REQUEST["frmUsername"];
}
if (isset($_SESSION["unBuy"])) {
$un = $_SESSION["unBuy"];
}
return $un;
}
function getpassword() {
//Get password from form if form have sent anything
//if there is an active passwordsession, then use session-variable
//to identifiy user
//
$pw = "";
if (isset($_REQUEST["frmPassword"])) {
$pw = $_REQUEST["frmPassword"];
}
if (isset($_SESSION["pwBuy"])) {
$pw = $_SESSION["pwBuy"];
}
return $pw;
}
function setsessions($username, $password, $typeUser) {
$userid = 0;
$username = trim($username);
$password = trim($password);
$typeUser = trim($typeUser);
if (strlen($username)>0 AND strlen($password)>0 AND strlen($typeUser)>0) {
$userid = chkIfPasswordTrue($username, $password, $typeUser);
}
//Set session-variable for user-identification
//
if ($userid>0) {
$_SESSION["unBuy"] = $username;
$_SESSION["pwBuy"] = $password;
$_SESSION{"typeUser"} = $typeUser;
}
return $userid;
}
?>
/G
http://www.varupiraten.se/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
