How to fetch a row using mysqli query?

Question

I am trying to fetch a row from my mysql DB using mysqli query.

PHP

$_SESSION['orderID'] = "632";
$orID = $_SESSION['orderID'];
$sql = $db->prepare('SELECT * FROM order_list WHERE order_id = ? ');
$sql->bind_param('s',$orID);
$sql->execute();
while($row = $sql->fetch()) 
{
   $productid = $row[0];
   $name = $row[1];
   echo $price = $row[2];

}

give no error in console and no result,

I have been trying to check the answers on stack overflow, I also googled it but all the suggestions gives me the same error.

I am pretty new with mysqli, your help will be highly appreciated

which particular answers did you try?

Your Common Sense
– Your Common Sense

2014-04-01 10:16:19 +00:00
Commented Apr 1, 2014 at 10:16 — Your Common Sense
– Your Common Sense, Commented Apr 1, 2014 at 10:16

DonCallisto · Accepted Answer · 2014-04-01 10:17:01Z

1

mysqli_fetch_array is a mysqli_result method not a mysqli_stmt one

You could use ->fetch() upon a mysqli_stmt

So basically your code could change that way

while($sql->fetch()) {
 //do something
}

but you need to call bind_result() before looping (otherwise you can't access returned values)

answered Apr 1, 2014 at 10:17

DonCallisto

30k9 gold badges74 silver badges104 bronze badges

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

Collectives™ on Stack Overflow

How to fetch a row using mysqli query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related