Collect username automatically

[Pavlos1316]

Hi

 

I have a form that only members can submit.

How do I get their username in my db when they submit the form?

 

Thanks

[DarkWater]

Where do you store the username?  Sessions?

[Pavlos1316]

I store it in my registration db

[peranha]

How do you store it in the website so you know they are logged in, or dont you store the username??

[Pavlos1316]

NO i use session_regenerate_id

[runnerjp]

ok so do something like this

 

$id= session_regenerate_id

 

$query = "SELECT * FROM table WHERE ID = '$id' LIMIT 1";

if ($result = mysql_query($query)){

    if (mysql_num_rows($result)) {

        $array = mysql_fetch_assoc($result);       

        $user = $array['Username'];

 

[Pavlos1316]

ok i will try it..

 

 

thanks

[DarkWater]

Pavlos, how do you actually store the username in the session?  $_SESSION['username']?