Doctrine\DBAL\Query\QueryBuilder::delete PHP Méthode

QueryBuilder Interface Documentation Usage Examples Of Doctrine\DBAL\Query\QueryBuilder::delete Afficher le fichier Open project: doctrine/dbal

delete() public méthode


    $qb = $conn->createQueryBuilder()
        ->delete('users', 'u')
        ->where('u.id = :user_id');
        ->setParameter(':user_id', 1);

public delete ( string $delete = null, string $alias = null )
$delete	string	The table whose rows are subject to the deletion.
$alias	string	The table alias used in the constructed query.

    public function delete($delete = null, $alias = null)
    {
        $this->type = self::DELETE;
        if (!$delete) {
            return $this;
        }
        return $this->add('from', array('table' => $delete, 'alias' => $alias));
    }

Usage Example

Exemple #1

Afficher le fichier

Fichier : NumberModel.php Projet : anthonypelletier/RPI-CallFilter-Web

 public function deleteNumber($id)
 {
     $queryBuilder = new QueryBuilder($this->db);
     $queryBuilder->delete('numbers')->where('id = :id')->andWhere('user_id = :id_user')->setParameter(':id', $id)->setParameter(':id_user', $this->id_user);
     return $queryBuilder->execute();
 }

All Usage Examples Of Doctrine\DBAL\Query\QueryBuilder::delete

QueryBuilder

__clone

__construct

__toString

add

addGroupBy

addOrderBy

addSelect

andHaving

andWhere

createNamedParameter