Using Sessions to transfer Userid from one table to another.

LordRogaine

I'm a newbie and perhaps I'm going about this all wrong but this is what I'm trying to do anyway. Hopefully someone can help me please.

I'm trying to create an interactive website using Mysql and PHP. There is a table for when new users log in , and a seperate table for when they fill out a profile of themselves.
I want to use "Sessions" to take the "userid" that is created when they log in as a new member and have that "userid" transfered over to the next table where they fill out a profile. I want to link the two tables together using the "userid" as a primary key. How can I use "Sessions" to acomplish this.
Thankyou in advance to anyone that can help.

Steve

P.S. I'm new to this so please be gentle lol

TalonFinsky

Well, first you have to start the session (session_start(); ) and then register the variables you want (session_register($var); ). That variable will then be available in all pages that it accesses. Remember though, you must have session_start(); at the beginning of each page (before the headers) that you want those variables to be accessible in. For example:

page1.php:

<?
session_start();
$userid = "TalonFinsky";
session_register($userid);
echo "<a href=\"page2.php\">Click here for next page</a>";
?>

...

page2.php:

<?
session_start();
echo "Welcome, ".$userid."!!";
?>

page2.php in a browser would look like:

Welcome, TalonFinsky!!

LordRogaine

thankyou for your help. I appreciate it!🙂

LordRogaine

I tried it but I seem to be doing something wrong. I keep getting this:

Cannot send session cache limiter - headers already sent

perhaps where I'm placing the session on my page?

rIkLuNd

A session must be set before any html output! make sure that your '<?php' tag is at the absolute top of the page!

TalonFinsky

Originally posted by TalonFinsky
Remember though, you must have session_start(); at the beginning of each page (before the headers) that you want those variables to be accessible in.

So for example:
<?
session_start();
?>

<html>
<head>
<title>Page Title</title>
</head>
<body>

<?
$userid = "TalonFinsky";
session_register($userid);
...
?>

LordRogaine

I'm beginning to feel like an idiot because I can't seem to get this right.. I set up the session just like is shown here. I don't get any errors when I try it out, but it seems that the variable does not carry over to the next page. In fact, I believe it is not even registering on the first page. Anyone have any ideas of why this is happening? Thanks in advance.

baffled_in_UK

I am no expert but this works for me....

I don't use session_register($var);

I use the value I want to initialise a session variable like this..

$_SESSION['id'] = $id;

and then I use it the other way to initialise a variable when I need it on other pages

$id=$_SESSION['id'];

It's probably not the best way but like I said, it works for me

LordRogaine

thanks. I appreciate the help.🙂