Yii2 Installation

D:\wamp\www\Yii2>php init

The OpenSSL PHP extension is required by Yii2.

D:\wamp\www\Yii2>php init

Yii Application Initialization Tool v1.0

Which environment do you want the application to be initialized in?

 [0] Development

 [1] Production

 Your choice [0-1, or "q" to quit] 0

 Initialize the application under 'Development' environment? [yes|no] YES

 Start initialization ...

  generate backend/config/main-local.php

  generate backend/config/params-local.php

  generate backend/web/index-test.php

  generate backend/web/index.php

  generate common/config/main-local.php

  generate common/config/params-local.php

  generate console/config/main-local.php

  generate console/config/params-local.php

  generate frontend/config/main-local.php

  generate frontend/config/params-local.php

  generate frontend/web/index-test.php

  generate frontend/web/index.php

  generate yii

  generate cookie validation key in backend/config/main-local.php

  generate cookie validation key in frontend/config/main-local.php

     chmod 0777 backend/runtime

     chmod 0777 backend/web/assets

     chmod 0777 frontend/runtime

     chmod 0777 frontend/web/assets

     chmod 0755 yii

     chmod 0755 tests/codeception/bin/yii

 ... initialization completed.

D:\wamp\www\Yii2>

YII Client side form validation error doesn't prevent form submit

YII Client side form validation error doesn't prevent form submit

To get this behavior you just need to add 'clientOptions' => array('validateOnSubmit'=>true), to your configuration so it would look like this:

?

1 2 3 4 5 6 7 8 9

$form=$this->beginWidget(     'CActiveForm',     array(         'id'=>'member-form',         'enableAjaxValidation'=>false,         'enableClientValidation'=>true,         'clientOptions' => array('validateOnSubmit'=>true),     ) );

Yii, how to add current date or time or timestamp in DB field automatically

To add current date or time or timestamp in DB field automatically

Using Rules in model use it like below :

<?php

/**
 * @return array validation rules for model attributes.
 */
public function rules()
{
    return array(
        array('title','length','max'=>255),
        array('title, created, modified', 'required'),
        array('modified','default',
              'value'=>new CDbExpression('NOW()'),
              'setOnEmpty'=>false,'on'=>'update'),
        array('created,modified','default',
              'value'=>new CDbExpression('NOW()'),
              'setOnEmpty'=>false,'on'=>'insert')
    );
}
?>

YII, Executing a SQL without calling a Model

<?
$connection=Yii::app()->db;
$sql = "SELECT id,username FROM users";
$command = $connection->createCommand($sql);            
$dataReader=$command->query();          
$rows=$dataReader->readAll();
print_r($rows);
?>