Data Retrieval bindVlaue array \Doctrine\DBAL\Connection::PARAM_INT_ARRAY #5627

New Issue

admin · 2026-01-22T15:13:13+01:00

admin commented

2026-01-22 15:13:13 +01:00

Originally created by @lcp0578 on GitHub (Aug 4, 2017).

Originally assigned to: @Ocramius on GitHub.

$stmt = $this->getDoctrine()->getEntityManager()
 ->getConnection()
 ->prepare('SELECT t1.id , t1.name
    FROM user t1 
    WHERE  t1.id IN (:ids)');

$stmt->bindValue('ids', $idsArray, \Doctrine\DBAL\Connection::PARAM_INT_ARRAY);
$stmt->execute();

when i use prepare and bindVlaue, get an error?

$stmt = $this->getDoctrine()->getEntityManager()
->getConnection()
->executeQuery('SELECT t1.id , t1.name 
    FROM user t1 
    WHERE t1.id IN (:ids)',
    array('ids' => $idsArray),
    array('ids' => \Doctrine\DBAL\Connection::PARAM_INT_ARRAY)
);

it is work

Originally created by @lcp0578 on GitHub (Aug 4, 2017). Originally assigned to: @Ocramius on GitHub. ``` $stmt = $this->getDoctrine()->getEntityManager() ->getConnection() ->prepare('SELECT t1.id , t1.name FROM user t1 WHERE t1.id IN (:ids)'); $stmt->bindValue('ids', $idsArray, \Doctrine\DBAL\Connection::PARAM_INT_ARRAY); $stmt->execute(); ``` when i use prepare and bindVlaue, get an error? ``` $stmt = $this->getDoctrine()->getEntityManager() ->getConnection() ->executeQuery('SELECT t1.id , t1.name FROM user t1 WHERE t1.id IN (:ids)', array('ids' => $idsArray), array('ids' => \Doctrine\DBAL\Connection::PARAM_INT_ARRAY) ); ``` it is work

admin added the Invalid label 2026-01-22 15:13:13 +01:00

admin closed this issue

2026-01-22 15:13:14 +01:00

admin commented

2026-01-22 15:13:14 +01:00

@lcp0578 commented on GitHub (Aug 4, 2017):

error use

@lcp0578 commented on GitHub (Aug 4, 2017): error use

admin referenced this issue

2026-01-22 16:05:04 +01:00

[PR #5627] Update EntityManager::create() to allow extend #9672

Sign in to join this conversation.