PostgreSQL in PHP - session variable seems to unset itself when posting data

Question

I'm trying to handle a form that updates some data in a postgreSQL table. To do that, I GET the id for the item to update. The URL reads:

[...]pojazd.php?id=1[...], which successfully GETs the data.

Then I want to store it in a session (that was opened before):

$_SESSION['id'] = $_GET['id'];
$id = $_SESSION['id'];

When I use my $id variable to SELECT the data, it works fine.

SELECT model, cena FROM pojazd WHERE id_poj = $id" does the job.

But when I want to update this data using a POST form:

if (isset($_POST['update'])){
[...]
UPDATE pojazd SET model = '$model', cena = '$cena' WHERE id_poj = $id;
}

nothing happens. When the $id variable is hardcoded (for example: replaced by 1 etc), it works fine. But the $id variable seems to unset itself whenever the form is POSTed. I tried echo'ing the $id variable whilst disabling the redirecting, and that's exactly what happens - the $id variable disappears.

I'm at a loss. The clock is ticking, I really don't want to fail my class, but that problems ruins my entire project...

Nick · Accepted Answer · 2020-01-26 01:50:18Z

1

You need to replace

$_SESSION['id'] = $_GET['id'];

with

if (isset($_GET['id'])) $_SESSION['id'] = $_GET['id'];

so that the value doesn't get overwritten with an empty value when the form is POSTed...

answered Jan 26, 2020 at 1:50

Nick

147k23 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

NijuGMD Over a year ago

Such a stupid mistake... I panicked and stopped thinking logically. Thank you <3

Collectives™ on Stack Overflow

PostgreSQL in PHP - session variable seems to unset itself when posting data

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related