<?php
$TableName=$_POST['TableName'];
$action=$_GET['action'];
if ($action=="deletetable"){
$TableName=$_GET['TableName'];
$hostname = "";
$username = "";
$password = "";
$dbname = "";
$conn = mysql_connect($hostname, $username, $password, $dbName);
$result=mysql_select_db($dbname,$conn);
$sql = "DROP TABLE $TableName";
mysql_select_db( '$dbname' );
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not delete table: ' . mysql_error());
}
echo "<div id=\"remove1\">Table $TableName deleted successfully!</div>";
mysql_close($conn);
echo "<style>#remove{display:none}</style>";
}
?>
<div id="remove">
<a class="moosebutt" href=".php?action=deletetable&TableName=<?php echo $TableName; ?>">Delete <?php echo $TableName; ?></a>
</div>
<form name="FearDearg" action=".php" method="post">
<table border="0" cellpadding="0" cellspacing="2" width="300"><tr>
<td><nobr>Table</td>
<td><SELECT NAME="TableName">
<OPTION value="<?php echo $_POST['TableName']; ?> "><?php echo $_POST['TableName']; ?> </OPTION>
<?php
$dbname = '';
$hostname = "";
$username = "";
$password = "";
$dbname = "";
$conn = mysql_connect($hostname, $username, $password, $dbName);
$result=mysql_select_db($dbName,$conn);
$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);
if (!$result) {
echo "DB Error, could not list tables\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_row($result)) {
echo "<OPTION value=\"{$row[0]}\">{$row[0]}</OPTION>";
}
mysql_free_result($result);
?>
</SELECT> </td>
</tr>
<tr>
<td></td>
<td><input class="moosebutta" type="submit" name="submit" value="View Table"></td>
</tr>
</table>
</form>
<?php
function MooseFind($tablename,$conn)
{
$query = "select * FROM $tablename" ;
$result= mysql_query($query, $conn) ;
$hostname = "";
$username = "";
$password = "";
$dbName = "";
$conn = mysql_connect($hostname, $username, $password, $dbName);
$result=mysql_select_db($dbName,$conn);
$query="select * from $tablename";
$result= mysql_query($query, $conn);
$column_count=mysql_num_fields($result);
echo "<table border=\"1\" cellpadding=\"5\"> ";
$column_num=0;
while ($column_num < $column_count){
echo "<th>" . mysql_field_name($result, $column_num) . "</th>";
$column_num++;
}
$i = 0;
while ($row=mysql_fetch_row($result))
{
if ($i % 2 != 0) # An odd row
$rowColor = "#fff";
else # An even row
$rowColor = "#eee";
$column_count=mysql_num_fields($result);
echo "<tr align=\"left\" valign=\"top\" bgcolor=$rowColor>";
for (
$column_num=0;
$column_num < $column_count;
$column_num++
)
echo "<td>$row[$column_num]<br></td>";
$i++;
}
mysql_free_result($result);
echo "</table>";
}
?>
<style type="text/css">
#remove,#remove1{
font-family:sans-serif;
padding:10px;
}
/* Hover Button 1 */
.moosebutt {
background-color: #f00;
text-decoration:none;
padding-left:6px;
padding-right:6px;
padding-top:3px;
padding-bottom:3px;
color: #ffffff;
border:1px solid #db6600;
margin:10px;
-webkit-border-radius: 10px;
-moz-border-radius: 10px;
border-radius: 10px;
}
.moosebutt:hover {
background-color: #000000;
border:1px solid #000000;
background-image: url(images/button_bg_over.jpg);
}
/* Hover Button 1 */
.moosebutta {
background-color: #336699;
text-decoration:none;
padding-left:6px;
padding-right:6px;
padding-top:3px;
padding-bottom:3px;
color: #ffffff;
border:1px solid #db6600;
margin:10px;
-webkit-border-radius: 10px;
-moz-border-radius: 10px;
border-radius: 10px;
}
.moosebutta:hover {
background-color: #000000;
border:1px solid #000000;
background-image: url(images/button_bg_over.jpg);
}
table
{
border-spacing:1px;
border-style:solid;
border-width:2px;
border-color:#2C4F85;
font-family:sans-serif;
padding:0;
box-shadow:0px 0px #000000;
border-radius:5px;
}
th
{
color:#FFFFFF;
background:#2C7EDB;
border-style:solid;
border-width:1px;
border-color:#2C4F85;
font-weight:bold;
padding:5px;
text-align:center;
vertical-align:top;
}
tr
{
color:#5A7ECC;
font-weight:normal;
}
tr:hover td
{
color:#003;
}
td
{
padding:3px 5px;
text-align:left;
vertical-align:top;
}
th:first-child
{
border-top-left-radius:5px;
}
th:last-child
{
border-top-right-radius:5px;
}
tr:last-child td:first-child
{
border-bottom-left-radius:5px;
}
tr:last-child td:last-child
{
border-bottom-right-radius:5px;
}
</style>
<?php MooseFind("$TableName",$conn);?><br><br>
<a href="export.php?tablename=<?php echo $TableName; ?>">Export Data For this Table</a>
<?php
$host = '';
$user = '';
$pass = '';
$db = '';
$table=$_GET['tablename'];
$file = $_GET['tablename'];
$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect.");
$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field'].", ";
$i++;
}
}
$csv_output .= "\n";
$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j].", ";
}
$csv_output .= "\n";
}
$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;
?>