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

07.

SELECCIONA la SUMA (o CUENTA)

|

|

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 $6.00

Previous Challenge

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

2 Comments

Sort By

Login or Register to join the conversation

Sebastien-D 1 year ago edited

Hi guys,
Does anybody knows how to write an addSelect() with COUNT(DISCINCT...) clause with a condition?
Something like:
->addSelect('COUNT(DISTINCT customer.id) IF (... some condition ...) as customers')
Thanks!

|

Victor SFCASTS Sebastien-D 1 year ago edited

Hey @Sebastien-D ,

Actually, addSelect('COUNT(DISTINCT customer.id)') should work. Did you try it? Do you have any issues with executing that query? Probably error message should hint the problem. About adding the IF right inside the addSelect() - not sure it will work, though I think you can easily move that condition out to the where(), no?

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

Previous Challenge

Next Challenge