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
– Nazmul Hasan, Commented Sep 9, 2017 at 6:28
this is the error now, Class 'App\Http\Controllers\PDO' not found — Yogesh Kumar Singh
– Yogesh Kumar Singh, Commented Sep 9, 2017 at 6:32
Did you have player_type column in your auction table? You are trying to fetch an unknown property — Geordy James
– Geordy James, Commented Sep 9, 2017 at 6:53

marc_s · Accepted Answer · 2018-08-02 04:58:24Z

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 2, 2018 at 4:58

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 9, 2017 at 7:03

Amin.Qarabaqi

7231 gold badge7 silver badges22 bronze badges

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

Comments

Sreejith BS · Accepted Answer · 2017-09-09 07:54:26Z

0

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.

answered Sep 9, 2017 at 7:54

Sreejith BS

1,1931 gold badge10 silver badges18 bronze badges

Collectives™ on Stack Overflow

convert data fetched from DB to array in laravel

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related