Blame view

delete_rub.php 678 Bytes
42868d70   andryeyev   Создал GIT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
  <?php
  require("./libs/setup.php");
  $setup = new setup();
  
  $objCatalogs = $setup->setupClass("Catalogs");
  
  $rub_id = $objCatalogs->db->getOne("select id from catalogs_rubrics where translit=?",array('tur-ryukzaki'));
  $res = $objCatalogs->db->getAll("select * from catalogs_products where rubric_id=?",array($rub_id),DB_FETCHMODE_ASSOC);
  foreach($res as $row){
  
  print $row['id']."<br>";
  $objCatalogs->db->query("delete from catalogs_modifications where product_id=?",array($row['id']));
  $objCatalogs->db->query("delete from catalogs_products_params where product_id=?",array($row['id']));
  $objCatalogs->db->query("delete from catalogs_products where id=?",array($row['id']));
  }
  ?>