FuelPHP Forums

codeyad

is there any way to get the metadata fields of the users (not only the logged in) from Auth?

Harro

Ormauth or Simpleauth?

In case of Ormauth:

// get the meta data for user 1:
if ($user = \Model\Auth_User::find(1, array('related' => 'metadata')))
{
$metatdata = \Arr::pluck($user->metadata, 'key', 'value');
}
else
{
// user not found
}

codeyad

Thanks a lot but i alrready did like this:

$users = \Model\Auth_User::query()->get();

foreach($users as $user){

echo $user->the_metadata_field;

}

Harro

Ok, I misunderstood you then.

I though you wanted all meta fields of a single user, not the same field from all users.

Since you need the metadata for each user, include it in the query. You are lazy loading the data, which means it will run a query to get the meta data for every user. With 1000 users, your code runs 1001 queries. Better use

$users = \Model\Auth_User::query()->related('metadata')->get();

which will run 1 query.

Harro

It's always handy to have the profiler active when you develop your application, you can easily see the effect a code change has on the performance, the database I/O, the memory usage, etc.

codeyad

thanks for the suggestion its a better way

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion