storing user_id in session variable

by

Debug.

Where do you store the value in the session state?:

$_SESSION['user_ID'] = $userID;

Ok, so where does $userID come from?:

function selectUser($conn, $username, $password, $userID)
{
    //...

Ok, so where does the function parameter come from?:

selectUser($conn,$username,$password)

Nowhere. You never supplied a value to be stored in session, so no value was stored in session.

It seems unlikely that you actually want to supply the User ID to the function. Instead, you probably want to supply just the username and password as you currently do and then get the User ID from the database. Which might look more like this:

$_SESSION['user_ID'] = $row["user_ID"];

Or perhaps:

$_SESSION['user_ID'] = $row->user_id;

Or however you get values from your $row object.

But basically the important lesson here is… When a value isn’t what you expect it to be, trace back where that value came from. Chances are you have a false assumption somewhere.

More Related Contents:

  1. Comma separated numeric values – PHP CodeIgniter
  2. PHP PDO and Mysql [closed]
  3. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  4. Notice: undifined index, but why?
  5. Automated or regular backup of mysql data
  6. Fatal error: Call to undefined function session_register()
  7. PHP: Warning: sort() expects parameter 1 to be array, resource given
  8. Save PHP array to MySQL?
  9. implement LIKE query in PDO
  10. PHP PDO prepared statement — MySQL LIKE query
  11. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  12. How can I use mysqli_fetch_array() twice?
  13. Executing multiple SQL queries in one statement with PHP
  14. MySQL db question marks instead of hebrew characters..?
  15. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  16. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  17. Easy way to export a SQL table without access to the server or phpMyADMIN
  18. using nulls in a mysqli prepared statement
  19. How can I count the numbers of rows that a MySQL query returned?
  20. How I can create installer for website. PHP mysql [closed]
  21. How to join two tables with ssp.class.php
  22. How to run the PHP script at scheduled time
  23. How to handle error for duplicate entries?
  24. MySql PHP select count of distinct values from comma separated data (tags)
  25. Eloquent many-to-many-to-many – how to load distant relation easily
  26. Select mySQL based only on month and year
  27. Mysql InnoDB engine in Laravel
  28. MySQL: Group by two columns and sum
  29. Which MySQL datatype to use for an IP address? [duplicate]
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment