Chapters

22 Chapters | 2:28:56 |

01

Installing Doctrine

6:15
02

docker-compose & Exposed Ports

6:53
03

Docker & Environment Variables

3:43
04

The "symfony console" Command & server_version

3:55
05

Entity Class

8:59
06

Migrations

4:14
07

Adding new Properties

5:19
08

Persisting to the Database

6:43
09

Querying the Database

7:25
10

Custom Entity Methods & Twig Magic

7:46
11

The Query Builder

10:04
12

Querying for a Single Entity for a "Show" Page

8:55
13

Param Converter & 404's

5:44
14

The Request Object

9:07
15

Updating an Entity

5:24
16

Flash Message & Rich vs Anemic Models

6:32
17

Doctrine Extensions: Timestampable

7:19
18

Clean URLs with Sluggable

6:48
19

Simple Doctrine Data Fixtures

3:25
20

Foundry: Fixtures You'll Love

7:20
21

Pagination

9:19
22

Forever Scroll with Turbo Frames

7:47

> Symfony 6 > Doctrine, Symfony 6 & the Database

Buy Access to Course

18.

Clean URLs with Sluggable

|

|

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 Chapter

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

14 Comments

Sort By

Login or Register to join the conversation

sujal_k 2 years ago edited

Slug behavior didn't work when I experimented in PHP 7, below is my code:

#[Route('/browse/{slug}', name: 'app_product_show')]
public function show(Product $product): Response
{
    return $this->render('product/show.html.twig', [
        'product' => $product
    ]);
}

The config is:

`stof_doctrine_extensions:

default_locale: en_US
orm:
    default:
        timestampable: true
        sluggable: true`

Services.yaml config is:

`parameters:

services:

_defaults:
    autowire: true      # Automatically injects dependencies in your services.
    autoconfigure: true # Automatically registers your services as commands, event subscribers, etc.

App\:
    resource: '../src/'
    exclude:
        - '../src/DependencyInjection/'
        - '../src/Entity/'
        - '../src/Kernel.php'

`

Error:
Controller "App\Controller\ProductController::show" requires the "$product" argument that could not be resolved. Cannot autowire argument $product of "App\Controller\ProductController::show()": it needs an instance of "App\Entity\Product" but this type has been excluded in "config/services.yaml".

1 |

MolloKhan SFCASTS sujal_k 2 years ago

Hey @sujal_k, the slug field of your entity needs to be unique in order to work with the param converter

Cheers!

|

sujal_k MolloKhan 2 years ago

It's actually this that I found and because I was working in latest version of Symfony, so: https://symfony.com/blog/new-in-symfony-7-1-mapped-route-parameters

1 |

Jared sujal_k 2 years ago edited HIGHLIGHTED

I found the same problem!
You can fix this like that, just add the following lines to the config/packages/doctrine.yaml:

doctrine:
    orm:
        controller_resolver:
            auto_mapping: true

In the latest versions of Symfony, that property will be false by default.

7 |

sergiofgdev Jared 1 year ago

Thanks! That worked for me.

1 |

EssKy Jared 1 year ago

Worked for me. Thanks Jared

Symfony v7.1.5
Symfony CLI v5.10.2
PHP v8.3.12

1 |

MolloKhan SFCASTS Jared 2 years ago edited

Hey @Jared

In the docs it says that config is enabled by default. https://symfony.com/doc/current/doctrine.html#automatically-fetching-objects-entityvalueresolver

Cheers!

|

Jared MolloKhan 2 years ago

Yeah, but in this case you will get a doctrine deprecation message. Moreover, without these lines you will get an error as it said above.

|

MolloKhan SFCASTS Jared 2 years ago

Didn't know about the deprecation message.
Are you sure about the error? What I understand from the docs is that that behavior is enabled by default doctrine.orm.controller_resolver.auto_mapping: true

|

Rob-T MolloKhan 2 years ago

auto_mapping was disabled by default in my 7.1 install as well :-/

2 |

MolloKhan SFCASTS Rob-T 2 years ago

That's interesting. It seems like the documentation is wrong

1 |

Jared MolloKhan 2 years ago

Yeah, I am sure. After adding these lines, the deprecation message and the error are gone.

1 |

Benoit-L 3 years ago edited

I have removed the db, recreated it but now I got the following error when

An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1048 Le champ 'slug' ne peut être vide (null)

Here is the content of the VinylMix for the slug file:

    #[ORM\Column(length: 100,unique:true)]
    #[Slug(fields:['title'])]
    private ?string $slug = null;

Ok. I found the problem, the library was not automatically uploaded

use Gedmo\Mapping\Annotation\Slug;

|

Victor SFCASTS Benoit-L 3 years ago

Hey Benoit-L,

It seems like the Sluggable behavior does not work for that field. It might be for many reasons. First of all, check that you have used the correct namespace above the entity class, there should be use Gedmo\Mapping\Annotation\Slug; line in the use statements. Also, make sure you enabled the sluggable extension, see this code block: https://symfonycasts.com/screencast/symfony-doctrine/sluggable#codeblock-35894f3389 . And finally, make sure you clear the cache just in case, it might be a simple cache issue :)

Cheers!

1 |

Symfony 6 Doctrine 2

What PHP libraries does this tutorial use?

// composer.json
{
    "require": {
        "php": ">=8.2",
        "ext-ctype": "*",
        "ext-iconv": "*",
        "babdev/pagerfanta-bundle": "^3.7", // v3.7.0
        "doctrine/doctrine-bundle": "^2.7", // 2.7.0
        "doctrine/doctrine-migrations-bundle": "^3.2", // 3.2.2
        "doctrine/orm": "^2.12", // 2.12.3
        "knplabs/knp-time-bundle": "^1.18", // v1.19.0
        "pagerfanta/doctrine-orm-adapter": "^3.6", // v3.6.1
        "pagerfanta/twig": "^3.6", // v3.6.1
        "sensio/framework-extra-bundle": "^6.2", // v6.2.6
        "stof/doctrine-extensions-bundle": "^1.7", // v1.7.0
        "symfony/asset": "6.1.*", // v6.1.0
        "symfony/console": "6.1.*", // v6.1.2
        "symfony/dotenv": "6.1.*", // v6.1.0
        "symfony/flex": "^2", // v2.4.5
        "symfony/framework-bundle": "6.1.*", // v6.1.2
        "symfony/http-client": "6.1.*", // v6.1.2
        "symfony/monolog-bundle": "^3.0", // v3.8.0
        "symfony/proxy-manager-bridge": "6.1.*", // v6.1.0
        "symfony/runtime": "6.4.3", // v6.4.3
        "symfony/twig-bundle": "6.1.*", // v6.1.1
        "symfony/ux-turbo": "^2.0", // v2.3.0
        "symfony/webpack-encore-bundle": "^1.13", // v1.15.1
        "symfony/yaml": "6.1.*", // v6.1.2
        "twig/extra-bundle": "^2.12|^3.0", // v3.4.0
        "twig/twig": "^2.12|^3.0" // v3.4.1
    },
    "require-dev": {
        "doctrine/doctrine-fixtures-bundle": "^3.4", // 3.4.2
        "symfony/debug-bundle": "6.1.*", // v6.1.0
        "symfony/maker-bundle": "^1.41", // v1.44.0
        "symfony/stopwatch": "6.1.*", // v6.1.0
        "symfony/web-profiler-bundle": "6.1.*", // v6.1.2
        "zenstruck/foundry": "^1.21" // v1.21.0
    }
}

Previous Chapter

Next Chapter