I deduce news from the news sections and from the subcategories of the news section on the home page of the site.

Made an extra block for output.

In the template code:

<?php foreach ($block_1 as $news_1):?> тут новости со стилями и т.д <?php endforeach?>

in the main controller application \ classes \ controller index.php

code for block:

 $this->template->categories = $data; $this->template->block_1 = ORM::factory('news')->where('status', '=', 1)->order_by('id', 'DESC')->and_where('block1', '=', 1)->limit(10)->find_all();

How to limit(10) display the value from the admin panel (show the value of the number of news on the main one)

In the "admin", in the settings made the field per_page_block1 , in the table settings .

I try to set a limit through the admin panel to display news on the main page.

    1 answer 1

    Get the value of per_page_block1 using an SQL query and substitute it in limit()

     $per_page_block1 = DB::select(...)->from('settings')->where(...)->execute()->get('...'); // условия запроса придумайте сами $this->template->block_1 = ORM::factory('news')->where('status', '=', 1)->order_by('id', 'DESC')->and_where('block1', '=', 1)->limit($per_page_block1)->find_all();