$value) { if($value == 'empty') { $empty_tables[] = $key; } elseif($value == 'drop') { $drop_tables .= ', '.$key; } } } else { $text = 'No Tables Selected'; } $drop_tables = substr($drop_tables, 2); if(!empty($empty_tables)) { foreach($empty_tables as $empty_table) { $empty_query = $wpdb->query("TRUNCATE $empty_table"); $text .= "Table '$empty_table' Emptied
"; } } if(!empty($drop_tables)) { $drop_query = $wpdb->query("DROP TABLE $drop_tables"); $text = "Table(s) '$drop_tables' Dropped"; } break; } } ### Show Tables $tables = $wpdb->get_results("SHOW TABLES"); ?>

'.$text.'

'; } ?>

Empty/Drop Tables

Tables_in_'.DB_NAME; eval("\$table_name = \"$table_name\";"); echo "\n"; echo ""; echo ""; } ?>
Tables Empty Drop
$table_name Empty Drop
1. DROPPING a table means deleting the table. This action is not REVERSIBLE.
2. EMPTYING a table means all the rows in the table will be deleted. This action is not REVERSIBLE.