Raw mysql in Doctrine

To perform a raw mysql statement in symfony through Doctrine:

$sql = ‘SELECT c.CampaignId as campaignId,
               c.ProfileId as profileId,
               p.Name as name
          FROM Profile.ProfileCampaign c
    INNER JOIN Profile.Profile p
            ON p.ProfileId = c.ProfileId
         WHERE c.CampaignId IN (:campaignIdList)
           AND p.Deleted = 0
           AND p.Active = 1’;

$stmt = $this->getDoctrine()
    ->getManager()
    ->getConnection()
    ->prepare($sql);
$stmt->bindValue(‘campaignIdList’, implode(“,”, $campaignIdList));
$stmt->execute();

$sql = ‘SELECT c.CampaignId as campaignId,

c.ProfileId as profileId,

p.Name as name

FROM Profile.ProfileCampaign c

INNER JOIN Profile.Profile p

ON p.ProfileId = c.ProfileId

WHERE c.CampaignId IN (:campaignIdList)

AND p.Deleted = 0

AND p.Active = 1′;

$stmt = $this->getDoctrine()

->getManager()

->getConnection()

->prepare($sql);

$stmt->bindValue(‘campaignIdList’, implode(“,”, $campaignIdList));

$stmt->execute();

This example was being used in a controller.

Comments

Leave a Reply Cancel reply

More posts

Credly only shows First and Last on public badgepage

Piwigo nginx problems

Google Family Link won’t unlock your child’s device

Outlook keeps asking for password