JSON encoding multi selected rows into an array [duplicate]

Question

I am working on the following snippet. How can I load all affected rows into $items array?

As you can see I am able to fetch each binded cell like $pid and $psku but I need to load them to $items

$items =[];
$stmt = $conn -> prepare("SELECT `pid`,`psku` FROM `appolo` ORDER BY `pid` ASC LIMIT 24");

$stmt -> execute();
$stmt -> store_result();
$stmt -> bind_result($pid, $psku);

while ($stmt -> fetch()) {
    echo $pid;
    echo $psku;
}
$stmt->free_result(); 

echo json_encode($items);

Use array_push instead of echoing them?

Chin Leung
– Chin Leung

2019-04-10 19:41:06 +00:00
Commented Apr 10, 2019 at 19:41 — Chin Leung
– Chin Leung, Commented Apr 10, 2019 at 19:41
So what's the problem - [] notation already invented.

u_mulder
– u_mulder

2019-04-10 19:41:42 +00:00
Commented Apr 10, 2019 at 19:41 — u_mulder
– u_mulder, Commented Apr 10, 2019 at 19:41

AbraCadaver · Accepted Answer · 2019-04-10 19:45:29Z

1

It's pretty simple, just build an array of the variables and add to an array:

while ($stmt -> fetch()) {
    $items[] = array($pid, $psku);
}

To get an associative array:

    $items[] = compact('pid', 'psku');

answered Apr 10, 2019 at 19:45

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

1 Comment

Mona Coder Over a year ago

Thanks AbraCadaver this was exactly what I was looking for

Collectives™ on Stack Overflow

JSON encoding multi selected rows into an array [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related