Chapters

27 Chapters | 2:45:18 |

01

The Answer Entity

5:32
02

The ManyToOne Relation

8:35
03

Saving Relations

3:58
04

Relations in Foundry

4:41
05

Foundry: Always Pass a Factory Instance to a Relation

4:57
06

Fetching Relations

6:58
07

Rendering Answer Data & Saving Votes

6:02
08

Owning Vs Inverse Sides of a Relation

7:11
09

Relation OrderBy & fetch=EXTRA_LAZY

7:22
10

Filtering to Return only Approved Answers

9:40
11

Collection Criteria for Custom Relation Queries

6:33
12

Most Popular Answers Page

6:23
13

The |u Filter & String Component

4:11
14

Joining Across a Relationship & The N + 1 Problem

6:30
15

Search, the Request Object & OR Query Logic

8:05
16

The 4 (2?) Possible Relation Types

4:02
17

ManyToMany Relation

4:53
18

Saving Items in a ManyToMany Relation

6:36
19

Handling ManyToMany in Foundry

4:01
20

Joining Across a ManyToMany

5:22
21

ManyToMany... with Extra Fields on the Join Table?

6:57
22

When a Migration Falls Apart

6:23
23

QuestionTag Fixtures & DateTimeImmutable with Faker

4:07
24

Doing Crazy things with Foundry & Fixtures

8:59
25

JOINing Across Multiple Relationships

3:52
26

Pagination with Pagerfanta

6:20
27

Themed Pagination Links

7:07

This tutorial has a new version, check it out!

> Symfony 5 > Symfony 5: Mastering Doctrine Relations

Buy Access to Course

14.

Joining Across a Relationship & The N + 1 Problem

|

Autoplay

Keep on Learning!

If you liked what you've learned so far, dive in! Subscribe to get
access to this tutorial plus video, code and script downloads.

Start your All-Access Pass

Buy just this tutorial for $12.00

Previous Chapter

Next Challenge

With a Subscription, click any sentence in the script to jump to that part of the video!

Login Subscribe

Login or register to check out the script

4 Comments

Sort By

Login or Register to join the conversation

MattHB 4 years ago

just a note for 5:52.. I had to bin/console cache:cl to get it to regen the query properly.

|

MolloKhan SFCASTS MattHB 4 years ago edited

Hey MattHB

That's odd, you should not need to clear the cache manually. Are you on prod enviroment?

|

MattHB MolloKhan 4 years ago

Nope. Dev confirmed. I thought it was odd as well.

I can remember on older symfony that even in Dev env sometimes config yamls would get cached occasionally.

Maybe we still have that edge case knocking around.

|

MolloKhan SFCASTS MattHB 4 years ago

Interesting... I wonder what caused that issue. If I recall correctly, there's still that problem when you add a translation file for the first time

|

Symfony 5.3 Doctrine 2

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": ">=8.2",
        "ext-ctype": "*",
        "ext-iconv": "*",
        "babdev/pagerfanta-bundle": "^3.3", // v3.3.0
        "composer/package-versions-deprecated": "^1.11", // 1.11.99.3
        "doctrine/doctrine-bundle": "^2.1", // 2.4.2
        "doctrine/doctrine-migrations-bundle": "^3.0", // 3.1.1
        "doctrine/orm": "^2.7", // 2.9.5
        "knplabs/knp-markdown-bundle": "^1.8", // 1.9.0
        "knplabs/knp-time-bundle": "^1.11", // v1.16.1
        "pagerfanta/doctrine-orm-adapter": "^3.3", // v3.3.0
        "pagerfanta/twig": "^3.3", // v3.3.0
        "sensio/framework-extra-bundle": "^6.0", // v6.2.1
        "stof/doctrine-extensions-bundle": "^1.4", // v1.6.0
        "symfony/asset": "5.3.*", // v5.3.4
        "symfony/console": "5.3.*", // v5.3.7
        "symfony/dotenv": "5.3.*", // v5.3.7
        "symfony/flex": "^1.3.1", // v1.21.6
        "symfony/framework-bundle": "5.3.*", // v5.3.7
        "symfony/monolog-bundle": "^3.0", // v3.7.0
        "symfony/runtime": "5.3.*", // v5.3.4
        "symfony/stopwatch": "5.3.*", // v5.3.4
        "symfony/twig-bundle": "5.3.*", // v5.3.4
        "symfony/validator": "5.3.*", // v5.3.14
        "symfony/webpack-encore-bundle": "^1.7", // v1.12.0
        "symfony/yaml": "5.3.*", // v5.3.6
        "twig/extra-bundle": "^2.12|^3.0", // v3.3.1
        "twig/string-extra": "^3.3", // v3.3.1
        "twig/twig": "^2.12|^3.0" // v3.3.2
    },
    "require-dev": {
        "doctrine/doctrine-fixtures-bundle": "^3.3", // 3.4.0
        "symfony/debug-bundle": "5.3.*", // v5.3.4
        "symfony/maker-bundle": "^1.15", // v1.33.0
        "symfony/var-dumper": "5.3.*", // v5.3.7
        "symfony/web-profiler-bundle": "5.3.*", // v5.3.5
        "zenstruck/foundry": "^1.1" // v1.13.1
    }
}

Previous Chapter

Next Challenge