Export CSV Cannot use object of type stdClass as array

Question

i want to export data from my json to csv file but i get this error Cannot use object of type stdClass as array

i want to know please how i can use it as array

public function exportUsers()
 {
  $users = ServicePoint::all()->where("nature", "SP")->toArray();
  $users = ServicePoint::all()->where('statut','<>', 2);

  $arrayCsv = [];
  foreach ($users as $key => $line){
   $arrayCsv[$key][] = $line['name'];
   $arrayCsv[$key][] = $line['lastname'];
   $arrayCsv[$key][] = $line['email'];

  
  }

anything can help please

Possible duplicate of https://stackoverflow.com/questions/6815520/cannot-use-object-of-type-stdclass-as-array — 04FS, May 24 '19 at 11:31
Possible duplicate of [Cannot use object of type stdClass as array?](https://stackoverflow.com/questions/6815520/cannot-use-object-of-type-stdclass-as-array) — MrMaavin, May 24 '19 at 11:46

linuxartisan · Answer 1 · 2019-05-24T11:46:12.470

1

I am assuming you are trying to get users based on 2 where clauses.

If so, try this

$users = ServicePoint::all()->where("nature", "SP")
                            ->where('statut','<>', 2)
                            ->get();

Then change these lines

$arrayCsv[$key][] = $line->name;
$arrayCsv[$key][] = $line->lastname;

and so on.

edited May 24 '19 at 11:46

answered May 24 '19 at 11:34

linuxartisan

2,396
3
21
40

is the same problem : Cannot use object of type stdClass as array – maro zoldik May 24 '19 at 11:45

Vishal Tarkar · Answer 2 · 2019-05-24T11:54:20.183

1

public function exportUsers() {
    $users = ServicePoint::where("nature", "SP")->where('statut','<>', 2)
->all()->toArray();
    $arrayCsv = [];
    foreach ($users as $key => $line){
        $arrayCsv[$key][] = $line['name'];
        $arrayCsv[$key][] = $line['lastname'];
        $arrayCsv[$key][] = $line['email'];
    }
}

Try this, it should be working.

edited May 24 '19 at 11:54

answered May 24 '19 at 11:34

Vishal Tarkar

808
11
32

you forget all() is function in servicepoint .. Type error: Too few arguments to function Illuminate\Support\Collection::get(), 0 passed in .... – maro zoldik May 24 '19 at 11:48
@marozoldik : thanks! I have changed it with all() . – Vishal Tarkar May 24 '19 at 11:55

score 1 · Accepted Answer · answered May 24 '19 at 11:41

1

As its object it can be accessible with -> operator

foreach ($users as $key => $line) {
    $arrayCsv[$key][] = $line->name;
    $arrayCsv[$key][] = $line->lastname;
    $arrayCsv[$key][] = $line->email;
}

Should work.

answered May 24 '19 at 11:41

Rahul

18,271
7
41
60

1

i try it befor but not working and now it's working thank you – maro zoldik May 24 '19 at 11:59

Export CSV Cannot use object of type stdClass as array

3 Answers3