Need help in Paris php quering

Question

Example: I have following two classes for tables in database.

            class Post extends Model {}
            class User extends Model {
               public function posts() {
                   return $this->has_many('Post'); // Note we use the model name literally - not a    pluralised version
               }
            }

Now I want to quert all users and their associated posts in one variable. something like that:

            $user = Model::factory('User')->find_many();
            // Find the posts associated with the user
            $posts = $user->posts()->find_many();

I want to get the result in $posts variable.

What kind of error? Please edit your question with the full content of your error. Thanks. — Davide Pastore, Mar 09 '15 at 08:02

Hikmat · Accepted Answer · 2015-03-10T09:12:14.377

3

I have solved this issue my self

            $user = Model::factory('User')->find_many();
            // Find the posts associated with the user
            //$posts = $user->posts()->find_many();

I looped through $user and passed each user id to $user->posts()->find_one();

sudo code is here:

            foreach($user as $usr)
            {
               $posts = $user->posts()->find_one($usr->Id);
            }

edited Mar 10 '15 at 09:12

answered Mar 10 '15 at 07:15

Hikmat

450
4
19

You must add your solution! Maybe there are other programmers who may have the same problem and needs your solution – Mihai Matei Mar 10 '15 at 07:19

Need help in Paris php quering

1 Answers1