Session in PHP in Social Engine

Question

I have this query in mysql in a php page:

mysql_query("INSERT INTO tz_todo SET text='".$text."', 
                                     position = ".$position.", 
                                     user_id=".$_SESSION['user_id'].", 
                                     view_stat=0");

I tried to echo the query and the result is this:

INSERT INTO tz_todo SET text='trial text', position = 21, user_id=, view_stat=0

it seems that it can't get the session value of user_id.

And $_SESSION['user_id'] is not working in social engine. How to correct this? I also made a localhost version in my xampp and everything is fine but when I converted it into social engine, session is not working.

Answer 1

In any page where you are using session objects, place this code at the beginning of the file:

if(!isset($_SESSION)){session_start();}

This way if the session is not already started, it starts it; otherwise it ignores the session start if the sesion is already started. This is important because calling session_start() if session is started already can sometimes cause errors.

Answer 2

That's how I get my user id through session

session_start();

$userID = $viewer->getIdentity();

$_SESSION['user_id'] = $userID;

echo $_SESSION['user_id'];