Laravel 5.5 - Parse result of db query

Question

I am using Laravel Framework 5.5.26 and I am querying my db with the following call:

    $symbolsArray = DB::table('exchanges')
        ->join('markets', 'exchanges.id', '=', 'markets.exchanges_id')
        ->where('name', $exchangeName)
        ->get(array(
            'symbol',
        ));

If I var_dump($symbolsArray) I get the following output:

class Illuminate\Support\Collection#619 (1) {
  protected $items =>
  array(99) {
    [0] =>
    class stdClass#626 (1) {
      public $symbol =>
      string(7) "BCN/BTC"
    }
    [1] =>
    class stdClass#621 (1) {
      public $symbol =>
      string(8) "BELA/BTC"
    }
    [2] =>
    class stdClass#623 (1) {
      public $symbol =>
      string(7) "BLK/BTC"
    }
    [3] =>
    class stdClass#627 (1) {
      public $symbol =>
      string(8) "BTCD/BTC"
    }
    ...
  }
}

I am trying to get the $symbol like the following:

$symbolsArray[$key]['symbol']

However, I get the following error:

  Cannot use object of type stdClass as array

Any suggestions how to access the symbol from the query output?

Alexey Mezenin · Accepted Answer · 2017-12-21 11:15:16Z

3

It's a collection of objects, not arrays. So you need to use this syntax to get property of an object in a collection:

$symbolsArray[$key]->symbol

If you need to get just symbols, use pluck() instead of get():

->pluck('symbol')->toArray()

edited Dec 21, 2017 at 11:15

answered Dec 21, 2017 at 11:11

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

Comments

Aman Kumar · Accepted Answer · 2017-12-21 11:13:51Z

1

Simple convert given output as an array like shown below

$symbolsArray = DB::table('exchanges')
        ->join('markets', 'exchanges.id', '=', 'markets.exchanges_id')
        ->where('name', $exchangeName)
        ->get(array(
            'symbol',
        ))->toArray(); // get data as array not object

answered Dec 21, 2017 at 11:13

Aman Kumar

4,5573 gold badges21 silver badges40 bronze badges

Comments

Matthias S · Accepted Answer · 2017-12-21 11:17:31Z

1

The result of DB::table()->get() is always a Collection, whose attributes you access like variables within a PHP class with ->.

In your example, your $symbolsArray is not actually an array, you access the content with $symbolsArray[$key]->symbol.

Assuming that you are new to Laravel, I suggest you have a look at Laravel's built in ORM Eloquent. It makes working with Databases easy and straightforward, and if you dive a bit into Eloquent's Collections you will see that they make working with data a breeze.

answered Dec 21, 2017 at 11:17

Matthias S

3,5834 gold badges26 silver badges33 bronze badges

Comments

Leo Rams · Accepted Answer · 2017-12-21 14:13:33Z

0

$symbolsArray is a collection and not an array. The get an array, you could pluck symbol from the collection $symbolsArray = DB::table('exchanges') ->join('markets', 'exchanges.id', '=', 'markets.exchanges_id') ->where('name', $exchangeName) ->pluck('symbol')->all(); or you could actually convert your collection to an array by $new_array = $symbolsArray->toArray()

answered Dec 21, 2017 at 14:13

Leo Rams

73911 silver badges25 bronze badges

Collectives™ on Stack Overflow

Laravel 5.5 - Parse result of db query

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related