Add array into an associative array using php

Question

I have an array $items from records in a MySQL database:

$result = array();
$result["total"] = 105;

$sql = "SELECT id, firstname, lastname FROM users LIMIT 10, 20";
$result = $conn->query($sql);

$items = array();
    while($row = mysqli_fetch_object($result)){
        array_push($items, $row);
    }

I want to add this to the associative array $result with the key "rows".

I have tried this code

$result["rows"] = $items;

but print_r($items); displays nothing.

The json that I want out at the end is:

{
   "total":"105",
   "rows":[
      {
         "id":"3",
         "firstname":"fname1234BBBB",
         "lastname":"lname10....",
         "phone":"Lacock 4919999",
         "email":"[email protected]"
      },

What am I doing wrong ? Thanks

What does print_r($result) display ?

RanjanaLK
– RanjanaLK

2016-08-24 10:08:43 +00:00
Commented Aug 24, 2016 at 10:08 — RanjanaLK
– RanjanaLK, Commented Aug 24, 2016 at 10:08
use $result["rows"][] = $row; inside the loop

devpro
– devpro

2016-08-24 10:08:44 +00:00
Commented Aug 24, 2016 at 10:08 — devpro
– devpro, Commented Aug 24, 2016 at 10:08

Kristiyan · Accepted Answer · 2016-08-24 10:08:42Z

3

    //First don't overwrite $result varaible.
    $result_associative = array();
    $result_associative["total"] = 105;

    $sql = "SELECT id, firstname, lastname FROM users LIMIT 10, 20";
    $result = $conn->query($sql);

    $items = array();
        while($row = mysqli_fetch_object($result)){
            array_push($items, $row);
           //push the item into array with associative key
        $result_associative['rows'][] = $row;
        }

answered Aug 24, 2016 at 10:08

Kristiyan

1,66314 silver badges17 bronze badges

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

3 Comments

devpro Over a year ago

remove this line inside the loop array_push($items, $row);

Kristiyan Over a year ago

@devpro, he might use this variable for something else.

peter300 Over a year ago

Thanks Kristiyan - works as I wanted. Thanks for the comment lines.

Manjeet Barnala · Accepted Answer · 2016-08-24 10:39:45Z

0

Try this code..

$resultArr = array();
$resultArr["total"] = 105;

$sql = "SELECT id, firstname, lastname FROM users LIMIT 10, 20";
$result = $conn->query($sql);

while($row = mysqli_fetch_object($result)){
    $resultArr["rows"][] = $row;
}
echo json_encode($resultArr);

answered Aug 24, 2016 at 10:39

Manjeet Barnala

2,9951 gold badge13 silver badges21 bronze badges

1 Comment

Manjeet Barnala Over a year ago

@peter300 welcome dear glad to help you please up vote and accept the helpful answer so that is makes easy for future users to choose the best answer :)

Collectives™ on Stack Overflow

Add array into an associative array using php

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related