If mysql data = php variable issue

mrbell11 · January 10, 2020, 4:58am

Currently I’m trying to make it so if someone logs in his the same id as the php $ variable then it will redirect them. although I am not sure why it isn’t working.

$query = “SELECT * FROM login WHERE username= '”.$_SESSION[‘username’]."’";
$result = $connection->query($query);
if($result->num_rows > 0){
$userData = $result->fetch_assoc();
if($userData[‘id’] = $siteokid){
header(“Location: admin.php”);
}
}else{
session_destroy();
header("Location: index.php ");
echo “”;
}

chorn · January 10, 2020, 7:14am

And what should that mean?

mrbell11 · January 10, 2020, 9:32am

It is allowing all users no matter the id number to be put into admin.php.

chorn · January 10, 2020, 9:58am

then you must check that ID on the admin.php

skawid · January 10, 2020, 10:44am

There’s an = sign missing here. It should be:

if ($userData['id'] == $siteokid) {

= is for assignment, so you’re changing the value of $siteokid rather than matching against it.