<?php while ($row = mysqli_fetch_assoc($result)): ?>
<div class='panel panel-default'>
<div class='panel-heading'><h4><?=$row['title']?></h4></div>
<div class='panel-body story'>
<?=$content[0]?>
<div class='clearfix'></div>
<hr>
<div class='row'>
<p class='col-xs-6 text-left'>
<a href='post.php?id=<?=$row['id']?>'>Прочитать</a>
</p>
<p class='col-xs-6 text-right'>
<span class='glyphicon glyphicon-comment'><?=$row['countcomments']?></span>
</p>
</div>
</div>
</div>
<?php endwhile; ?>// контроллер
public function actionArticle() {
$categories = Category::find->all();
$articles = Articles::find->all();
return $this->render('article', [
'categories' => $categories,
'articles' => $articles
]);
}
// вьюха article.php
<?php
foreach ($categories as $category) {
echo $category->name;
}
foreach ($articles as $article) {
echo $article->name;
echo $article->someone;
echo $article->id;
}$conn = array(
'driver' => 'mysql',
'host' => 'localhost',
'database' => 'DATABASE',
'username' => 'USERNAME',
'password' => 'SOME_PASSWORD',
'charset' => 'utf8',
'collation' => 'utf8_general_ci',
'prefix' => '',
);
Config::set('database.connections.DB_CONFIG_NAME', $conn);MODEL::on('DB_CONFIG_NAME')->find(1);
// чтобы не указывать постоянно on('DB_CONFIG_NAME')
// мы можем указать через какой конфиг подключаемся
// в самой моделе
class Page extends Eloquent
{
// через переменную $connection
protected $connection = 'DB_CONFIG_NAME';
// либо в конструкторе
function __construct()
{
$this->connection = 'DB_CONFIG_NAME';
}public function write($id, $data) {
echo $data; exit;
$sql = sprintf("REPLACE INTO %s VALUES('%s', '%s', '%s')",
...
}