how to view my data in my database in a certain items?

jhanny007 · January 3rd, 2009, 07:47 AM

Hi,

Im quite new in php mysql, i have a problem regarding on how to view a single item, like for example, im my database i have a table name called "list" in my table i have "id, title,firstname,lastname, status" and id is my primary key, now i have no problem in displaying my data in all, what i want is like for example i have a record in my database like:

ID TITLE FIRSTNAME LASTNAME STATUS
view 1 REGISTER JHON CRUZ SINGLE
view 2 REGISTER JHON1 CRUZ MARRIED
view 3 REGISTER JHON2 CRUZ SINGLE

Now my problem is how im going to make a certain code that if i have to click the " view" only in person will appear let say if im going to click view from id 1 only the profile of JHON will display. 1 hope i made it clear. sori my english is bad.

jhanny

anees_muhd · March 6th, 2009, 12:43 AM

am summarizing ur needs

- You want to list the whole users in a table
- Each user has a view link near to each row
- when u click on it, u want to show his/her full details in another page

PHP Code:


			
$get_users = "SELECT `id`, `firstname` FROM `your_table` ORDER BY `id`;
$get_users_qr = mysql_query($get_users);
while($get_users_obj = mysql_fetch_array($get_users_qr)) {
      echo $get_users_obj['firstname']." <a href='details.php?id=".$get_users_obj['id']."'>View Details</a><br/>";
}

This will list your whole db users list with view details link
=============================================

In details.php

get the id and list its details

PHP Code:


			
$user_id = $_GET['id'];
$get_details = "SELECT * FROM `your_table` WHERE `id`='".$user_id."'";
$get_details_qry = mysql_query($get_details);
if($get_details_obj = mysql_fetch_array($get_details)) {
   echo "First Name:".$get_details_obj['firstname'];
  echo "<br> Last Name:".$get_details_obj['lastname'];
}