PHP Foreach MySQL Query

Question

This is a receipt I'm trying to generate but i also need it to deduct quantity from our webshop. It works correctly when I only put one product through but I want it to work for each product displayed on the receipt.

<?php $r = 1; foreach ($rows as $row):?>


        <tr>

            <td style="text-align:center; width:30px;"><?php echo $r; ?></td>

            <td style="text-align:left; width:180px;"><?php echo $row->product_code; ?></td>

            <td style="text-align:center; width:50px;"><?php echo $row->quantity; ?></td>

            <td style="text-align:right; width:70px; "><?php echo $row->gross_total; ?></td>

        </tr> 

<?php

    mysqli_query($con,"UPDATE product SET quantity = quantity - '$row->quantity;' WHERE mpn = '$row->product_code'");

    mysqli_close($con);

?>

<?php $r++; endforeach; ?>

Upon adding more than 1 item to the receipt I get this error.

A PHP Error was encountered

Severity: Warning Message: mysqli_query(): Couldn't fetch mysqli Filename: views/view.php Line Number: 142

Is ur mysqli extension enabled in PHP.ini??

Amit Horakeri
– Amit Horakeri

2014-08-12 11:50:33 +00:00
Commented Aug 12, 2014 at 11:50 — Amit Horakeri
– Amit Horakeri, Commented Aug 12, 2014 at 11:50
'$row->quantity;' <- what's the semicolon doing there?

Niels Keurentjes
– Niels Keurentjes

2014-08-12 11:51:41 +00:00
Commented Aug 12, 2014 at 11:51 — Niels Keurentjes
– Niels Keurentjes, Commented Aug 12, 2014 at 11:51

Farshad · Accepted Answer · 2014-08-12 11:51:33Z

1

take mysqli_close($con); after endforeach;

answered Aug 12, 2014 at 11:51

Farshad

1,4951 gold badge9 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

PHP Foreach MySQL Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related