MySQLi OOP Bind Parameters Error

Question

I am starting with MySQLi, I started with a simple select and it works:

$sql = "SELECT nombres, apellidos FROM users WHERE user = 'juan'";
$result = $con->query($sql);
while($row = $result->fetch_object()){
    print $row->nombres . '<br />';
    print $row->apellidos . '<br />';
}

But when I'm trying out using prepared statements have no results displayed... what am I doing wrong?

$user = 'juan';
$sql = "SELECT nombres, apellidos FROM users WHERE user = ?";
$result = $con->prepare($sql);
$result->bind_param('s', $user);
$result->execute();

while($row = $result->fetch_object()){
    print $row->nombres . '<br />';
    print $row->apellidos . '<br />';
}

Kevin · Accepted Answer · 2016-05-05 22:46:44Z

1

Using fetch in prepared statements is a little bit different. There's another fethcing API for mysqli prepared statements and you'll need to use ->bind_result() and stmt_fetch() for it to work.

$result->bind_param('s', $user);
$result->execute();
$result->bind_result($nombres, $apellidos);

while($result->fetch()){
    print $nombres . '<br />';
    print $apellidos . '<br />';
}

answered May 5, 2016 at 22:46

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

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

Comments

RiggsFolly · Accepted Answer · 2016-05-06 08:03:16Z

1

An execute will return a mysqli_statement object. If you want to process the results of the query like they were a mysqli_result object you have to run a $stmt->get_result() to convert it to a mysqli_result object, then you can process as a mysqli_result object with a while loop as you were doing

$user = 'juan';
$sql = "SELECT nombres, apellidos FROM users WHERE user = ?";
$stmt= $con->prepare($sql);
$stmt->bind_param('s', $user);
$stmt->execute();

$result = $stmt->get_result();

while($row = $result->fetch_object()){
    print $row->nombres . '<br />';
    print $row->apellidos . '<br />';
}

Unfortunately this function/method is only available if you have the Native Driver mysqlnd installed.

edited May 6, 2016 at 8:03

answered May 5, 2016 at 22:56

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

3 Comments

Kevin Over a year ago

->get_result() another good alternative if this method is available in your env @PatricioCarvajalH

RiggsFolly Over a year ago

@PatricioCarvajalH.Ah yes, thanks for reminding me that this is not always available, added a note to that effect

Patricio Carvajal H. Over a year ago

@RiggsFolly thank you. Found those interesting links: stackoverflow.com/questions/18753262/… stackoverflow.com/questions/8321096/… When to use bind_result vs get_result in mysql --> arian.io/when-to-use-bind_result-vs-get_result-in-mysql

Collectives™ on Stack Overflow

MySQLi OOP Bind Parameters Error

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related