Bolt\Storage\Query\SelectQuery::setParameters PHP Method

setParameters() public method

Sets the parameters that will filter / alter the query
public setParameters ( array $params )
$params array
    public function setParameters(array $params)
    {
        $this->params = array_filter($params);
        $this->processFilters();
    }

Usage Example

Esempio n. 1
0
 public function testQuery()
 {
     $app = $this->getApp();
     $filters = ['username' => '%fred%', 'email' => '%fred', 'status' => 'published'];
     $query = new SelectQuery($app['storage']->createQueryBuilder(), $app['query.parser.handler']);
     $query->setContentType('pages');
     $query->setParameters($filters);
     $expr = $query->getWhereExpression();
     $this->assertEquals('(pages.username LIKE :username_1) AND (pages.email LIKE :email_1) AND (pages.status = :status_1)', $expr->__toString());
     $this->assertEquals(['%fred%', '%fred', 'published'], array_values($query->getWhereParameters()));
 }