вот код чтобы не удалять ручками
[CODE]<?
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');
[/CODE]
