$_SESSION['id'] is null

Question

I am trying to update the password in a php script,howerver $_SESSION['id'] is null. This is shown via the var_dump function. Hence I can't update it

<?php
session_start();
require "../init.php";
ini_set('display_errors', 1);


if(isset($_POST['update'])){
    $password = $_POST['user_pass'];
    $passwordEncrypted = sha1($user_pass); 

    $confpassword = $_POST['confirm_pass'];
    $confPasswordEncrypted = sha1($confirmPass);  
    if($password !== $confpassword){
       echo "Passwords don't match!";
    }else{
        $select_query = "SELECT id FROM user_info";
        $run_select_query = mysqli_query($con,$select_query); 
        while ($row_post=mysqli_fetch_array($run_select_query)){

            $_SESSION['id'] = $row['id'];
            $user_id = $_SESSION['id'];
            var_dump($user_id);

        }

        $update_posts = "UPDATE user_info SET user_pass='$passwordEncrypted',confirm_pass ='$confPasswordEncrypted' WHERE id='$user_id'";  
        $run_update = mysqli_query($con,$update_posts); 
        echo "<script>alert('Post Has been Updated!')</script>";
    }

}
?>

Any ideas? Thanks.

`while ($row_post` then look at `$row['id']` ;-) wrong variable and error reporting http://php.net/manual/en/function.error-reporting.php would have signaled that undefined variable. — Funk Forty Niner, Apr 21 '16 at 17:46

urfusion · Answer 1 · 2016-04-21T17:48:30.243

2

You are using a wrong variable $row while assign value to session variable.

while ($row_post=mysqli_fetch_array($run_select_query)){
    $_SESSION['id'] = $row_post['id'];
    $user_id = $_SESSION['id'];
    var_dump($user_id);
}

edited Apr 21 '16 at 17:48

answered Apr 21 '16 at 17:48

urfusion

5,528
5
50
87

yeah I said that too, 2 minutes prior to this – Funk Forty Niner Apr 21 '16 at 17:48
@Fred-ii-: I am writing the answer while you commented on that :) – urfusion Apr 21 '16 at 17:49
@Fred-ii- : any way I can delete the answer if you want, not greedy for repu :D – urfusion Apr 21 '16 at 17:49
that's up to you, I'm not forcing your hand ;-) – Funk Forty Niner Apr 21 '16 at 17:50
1

let me enhance something to that answer so it will provide a bit more knowledge – urfusion Apr 21 '16 at 17:50

$_SESSION['id'] is null

1 Answers1

Linked