DB query builder toArray() laravel 4

laravel-4 query-builder
Fabrizio Fenoglio picture Fabrizio Fenoglio · Dec 25, 2013 · Viewed 96.8k times · Source

I'm trying to convert a query to an array with the method toArray() but it doesn't work for the query builder. Any ideas for convert it?

Example

DB::table('user')->where('name',=,'Jhon')->get()->toArray();

Answer

Somwang Souksavatd picture Somwang Souksavatd · Jun 15, 2015

If you prefer to use Query Builder instead of Eloquent here is the solutions

$result = DB::table('user')->where('name',=,'Jhon')->get();

First Solution

$array = (array) $result;

Second Solution

$array = get_object_vars($result);

Third Solution

$array = json_decode(json_encode($result), true);

hope it may help

Related questions

How to select from subquery using Laravel Query Builder?

I'd like to get value by the following SQL using Eloquent ORM. - SQL SELECT COUNT(*) FROM (SELECT * FROM abc GROUP BY col1) AS a; Then I considered the following. - Code $sql = Abc::from('abc AS a')->…

Read More
Laravel whereIn OR whereIn

I'm making a products search by filters: My code: ->where(function($query) use($filter) { if(!empty($filter)){ foreach ($filter as $key => $value) { $f = explode(",", $value); $query-> whereIn('products.value', $f); } } }) Query: and (products.value in (Bomann, …

Read More
DB->count() returning different value from count(DB->get())

I have the simplest of queries that I'm trying to run DB::table('user_visits')->groupBy('user_id')->count(); But it's returning the wrong number, 8. If I change it to this: count(DB::table('user_visits')…

Read More