Форум

<?
function searchAllDB($search){
    global $mysqli;

    $out = [];

    $sql = "show tables";
    $rs = $mysqli->query($sql);
    if($rs->num_rows > 0){
        while($r = $rs->fetch_array()){
            $table = $r[0];
            $sql_search = "sel ect * fr om ".$table." where ";
            $sql_search_fields = Array();
            $sql2 = "SHOW COLUMNS FR OM ".$table;
            $rs2 = $mysqli->query($sql2);
            if($rs2->num_rows > 0){
                while($r2 = $rs2->fetch_array()){
                    $colum = $r2[0];
                    $sql_search_fields[] = $colum." like('%".$search."%')";
                }
                $rs2->close();
            }
            $sql_search .= implode(" OR ", $sql_search_fields);
            $rs3 = $mysqli->query($sql_search);
            // $out .= $rs3->num_rows."\n";
            if($rs3 == true &&  $rs3->num_rows > 0){               
               $out[] =  $table;
                $rs3->close();
            }
        }
        $rs->close();
    }

    return $out;
}

$site_id = 's3';
$mysqli = new mysqli('localhost', 'login', 'password', 'database') ;
$res = searchAllDB($site_id);

// print_r($res);

function delete_site($item, $key){
   // echo $item;
   global $mysqli;
   $table_columns = [];
   $sql = "show columns FROM $item" ;
   $res = $mysqli->query($sql);
   while($ob = $res->fetch_assoc()){
      $table_columns[] = $ob['Field'] ;
   }
   if(in_array('LID' , $table_columns)){
      $sql2 = "DELETE FROM $item WH ERE LID = $site_id";      
      $res = $mysqli->query($sql2);
      echo $res;
   }else if(in_array('SITE_ID' , $table_columns)){
      $sql2 = "DELETE FR OM $item WH ERE SITE_ID = $site_id" ;
      $res = $mysqli->query($sql2);
      echo $res;
   }
}

array_walk($res, 'delete_site');

$results = $DB->Query("DELETE FR OM `b_sale_person_type` WHERE `LID`=".SITE_ID);
$row = $results->Fetch();
Bitrix\Main\Diag\Debug::writeToFile($row);

$results = $DB->Query("DELETE FR OM `b_sale_person_type_site` WH ERE `SITE_ID`=".SITE_ID);
$row = $results->Fetch();
Bitrix\Main\Diag\Debug::writeToFile($row);

//clear subscribe rubric
$results = $DB->Query("DELETE FROM `b_list_rubric` WH ERE `LID`=".SITE_ID);
$row = $results->Fetch();
Bitrix\Main\Diag\Debug::writeToFile($row);