create objects containing arrays in it from database in laravel

Question

[{
"productname" : "product 1",
"label" :["used license", "unused license"],
"value" : [16,15]
},
{
"productname" : "product 2",
"label" :["used license", "unused license"],
"value" : [16,15]
}]

I am trying to create the above format from laravel code.But there were no success so far. In the above code label is the names of two columns and value are the values of two columns.

My code so far is below

 $licenses_count = products::select('product_name AS 
 productname','total_license', 'license_remaining')
        ->get();
        return $licenses_count;

my code output

[{
 "productname" : "product 1",
 "total_licenses" :5,
 "remaining_licenses" : 11,
 },
 {
 "productname" : "product 2",
 "total_licenses" :16,
 "remaining_licenses" : 15,
}]

Any help would be appreciated.

developer · Accepted Answer · 2018-12-31 05:28:59Z

1

I changed the code as below which is working as in the required format.

$result = array();
foreach($licenses_count as $row){
            foreach($row as $k=>$v){
                $product = array();
               if($v=="productname"){
                  $product['productname'] = $row->productname;
               }
               if($v=="total_license"){
                  //return $row;
                  $product['label'][] = 'used license';
                  $product['value'][] = $row->total_license;
               }
               if($v=="license_remaining"){
                  $product['label'][] = 'unused license';
                  $product['value'][] = $row->license_remaining;
               }
            }
            $result[] = $product;
        }
        return $result;

answered Dec 31, 2018 at 5:28

developer

339 bronze badges

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

Comments

McBern · Accepted Answer · 2018-12-31 03:24:46Z

0

Try this:

$licenses_count = products::select('product_name AS 
productname','total_license', 'license_remaining')
    ->get();

$result = array();
foreach($licenses_count as $row){
    $product = array();
    foreach($row as $k => $v){
       if($k=="productname"){
          $product['productname'] = $v;
       }
       if($k=="total_licenses"){
          $product['label'][] = 'used license';
          $product['value'][] = $v;
       }
       if($k=="remaining_licenses"){
          $product['label'][] = 'unused license';
          $product['value'][] = $v;
       }
    }
    $result[] = $product;
}

return $result;

edited Dec 31, 2018 at 3:24

answered Dec 31, 2018 at 3:17

McBern

5491 gold badge4 silver badges8 bronze badges

2 Comments

developer Over a year ago

Thanks, When i tried your code, it was giving empty array. But i modified the code as below. which is working as expected.

McBern Over a year ago

Oh yeah you are right. Must access row as obejct to get the value

Collectives™ on Stack Overflow

create objects containing arrays in it from database in laravel

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related