First issue after installing all of that was symfony-cli could not find Plesk’s PHP, this fixed it.
sudo ln -s /opt/plesk/php/8.0/bin/php /usr/local/bin/phpNext issue was “KnpMenuBundle” in 6.1 it needs to be used as a service, see here. Also if you want custom template the path needs to be set this way; if your template is in “templates/Menu/knp_menu.html.twig”
#config/packages/knp_menu.yaml
knp_menu:
# use 'twig: false' to disable the Twig extension and the TwigRenderer
twig:
template: Menu/knp_menu.html.twig
# if true, enables the helper for PHP templates
templating: false
# the renderer to use, list is also available by default
default_renderer: twig
Another issue was, how to use raw SQL in symfony 6, very simple thanks to auto-wiring.
https://symfonycasts.com/screencast/doctrine-queries/raw-sql-queries
Few samples of raw SQL for MySQL:
# get connection $conn = $managerRegistry->getConnection(); # sample 1 $sql = "SELECT * FROM somethingWHERE id = :user_id"; $resultSet = $conn->executeQuery($sql, ['user_id' => 123]); $results = $resultSet->fetchAllAssociative(); # sample 2 $sql = "SELECT * FROM something"; $result = $conn->fetchAllAssociative($sql);