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>';
|