Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Получение данных
- $connection = Bitrix\Main\Application::getConnection();
- $sqlHelper = $connection->getSqlHelper();
- $name = "lists_list_elements_14";
- $user_id = "1";
- $sql = "SELECT * FROM b_user_option WHERE NAME = '".$name."' AND USER_ID = '".$user_id."' AND CATEGORY = 'main.ui.filter'";
- $recordset = $connection->query($sql);
- while ($record = $recordset->fetch())
- {
- }
- //Изменение данных
- $connection = Bitrix\Main\Application::getConnection();
- $sqlHelper = $connection->getSqlHelper();
- $sql = "UPDATE b_user_option SET VALUE='".$nowParam."' WHERE `ID`='".$record["ID"]."'";
- $connection->query($sql);
- //Добавление данных
- $connection = Bitrix\Main\Application::getConnection();
- $sqlHelper = $connection->getSqlHelper();
- $sql = "INSERT INTO `b_user_option` (`USER_ID`, `CATEGORY`, `NAME`, `VALUE`, `COMMON`) VALUES ('" . $user_id . "', 'main.ui.filter', '" . $name . "', '" . $nowParam . "', 'N');";
- $connection->query($sql);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement