[SOLVED] user page load name

[perezf]

im trying to load the user name from my database so after the user is logged in they will see

Welcome user!

 

right now it just shows welcome am i calling the name from the database wrong

 

<?php

session_start();
if(!session_is_registered('username')) {
	header("Location: http://localhost/practice.com/?page=log-on");
}

$sessionid = session_is_registered('username');
$query = "SELECT username FROM ph_users WHERE username = '$sessionid'";
$result = mysql_query($query);
$row = mysql_fetch_row($result);

?>

ONLY MEMBERS CAN VIEW THIS PAGE
<p>Welcome <?php echo $row['username']; ?></p>
<p><a href="?page=logout">LogOut</a></p>

[Fadion]

Not very sure, but mysql_fetch_row() returns data with numeric indexes. Try echoing $row[0] or just use mysql_fetch_array().

[perezf]

i tried this and the username still does not load after the welcome, am i missing something

<?php

session_start();
if(!session_is_registered('username')) {
	header("Location: http://localhost/practice.com/?page=log-on");
}

$sessionid = session_is_registered('username');
$query = "SELECT username FROM ph_users WHERE username = '$sessionid'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

?>

ONLY MEMBERS CAN VIEW THIS PAGE
<p>Welcome <?php echo $row['username']; ?></p>
<p><a href="?page=logout">LogOut</a></p>

[Fadion]

session_is_registered() will return true/false depending if the session is set. Instead of that u can just use isset($_SESSION['username']);. I find it better that way but thats not your problem. Actually u are assigning TRUE to $sessionid with session_is_registered(). Instead use:

 

$sessionid = session_id();
session_start();

[Fadion]

Just figured it out that u dont actually need the session id. U just need the session value:

 

$sessionid = $_SESSION['username'];
//the other code

[perezf]

for some reason i can figure this out :(

 

what do i do

<?php

session_start();
if(!session_is_registered('username')) {
	header("Location: http://localhost/practice.com/?page=log-on");
}

$sessionid = $_SESSION['username'];
$query = "SELECT username FROM ph_users WHERE username = '$sessionid'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

?>

ONLY MEMBERS CAN VIEW THIS PAGE
<p>Welcome <?php echo $row['username']; ?></p>
<p><a href="?page=logout">LogOut</a></p>

[Fadion]

Its right in that way. It isnt working? If not echo $sessionid to see if it gets a value.

[perezf]

yes it returned a value of 1

[Fadion]

Value of 1? Ok, what value did u assign to the session 'username'? Isnt it the username of the user who just logged in? In the database, the field 'username' contains the username of the users (ex. John)?

[perezf]

thank you i got it now