Order website or plugin development for WordPress, website development on the Laravel, Symfony, or Yii2 framework…
It would seem a simple and trivial task. But I had to dig a little into the code and docs.
And so, to get a "clean" SQL query that will subsequently be transferred to the DB for execution, it is enough to use the following code:
echo $Query -> select('*')
-> from('{{%authitem}}') -> createCommand() -> getRawSql();
To connect to multiple databases in the Yii2 framework, you need to do the following:
1. Create two database configuration files in your site’s config. I keep the connections in separate files, and they look like this (example).
Connection to the first database:
return [ 'class' => 'yiidbConnection', 'dsn' => 'mysql:host=127.0.0.1;dbname=work_db1', 'username' => 'root', 'password' => '', 'charset' => 'utf8', 'tablePrefix' => 'tbl_', ];
Connection to the second database:
return [ 'class' => 'yiidbConnection', 'dsn' => 'mysql:host=127.0.0.1;dbname=work_db2', 'username' => 'root', 'password' => '', 'charset' => 'utf8', 'tablePrefix' => 'tbl_', ];
2. In the main config file, register both connections:
'db' => require(__DIR__ . '/db.php'), 'db2' => require(__DIR__ . '/db2.php'),
To do this, we need the following:
/* ... */ use Yii; use yiirbacItem; /* ... */ $auth = Yii::$app -> authManager; $Item = new Item(); $Item -> type = 3; $Item -> name = 'ItemNewName' $Item -> description = 'ItemNewDescription'; $auth -> add($Item);
The first thing we need to do is include "Pjax" itself:
use yiiwidgetsPjax;
Next, wrap the desired content in the Pjax widget. For example:
<?php Pjax::begin([ 'id' => 'pjaxContent' ]); ?> Content here <?php Pjax::end(); ?>
There’s a saying:
live and learn — and still die a fool
Why am I saying this? It’s about traits in PHP. They’ve been around for quite a while, but I only recently started using them in a new project.
The first thing I had to do was move the attributeLabels method into a trait. Yes, I could have created a single base class and extended it. But I decided to go with traits instead. So, here’s what we have:
namespace commontraitsobject;
use Yii;
trait ObjectModelTrait
{
/**
* Labels
* @return array
*/
public function attributeLabels()
{
return [
'id' => Yii::t('app', 'ID'),
'name' => Yii::t('app', 'Name'),
'desc' => Yii::t('app', 'Description'),
'index_id' => Yii::t('app', 'Index'),
'is_active' => Yii::t('app', 'Is active'),
];
}
}This trait was reused multiple times in models. Here’s one example:
namespace commonmodelsterritory;
use yiidbActiveRecord;
use commontraitsobjectObjectModelTrait;
class TerritoryAreaModel extends ActiveRecord
{
use ObjectModelTrait;
public static function tableName()
{
return '{{%territory_area}}';
}
}