<?php
/******************************************************************************/
/*                                                                            */
/*                       __        ____                                       */
/*                 ___  / /  ___  / __/__  __ _____________ ___               */
/*                / _ \/ _ \/ _ \_\ \/ _ \/ // / __/ __/ -_|_-<               */
/*               / .__/_//_/ .__/___/\___/\_,_/_/  \__/\__/___/               */
/*              /_/       /_/                                                 */
/*                                                                            */
/*                                                                            */
/******************************************************************************/
/*                                                                            */
/* Titre          : Liste et supprime les tables d'une base MySQL             */
/*                                                                            */
/* URL            : http://www.phpsources.org/scripts15-MySQL.htm             */
/* Auteur         : Olivier                                                   */
/* Date édition   : 20 Fév 2007                                               */
/*                                                                            */
/******************************************************************************/


//connection
$connectfile = "connection.php";
require $connectfile;
$dbname = 'DATABASE NAME';

$result = mysql_list_tables($dbname);

echo '<table>';
echo  '<tr>';
echo  '<td>Table nom:</td>';
echo  '<td>Supprimer?</td>';
echo  '</tr>';
  
   if (!$result) {
       print "Impossible de lister les tables\n";
       print 'MySQL erreurs: ' . mysql_error();
       exit;
   }
   
   while ($row = mysql_fetch_row($result)) {
       echo '<tr>';
       echo '<td>';
       print "$row[0]\n";
       echo '</td>';
       echo '<td>';
       echo '<a href="'.$PHP_SELF.'?action=delete&table="';
       print "$row[0]\n";
       echo ' oui?</a>';
       echo '</td>';
       echo '</tr>';
   }

   mysql_free_result($result);

//Delete
if($action=="delete")
{
$deleteIt=mysql_query("DROP TABLE $table"); 
if($deleteIt)
{
echo 'La table';
echo ''.$table.' a été supprimer avec succés!<br />';
}
else
{
echo "Une erreur est arrivé, rééssayer !!<br />";
}
}
  
?>