Database & Doctrine

Symfony integrates Doctrine, the most powerful PHP ORM. Each database table maps to an entity: a plain PHP class where attributes describe the columns.

You don't even write these classes by hand: the interactive make:entity command generates and updates them, and the migration commands create the SQL to evolve your database schema safely.

To query the database, autowire the entity's repository. The built-in methods cover the common cases, and you add your own methods for complex queries.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23<?phpnamespace App\Entity;use App\Repository\ArticleRepository;use Doctrine\ORM\Mapping as ORM;#[ORM\Entity(repositoryClass: ArticleRepository::class)]class Article{    #[ORM\Id]    #[ORM\GeneratedValue]    #[ORM\Column]    private ?int $id = null;    #[ORM\Column(length: 255)]    private ?string $title = null;    #[ORM\Column(type: 'text')]    private ?string $content = null;    // ... getters and setters}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21<?phpnamespace App\Controller;use App\Repository\ArticleRepository;use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;use Symfony\Component\HttpFoundation\Response;use Symfony\Component\Routing\Attribute\Route;class ArticleController extends AbstractController{    #[Route('/articles')]    public function list(ArticleRepository $articles): Response    {        $latest = $articles->findBy([], ['title' => 'ASC'], limit: 10);        return $this->render('article/list.html.twig', [            'articles' => $latest,        ]);    }}

$ php bin/console make:entity Article$ php bin/console make:migration$ php bin/console doctrine:migrations:migrate