DB query builder toArray laravel 4

Question

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  - gt where  name     Jhon  - gt get  - gt toArray

User · Answer

You can do this using the query builder  Just use SELECT instead of TABLE and GET   DB  select  select   from user where name        Jhon       Notes   1  Multiple question marks are allowed   2  The second parameter must be an array  even if there is only one parameter   3  Laravel will automatically clean parameters  so you don t have to   Further info here  http   laravel com docs 5 0 database running-queries  Hmmmmmm  turns out that still returns a standard class for me when I don t use a where clause  I found this helped   foreach  results as  result    print r get object vars  result        However  get object vars isn t recursive  so don t use it on  results

User · Answer

And another solution   objectData   DB  table  user       - gt select  column1    column2       - gt where  name         Jhon       - gt get     arrayData   array map function  item        return  array  item       objectData- gt toArray       It good in case when you need only several columns from entity

User · Answer

If you prefer to use Query Builder instead of Eloquent here is the solutions   result   DB  table  user  - gt where  name     Jhon  - gt 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

User · Answer

Easiest way is using laravel toArray function itself        result   array map function   value            return  value instanceof Arrayable    value- gt toArray      value          result

User · Answer

Please note  the option presented below is apparently no longer supported as of Laravel 5 4  thanks  Alex    In Laravel 5 3 and below  there is a method to set the fetch mode for select queries   In this case  it might be more efficient to do   DB  connection  - gt setFetchMode PDO  FETCH ASSOC    result   DB  table  user  - gt where  name     Jhon  - gt get      That way  you won t waste time creating objects and then converting them back into arrays

User · Answer

toArray is a model method of Eloquent  so you need to a Eloquent model  try this    User  where  name         Jhon  - gt get  - gt toArray      http   laravel com docs eloquent collections

User · Answer

try this one  DB  table  user  - gt where  name   Jhon  - gt get      just remove the     sign        because you are trying to array just the name  jhon                 I hope it s help you

[laravel-4] DB query builder toArray() laravel 4

Examples related to laravel-4

Examples related to query-builder