How can I get an unknown username given an ID?

by

That’s actually a very good question that has almost no good answers on Stack Overflow.

Basically you need the following steps to perform a SELECT query using mysqli:

  • create a correct SQL SELECT statement and replace all variables in the query with with question marks (called placeholders or parameters)
  • Prepare the resulting query
  • Bind all variables to the previously prepared statement
  • Execute the statement
  • get the mysqli result variable from the statement.
  • fetch your data

The detailed explanation can be found in my article, How to run a SELECT query using Mysqli, as well a helper function to simplify the routine.

Following this plan here is your code

$sql = "SELECT * FROM users WHERE id=?"; // SQL with parameters
$stmt = $conn->prepare($sql); 
$stmt->bind_param("s", $id);
$Stmt->execute();
$result = $stmt->get_result(); // get the mysqli result
$user = $result->fetch_assoc(); // fetch the data

now you can store the username in the session variable:

$_SESSION['name'] = $user['name'];

More Related Contents:

  1. Can’t pass mysqli connection in session in php
  2. About how does mysqli_query() Function and mysqli_fetch_array($result) work?
  3. Can I mix MySQL APIs in PHP?
  4. PHP session lost after redirect
  5. Best way to INSERT many values in mysqli?
  6. Call to a member function bind_param() on a non-object [duplicate]
  7. How do PHP sessions work? (not “how are they used?”)
  8. How unique is the php session id
  9. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  10. MySQLi query returns only one row
  11. Cookies vs. sessions
  12. How to call a MySQL stored procedure from within PHP code?
  13. PHP sessions that have already been started [duplicate]
  14. How do I migrate my site from mysql to mysqli? [duplicate]
  15. Converting MySQL result array to JSON [duplicate]
  16. Fatal error: Cannot use object of type mysqli_result [closed]
  17. Do I have to guard against SQL injection if I used a dropdown?
  18. Inserting data to table (mysqli insert) [duplicate]
  19. How to echo a MySQLi prepared statement?
  20. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  21. Detect if PHP session exists
  22. MySQLi prepared statements with IN operator [duplicate]
  23. Unknown database error in PHP but it exists in PHPMyAdmin
  24. Can I blindly replace all mysql_ functions with mysqli_?
  25. Call to undefined function session_register() [duplicate]
  26. Is mysqli_real_escape_string safe?
  27. My Laravel 5.2.10 Sessions wont persist
  28. laravel – Can’t get session in controller constructor
  29. How do I save PHP session data to a database instead of in the file system?
  30. Strange problem with the length of the field gotten from database [duplicate]

Leave a Comment