Code snippets

You will find here 6 code snippets I find useful so I don't have to Google ™ or Stackoverflow ™ them when I need. There are also code snippets I always forget! 😁 Sometimes, related links to the code will be available. The main difference with other random snippets you will find on the web is that in most cases (for the Symfony related ones) you will be able to run them directly from this website to check the output so you can verify it works as expected ™.

In this snippet we will see how to run raw SQL queries via the Doctrine DBAL connection instance. In...

Doctrine

Published on 2020-01-16 • Modified on 2020-01-16

 View the code


When having to process a large number of rows with Doctrine, it's not a good idea to use the standar...

Doctrine

Published on 2019-11-16 • Modified on 2019-11-27

 View the code


This is a small trick to avoid putting raw values in your Doctrine annotations. For example, it is u...

Doctrine

Published on 2019-11-07 • Modified on 2019-11-07

 View the code


[Edit 2020-02-19] Please read my blog post on this topic. This is was my preferred way to declare a...

Doctrine

Published on 2019-08-27 • Modified on 2020-02-17

 View the code


The trick here is that the like must be in the where clause andWhere() whereas the wildcard characte...

Doctrine

Published on 2019-01-08 • Modified on 2019-01-08

 View the code


This code is called from an action function of a Symfony 4.1 standard controller (extending Symfony\...

Doctrine

Published on 2018-09-11 • Modified on 2018-09-23

 View the code