访问会话数据以查询DB以获取其他数据

Question

So when a user logs into my site, I pull the user ID from the users table and save it in the session. THis works i've tested it by using

echo "test" . $_SESSION['UserID'];

this displays the current user ID now how do I use $_SESSION['UserID'] in a mysql query to get a number from a different table which has user ID as a foreign key?

Apologies if this seems stupid, first time dealing with sessions

Answer 1

You can directly hold the value of $_SESSION['UserID'] into a variable and use it like a normal PHP constructs.

Perhaps one of the way:

if(isset($_SESSION['UserID'])) {
    $userId = $_SESSION['UserID'];
    $sql= 'select * from user_addresses where UserID = '.$userId;
}