urgent! I need to display user info. after login

dotty

I have a login to a page and I want to display user details on that page - based on user id but can't get it working

The session is started and userid approved (using Dreamweavers restrict access script). Now I want to display some other details belonging to that user based on the user id they logged in with.

my code for this is:

<?php require_once('../Connections/own_local.php'); ?> 
<? 
$userid = $HTTP_SESSION_VARS["MM_Username"]; 
function rsgetuser($userid) 
{ 
$db = mysql_select_db("members") 
  or die ("<p align=center><font face=verdana size=1>couldn't select db</font></p>"); 
$query = "SELECT company, email FROM memberlist WHERE username =" . $userid; 
$result = mysql_query($query) 
  or die ("<p align=center><font face=verdana size=1>couldn't execute query</font></p>"); 
return mysql_fetch_array($result.MySQL_ASSOC); 
}         

$company = $rsgetuser["company"]; 
$email = $rsgetuser["email"]; 

echo $userid; 
echo $company; 
echo $email; 
?>

... but the only thing that echoes is the userid!! So the username variable is echoing out but not the results of the SQL statement above. I can't see why not! The SQL statment returns the correct result when I enter it directly through phpmyadmin.

Anyone got any suggestions??

Installer

The function is never called. With these lines:

$company = $rsgetuser["company"];  

$email = $rsgetuser["email"];

the interpreter looks for an array variable named "$rsgetuser" and of course doesn't find one. So "null" is assigned to "$company" and "$email".

Call the function with this line (right before those two):

$rsgetuser = rsgetuser($userid);

You might want to read up on how functions work.

dotty

Do you mean this:

function rsgetuser(
{
$rsgetuser = rsgetuser($userid);
$company = $rsgetuser["company"];  

$email = $rsgetuser["email"];  

echo $userid;
echo $company;  

echo $email;  

}

It doesn't work either. It doesn't echo anything - not even the userid now.
There's something I don't understand - when a person logs in sucessfully using their username they are registered for that session - now I want to use that session to display their details - the sql returns the correct results so is there some trick involved in getting these to display?

Am getting very frustrated and running out of time - please help!

dotty

Okay so I've tried this:

while(list($company,$email)=mysql_fetch_row($result)) { 
echo $company; 
echo $email;
echo $userid;
}

and now they all echo

the next bit is not working - I want to insert these variables into another table

//insert into broker logs
$query = "INSERT INTO brokers (userid,company,email) VALUES ($userid','$company','$email')"; 
$result = mysql_query($query)
	or die ("<p align=center><font face=verdana><size=1>Couldn't execute query  - Error: "  . mysql_error() ." <br>please <a href=index.html> click here</a> to enter page</font>");

Only the userid is inserted - why??

Anybody know?

Davy

VALUES ($userid','$company','$email')";

missing a ' mark?

Jesuz...learn how to debug!

Installer

Also, You might want to read up on how functions work.

dotty

actually Davy it's not that - I'd noticed that and fixed it after I copied the code to this forum.

Anyway, I'm not getting any error messages, it's just that the $company and $email are not inserting into the table - but they are echoed just above the insert sql. So it they they can be printed on the page - why in the world won't they insert into the database?

I admit I don't understand functions and how they work - there are so many different types - what type can I use in my example and where??

This is the newbie forum so please be patient 🙂

dotty

got this resolved elsewhere

For anyone who needs the same fix:

$company="";
$email="";
//get company name and email  

$query = "SELECT company, email FROM memberlist WHERE username = '$userid'";  

$result = mysql_query($query) or die("<p align=center><font face=verdana size=1>Query failed : " . mysql_error() ."</font></p>"); 
while(list($a,$b)=mysql_fetch_row($result)) { 

//$a and $b are now the lists' temporary variables
	$company=$a;
	$email=$b;
}

Installer - I will look up functions

🆒