<?php

$host = 'localhost';
$login = 'root';
$password = '';
$database = '';
$prefixe = 'fsb2_';

$handle = mysql_connect($host, $login, $password);
mysql_select_db($database, $handle);

$sql = "SHOW TABLES LIKE '".$prefixe."%'";
$result = mysql_query($sql, $handle);

$nom_colonne = 'Tables_in_'.$database.' ('.$prefixe.'%)';

$tables = array();
while( $row = mysql_fetch_array($result, $handle) )
{
	$tables[] = $row[$nom_colonne];
}

$sql = 'DROP TABLE '.implode($tables, ', ');
mysql_query($sql, $handle);

mysql_close($handle);

echo(count($tables).' tables ont été supprimés');

?>

$host = 'localhost';
$login = 'root';
$password = '';
$database = '';
$prefixe = 'fsb2_';