global $wo, $sqlConnect;
$query_one = " SELECT `user_id`, SUM( `views` ) FROM `Wo_Posts` WHERE `date_pub` >= DATE_SUB( CURRENT_DATE, INTERVAL 90
DAY ) AND `page_id` = 0
GROUP BY `user_id`
ORDER BY COUNT( `views` ) DESC
LIMIT 3";
if ($mysql_count > 7) {
$query_one = " SELECT `user_id`, SUM( `views` ) FROM `Wo_Posts` WHERE `date_pub` >= DATE_SUB( CURRENT_DATE, INTERVAL 90
DAY ) AND `page_id` = 0
GROUP BY `user_id`
ORDER BY COUNT( `views` ) DESC
LIMIT 3
";
$sql = mysqli_query($sqlConnect, $query_one);
while ($fetched_data = mysqli_fetch_assoc($sql)) {
$data[] = Wo_UserData($fetched_data['user_id']);
}
} else {
while ($fetched_data = mysqli_fetch_assoc($sql)) {
$data[] = Wo_UserData($fetched_data['user_id']);
}
}
while ($fetched_data = mysqli_fetch_assoc($sql)) {
$data[] = Wo_UserData($fetched_data['user_id']);
}
установлен yii2 -но там только листинг папок в браузере пока что.
http://site.loc/frontend/web
, если без web, то будет листинг директорий. Чтобы убрать web из строки запроса - настраивайте сервер или .htaccess.'value' => Html::tag('span',
$model->getStatusName(),
['class' => 'label label-' . ArrayHelper::getValue([0 => 'danger', 1 => 'success'], $model->status)])
],
'value' => function($model){
return Html::tag('span',
$model->getStatusName(),
['class' => 'label label-' . ArrayHelper::getValue([0 => 'danger', 1 => 'success'], $model->status)])
]
}