Mysql select query results in null row values using php

Question

** Following query executes properly and gives exact result for login. But when I trying to access fields returned from the query, it shows me null. In below code, I've checked for correct email id and my column name is 'user_email', it validates the user login correctly, but when I was trying to access the same email id from returned result($checkLogin->user_email), it gives me null **

 $checkLogin=$db->query("SELECT * from `users` where
    `user_email`='$u_email' and `user_password`='$u_password'");
      if($checkLogin)
      {
        $data[]=array(
         'status'=>'success',
         'email'=>$u_email,
         'pass'=>$u_password,
         'email1'=>$checkLogin->user_email
        );
      }

Please give me solution over this

I did it.. Query executes correctly, that's why $checkLogin has been set — Avdhut K
– Avdhut K, Commented Sep 15, 2017 at 5:37

pgross · Accepted Answer · 2017-09-15 06:16:17Z

2

The query() function returns a result object. You need to fetch your result. There are a lot of functions for this: fetch_row(), fetch_assoc(), fetch_array(), fetch_all(). You can find examples of how to use those at php.net.

You could for example write the following:

$checkLogin = $db->query("SELECT * from `users` where `user_email`='$u_email' and `user_password`='$u_password'");

if($row = $checkLogin->fetch_object())
{
    echo $row->user_email;
}

edited Sep 15, 2017 at 6:16

answered Sep 15, 2017 at 5:39

pgross

5095 silver badges16 bronze badges

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

Comments

Avdhut K · Accepted Answer · 2017-09-15 05:36:48Z

0

I found the Solution. I've to use $db->get_row instead of $db->query as follows

  $checkLogin=$db->get_row("SELECT * from `users` where `user_email`='$u_email' and `user_password`='$u_password'");
  if($checkLogin)
  {
    $data[]=array(
     'status'=>'success',
     'email'=>$u_email,
     'pass'=>$u_password,
     'email1'=>$checkLogin->user_email
    );
  }

answered Sep 15, 2017 at 5:36

Avdhut K

741 silver badge13 bronze badges

Collectives™ on Stack Overflow

Mysql select query results in null row values using php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related