Breaking News: Grepper is joining You.com. Read the official announcement!

symfony do classic sql request with repository

EnzoK answered on August 25, 2022 Popularity 3/10 Helpfulness 4/10

answer symfony do classic sql request with repository

symfony do classic sql request with repository

Comment

// src/Repository/ProductRepository.php

// ...
class ProductRepository extends ServiceEntityRepository
{
    public function findAllGreaterThanPrice(int $price): array
    {
        $conn = $this->getEntityManager()->getConnection();

        $sql = '
            SELECT * FROM product p
            WHERE p.price > :price
            ORDER BY p.price ASC
            ';
        $stmt = $conn->prepare($sql);
        $resultSet = $stmt->executeQuery(['price' => $price]);

        // returns an array of arrays (i.e. a raw data set)
        return $resultSet->fetchAllAssociative();
    }
}

Popularity 3/10 Helpfulness 4/10 Language sql

Source: symfony.com

Tags: repository request sql symfony

Link to this answer
Share Copy Link

Contributed on Aug 25 2022

EnzoK

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

symfony do classic sql request with repository

Contents

More Related Answers

symfony do classic sql request with repository

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.