Chapters

16 Chapters | 1:26:33 |

01

Doctrina DQL

7:38
02

El QueryBuilder

2:02
03

yDónde() y oDónde()

7:06
04

JOINs

3:45
05

Consultas de reducción JOINs y addSelect

5:22
06

Relaciones EXTRA_LAZY

6:07
07

SELECCIONA la SUMA (o CUENTA)

6:15
08

Seleccionar campos específicos

5:09
09

Seleccionar en un nuevo objeto DTO

3:40
10

Consultas SQL sin procesar

6:52
11

Reutilizar consultas en el Generador de consultas

4:42
12

Criterios: Filtrar colecciones de relaciones

9:09
13

Filtros: Modificar consultas automáticamente

6:59
14

DONDE EN()

2:07
15

Utilizar RAND() u otras funciones no compatibles

3:11
16

Utilizar GROUP BY para buscar y contar en una sola consulta

6:29

> Symfony > Hazte profesional con las consultas de Doctrine

Buy Access to Course

01.

Doctrina DQL

|

|

Autoplay

Next Challenge

Login or register to check out the script

25 Comments

Sort By

Login or Register to join the conversation

Ryan-L 2 years ago edited

If you're on the Symfony 6 track and feel like you're missing a course between "Doctrine, Symfony 6 & the Database" and this one, you are. It's this one: https://symfonycasts.com/screencast/doctrine-relations

2 |

Victor SFCASTS Ryan-L 2 years ago

Hey Ryan-L,

Yeah, unfortunately that course is not re-written with the latest Symfony 6 yet so that's why it's missing in the Symfony 6 track. Thanks for this reference, might be useful indeed :)

Cheers!

|

Coding010 3 years ago

I believe Rufnex is referring to the project's folder and files icons. I was having the same question.
But I found it's the Atom Material Icons plugin, which can be installed via the Marketplace.

1 |

sadikoff Coding010 3 years ago

yeah, you found a correct package =)

1 |

Pieter-S 1 year ago

Hey there! forget about my stupid question earlier about the database. OF COURSE should i run a make:migration and then migrate

duh!

sorry sorry sorry - do not publish my post please ;)

|

Victor SFCASTS Pieter-S 1 year ago

Hey Pieter,

No problem! It's still might be useful for some users ;) But I'm happy to hear you were able to figure out the steps yourself. If you ever have any problems following our tutorials - feel free to leave a comment and our support team will help you :)

Cheers!

|

Pieter-S 1 year ago

Hi,

I dived right into this course, downloaded the code, downgraded to php 8.1, did the composer install and think i have everything rolling but then... the database! Where can I find an SQL dump with the tables/data from this course at start?

|

Victor SFCASTS Pieter-S 1 year ago

Hey Pieter,

When you download and unzip the course code, you will find the README file inside. Follow the instructions there to start the project locally :) Specifically for this course, we do recommend to use Docker for the DB:

docker compose up -d
symfony console doctrine:database:create --if-not-exists
symfony console doctrine:schema:update --force
symfony console doctrine:fixtures:load

Read the README for more details. But if you don't want to use Docker - you can run those commands directly in your CLI if you have MySQL installed, just make sure you update the DB credentials in your .env.local. :)

But if you still have any problems starting the project - let us know!

Cheers!

|

Alex-B 1 year ago

I downloaded the course code and follower the instructions in the README, but my site looks like this screenshot right now. What do I need to do to fix it?

Here is the link to my GitHub repository, if that's useful.

|

Victor SFCASTS Alex-B 1 year ago

Hey Alex,

Seems you have problems with assets. Did you have composer install command finished without any errors?

Also, could you try to run the next commands:

yarn install
yarn encore dev --watch

Do you see any errors in the output or did they finish OK? Please, reload your website again, does it help?

Also, do you use symfony serve command to spin your website or did you configure a real web server like Apache/Nginx? Could you try to run the website via symfony serve?

Also, you can open Chrome dev tools and in the Network tab watch for the errors regarding the assets, it may contain some hints.

Cheers!

|

Jared 2 years ago

I downloaded course files, but there are no migrations.

|

Jared Jared 2 years ago edited

@Victor @MolloKhan Guys, can you fix that?

|

MolloKhan SFCASTS Jared 2 years ago edited

Hey @Jared

Could you tell me what migrations are missing? I don't see any migrations being generated in this tutorial. You only need to create the database and then run bin/console doctrine:schema:update - check out the README file

Let me know if I'm missing something. Cheers!

1 |

Jared MolloKhan 2 years ago edited

Thank you so much, @MolloKhan ! I fixed it.
For now I encountered a new problem: my assets won't show up. I ran bin/console assets:install, and the build directory has appeared in public, but files like app.css, app.js return a 404 error.

|

MolloKhan SFCASTS Jared 2 years ago

Yea, this course uses Webpack instead of Asset Mapper. You need to run yarn install (or npm install) and then yarn encore dev

Cheers!

1 |

Jared MolloKhan 2 years ago edited

Doesn't work :( Still got messages in the chrome console:
GET http://localhost/build/app.css net::ERR_ABORTED 404 (Not Found)
I run the following commands: yarn install and yarn encore dev
A build directory has appeared, files are present in the public directory, but I'm still getting 404 errors.

|

Jared Jared 2 years ago edited

I got it. The issue was with the Docker containers: NGINX and PHP-FPM. NGINX uses fastcgi_pass to redirect PHP files to PHP-FPM, but the assets from the build directory are not present in the NGINX container.

Thank you @MolloKhan , problem is solved!

1 |

Jared Jared 2 years ago

Interesting that configs for nginx and php-fpm work like a charm for Symfony 7, but not for Symfony 6.2.
I mean assets, because I had no problems in version 7.

|

MolloKhan SFCASTS Jared 2 years ago

Ha! That's interesting. I suppose they improved Docker integration in Symfony 7

Cheers!

1 |

Thilo-H 2 years ago

Don't get the project started on Mac with Docker.
"composer install" and "docker compose up -d" finished without errors, but "symfony console doctrine:database:create --if-not-exists" throws:
[critical] Error thrown while running command "doctrine:database:create --if-not-exists". Message: "An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused"

|

Iqpal-M Thilo-H 1 year ago

I get the exact same error message was this resolved?

|

Victor SFCASTS Iqpal-M 1 year ago

Hey Iqpal,

I bet it was, it's a connection problem which means you most probably have invalid credentials configured. Have you followed my advice in the comment below? https://symfonycasts.com/screencast/doctrine-queries/dql#comment-31434

Cheers!

|

Victor SFCASTS Thilo-H 2 years ago

Hey Thilo,

First of all, make sure you install all the dependencies, i.e. Composer install should finish successfully. The error about the DB sounds like DB server is down. Probably try to restart the Docker completely, run the docker compose up again and make sure no errors. Let us know if you still have the same DB error

Cheers!

|

Rufnex 3 years ago

Hey, side question ;o) What phpstrom UI do you use? Greetings.

|

Victor SFCASTS Rufnex 3 years ago

Hey Rufnex,

Are you talking about PhpStorm theme? If so, we use Darcula in our videos :)

Cheers!

|

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
    }
}

Next Challenge