Display user-specific table after login...

mibrahim

I have setup my website so members will login and be directed to their "my account" page, which will display their account information. However, I'm stuck at the following point: When a member signs in, it displays all of the information on the table. How can I set it so that only the information specific to the user is displayed? I'm pretty certain the answer is in the SELECT * FROM query, but I don't know what to change it to. Please help. Thank you.

Here is the code I am using, which is the page users are automatically redirected to after login:

<html>
<body>
<?php
$username="*****";
$password="**";
$database="**";
$localhost="*****";

mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM users";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th>First name</th>
<th>Last name</th>
<th>Email</th>
<th>Password</th>
<th>Active</th>
<th>Web development</th>
<th>Web hosting</th>
</tr>

<?php
$i=0;
{

$f1=mysql_result($result,$i,"first_name");
$f2=mysql_result($result,$i,"last_name");
$f3=mysql_result($result,$i,"email");
$f4=mysql_result($result,$i,"pass");
$f5=mysql_result($result,$i,"active");
$f6=mysql_result($result,$i,"web_development");
$f7=mysql_result($result,$i,"web_hosting");
?>

<?php
$i++;
}
?>
</body>
</html>

cretaceous

do you track the unique id of each user? (you should do..) - if so then :

$query="SELECT * FROM users WHERE uniqueid='$currentusersid' ";

you could also do
$query="SELECT * FROM users WHERE accountusername='$accountusername' ";

the two items $currentusersid and $accountusername are the identifiers you can use to track who is logging in - you will need to initialise those when users log in

you should probably read up on some tutorials to get this straight!

mibrahim

I wish I had the time to track down my specific issue through tutorials, but I am very pressed for time unfortunately. Thank you for the help.

Is there a script for tracking/initialization?

mibrahim

When I only made the change from

$query="SELECT * FROM users

$query="SELECT * FROM users WHERE uniqueid='$currentusersid' ";

the page now only displays the fields, but not the values. I'm sure this is because $currentuserid is not recognized by the script?

Weedpacket

mibrahim wrote:
I'm sure this is because $currentuserid is not recognized by the script?

That's because

cretaceous wrote:
the two items $currentusersid and $accountusername are the identifiers you can use to track who is logging in - you will need to initialise those when users log in

mibrahim

sorry i just started learning php script this week. can anyone direct me to a tutorial or some script on how to initialize those items?

johanafm

And there is no guarantee "uniqueid" exists either. It could just as well be id, person_id, unique_id etc.

Google: php session tutorial

cretaceous

yes I may have misled you - you have to create those items, they don't exist yet

but there really is no short cut to learning however little time you may have