drqrdkfue521903877 2014-01-25 19:32
浏览 137

Doctrine2 - 动态添加“andWhere”并设置参数

Please, is there any way how to dynamically add "andWhere" with setting parameter? I want to build query which select rows from database by parameters but I don´t know number of parameters, so I need to do it dynamically. I tried to wrote a code bellow but it returns no result.

    $parametersRepository = $this
        ->getEntityManager()
        ->getRepository('AcmeEntityBundle:Parameter');      
    $qb = $this->createQueryBuilder('p');

    $q = 
    $qb
    ->orderBy('p.id', 'ASC');
    $p = 0;
    $par = array();
    foreach ($associations as $parameter => $value){
        if($value != NULL){ 
        $par[$p] = $parametersRepository->find($value);
            $qb->andWhere(':parameter'.$p.' MEMBER OF p.parameters')
            ->setParameter('parameter'.$p, $par[$p]);
        $p++;
        }
    }
    $qb->getResult();
    return $q;
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致
    • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
    • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
    • ¥15 谁有desed数据集呀
    • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100
    • ¥15 关于#hadoop#的问题
    • ¥15 (标签-Python|关键词-socket)
    • ¥15 keil里为什么main.c定义的函数在it.c调用不了
    • ¥50 切换TabTip键盘的输入法