PHP - Push data to array in foreach loop [duplicate]

Question

I want to achieve below array format:

{
    "success": true,
    "results": [
      {
        "name"  : "Choice 1",
        "value" : "value1",
        "text"  : "Choice 1"
      },
      {
        "name"  : "Choice 2",
        "value" : "value2",
        "text"  : "Choice 2"
      }
    ]
}

However, I am using PHP and a foreach loop, to return some values from my database:

//Search for clients in our database.
$stmt = $dbh->prepare("SELECT * FROM customers");
$stmt->execute();
$showAll = $stmt->fetchAll();

I then have my first part of the array, and my foreach loop:

$data = array(
    "success" => false,
    "results" => array()
);

foreach ($showAll as $client) {  
               $data_array[] = 
                     array(
                     'name' => $client['name'],
                     'value' => $client['name'],
                     'text' => $client['name']
                );

}

Above only outputs:

[
 {
   "name":"Choice 1",
   "value":"value 1",
   "text":"Choice 1"
 },
 {
   "name":"Choice 2",
   "value":"value2",
   "text":"Choice 2"
 }
]

So it is missing the top part of my original array - but I want to loop through each database results in "results": [ ... ]

@Steve it is showed just below the text "Above only outputs:" — oliverbj
– oliverbj, Commented Apr 20, 2017 at 8:55
There is no code in this question that outputs anything. i'm guessing you call json_encode somewhere, but your question does not show that — Steve
– Steve, Commented Apr 20, 2017 at 9:10

mickmackusa · Accepted Answer · 2017-05-17 07:56:49Z

12

Try this

$data = array(
  "success" => false,
  "results" => array()
);

foreach ($showAll as $client) {  
  $data['results'][] = array(
    'name' => $client['name'],
    'value' => $client['name'],
    'text' => $client['name']
  );
}

$data['success'] = true; // if you want to update `status` as well
echo json_encode($data);

edited May 17, 2017 at 7:56

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered Apr 20, 2017 at 8:48

Farooq Ahmed Khan

4,0943 gold badges29 silver badges36 bronze badges

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

2 Comments

oliverbj Over a year ago

This adds the "success" value to the end, and doesn't output the values as mentioned in my OP..

Farooq Ahmed Khan Over a year ago

'success' is already in $data array, the order should not change.

Sahil Gulati · Accepted Answer · 2017-04-20 09:07:37Z

5

After creating $data_array array just add few lines which i have in my post.

Try this code snippet here(with sample input)

ini_set('display_errors', 1);
foreach ($showAll as $client)
{
    $data_array[] = array(
                'name' => $client['name'],
                'value' => $client['name'],
                'text' => $client['name']
    );
}
// add these lines to your code.
$result=array();
$result["success"]=true;
$result["results"]=$data_array;
echo json_encode($result);

edited Apr 20, 2017 at 9:07

answered Apr 20, 2017 at 8:48

Sahil Gulati

15.2k4 gold badges28 silver badges43 bronze badges

2 Comments

Sahil Gulati Over a year ago

@arkascha Sir I have tested it, it is giving the expected output the way user want

arkascha Over a year ago

I have to apologize, you are indeed right! I was fooled by the fact that json encloses immediate values by a single curly brace. Sorry!

Badshah Sahib · Accepted Answer · 2017-04-20 09:01:32Z

1

try this as you have an array inside the $data_array on Key "Results" so you should use "results" as a key also and then try to push data in that array

foreach ($showAll as $client) {  
               $data_array["results"][] = 
                     array(
                     'name' => $client['name'],
                     'value' => $client['name'],
                     'text' => $client['name']
                );

}

answered Apr 20, 2017 at 9:01

Badshah Sahib

1842 silver badges11 bronze badges

1 Comment

Badshah Sahib Over a year ago

so he can use json_encode(). this is not an issue. :)

Priyank · Accepted Answer · 2017-04-20 09:07:30Z

0

You can simply use json_encode and push it to your result array

$data = array(
    "success" => false,
    "results" => array()
);

$result = [
 [
   "name" => "Choice 1",
   "value" => "value 1",
   "text" => "Choice 1"
 ],
 [
   "name" => "Choice 2",
   "value" => "value2",
   "text" => "Choice 2"
 ]
];

$data['results'] = json_encode($result);

answered Apr 20, 2017 at 9:07

Priyank

1,3481 gold badge16 silver badges27 bronze badges

2 Comments

Badshah Sahib Over a year ago

it will make the $result as json but "success" will remain the same as it is. So, He want to make whole array as json. i think he should assign the $result array to $data["results"] first then json_encode($data); this might be helpful for him to solve his problem.

Priyank Over a year ago

Ya OP can do that I missed that out I guess :p

Collectives™ on Stack Overflow

PHP - Push data to array in foreach loop [duplicate]

4 Answers 4

2 Comments

2 Comments

1 Comment

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

1 Comment

2 Comments

Linked

Related