codeigniter result vs result array

Question

I use both result   and result array     Usually i like to get my result as array thats why i use result array   mostly    But i want to know which is the better approach that i should follow  Which one of them is more efficient to use in regards to performance   Here is the Example i am talking about in codeigniter queries   query    this- gt db- gt get     result    query- gt result array      or is this should be the better approach     query    this- gt db- gt get     result    query- gt result      also right now i am using result array in my generic model

User · Answer

for the sake of reference       query- gt result object        query- gt result      returns  Array    0    gt  stdClass Object    col A    gt  val 1A    col B    gt  val 1B                   0    gt  stdClass Object    col A    gt  val 2A    col B    gt  val 2B                                      query- gt result array        query- gt result      returns  Array    0    gt  Array    col A    gt  val 1A    col B    gt  val 1B                   1    gt  Array    col A    gt  val 2A    col B    gt  val 2B                                 codeigniter docs for result    and result array

User · Answer

in my experince the problem using result   and result array   in my JSON if using result   there no problem its works but if using result array   i got error  Trying to get property of non-object  so im not search into deep the problem so i just using result   if using JSON and using result array   if not using JSON

User · Answer

result   is recursive in that it returns an std class object where as result array   just returns a pure array  so result array   would be choice regarding performance   There is very little difference in speed though

User · Answer

result array   returns Associative Array type data  Returning pure array is slightly faster than returning an array of objects  result   is recursive in that it returns an std class object where as result array   just returns a pure array  so result array   would be choice regarding performance

User · Answer

Result has an optional  type parameter which decides what type of result is returned  By default   type    object    it returns an object  result object     It can be set to  array   then it will return an array of result  that being equivalent of caling result array    The third version accepts a custom class to use as a result object   The code from CodeIgniter         Query result  Acts as a wrapper function for the following functions       param string  type  object    array  or a custom class name    return array    public function result  type    object         if   type      array                 return  this- gt result array              elseif   type      object                 return  this- gt result object              else               return  this- gt custom result object  type             Arrays are technically faster  but they are not objects  It depends where do you want to use the result  Most of the time  arrays are sufficient

User · Answer

Returning pure array is slightly faster than returning an array of objects

User · Answer

result array   is faster  result   is easier

User · Answer

result   returns Object type data        result array   returns Associative Array type data

[php] codeigniter, result() vs. result_array()

Examples related to php

Examples related to codeigniter