public function delete() : int
    {
        $table = $this->definition->getName();
        $sql = 'DELETE FROM '.$table.' ';
        $par = [];
        if (count($this->where)) {
            $sql .= 'WHERE ';
            $tmp = [];
            foreach ($this->where as $v) {
                $tmp[] = $v[0];
                $par = array_merge($par, $v[1]);
            }
            $sql .= implode(' AND ', $tmp) . ' ';
        }
        if (count($this->order)) {
            $sql .= $this->order[0];
            $par = array_merge($par, $this->order[1]);
        }
        return $this->db->query($sql, $par)->affected();
    }
public function delete() : int
    {
        $table = $this->definition->getName();
        $sql = 'DELETE FROM '.$table.' ';
        $par = [];
        if (count($this->where)) {
            $sql .= 'WHERE ';
            $tmp = [];
            foreach ($this->where as $v) {
                $tmp[] = $v[0];
                $par = array_merge($par, $v[1]);
            }
            $sql .= implode(' AND ', $tmp) . ' ';
        }
        if (count($this->order)) {
            $sql .= $this->order[0];
            $par = array_merge($par, $this->order[1]);
        }
        return $this->db->query($sql, $par)->affected();
    }
public function delete ( ) : int { $ table = $ this -> definition -> getName ( ) ; $ sql = 'DELETE FROM ' . $ table . ' ' ; $ par = [ ] ; if ( count ( $ this -> where ) ) { $ sql .= 'WHERE ' ; $ tmp = [ ] ; foreach ( $ this -> where as $ v ) { $ tmp [ ] = $ v [ 0 ] ; $ par = array_merge ( $ par , $ v [ 1 ] ) ; } $ sql .= implode ( ' AND ' , $ tmp ) . ' ' ; } if ( count ( $ this -> order ) ) { $ sql .= $ this -> order [ 0 ] ; $ par = array_merge ( $ par , $ this -> order [ 1 ] ) ; } return $ this -> db -> query ( $ sql , $ par ) -> affected ( ) ; }
Delete the filtered rows from the DB
@return int the number of deleted rows
Delete the filtered rows from the DB