convert data fetched from DB to array in laravel

Question

I fetched data from table 'auction'

$players = DB::table('auction')->where('id',$id)->get();

I'm getting the data in this form

[
  {
    "id": 3,
    "name": "Yogesh Singh",
    "year": "BE",
    "branch": "CE",
    "division": "D",
    "achievements": "College Cricket Team",
    "base_price": 5000000,
    "status": 1,
    "manager": 0
  }
]

now I need to shift this data into another table 'team', and hence I did

DB::table('team')->insert(['player_id' => $id, 'player_type' => $player->player_type, 'name' => $player->name, 'price' => $player->price]);

it throws an error saying, Property [player_type] does not exist on this collection instance.

I'm pretty sure i'm not able to convert the data fetched from DB to array.

How do I do this?

use `DB::setFetchMode(PDO::FETCH_ASSOC);` before query builder — Nazmul Hasan, Sep 09 '17 at 06:28
this is the error now, Class 'App\Http\Controllers\PDO' not found — Yogesh Kumar Singh, Sep 09 '17 at 06:32
Did you have player_type column in your auction table? You are trying to fetch an unknown property — Geordy James, Sep 09 '17 at 06:53

score 2 · Answer 1 · edited Aug 02 '18 at 04:58

2

Laravel query builder select method returns a variable of Collection type. each member is of type stdclass.

Collection has a toArraye member:

toArray()

Just notice this function returns back 2 dimension array.

Another way is using collection->first to get first member of collection and convert this stdclass into array using this approach:php stdClass to array

edited Aug 02 '18 at 04:58

marc_s

732,580
175
1,330
1,459

answered Sep 09 '17 at 07:03

Amin.Qarabaqi

661
7
19

score 0 · Answer 2 · answered Sep 09 '17 at 07:54

It's because the $players is returning a collection since you used get(). Change it to first() which will return Model instance if exists. Also variable name is $player , not $players

$player = DB::table('auction')->where('id',$id)->first();

Now access data like:

DB::table('team')->insert(['player_id' => $id, 'player_type' => $player->player_type, 'name' => $player->name, 'price' => $player->price]);

OR

You can keep the get() and access data like this:

DB::table('team')->insert(['player_id' => $id, 'player_type' => $player[0]->player_type, 'name' => $player[0]->name, 'price' => $player[0]->price]);

Hope it's helpful.

convert data fetched from DB to array in laravel

2 Answers2