Ask a Question Register Login

Laravel - Trying to get property of non-object - PHP

985

I am currently trying to learn Laravel and PHP in general.

I need to be able to import an Excel file, then get the data from that file. Currently, the import part works and I can see the data from the file. However, I am having trouble accessing the data.

I've read about thetoArray() function in Laravel, and is using that as below:

 $data = Excel::load($path, function($reader) {})->skipColumns(2)->get();
 $data = $data->toArray();

         foreach ($data as $key => $value) {

           //We only need some of the available data.
           echo $value->next_milestone_desc_cur._comp._incl_rltd;
           echo $value->shipment_id;

          }

Above code gives me below error:

Trying to get property 'next_milestone_desc_cur' of non-object

Below is an output from the array, which I have generated usingdd($value):

array:543 [▼
  0 => array:20 [▼
    "next_milestone_desc_cur._comp._incl_rltd" => "005. DK - Add DropMode/Local Trp Org in Pickup Tab"
    "milestone_cur._comp._sequence_no" => "005"
    "cur._comp._export_validation" => "NOT OK"
    "shipment_id" => "SBRY0162091"
    "consol_id" => "CDK327188"  ]
  1 => array:20 [▼
    "next_milestone_desc_cur._comp._incl_rltd" => "005. DK - Add DropMode/Local Trp Org in Pickup Tab"
    "milestone_cur._comp._sequence_no" => "005"
    "cur._comp._export_validation" => "NOT OK"
    "shipment_id" => "SBRY0162124"
    "consol_id" => "CDK327221"
  ]

What am I doing wrong here? I have also triedecho $value[0]->next_milestone_desc_cur._comp._incl_rltd;, however this doesn't work either.

933

Answer

Solution:

You are trying to access an array as an object hence your error and to address you second point, you need to use a nested loop to then access the sub-array.

Your array looks something like this:

$array = [
  0 => [
    0 => [
      'test' => 'value'
    ],

    1 => [
      'test' => 'something'
    ]  
  ],

  1 => [
    0 => [
      'test' => 'value'
    ],

    1 => [
      'test' => 'something'
    ]  
  ]  
];

You need the following loop:

foreach ($array as $key => $nested) {
  foreach ($nested as $nested_value) {
    // You have access to your inner arrays.
    echo  $nested_value['test'] . ' | ';
  }
}

Where your nested loops$nested would be$value.

Live Example

Repl

648

Answer

Solution:

Your output from dd($value) shows that $value is an array. So you cannot use arrow notation that is for objects. Change these lines:

echo $value->next_milestone_desc_cur._comp._incl_rltd;
echo $value->shipment_id;

To:

echo $value[0]["next_milestone_desc_cur._comp._incl_rltd"];
echo $value[0]["shipment_id"];

People are also looking for solutions to the problem: php - Want to get array value

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.