Symfony2 working with database

Question

I'm working on my first project on Symfony2. I have some problems with basic actions. I've generated entity of my table:

CREATE TABLE IF NOT EXISTS `product_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Now I want to select all rows from this table. How should I do that? I tried to add new method in my entity.

public function getAll()
{
    $em = $this->getDoctrine()->getManager();
    $query = $em->createQuery(
        'SELECT *
        FROM product_category'
    );

    return $query->getResult();
}

... but I'm pretty sure that this is bad way cause I would have to use this method in context of concrete entity. Any tips?

1ed · Accepted Answer · 2014-01-06 00:43:53Z

1

Doctrine uses DQL not SQL and you don't need a custom query get all the records, you can use the default repository:

// e.g. in a controller
$repository = $this->getDoctrine()->getRepository('AcmeStoreBundle:Product');
$products = $repository->findAll();

This is an example right from the symfony docs. You should really read the docs first, these projects have greate docs.

answered Jan 6, 2014 at 0:43

1ed

3,66817 silver badges25 bronze badges

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

2 Comments

webrama.pl Over a year ago

Thanks, I just read that. But after doing that in $products I have a large set of variety of data.

webrama.pl Over a year ago

Looks like I don't have to convert result into array or something just pass it into the template as written here: stackoverflow.com/questions/19138915/…

Collectives™ on Stack Overflow

Symfony2 working with database

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related