AllSyntax.com: » Forums » View ?f=4&t=198&p=1254

[login] | [Register]

Forum Index » PHP and mySQL » Viewing Topic and Replies

Viewing Topic: Member ID in Session

BoricuaLayz

Subject: "Member ID in Session" Posted: @ 10:08 pm on Jun 30 2007

Member #: 356
Rank: user - (30)
Since: 06/25/07
Posts: 44
From: Florida

If i wanted a members ID stored in the session when they log in how would i go about that

Viewed: 13,445 Times |

bs0d

Subject: "re: Member ID in Session" Posted: @ 4:47 pm on Jul 01 2007

Member #: 1
Rank: Admin. - (1,509)
Since: 02/06/05
Posts: 603
From: USA

see if this is what you're looking for: PHP.NET/SESSIO N_ID

-bs0d | AllSyntax.com

Viewed: 13,431 Times |

BoricuaLayz

Subject: "re: Member ID in Session" Posted: @ 3:50 am on Jul 02 2007

Member #: 356
Rank: user - (30)
Since: 06/25/07
Posts: 44
From: Florida

no i mean how can i make it so that the users's id

the one that is manually given to them when they register

can also be stored in the session with the username and password

because i am scripting a PM system (Private Messaging System) for my member area and it needs the id of the logged in member to check if he has any messages and to send a message

Edited at 03:52:59 am on 07/02/07

Viewed: 13,411 Times |

WintersDance

Subject: "re: Member ID in Session" Posted: @ 1:37 pm on Jul 02 2007

Member #: 353
Rank: user - (27)
Since: 06/19/07
Posts: 36
From: California

maybe just query the member id number by matching where 'username' = $_SESSION['use rname'] and set the result as a varible that can now be called up by your PM script.

| Viewed: 13,401 Times |

bs0d

Subject: "re: Member ID in Session" Posted: @ 6:10 pm on Jul 02 2007

Member #: 1
Rank: Admin. - (1,509)
Since: 02/06/05
Posts: 603
From: USA

Well, i have id for the members table that is auto_increment. Assign that value to $_SESSION['use r_id'] in your page header and it'll be available throughout the website.

-bs0d | AllSyntax.com

Viewed: 13,395 Times |

BoricuaLayz

Subject: "re: Member ID in Session" Posted: @ 6:18 pm on Jul 02 2007

Member #: 356
Rank: user - (30)
Since: 06/25/07
Posts: 44
From: Florida

so you are telling me to edit this code

Code:

if ($_SESSION['lo gged_in'] != 1 && isset($_COOKIE[ 'login_cookie '])) {
list($user, $pass) = explode('[]', $_COOKIE['logi n_cookie']);
$qu = mysql_query(&q uot;SELECT `user_password` FROM `members` WHERE `username` = '".addsl ashes($user).& quot;'";
if (mysql_num_rows ($qu) == 1) {
$passw = mysql_fetch_obj ect($qu);
if ($passw->use r_password == $pass){
$_SESSION['log ged_in'] = 1;
$_SESSION['use rname'] = $user;
$_SESSION['pas sword'] = $pass;
}
}
}

Edited at 06:28:52 pm on 07/02/07

Viewed: 13,391 Times |

BoricuaLayz

Subject: "re: Member ID in Session" Posted: @ 7:09 pm on Jul 02 2007

Member #: 356
Rank: user - (30)
Since: 06/25/07
Posts: 44
From: Florida

Would this work?

$username = $_SESSION['use rname'];
$q = "SELECT id FROM members WHERE CONVERT( `members`.`user name` USING utf8 ) = '$username' LIMIT 1;";
$result = @mysql_query($q );
$row = mysql_fetch_arr ay($result);
$member_id = $row['id'];

Viewed: 13,385 Times |

Viewing Page: 1 of 1

1 |

You must be logged in to post on the forums. Login or Register