Advertisement
Trigub_Ilia

Работа с БД в Битрикс

Nov 23rd, 2021 (edited)
699
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.98 KB | None | 0 0
  1. //Получение данных
  2. $connection = Bitrix\Main\Application::getConnection();
  3. $sqlHelper = $connection->getSqlHelper();
  4. $name = "lists_list_elements_14";
  5. $user_id = "1";
  6.  
  7. $sql = "SELECT * FROM b_user_option WHERE NAME = '".$name."' AND USER_ID = '".$user_id."' AND CATEGORY = 'main.ui.filter'";
  8.  
  9. $recordset = $connection->query($sql);
  10. while ($record = $recordset->fetch())
  11. {
  12.    
  13. }
  14.  
  15.  
  16. //Изменение данных
  17. $connection = Bitrix\Main\Application::getConnection();
  18. $sqlHelper = $connection->getSqlHelper();
  19. $sql = "UPDATE b_user_option SET VALUE='".$nowParam."' WHERE `ID`='".$record["ID"]."'";
  20. $connection->query($sql);
  21.  
  22.  
  23. //Добавление данных
  24. $connection = Bitrix\Main\Application::getConnection();
  25. $sqlHelper = $connection->getSqlHelper();
  26. $sql = "INSERT INTO `b_user_option` (`USER_ID`, `CATEGORY`, `NAME`, `VALUE`, `COMMON`) VALUES ('" . $user_id . "', 'main.ui.filter', '" . $name . "', '" . $nowParam . "', 'N');";
  27. $connection->query($sql);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement