Problems with showing username

[pettsogn]

Hi.

I want to show something like "logged in as: testuser" on my page..
How can i get that information from my mysql table?

thanks

[cmancone]

How are you managing logins? It depends on what you are doing.

[pettsogn]

I dont really know how to show this, but here is my login.php

if ($submit)
{
$loggedin = "false";
$result = mysql_query("SELECT * FROM ".$PA["table"]." WHERE nick='$nick' AND password='$pw'",$db);
$myrow = mysql_fetch_array($result);
if ($myrow['closed']==1) { require "header.php"; die("Account closed."); }

if (mysql_num_rows($result)>=1){
    $Userid = $myrow["id"];
    Logging("login","$nick");
    setcookie("Username",$nick);
    setcookie("Password",$pw);
    setcookie("Userid",$myrow["id"]);
    setcookie("Access",$myrow["access"]);
    $loggedin = "true";
}
else setcookie("Username","");
if ($loggedin=="true") Header("Location: index.php");
else Header("Location: index.php?msgred=Wrong+login+or+password!");
die;

}
require "header.php";

if (!$submit) {
?>
<table>
<form method="post" action="<?php echo $PHP_SELF?>">
<td><font face="Arial" size="2"><b>Brukernavn:</td><td><input type="Text" name="nick"><tr>
<td><font face="Arial" size="2"><b>Passord:</td><td><input type="Password" name="pw"><tr>
<td></td><td><input type="Submit" name="submit" value="Logg inn"><tr>
</form>
</table>
<font size="1"><a href="sendpass.php">Mistet passordet?</a>
<?
}

was is that you where asking for?

[LoganK]

Have you even attempted to display the username? What type of user authentication/login system do you have in place? What's your DB structure?

[cmancone]

If you look up setcookie() on the php manual, it says that you access the values in a cookie using $COOKIE['cookiename'], so with the above code your username would be: $COOKIE['Username']. For the record though, using session_start() you can put more than one varable in a single cookie, rather than having one cookie per variable (which is what setcookie() does. With session_start(), you access your values using $_SESSION['variable'].

[pettsogn]

I am pretty lost here, yeah...

I've tried with $ARET[name], but that only showed the last member...

I run a game at my site,it's that game i want to take to get the username from..

I dont know if this is any help but...

header.php (the games header file)

if ($Username!=""){
$result = mysql_query("SELECT * FROM ".$PA["table"]." WHERE nick='$Username' AND password='$Password' AND closed=0",$db);
if (mysql_num_rows($result)==1) { }
else
{
Setcookie("Username","");
Setcookie("Password","");
Setcookie("Userid","");
Setcookie("Access","");
$Username = "";
$Userid = "";
$Access = "";
Header("Location: index.php");
die();
}
}

I guess my problem here is that i dont know where to look 🙁

[pettsogn]

I think i've figured it out...
When all the files are in the same folder, it seems to work...