My develop blog

Search This Blog

Linux - ls hidden files

on September 17, 2020

Get link
Facebook
X
Pinterest
Email
Other Apps

    
    ls -a

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

A FOREIGN KEY is a key used to link two tables together. Syntax $this->addForeignKey(name, table, column, referringTable, referringColumn, delete, update); // delete options: RESTRICT, CASCADE, NO ACTION, SET DEFAULT, SET NULL // update options: RESTRICT, CASCADE, NO ACTION, SET DEFAULT, SET NULL

Yii2 - andFilterWhere

filterWhere() - ignores search by empty values. When the search is executed by two fields, for example book and author, if the book value is empty then filterWhere() ignores the search by book and the search will be executed only by author filterWhere() $query->filterWhere([ 'author' => $author, 'book' => null, ]); // generated sql query // SELECT * FROM `library` WHERE (`author` = $author) andFilterWhere - Appends WHERE condition to the existing one. $query->where(['author' => $author]); $query->andFilterWhere(['book' => $book]); // generated sql query // SELECT * FROM `library` WHERE (`author` = $author) AND (`book` = $book)

Powered by Blogger

Linux - ls hidden files

Comments

Post a Comment