Load Categorywith id in bootstrap.php Shopware 5

Question

in my bootstrap.php I try to load a category with a special id. Its not quite working.

    public function getCatFromDb($idCat){
    /** @var \Doctrine\DBAL\Connection $connection */
    $connection = $connection->get('dbal_connection');
    $sql = 'SELECT * FROM s_categories WHERE id=$idCat';
    $result = $connection->query($sql)->fetch();
    var_dump($result);

    return $result;
}

Can someone spot the mistake? Thanks in advance!

Figured out the mistake. Put $connection = $container->get('dbal_connection'); and $sql = 'SELECT * FROM s_categories WHERE id="$idCat"'; — Langer.197, Jun 28 '17 at 09:02

score 3 · Accepted Answer · answered Jun 29 '17 at 07:18

You should use the ModelManager to retrieve the Category.

/** @var ModelManager $modelManager */
$modelManager = Shopware()->Container()->get('models');
// you could use this, too
// $modelManager = $this->container->get('models');
/** @var Category $category */
$category = $modelManager->getRepository(Category::class)->find($id);

score 2 · Answer 2 · answered Jun 28 '17 at 09:04

2

$connection = $container->get('dbal_connection');
$sql = 'SELECT * FROM s_categories WHERE id="$idCat"';

Container instead the second connection, and $idCat in quotation marks.

answered Jun 28 '17 at 09:04

Langer.197

78
8

score 2 · Answer 3 · answered Jun 28 '17 at 10:58

public function getCatFromDb($idCat){
    /** @var \Doctrine\DBAL\Connection $connection */
    //$connection = Shopware()->Container()->get('dbal_connection');
    $connection = $connection->get('dbal_connection');
    $result = $connection->executeQuery(
        "SELECT * FROM s_categories WHERE id=?", [$idCat]
    )->fetchAll();
    var_dump($result);

    return $result;
}

Load Categorywith id in bootstrap.php Shopware 5

3 Answers3