http://wiki.techtic.pro/ 2026-05-12T21:24:05+0200 http://wiki.techtic.pro/ http://wiki.techtic.pro/lib/exe/fetch.php?media=favicon.ico text/html 2022-10-23T17:08:49+0200 Anonymous (anonymous@undisclosed.example.com) http://wiki.techtic.pro/doku.php?id=prog:symfony:doctrine:databases&rev=1666537729&do=diff Symfony et les Databases Sources à jour * <https://symfony.com/doc/current/doctrine.html> Prérequis Il faut que l'ORM soit installé, sinon ->symfony composer req orm In PDOConnection.php : could not find driver Configurer un projet dans le fichier .env modifier la valeur DATABASE_URL .env.local text/html 2022-11-03T18:30:58+0200 Anonymous (anonymous@undisclosed.example.com) http://wiki.techtic.pro/doku.php?id=prog:symfony:doctrine:problemes&rev=1667496658&do=diff Problèmes et Erreurs Fonction qui n'existe pas Par exemple, en voulant utiliser la fonction SQL date_format on obtient une erreur : [Syntax Error] line 0, col 20: Error: Expected known function, got 'date_format' Pour y remedier il faut installer le package text/html 2022-10-23T17:08:18+0200 Anonymous (anonymous@undisclosed.example.com) http://wiki.techtic.pro/doku.php?id=prog:symfony:doctrine:querybuilder&rev=1666537698&do=diff Le QueryBuilder Sources & Ressources * <https://www.doctrine-project.org/projects/doctrine-orm/en/2.13/reference/query-builder.html#> text/html 2022-10-23T17:07:57+0200 Anonymous (anonymous@undisclosed.example.com) http://wiki.techtic.pro/doku.php?id=prog:symfony:doctrine:sql&rev=1666537677&do=diff du SQL Update $queryBuilder = $this->em->createQueryBuilder(); $query = $queryBuilder->update('models\User', 'u') ->set('u.username', ':userName') ->set('u.email', ':email') ->where('u.id = :editId') ->setParameter('userName', $userName) ->setParameter('email', $email) ->setParameter('editId', $editId) ->getQuery(); $result = $query->execute();