Yii2 dropdown multiple selected

MultiSelect Widget for Yii2

It supports searching, remote data sets, and infinite scrolling of results.

https://github.com/kartik-v/yii2-widget-select2

Kartik Multiselect widget

in _form.php

use kartik\select2\Select2;



<?php
    echo Select2::widget([
        'model' => $model,
        'name' => 'certificates',
        'attribute' => 'certificates',
        'data' => ArrayHelper::map(Mulcertificates::find()->orderBy('description')->all(),'id','description'),  //['1'=>'1','2'=>2],
        'options' => [
            'placeholder' => 'Select certificates ...',
            'multiple' => true
    ],
    ]);
    ?>


Controller.php

public function actionCreate()
    {
        $model = new Mulselect();

        if ($model->load(Yii::$app->request->post())) {
         
            $model->certificates = implode(",",$model->certificates);
            
            $model->save();
            return $this->redirect(['view', 'id' => $model->id]);
         
        } else {
            return $this->render('create', [
                'model' => $model,
            ]);
        }
    }


 public function actionUpdate($id)
    {
        $model = $this->findModel($id);

        if ($model->load(Yii::$app->request->post()) && $model->save()) {
            return $this->redirect(['view', 'id' => $model->id]);
        } else {
            $model->certificates= explode(',', $model->certificates);
            return $this->render('update', [
                'model' => $model,
            ]);
        }
    }


Links

Select2 Widget 

2amigos/yii2-multi-select-widget

PHP - MySQL - Connection

MySQL Connection Using PHP Script

PHP provides mysql_connect() function to open a database connection.

Syntax

connection mysql_connect(server,user,passwd,new_link,client_flag);

Returns a MySQL link identifier on success or FALSE on failure.

Example

<?php
         $dbhost = 'localhost';
         $dbuser = 'test';
         $dbpass = 'Ii@21!abg';

         $conn = mysql_connect($dbhost, $dbuser, $dbpass);

         if(! $conn ) {
            die('Could not connect: ' . mysql_error());
         }
         echo 'Connected successfully<br>';

         $sql = 'SELECT id, name, course FROM std';

         mysql_select_db('ellorahs_test');
         $retval = mysql_query( $sql, $conn );
   
         if(! $retval ) {
              die('Could not get data: ' . mysql_error());
         }
   
         while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
            echo "ID :{$row['id']}  <br> ".
                 "Name : {$row['name']} <br> ".
                 "Course : {$row['course']} <br> ".
                 "--------------------------------<br>";
         } 

         echo "Fetched data successfully\n";

         mysql_close($conn);
?>

mysql_close()

Disconnect from the MySQL database anytime using another PHP function mysql_close().

SELECT command is used to fetch data from the MySQL database. 

Selecting a MySQL Database Using PHP



mysql_select_db to select a database. 

It returns TRUE on success or FALSE on failure.

Fetching Data Using a PHP

The SQL SELECT command is used to fetch data from the MySQL database.

SELECT command into a PHP function mysql_query().

mysql_fetch_array() can be used to fetch all the selected data. 

How to format pen drive in Ubuntu

Graphical Method

Open Disks program 

Then choose your device from left. 
Click more options button and click onformat as below:

Command-Line

How to format pen drive in ubuntu any version.

Open the Terminal (Ctrl + Alt + T)

fdisk -l

umount /dev/sdc*

mkfs.vfat /dev/sdc*

Thank You

How to completely uninstall android studio in ubuntu

Open Terminal

Ctrl + Alt + T

sudo su  //login to superuser

Run the following commands in the terminal:

rm -Rf /Applications/Android\ Studio.app  
rm -Rf ~/Library/Preferences/AndroidStudio*  
rm -Rf ~/Library/Preferences/com.google.android.*  
rm -Rf ~/Library/Preferences/com.android.*  
rm -Rf ~/Library/Application\ Support/AndroidStudio*  
rm -Rf ~/Library/Logs/AndroidStudio*  
rm -Rf ~/Library/Caches/AndroidStudio*  
rm -Rf ~/.AndroidStudio*  
rm -Rf ~/.gradle  
rm -Rf ~/.android  
rm -Rf ~/Library/Android*  
rm -Rf /usr/local/var/lib/android-sdk/  
rm -Rf ~/.AndroidStudio*  

To delete all projects:

rm -Rf ~/AndroidStudioProjects  

Uninstall Android Studio

Yii2 CheckBox

ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ

ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ

Yii2 - Display checkbox for boolean database field on active form

<?= $form->field($model, 'mon')->checkBox(['selected' => $model->mon])?>

Change Label

<?= $form->field($model, 'mon')->checkBox(['label'=> 'Monday',  'selected' => $model->mon])?>

Required Checkbox

Add this code your rules function on model class

           [['mon''], 'compare',
                'compareValue' => true,
                'operator' => '==',
                'message' => "Check to Continue",
                'when' => function ($data) {
                    return $data->mon== 1;
                }
            ],



Example

Model class

<?php

namespace backend\modules\test\models;

use Yii;

/**
 * This is the model class for table "studentsdetails".
 *
 * @property integer $id
 * @property string $name
 * @property string $address
 * @property integer $isverified
 */
class Studentsdetails extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'studentsdetails';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['name', 'isverified'], 'required'],
            [['isverified'], 'integer'],
            [['name'], 'string', 'max' => 300],
            [['address'], 'string', 'max' => 500],
         
            [['isverified'], 'compare',
                'compareValue' => true,
                'operator' => '==',
                'message' => "Check to Continue",
                'when' => function ($data) {
                    return $data->isverified== 1;
                }
            ],

         
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'name' => 'Name',
            'address' => 'Address',
            'isverified' => 'Isverified',
        ];
    }
}

View file

_form.php

<?php

use yii\helpers\Html;
use yii\widgets\ActiveForm;

/* @var $this yii\web\View */
/* @var $model backend\modules\test\models\Studentsdetails */
/* @var $form yii\widgets\ActiveForm */
?>

<div class="studentsdetails-form">

    <?php $form = ActiveForm::begin(); ?>

    <?= $form->field($model, 'name')->textInput(['maxlength' => true]) ?>

    <?= $form->field($model, 'address')->textInput(['maxlength' => true]) ?>

 
    <?= $form->field($model, 'isverified')->checkBox(['selected' => $model->isverified])?>
 
 
    <div class="form-group">
        <?= Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?>
    </div>

    <?php ActiveForm::end(); ?>

</div>

Related Links

MySql Boolean Data type field create

MySql Boolean Data type field create

MySql BOOLEAN or TINYINT

MySQL provides BOOLEAN or BOOL as the synonym of TINYINT(1).

Example 1
Create job table  with boolean data type.

After save job table structure.

Example 2

CREATE TABLE tasks (

    id INT PRIMARY KEY AUTO_INCREMENT,

    title VARCHAR(255) NOT NULL,

    completed BOOLEAN

)

Javascript Tutorials

Convert DD-MM-YYYY to YYYY-MM-DD format using Javascript

var date = "03-11-2014"; 

var newdate = date.split("-").reverse().join("-");

Javascript add number of days to today's date?

   var dd = 07-12-2017
   var x = 30; //days for add 

   var newdate = dd.split("-").reverse().join("-");   //date convert yyyy-mm-dd
   var someDate = new Date(newdate);
   someDate.setDate(someDate.getDate() + x); //number  of days to add, e.x. x days
   var dateFormated = someDate.toISOString().substr(0,10);     
          
   var vdate = dateFormated.split("-").reverse().join("-");   //date convert to dd-mm-yyyy