PHP mysqli printing array issue

Question

I have an issue with PHP and mysqli, as im not really familiar with the coding language i have this issue: When i try to fill the array from row 1 to 8 the only return i get when i do print_r $items the result is 8. Not 1 to 8. Can someone help me ?

Code

$gebruiker = $_SESSION['user'];

$query = "select `item_id` from inventory where `gebruiker_id` = ?";
    $stmt = $db->prepare($query);
    $stmt-> bind_param('i', $gebruiker->id);
    $stmt->execute();
    $stmt->bind_result($item_id);
    $items = array();
    while ($stmt->fetch()) {
        $items['item_id'] = $item_id;
    }

Inventory Table

    gebruiker_id |   item_id
__________________________
    1        |      1
    1        |      2
    1        |      3
    1        |      4
    1        |      5
    1        |      6
    1        |      7
    1        |      8

John Conde · Accepted Answer · 2015-01-12 18:30:25Z

3

You keep overwriting the value of $item['item_id'] in your loop. What you're probably looking for is:

$items[] = $item_id;

That will capture all of the item IDs in an array.

answered Jan 12, 2015 at 18:30

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

5 Comments

J.Koppen Over a year ago

Doesn't give me a return at all... EDIT: it did but still it only returns 8

Funk Forty Niner Over a year ago

I'm wondering if the OP started the session or not, and if it has any bearing on the issue.

John Conde Over a year ago

@Fred-ii- Since they do get one row I am assuming their query is running successfully

J.Koppen Over a year ago

@JohnConde That's correct, when I run the query trough PHPmyAdmin it returns 8 rows with the correct values.

Funk Forty Niner Over a year ago

Gotta be the fetch method then.

STLMikey · Accepted Answer · 2015-01-12 18:40:37Z

2

You are overwriting the same element in the array each time...try:

 $items[] = array('item_id' => $item_id);

edited Jan 12, 2015 at 18:40

answered Jan 12, 2015 at 18:30

STLMikey

1,2208 silver badges19 bronze badges

11 Comments

J.Koppen Over a year ago

Still only returns 8.

J.Koppen Over a year ago

Thanks for your help! Although gebruiker_id is a user, so it has to fetch the values for the currently logged in user and the values differs per user, this user has 8 items and another user has 6 items so BETWEEN won't work. when i try to run the query in PHPmyAdmin it returns 8 rows.

STLMikey Over a year ago

Yeah i just noticed that, and deleted the misleading SQL ...I would debug by adding a "count" variable inside of your while loop and making sure that the loop is looping 8 times. It's possible your $stmt->fetch() is not returning the expected number of rows

J.Koppen Over a year ago

I tried debugging as you said and it count returns 8 so the loop is working fine.

STLMikey Over a year ago

Alright, for debugging try adding this to the interior of your loop: $items_debug[] = $++count; what is the value of $items_debug after the loop runs?

|

Collectives™ on Stack Overflow

PHP mysqli printing array issue

2 Answers 2

5 Comments

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related