1 Topic by citak

  • citak
  • Baby member
  • Offline
  • Registered: 2010-05-29
  • Posts: 42

Topic: Get members ID in PHP

HI,

I want to now how I can get the members ID from logged in members in php outside of the .tpl files.
I tried:

////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$memberID = get_members_details($SESSION->conf['member_id']);
   
$result = mysql_query("SELECT * FROM " . DB_PREFIX . "members WHERE member_id='$memberID'");
$array = mysql_fetch_assoc($result);

echo gettype($array['member_id']);
////////////////////////////////////////////////////////////////////////////////////////////////////////////////

But no results.
Could someone help,

Thank you

2 Reply by vlad

  • vlad
  • Developer
  • Offline
  • Registered: 2006-01-22
  • Posts: 6,995

Re: Get members ID in PHP

Use $_SESSION['member_id'].

Developer

vlad's Website

3 Reply by citak

  • citak
  • Baby member
  • Offline
  • Registered: 2010-05-29
  • Posts: 42

Re: Get members ID in PHP

Hello Vlad,

I have do that but no results.

//////////////////////////////////////////////////////////////////////////////////////////
$memberID = get_members_details($_SESSION['member_id']);   

$result = mysql_query("SELECT * FROM " . DB_PREFIX . "members WHERE member_id='$memberID' ");

echo $result;
//////////////////////////////////////////////////////////////////////////////////////////

I think I have the wrong code at the 1 and 3 line.
I want to show user ID on the screen when I type echo $.... at the end of the script.

4 Reply by vlad

  • vlad
  • Developer
  • Offline
  • Registered: 2006-01-22
  • Posts: 6,995

Re: Get members ID in PHP

You should probably read up on how to query mysql in php. What you're doing above is not really correct.

Developer

vlad's Website