insert() public method Creates an INSERT SQL statement. For example, $sql = $queryBuilder->insert('user', [ 'name' => 'Sam', 'age' => 30, ], $params); The method will properly escape the table and column names. public string insert ( $table, $columns, &$params )$table string The table that new rows will be inserted into. $columns array The column data (name => value) to be inserted into the table. $params array The binding parameters that will be generated by

translate() public method Translates a message to the specified language. Note that unless $forceTranslation is true, if the target language is the same as the source language, the message will NOT be translated. If a translation is not found, a missingTranslation event will be triggered. public string|boolean translate ( $category, $message, $language )$category string The message category $message string The message to be translated $language string The target language return str

$columns public property Column metadata of this table. Each array element is a yii\db\ColumnSchema object, indexed by column names. public yii\db\ColumnSchema[] $columns = []

open() public method Establishes a DB connection. It does nothing if a DB connection has already been established. public void open ( )throws yii\db\Exception if connection fails

generateAuthState() protected method Generates the auth state value. protected string generateAuthState ( )return string Auth state value.

rules() public method Returns the validation rules for attributes. Validation rules are used by validate() to check if attribute values are valid. Child classes may override this method to declare different validation rules. Each rule is an array with the following structure: [ ['attribute1', 'attribute2'], 'validator type', 'on' => ['scenario1', 'scenario2'], //...other parameters... ] where attribute list: required, specifies the attributes array to be validated, for s

defaultNormalizeUserAttributeMap() protected method Returns the default $normalizeUserAttributeMap value. Particular client may override this method in order to provide specific default map. protected array defaultNormalizeUserAttributeMap ( )return array Normalize attribute map.

clientValidateAttribute() public method Returns the JavaScript needed for performing client-side validation. You may override this method to return the JavaScript validation code if the validator can support client-side validation. The following JavaScript variables are predefined and can be used in the validation code: attribute: an object describing the the attribute being validated. value: the value being validated. messages: an array used to hold the validation error messages for the

renameTable() public method Builds a SQL statement for renaming a DB table. public string renameTable ( $oldName, $newName )$oldName string The table to be renamed. The name will be properly quoted by the method. $newName string The new table name. The name will be properly quoted by the method. return string The SQL statement for renaming a DB table.

registerAssetFiles() public method Registers the CSS and JS files with the given view. public void registerAssetFiles ( $view )$view yii\web\View The view that the asset files are to be registered with.