require_once(getenv('DOCUMENT_ROOT').'/local/modules/add.blite/autoload.php'); $config = array( 'dbname' => 'blite', 'dbhost' => '127.0.0.1', 'dbuser' => 'blite', 'dbpass' => 'blite', ); $mysqli = new mysqli($config['dbhost'], $config['dbuser'], $config['dbpass'], $config['dbname']); $iblock_id_or_code = 'news'; $blite = new \Add\Blite($mysqli); $list = $blite ->iblock() ->select($iblock_id_or_code) ->fields(array('ID','NAME', 'DATE_CREATE')) ->property(array('PROP_CODE_1', 'PROP_CODE_2')) ->where( array( array('ID', '!=', 12345), array('ID', 'is not', null), array('ID', 'is', true), array('DATE_CREATE', '>=', '2018-01-01'), array('PROP_CODE_1', 'in', array(111,'sss','ddd')), array('PROP_CODE_1', 'like', 'ss%'), array('PROP_CODE_2', 'not in', array('aaa','bbb')), ) ) ->order(array('ID' => 'DESC')) ->limit(0,3) ->exec(); echo '<pre>'; var_export($list); echo '</pre>'; |
require_once(getenv('DOCUMENT_ROOT').'/bitrix/modules/main/include/prolog_before.php'); \Bitrix\Main\Loader::includeModule('add.blite'); $connection = \Bitrix\Main\Application::getConnection(); $mysqli = $connection->getResource(); $iblock_id_or_code = 'news'; $blite = new \Add\Blite($mysqli); $list = $blite ->iblock() ->select($iblock_id_or_code) ->fields(array('ID','NAME', 'DATE_CREATE')) ->property(array('PROP_CODE_1', 'PROP_CODE_2')) ->where( array( array('ID', '!=', 12345), array('ID', 'is not', null), array('ID', 'is', true), array('DATE_CREATE', '>=', '2018-01-01'), array('PROP_CODE_1', 'in', array(111,'sss','ddd')), array('PROP_CODE_1', 'like', 'ss%'), array('PROP_CODE_2', 'not in', array('aaa','bbb')), ) ) ->order(array('ID' => 'DESC')) ->limit(0,3) ->exec(); echo '<pre>'; var_export($list); echo '</pre>'; |
Установите этот модуль прямо сейчас!
Для этого укажите адрес сайта: