Database Migrate in Yii

-> After Database Connctive

CMD in

D:\wamp\www\Yii2\>yii migrate

Yii Migration Tool (based on Yii v2.0.6)

Creating migration history table "migration"...Done.

Total 1 new migration to be applied:

       m130524_201442_init

Apply the above migration? (yes|no) [no]:yes

*** applying m130524_201442_init

   > create table {{%user}} ... done (time: 1.185s)

*** applied m130524_201442_init (time: 1.335s)

Migrated up successfully.

D:\wamp\www\Yii2\>

Theme Installing

#   frontend->assets->AppAsset.php

Put here css & js links

like as

public $css = [

       //'css/site.css',

       'assets/css/bootstrap.css',

       'assets/css/font-awesome.css',

       'assets/js/morris/morris-0.4.3.min.css',

       'assets/css/custom-styles.css',

            'http://fonts.googleapis.com/css?family=Open+Sans',

   ];

   public $js = [

       'assets/js/jquery-1.10.2.js',

       'assets/js/bootstrap.min.js',

       'assets/js/jquery.metisMenu.js',

       'assets/js/morris/raphael-2.1.0.min.js',

       'assets/js/morris/morris.js',

       'assets/js/custom-scripts.js',

   ];

put links files on web folder

# set views in layout  main & index  

Yii2 dropdown multiple selected values

Form

 <?= 
  $form->field($model, 'categories')            
         ->dropDownList($model->CategoryDropdown,
         [
          'class'=>'chosen-select input-md required',
          'multiple'=>'multiple'              
         ]             
        )->label("Add Categories");
 ?>

Controller:

 public function actionCreate(){
 ...
     $model->categories = implode(",",$_POST['Company']['categories']);
    ...
    return $this->render('create', [
            'model' => $model,           
        ]);
 }

public function actionUpdate($id)
{
    $model = $this->findModel($id); 
    $model->categories = explode(',', $model->categories);        
    ...
    if($model->load(Yii::$app->request->post()))
    {
         $model->categories = implode(",",$_POST['Company']['categories']);    
         ...
         $model->save()
    }
    return $this->render('update', [
                'model' => $model,                    
            ]); 
  }

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);
?>