[SOLVED] display session id and store it in database

[Marcos01]

Hello,

 

How do I display the session id? And how do I store it a database?

 

This is the code i have so far:

 

           session_start();


           $bedrijfsnaam = $_POST['companyname'];
$naam = $_POST['name'];
$email = $_POST['email'];



$query ="INSERT INTO formusers (sessionid, companyname, name, email)	
		values('{$sessionid}','{$companyname}', '{$name},'{$email}')";

$result = mysql_query($query, $connection);
if ($result){

echo "data added";

}else{
echo "data has not been added to database";
echo 'mysql_error()';
}

[waynew]

session_id();

[MadTechie]

<?php
           session_start();


           $bedrijfsnaam = $_POST['companyname'];
   $naam = $_POST['name'];
   $email = $_POST['email'];
$sessionid = session_id(); //<--ADD


   $query ="INSERT INTO formusers (sessionid, companyname, name, email)   
         values('{$sessionid}','{$companyname}', '{$name},'{$email}')";
   
   $result = mysql_query($query, $connection);
   if ($result){
   
   echo "data added";
      
   }else{
   echo "data has not been added to database";
   echo 'mysql_error()';
   }
?>

 

 

EDIT: ahh too slow

[GKWelding]

after

 

session_start();

 

you need to add

 

$sessionid=session_id();

 

This will populate your $sessionid variable with the current session id as determined by session_id().

[Marcos01]

Thanks all

 

It worked!