CODEWITHSUNDEEP
phpmysqlmysqli
Chris Crossman
Chris Crossman

Reputation: 15

MySQLi Query prepare and retrieving results

I've gone through quite a number of stackoverflow threads and I simply can't get it right to retrieve the results after preparing a query. I've tried a number of different solutions and none seem to be able to fetch the associative array after I execute the query

    $mysqli = new MySQLi('localhost', 'root', '', 'prac2');
    $query = $mysqli-> prepare("SELECT * FROM `user` WHERE username=? and password=?");
    $query-> bind_param('ii', $username, $password);
    if($query-> execute())  {
        $query->store_result();
        if ($query -> num_rows > 0) {
            $result = $mysqli->query($query);
            $r = $result -> fetch_array(MYSQLI_ASSOC)['userid'];
            $_SESSION['userid'] = $r;
        }
    }

I've established that sometimes its a case of result containing a boolean for success but I'm still not certain what exactly I'm doing wrong.

UPDATED:

Okay the bind_param works now, but the fetch_assoc keeps giving me the error "Call to a member function fetch_assoc() on a non-object", I even test the result to ensure that it returns true.

$mysqli = new MySQLi('localhost', 'root', '', 'prac2');
$query = $mysqli->prepare("SELECT * FROM user WHERE username=? and password=?");
echo $mysqli->error;
$query-> bind_param('ss', $username, $password);
if($query->execute())  {
    $result = $query -> store_result();
    if($result) {
        while($row = $result -> fetch_assoc()){
            echo $row['userid'];
            $_SESSION['userid'] = $row['userid'];
        }
    }
}

Upvotes: 0

Views: 90

Answers (2)

user2958326
user2958326

Reputation: 1

Inside bind_param for string you should use s. I mean try ss instead of ii.

Upvotes: 0

John Robertson Nocos
John Robertson Nocos

Reputation: 1485

Usernames and password are strings and it should be 's' denoting that corresponding variable has type string. I don't see how usernames and passwords are integers. Bind Param Types

   $query-> bind_param('ss', $username, $password);

Upvotes: 2

Related Questions