MySQL Shopping Cart Error

Question

I keep getting this error when I try to process a shopping cart

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in

Here's the code section that I've been working on:

//STATEMENTS TO STORE ITEM ORDER
while($row = mysqli_fetch_array($r , MYSQLI_ASSOC)){
    $query = 
        "INSERT INTO order_contents (order_id,item_id,quantity,price)
        VALUES ($order_id, ".$row['item_id'].",".
        $_SESSION['cart'][$row['item_id']]['quantity'].",".
        $_SESSION['cart'][$row['item_id']]['price'].")";

    $result = mysqli_query($dbc,$query) or die (mysqli_error($dbc));
}

//CLOSE DB
mysqli_close($dbc);

//MESSAGE
echo "<p>Thanks for your order.<br/>
Your order number is #".$order_id."</p>";
$_SESSION['cart'] = NULL;
}

Any ideas? Thanks

Please don’t use session variables directly in your query. Prepare your statements and bind your parameters. — Martin Bean, May 28 '13 at 11:38
This means that query has not succeed so no resource parameter `$r` is given. — Voitcus, May 28 '13 at 11:38
check select query you have written for $r is correctly executed. — Srikanth Kolli, May 28 '13 at 11:39
[Mysqli update throwing Call to a member function bind_param() error](http://stackoverflow.com/a/15447204/285587) — Your Common Sense, May 28 '13 at 11:43

score -1 · Answer 1 · edited May 28 '13 at 13:54

-1

You are running mysqli_fetch_array against the resource identifier $r but that value is only a boolean (true or false).

You need to have run a query before the while loop something like...

$r = mysqli_query($query, $dbc);

... where query is the sql that will generate the data to be used by mysql_fetch_array.

I hope this helps.

edited May 28 '13 at 13:54

MMM

7,013
2
23
42

answered May 28 '13 at 12:58

user466764

1,179
6
7

MySQL Shopping Cart Error

1 Answers1