Add Session variable to database

[Liz_SA]

Hi there, is there a way that I can add a session variable to a database. This is what I have done that does not work? Any suggestions?

On the login page :

<?php
session_start();
$SESSION['user_name'] = $POST['user_name'];
$_SESSION['user_name'] = $user_name;
?>

On the page to add to database :

<?php
session_start();
$SESSION['user_name'] = $POST['user_name'];
$_SESSION['user_name'] = $user_name;
?>

<?php
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="INSERT INTO $tbl_name(user_name)VALUES('$user_name')";
$result=mysql_query($sql);

Thanks

[kakki]

hmmm..
to get the name/value of the session-var.: use "session_name()", "session_id()"

[Houdini]

Well if register_globals is off (like they should be) then you are overwriting the $username with both these lines as per you example

<?php
session_start();
$_SESSION['user_name'] = $_POST['user_name'];//set to $_Post variable
$_SESSION['user_name'] = $user_name;//Now it is set to nothing
?>

On the page to add to database :

<?php
session_start();
$_SESSION['user_name'] = $_POST['user_name'];//Same as above
$_SESSION['user_name'] = $user_name;
?>

First you need to remove the $_SESSION['user_name'] = $user_name; and keep the $POST variable then when you need the $SESSION['user_name'] just make a short variale like

$user_name=$_SESSION['username'];

[Liz_SA]

Now I am really confused.

Will my query then be
$sql="INSERT INTO $tbl_name(user_name)VALUES('$_SESSION['user_name']')";
$result=mysql_query($sql);

[Houdini]

Well you could do that but once on the page where you are wanting to use it in a query just for ease in steat of

$sql="INSERT INTO $tbl_name(user_name)VALUES('$SESSION['user_name']')";
$result=mysql_query($sql);

first make a short variable and then use it like this

//create a short variable from $_SESSION variable
$user_name=$_SESSION['user_name'];
$sql="INSERT INTO $tbl_name(user_name)VALUES('$user_name')";
$result=mysql_query($sql);