?
Solved

Retrieving user information from database - help

Posted on 2011-09-06
6
Medium Priority
?
234 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 11

Accepted Solution

by:
maeltar earned 2000 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
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 2000 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

I hope you'll find this tutorial useful and interesting. So let's try to extend Tcl with a new package.  For anyone more deeply interested please check out the book "Practical Programming in Tcl and Tk". It's really one of the best written books abo…
Batch, VBS, and scripts in general are incredibly useful for repetitive tasks.  Some tasks can take a while to complete and it can be annoying to check back only to discover that your script finished 5 minutes ago.  Some scripts may complete nearly …
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Suggested Courses

762 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