return array of objects by foreign key from database table

Question

I have a database it looks like this:

Entity: Post, Comment.. Comment has a foreign key post_id.

I need to get Comments that belongs to specific post by its ID. And sort it by getCreated() metod.

Problem is, when i try to find all comments by post_id like:

$comments = $this->get('doctrine')->getRepository('BlogCommonBundle:Comment')->findBypost_id($postID); 

usort($comments, function($a, $b){
       return ($a->getCreated() < $b->getCreated());
    });

Im gettig ..CommonBundle\Entity\Comment' has no field 'postId'. Probably because its foreign key.

Is there any way, how to do it?

Thanks a lot!

You could try findBy(array('IDENTITY(comment)' => $postID)), although I'm not sure if you can use the IDENTITY function within findBy...so you might need to create a query builder instead. — Matt Browne
– Matt Browne, Commented Dec 28, 2014 at 20:10
thanks but, it gives "Unrecognized field: IDENTITY(Comment)" :/ — Fappie.
– Fappie., Commented Dec 28, 2014 at 20:14

chapay · Accepted Answer · 2014-12-28 21:08:10Z

2

Seems you have an association like this:

/**
 * @ORM\ManyToOne(targetEntity="Post")
 */
protected $post;

So you should find your comments by post, not by post_id:

$comments = $this->get('doctrine')->getRepository('BlogCommonBundle:Comment')->findBy(['post' => $postID]);

And you can also sort it just by adding ['created' => 'DESC'] as a second parameter:

$comments = $this->get('doctrine')->getRepository('BlogCommonBundle:Comment')->findBy(['post' => $postID], ['created' => 'DESC']);

answered Dec 28, 2014 at 21:08

chapay

1,3151 gold badge13 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

return array of objects by foreign key from database table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related