SQL returning null rows

Question

I have the below PHP code for returning the user details from the table

<?php

$con=mysqli_connect("localhost","root","");
if(!$con)
    {
        die('Could not connect'.mysqli_error());
    }
mysqli_select_db($con,"mysql");
$username=$_POST["username"];
$password=$_POST["password"];
$statement=mysqli_prepare($con,"Select * from bbau_login where username= ? and password= ? ");
mysqli_stmt_bind_param($statement,"ss",$username,$pasword);
mysqli_stmt_execute($statement);
mysqli_stmt_store_result($statement);
mysqli_stmt_bind_result($statement,$id,$name,$username,$password);

$user=array();

while(mysqli_stmt_fetch($statement))
    {
        $user['name']=$name;
        $user['username']=$username;
        $user['password']=$password;
    }
echo json_encode($user);
mysqli_stmt_close($statement);
mysqli_close($con);

?>

But it is returning null result when I am hitting this code from the application. If I run the sql with hard coded value

Select * from bbau_login where username= 'aqsdfg' and password= 'adjbf'

then I am getting the desired result but not with the sql specified in the php script

Also I checked I am getting the proper values in $username and $password. I think i need to pass the $username and $password in quotes. Please can someone help in writing correct query with quotes.

You are calling the prepared statement function so it cannot retrieve your data's — aldrin27
– aldrin27, Commented Sep 9, 2015 at 8:05

paxdiablo · Accepted Answer · 2015-09-09 08:07:24Z

4

Well, I would think that a consistent spelling of pasword/password would help immensely:

#  vv
$password=$_POST["password"];
:
mysqli_stmt_bind_param($statement,"ss",$username,$pasword);
#                                                   ^

You may well, as you state, be "getting the proper values in $username and $password", but that's not going to help if you don't actually use what's in $password :-)

answered Sep 9, 2015 at 8:07

paxdiablo

889k243 gold badges1.6k silver badges2k bronze badges

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

3 Comments

Fky Over a year ago

And test your $_POST variables too =)

paxdiablo Over a year ago

@Fky, yes, there's all sorts of other good advice such as what you've stated, and explicitly asking for the columns in order (no * allowed) so that the result binding doesn't screw up should column order change, and doing the associative arrays correctly so that later rows don't overwrite earlier ones. But, really, the question is about why no rows are being returned, all that other stuff is superfluous in the context of the question :-)

Fky Over a year ago

Yes but an advice who can helps to improve code quality is good to learn ;)

Danyal Sandeelo · Accepted Answer · 2015-09-09 08:12:12Z

0

You have written incorrect spelling of password while passing it

change

 mysqli_stmt_bind_param($statement,"ss",$username,$pasword);

to

mysqli_stmt_bind_param($statement,"ss",$username,$password);

answered Sep 9, 2015 at 8:12

Danyal Sandeelo

12.4k10 gold badges57 silver badges90 bronze badges

Collectives™ on Stack Overflow

SQL returning null rows

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related