Chapters

16 Chapters | 1:26:33 |

01

Doctrine DQL

7:38
02

The QueryBuilder

2:02
03

andWhere() and orWhere()

7:06
04

JOINs

3:45
05

JOINs and addSelect Reduce Queries

5:22
06

EXTRA_LAZY Relationships

6:07
07

SELECT the SUM (or COUNT)

6:15
08

Selecting Specific Fields

5:09
09

SELECTing into a New DTO Object

3:40
10

Raw SQL Queries

6:52
11

Reusing Queries in the Query Builder

4:42
12

Criteria: Filter Relation Collections

9:09
13

Filters: Automatically Modify Queries

6:59
14

WHERE IN()

2:07
15

Using RAND() or Other Non-Supported Functions

3:11
16

Using GROUP BY to Fetch & Count in 1 Query

6:29

> Symfony > Go Pro with Doctrine Queries

Buy Access to Course

04.

JOINs

|

|

Autoplay

Previous Challenge

Next Challenge

Login or Register to check out the script

2 Comments

Sort By

Login or Register to join the conversation

Daniyal-J 2 years ago

But how can I create a one-to-many relationship in the first place?

1 |

Victor SFCASTS Daniyal-J 2 years ago

Hey Daniyal,

We don't focus too much on how to create relationships in this tutorial because this tutorial is about a different topic, specifically, how to work with Doctrine queries. So here we're mostly working on an existent DB structure. You can spy on how the relationship is created in the entity mapping, but if you want to learn more on how to create it - take a look at e.g.: https://symfonycasts.com/screencast/symfony3-doctrine-relations/many-to-one-relation - or try our advanced search to find more related content. For example, we talk a lot about Doctrine and its relationships in our latest Symfony Doctrine course: https://symfonycasts.com/screencast/symfony-doctrine

Cheers!

3 |

This tutorial is built on Symfony 6 but works great on Symfony 7 & 8!

Symfony 6 Doctrine 2

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": ">=8.2",
        "ext-ctype": "*",
        "ext-iconv": "*",
        "beberlei/doctrineextensions": "^1.3", // v1.3.0
        "doctrine/doctrine-bundle": "^2.7", // 2.9.1
        "doctrine/doctrine-migrations-bundle": "^3.2", // 3.2.2
        "doctrine/orm": "^2.13", // 2.15.1
        "symfony/asset": "6.2.*", // v6.2.7
        "symfony/console": "6.2.*", // v6.2.10
        "symfony/dotenv": "6.2.*", // v6.2.8
        "symfony/flex": "^2", // v2.2.5
        "symfony/framework-bundle": "6.2.*", // v6.2.10
        "symfony/proxy-manager-bridge": "6.2.*", // v6.2.7
        "symfony/runtime": "6.2.*", // v6.2.8
        "symfony/twig-bundle": "6.2.*", // v6.2.7
        "symfony/webpack-encore-bundle": "^1.16", // v1.16.1
        "symfony/yaml": "6.2.*" // v6.2.10
    },
    "require-dev": {
        "doctrine/doctrine-fixtures-bundle": "^3.4", // 3.4.4
        "symfony/maker-bundle": "^1.47", // v1.48.0
        "symfony/stopwatch": "6.2.*", // v6.2.7
        "symfony/web-profiler-bundle": "6.2.*", // v6.2.10
        "zenstruck/foundry": "^1.22" // v1.32.0
    }
}

Previous Challenge

Next Challenge