You will find here 7 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 ™.
When you use a database container for MySQL, you start the service by calling docker-compose up -d db. But, if you run a Symfony c...
Published on 2021-02-06 • Modified on 2021-02-06
In the previous snippet, we saw how to do it for a Postgres service; now it's for MySQL. The process is similar, but there is a sl...
Published on 2020-09-03 • Modified on 2020-09-03
In this snippet, we will see how to randomize MySQL query results. On this website, I am using this functionality for the random ...
Published on 2020-01-27 • Modified on 2020-01-27
In this snippet we will see how to use a regexp to select data in a MySQL query. First in the where clause we declare the column t...
Published on 2020-01-18 • Modified on 2020-01-18
In this snippet we will see how to run raw SQL queries via the Doctrine DBAL connection instance. In the first example, we prepare...
Published on 2020-01-16 • Modified on 2020-01-16
This is the docker compose file I am using for MySQL 5.7. As this is an official image, there should't be any problem. Before I wa...
Published on 2019-09-26 • Modified on 2019-09-26