Session help

[Paranormalcy]

Hi all...need some help understanding sessions...

Background on project:

i have a user and subuser

the user sets up the account and adds each subuser as part of his "group". they share an XID inside the database. so user XID = 001 and subuser XID=001 so i know they belong to the same group.

I want to be able to pass this XID via a session along each and every page. So one of my functions in my application would be to list all submembers with this XID.

My question is when the main user signs in, how can he carry this XID over every single page he visits? (There is no telling when the main user wants to perform the function above)

So login would include username and password, but in the background i want the XID to be passed along somehow after login.

So obviously the username password and XID would be in the same table.. Would i pass information in an array? how does the script know to hit this one table.

I guess im having trouble putting 2 and 2 together.

Thanks for any help in advance.

[Kudose]

Use [man]session_start[/man] on every page you want to carry session information on.

Here is a tutorial on sessions. To be honest, I haven't read it, but PHP Freaks has always been good to me before.

http://www.phpfreaks.com/tutorials/41/0.php

[Paranormalcy]

yeah i read that tutorial once before. After I had posted last night i went back into my book and think i have a better grasp on sessions.

The only question left would be can you two session variables. I havent seen any examples in my book with two session variables.

so $_SESSION ['user'] = $username

&

$_SESSION ['XID'] = $XID

[lozza1978]

you can use as many sessions as required to preserve the data across multiple pages

HTH

lozza

[macmonkey]

Sessions are the shit! Get ready for your development's to get a LOT more interesting....

way-to-go.

[Kudose]

Yes, you can use single and multi-dimensional arrays on sessions.

All of the following are valid.

$_SESSION['XID'] = 42;
$_SESSION['user'] = 'Bugs Bunny';

$_SESSION['userinfo']['username'] = 'Droopy';
$_SESSION['userinfo']['XID'] = 21;

//you can even add more dimensions, although you will probably never need to

[Paranormalcy]

So to go back...i just want to have a bit more information from the database side of things.

User TABLE
userid | Password | XID

qwert | xxxxxxxx | 001
wang | yyyyyyyy | 002
popa | zzzzzzzz | 003

User Login with username and password

Here you will have to query the database in this particular table to make sure the two fields input by the user match.

and then you can refernce userid like so

$_SESSION['userid'] = $userid

but how would i use the XID as a session variable if it is not being input by the user?

[Kudose]

You need to run a database query and fetch the XID of the user. Once youhave that, you set it to the session variable.

<?php
//start sessions
session_start();

//get form information
$userid = $_POST['username'];
$password = md5($_POST['password']);

//setup the DB query
$sql = "SELECT * FROM users WHERE userid='".$userid."' AND password='".$password."'";

//query the db
$query = mysql_query($sql);

//make sure only one row matches
if(mysql_num_rows($query) == 1){ //fetch the data
  $fetch = mysql_fetch_array($query);

  //setup session info
  $_SESSION['userid'] = $userid;
  $_SESSION['XID'] = $fetch['XID'];

 //welcome the user
  echo 'Welcome '.$_SESSION['userid'];
} else //bad credentials
  die("Error: False credentials.");
?>

[Paranormalcy]

DUde! You are awesome! This is exactly what i was trying to do. I initially thought it might have to be done through and array but wasnt quit sure...

Thanks for your help...totally owe you big

[Kudose]

Your welcome.