本文整理汇总了PHP中Doctrine\DBAL\Query\QueryBuilder::update方法的典型用法代码示例。如果您正苦于以下问题：PHP QueryBuilder::update方法的具体用法？PHP QueryBuilder::update怎么用？PHP QueryBuilder::update使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Doctrine\DBAL\Query\QueryBuilder的用法示例。
在下文中一共展示了QueryBuilder::update方法的8个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: testEmptyUpdate
public function testEmptyUpdate()
{
$qb = new QueryBuilder($this->conn);
$qb2 = $qb->update();
$this->assertEquals(QueryBuilder::UPDATE, $qb->getType());
$this->assertSame($qb2, $qb);
}示例2: updateQuotesIdentifierAndDelegatesToConcreteQueryBuilder
/**
* @test
* @todo: Test with alias
*/
public function updateQuotesIdentifierAndDelegatesToConcreteQueryBuilder()
{
$this->connection->quoteIdentifier('aTable')->shouldBeCalled()->willReturnArgument(0);
$this->concreteQueryBuilder->update(Argument::exact('aTable'), Argument::cetera())->shouldBeCalled()->willReturn($this->subject);
$this->subject->update('aTable');
}示例3: update
/**
* Turns the query being built into a bulk update query that ranges over
* a certain table
*
* <code>
* $qb = $conn->getQueryBuilder()
* ->update('users', 'u')
* ->set('u.password', md5('password'))
* ->where('u.id = ?');
* </code>
*
* @param string $update The table whose rows are subject to the update.
* @param string $alias The table alias used in the constructed query.
*
* @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance.
*/
public function update($update = null, $alias = null)
{
$this->queryBuilder->update($this->getTableName($update), $alias);
return $this;
}示例4: expedierCommande
public function expedierCommande($id)
{
$queryBuilder = new QueryBuilder($this->db);
$queryBuilder->update('commandes', 'c')->set('c.id_etat', ':etat')->set('c.date_expedition', ':date_expedition')->where('c.id = :id')->setParameter(':etat', 1)->setParameter(':date_expedition', date('Y-m-d'))->setParameter(':id', $id);
return $queryBuilder->execute();
}示例5: update
/**
* Turns the query being built into a bulk update query that ranges over
* a certain table
*
* @param string $update The table whose rows are subject to the update.
* @param string $alias The table alias used in the constructed query.
*
* @return self
*/
public function update($update = null, $alias = null)
{
$this->qb->update($update, $alias);
return $this;
}示例6: update
/**
* Turns the query being built into a bulk update query that ranges over
* a certain table
*
* <code>
* $qb = $conn->getQueryBuilder()
* ->update('users', 'u')
* ->set('u.password', md5('password'))
* ->where('u.id = ?');
* </code>
*
* @param string $update The table whose rows are subject to the update.
* @param string $alias The table alias used in the constructed query.
*
* @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance.
*/
public function update($update = null, $alias = null)
{
$this->queryBuilder->update($this->helper->quoteColumnName($update), $alias);
return $this;
}示例7: removeToken
public function removeToken($id)
{
$queryBuilder = new QueryBuilder($this->db);
$queryBuilder->update('users', 'u')->set('u.token', ':token')->where('u.id = :id')->setParameter(':token', NULL)->setParameter(':id', $id);
$queryBuilder->execute();
}示例8: editNumber
public function editNumber($id, $data)
{
$queryBuilder = new QueryBuilder($this->db);
$queryBuilder->update('numbers', 'n')->set('n.number', ':number')->where('n.id = :id')->andWhere('n.user_id = :id_user')->setParameter(':number', $data['number'])->setParameter(':id', $id)->setParameter(':id_user', $this->id_user);
return $queryBuilder->execute();
}