Doctrine\DBAL\Query\QueryBuilder::values PHP Method

values() public method

Replaces any previous values, if any. $qb = $conn->createQueryBuilder() ->insert('users') ->values( array( 'name' => '?', 'password' => '?' ) );
public values ( array $values )
$values array The values to specify for the insert query indexed by column names.
    public function values(array $values)
    {
        return $this->add('values', $values);
    }

Usage Example

Esempio n. 1
0
 /**
  * Specifies values for an insert query indexed by column names.
  * Replaces any previous values, if any.
  *
  * <code>
  *     $qb = $conn->getQueryBuilder()
  *         ->insert('users')
  *         ->values(
  *             array(
  *                 'name' => '?',
  *                 'password' => '?'
  *             )
  *         );
  * </code>
  *
  * @param array $values The values to specify for the insert query indexed by column names.
  *
  * @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance.
  */
 public function values(array $values)
 {
     $quotedValues = [];
     foreach ($values as $key => $value) {
         $quotedValues[$this->helper->quoteColumnName($key)] = $value;
     }
     $this->queryBuilder->values($quotedValues);
     return $this;
 }
All Usage Examples Of Doctrine\DBAL\Query\QueryBuilder::values