class MySingleMysqlConnection {
private static $instance;
private $connection;
private function __clone() {}
private function __construct() {
$this->connection = new MysqlConnection();
}
public static function getConnection(){
if (null === self::$instance){
self::$instance = new self();
}
return self::$instance->connection;
}MySingleMysqlConnection::getConnection()
if (isset($result) && $result){
$this->registerJs("$('#myModal').hide()");
}$item = Item::find()->select(['item.*'])
->joinWith(['user', 'order'])
->where(['user.status' => User::STATUS_ACTIVE,'item.status' => 'available', 'item.deleted' => 0])
->andWhere(['user.hide_items' => 0])
->groupBy('item.id');на удаленку без опыта же не берут
INT(11) UNSIGNEDINET_ATON - это функция mysql
$this->update('table_name', ['new_birth_of_date' => new Expression('FROM_UNIXTIME([[birth_of_date]])')]);/**
* @param array $input
* @param array $items
*
* @return int|null
*/
function compare(array $input, array $items)
{
foreach ($items as $index => $item) {
$compareResult = version_compare(implode('.', $input), implode('.', $item));
if ($compareResult <= 0) {
if ($compareResult === 0 || !array_key_exists($index - 1, $items)) {
return $index;
}
return $index - 1;
}
}
return null;
}
$items = [
[1, 1, 1],
[1, 2, 1],
[1, 2, 2],
[1, 5, 4],
[1, 5, 6],
[2, 1, 6],
[2, 2, 2],
];
$input = [1, 5, 5];
if (null === $index = compare($input, $items)) {
echo 'Элемент не найден';
} else {
echo "Элемент под номером {$index} является наиболее близким";
}'accessControl' => [
'class' => AccessControl::class,
'rules' => [
[
'allow' => true,
'roles' => ['@'],
'matchCallbak' => function($rule, $action){
return Yii::$app->user->identity->status !== User::STATUS_BLOCKED;
}
]
],
],