retrieve any user profile data

[Unknown_2]

For example, in Facebook, if you enter someone's profile you can see all the user's data. I know how to get the logged in user's data. But what I don't know is how to get every single user's data and show them. I searched a lot and all what I got was how to get logged in user's data. I don't want that.

Can someone please help me out?

[rproffitt]

Wait, did you just ask how to get all 1.86 Billion Facebook user info? Can you rephrase the question?

[mexabet]

I'm assuming that you simply want to display the details of all the users of your own script.

Lets assume you have a table named "users" that have "id", "userimage", "username", "firstname", "lastname" and "usersex" columns. You can use the "foreach" loop to display the details of each user like this:

  <?php

      // query users' table to retrieve all the users' contents
      $users = query("SELECT * FROM users");
      foreach ($users as $row)
      {
      printf("<tr>");
      printf("<td>" . $row["id"] . "</td>");        
      printf("<td><img src='../images/user/" . $row['userimage']."' width='100' height='159'/></td>");
      printf("<td>" . $row["username"] . "</td>");
      printf("<td>" . $row["firstname"] . "</td>");
      printf("<td>" . $row["lastname"] . "</td>");
      printf("<td>" . $row["usersex"] . "</td>");

  ?>

[Unknown_2]

Thanks mexabet for this information.
But I don't need that. I just need, when you click on the name of someone, it shows you the entire profile of that someone.
What I tried to do was not what I wanted. What I did was: when a new user registers, for example if that user has the id 7 and you want to go to the user with the id 4, it always shows the last user's information.

[mexabet]

If you want members to successfully assist you, you have to post your code. Otherwise, it would be pure guessing and time-consuming.

I can only guess that you did was use a code like $row[0]["id"]; to attempt to access each user. If that is your case, try using $row["id"];

Below is an example usage:

printf("<td><a href='../profile.php?id=%d'>Michael</a></td>", $row['id']);