Need some design and programming help

tony_l

I have been coming here for a while now and asking questions about simple things really that just required some logical help.

BUT NOW, I want to start on a HUGE project and I need you guys to help me out with what I need to do.

Basically I have a members only website. I have it set up where they have to log in before they see the member content. I am currently using PHP sessions to do this.

I would like to design it so that the session is logged into the MySQL database. This would allow me to track the members better and to be able to display when their last log in was.

My question is how would I set this up? I am not looking for someone to program it for me, I just need to know where to start and how to get it set up. I am running apache, MySQl and PHP4.

Thanks for the help in advance folks.

shibiny

You can set the following codes in a php file, so you need include the file in any page needs to implement session function.

//sessions
$SESS_DBHOST=$dbhost;
$SESS_DBNAME=$dbname;
$SESS_DBPASS=$dbpasswd;
$SESS_DBUSER=$dbuser;

$SESS_DBH="";
$SESS_LIFE=40;

/*************************************

 Session Handler functions
 sess_open
 sess_read
 sess_writer
 sess_close
 sess_destroy
 sess_gc

**************************************/

/*********
open session
*********/
function sess_open($sess_path,$session_name) {
global $SESS_DBH,$SESS_DBHOST,$SESS_DBNAME,$SESS_DBUSER,$SESS_DBPASS;

if (! $SESS_DBH=mysql_connect($SESS_DBHOST,$SESS_DBUSER,$SESS_DBPASS))
error_die("²»ÄÜÁ¬½Óµ½Êý¾Ý¿â");
if (!mysql_select_db($SESS_DBNAME,$SESS_DBH))
error_die("²»ÄÜÁ¬½Óµ½Êý¾Ý±ísession");

return true;
}

function sess_close(){
return true;
}

function sess_read($key)
{

global $SESS_DBH,$SESS_LIFE;
$qry="select value from sessions where sesskey='$key' and expiry>".time();
$qid=mysql_query($qry,$SESS_DBH);

if (list($value)=mysql_fetch_row($qid)) {

return $value;
}

return false;

}

function sess_write($key,$val){
global $SESS_DBH,$SESS_LIFE;

$expiry=time()+$SESS_LIFE;

$value=addslashes($val);

$qry="insert into sessions values('$key','$expiry','$value')";
$qid=mysql_query($qry,$SESS_DBH);
if (!$qid) {
$qry="update sessions set expiry=$expiry,value='$value' where sesskey='$key' and expiry>".time();
$qid=mysql_query($qry,$SESS_DBH);
if (!$qid) error_die(" sess update error<br>$qry");
}
return $qid;

}

function sess_destroy($key) {
global $SESS_DBH;
$qry="delete from sessions where sesskey='$key' ";
$qid=mysql_query($qry,$SESS_DBH);
return $qid;
}

function sess_gc($maxlifetime){

global $SESS_DBH;

$qry="delete from sessions where expiry<".time();
$qid=mysql_query($qry,$SESS_DBH);
return mysql_affected_rows($SESS_DBH);

return true;

}

session_set_save_handler(
"sess_open",
"sess_close",
"sess_read",
"sess_write",
"sess_destroy",
"sess_gc"
);