Очистка

[B0Bka]

`<?php //rename("index.php", "restore.php"); / удалить базу/

require($_SERVER["DOCUMENT_ROOT"]."/bitrix/php_interface/dbconn.php");

if (!mysql_connect($DBHost, $DBLogin, $DBPassword)) {
    print 'Could not connect to mysql';
    exit;
}

$result = mysql_list_tables($DBName);

if (!$result) {
    print "DB Error, could not list tables\n";
    print 'MySQL Error: ' . mysql_error();
    exit;
}
$arTable= array();
while ($row = mysql_fetch_row($result)) {
    $arTable[]= $row[0];
 print "Table: $row[0]\n";
}
    mysql_free_result($result);
  unset ($result);  
if (count($arTable)>0){
    $query="DROP TABLE ".implode(', ',$arTable);
    if(mysql_connect($DBHost, $DBLogin, $DBPassword)){echo('good');}else{echo('bad');}
    $result = mysql_query($query) or die ("Не возможно удалить таблицы");
    mysql_free_result($result);
}
echo "Все Таблицы БД удалены - ".$result;

rrmdir(".");

//Another simple way to recursively delete a directory that is not empty: function rrmdir($dir) { if (is_dir($dir)) { $objects = scandir($dir);

 foreach ($objects as $object) {

   if ($object != "." && $object != "..") {
    if ( $object=='clear.php')  continue;
     if (filetype($dir."/".$object) == "dir") rrmdir($dir."/".$object); else unlink($dir."/".$object);
   }
 }
 reset($objects);
 rmdir($dir);

} } ?>`

[B0Bka]

$conn = mysqli_connect($DBHost, $DBLogin, $DBPassword,$DBName);

if(!$conn) {
die('Could not connect: '.mysqli_connect_error());
}
echo 'Connected successfully
'; $res = mysqli_query($conn,"SHOW TABLES"); while($cRow = mysqli_fetch_array($res)) { $sql = "DROP TABLE ".$cRow[0];

if(mysqli_query($conn, $sql)) {
echo "Table ".$cRow[0]." is deleted successfully";
} else {
echo "Table ".$cRow[0]." is not deleted successfully\n"; }
} mysqli_close($conn);