Retrieve data from database using mysqli

I have a problem when I fetching data from database and row it I Got an error. How To fetch data From database using while and row it.

Fatal error: Call to a member function fetch() on a non-object in

Thanks in advance..

Here is my Code..

 <body>
<?php

$id = $_GET['id'];

$iqry = $mysqli->prepare("SELECT itemcode,itemname,brandname,quantity FROM table_inventory WHERE id = ?");
$iqry->bind_param('i', $id);
$iqry->execute();
$iqry->bind_result($itemcode,$itemname,$brandname,$quantity);
$res = $iqry->store_result();

while ($row = $res->fetch()){
  $itemcode = $row['itemcode'];
  $itemname = $row['itemname'];
  $brandname = $row['brandname'];
  $quantity = $row['quantity'];
}
?>

    <form method="post" name="increasing" action="save.php">
        <table>
            <tr><td>Itemcode</td><td>:</td><td><input type="text" name="itemcode" required="required"  value="<?php echo $itemcode; ?>">/></td></tr>
            <tr><td>Itemname</td><td>:</td><td><input type="text" name="itemname" required="required"  value="<?php echo $itemname; ?>"/></td></tr>
            <tr><td>Brandname</td><td>:</td><td><input type="text" name="brandname" required="required" value="<?php echo $brandname; ?>"/></td></tr>
            <tr><td>Quantity</td><td>:</td><td><input type="text" name="quantity" required="required" value="<?php echo $quantity; ?>"/></td></tr>
            <tr><td></td><td></td><td><input type="submit" class="myButton" value="Save"/></td></tr>
        </table>
    </form>
<body>

标签： php mysqli

1条回答

太酷不给撩

2楼-- · 2019-09-26 10:32

You seem to be mixing up mysqli_stmt and mysqli_result methods.

Try making the following changes:

LIMIT your resultset to one

... FROM table_inventory WHERE id = ? LIMIT 1

Stick with the mysqli_stmt as you seem to be further along with that

$iqry->bind_param('i', $id);
$iqry->execute();
$iqry->bind_result($itemcode, $itemname, $brandname, $quantity);

if (!$iqry->fetch()) {
    throw new Exception('No results found for ID ' . $id, 404);
}

// You can now use $itemcode, $itemname, $brandname and $quantity,
// they will all be set

?>

<form ...

0人赞添加讨论(0) 举报

Retrieve data from database using mysqli

采纳回答

编辑标签

举报内容

检举类型

检举原因

检举说明(必填)

打开微信“扫一扫”，打开网页后点击屏幕右上角分享按钮

付费偷看金额在0.1-10元之间