Solved

Retrieving user information from database - help

Posted on 2011-09-06
6
224 Views
Last Modified: 2012-05-12
Right, my code that I have written will retrieve the records from the database table containing the users
but I only want to display the details of the user logged in rather than all of the users.

I can't seem to work out how to change it so it only displays the logged in user.

<?php
include("database.php");

$query = "SELECT * FROM user ";
$result = mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();

if ($num > 0 ) {
$i=0;
while ($i < $num) {
$FirstName = mysql_result($result,$i,"FirstName");
$Surname = mysql_result($result,$i,"Surname");
$DOB = mysql_result($result,$i,"DOB");
$City = mysql_result($result,$i,"City");
$Postcode = mysql_result($result,$i,"Postcode");
$WebAddress = mysql_result($result,$i,"WebAddress");
$USER_ID = mysql_result($result,$i,"USER_ID");

echo "<b>First Name:</b> $FirstName<br>";
echo "<b>Surname:</b> $Surname<br>";
echo "<b>Date of Birth:</b> $DOB<br>";
echo "<b>City:</b> $City<br>";
echo "<b>Postcode:</b> $Postcode<br>";
echo "<b>Website:</b> $WebAddress<br>";
echo "<a href=\"account_save.php?id=$USER_ID\">Update</a>";
echo "<br><br>";

++$i; } } else { echo "The database is empty"; }

?>

Open in new window


Your help is much appreciated.
Thank you.
0
Comment
Question by:PSTCAT
  • 4
  • 2
6 Comments
 
LVL 11

Accepted Solution

by:
maeltar earned 500 total points
ID: 36489899
Why not use a while loop to run though and put it within an if statement :

Obviously the $row array elements need to be adjusted to suit.
if ( $num > 0)
{
while ($row = mysql_fetch_array($result)
{
echo "<b>First Name:</b> {$row[0]}<br>";
echo "<b>Surname:</b> {$row[1]}<br>";
echo "<b>Date of Birth:</b>{$row[2]}<br>";
echo "<b>City:</b> {$row[3]}<br>";
echo "<b>Postcode:</b> {$row[4]}<br>";
echo "<b>Website:</b>{$row[5]}<br>";
echo "<a href=\"account_save.php?id=$id\">Update</a>";
echo "<br><br>";

}

} // end if

Open in new window

0
 
LVL 11

Expert Comment

by:maeltar
ID: 36489911
NOTE  Line 3 should read
while ( $row = mysql_fetch_array($result) )

Open in new window

0
 

Author Comment

by:PSTCAT
ID: 36489963
Hi,

Thanks for your reply,

That code works for displaying the user's information
but I am still getting the other users in the table being displayed on the page.

0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
LVL 11

Expert Comment

by:maeltar
ID: 36490051
how do you know what user is logged in ?
As in is there a variable set to a value ?
0
 
LVL 11

Assisted Solution

by:maeltar
maeltar earned 500 total points
ID: 36490065
If the user id is set in a variable you could adjust the sql to something similar to :

$query = "SELECT * FROM user where <user id field> = <variable holding user id>";

Open in new window

0
 

Author Comment

by:PSTCAT
ID: 36490087
I see where you are going with that.

Thank you.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Ready Made PHP Scripts 5 72
Batch FIle delete files with particular date 10 90
Register AutoHotkey 12 73
Powershell Script need assistance to make some changes 4 81
The following is a collection of cases for strange behaviour when using advanced techniques in DOS batch files. You should have some basic experience in batch "programming", as I'm assuming some knowledge and not further explain the basics. For some…
In this tutorial I will show you how to provide a dynamic RTF document on your website generated with data from your database. For this tutorial you will need Microsoft Word or WordPad, WhizBase and Microsoft Access. In this tutorial I will show …
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…
The viewer will learn how to dynamically set the form action using jQuery.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question