Having problems comparing strings (PHP)

Question

My goal is to check if the value of the "token" stored in a cookie is the same as the value in the loginTable table in the db. I am able to save the value of the cookie in the variable $token. The problem I have is here --> if ($row["token"] == $token). For example the value of the $token is bm0h8sdigs and the value in the row is bm0h8sdigs, but it does not enter the if. I also tried strcmp function but it didn't work. if(strcmp($row["token"], $token) == 0) I also tried $sqlToken = "select * from loginTable where token='" . $token . "'"; but it does not work.

echo $token; prints what is in my cookie - bm0h8sdigs

<!-- https://github.com/js-cookie/js-cookie This is a library to make handling cookies easier -->
<script>
   var token = Cookies.get('token');
</script>

<?php
   $token = "<script>document.write(token)</script>";

   $var = 0;
   include "connectDB.php";
                                
   $sqlToken = "SELECT * FROM loginTable";
   $resultToken = $mysqli->query($sqlToken);

   while($row = $resultToken->fetch_assoc()){
        if ($row["token"] == $token){
            $var = 1;
        }
   }
   $mysqli->close();
                                
   if ($var == 1){
   //Token found in db
   }
   else{
   //Token not found in db
   }
?>

connectDB.php

<?php
    $host = "localhost";
    $username = "root";
    $password = "usbw";
    $database = "test";

    $mysqli = new mysqli($host, $username, $password, $database);
    $mysqli -> set_charset("utf8");

    if ($mysqli->connect_errno) {
        echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; 
    }
?>

loginTable - prnt.sc/u7nidn

Create table loginTable(
    loginID int AUTO_INCREMENT,
    userID int not null,
    token varchar(20) not null,
    Constraint PK_loginTable Primary Key(loginID),
    Constraint FK_loginTable_userID Foreign Key (userID) References usersTable (userID)
)

can I see a screenshot of the value that is stored in your database table? — Omi Shah
– Omi Shah, Commented Aug 28, 2020 at 18:12
above the comparison line do var_dump($row["token"], $token); to see if this really matches. Also why not SELECT * WHERE token = :token insead of fetching all and comparing? — blahy
– blahy, Commented Aug 28, 2020 at 18:14
I have put above da comparison line and the result is this :Fatal error: Call to a member function fetch_assoc() on a non-object. I also tried $sqlToken = "select * from loginTable where token='" . $token . "'"; but it does not work, i know it does the same job. — dadidasete
– dadidasete, Commented Aug 28, 2020 at 18:20

xtothea · Accepted Answer · 2020-08-28 19:33:09Z

1

The example you provided shows that $token holds the value <script>document.write(token)</script>; Of course comparison will fail then.

Your approach of passing the javascript variable to php will not work. php has no acces to the javascript scope. Try passing your variable via form submit or try to access the cookie values directly in php, via $_COOKIE

edited Aug 28, 2020 at 19:33

answered Aug 28, 2020 at 19:25

xtothea

1691 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

Having problems comparing strings (PHP)

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related