"; echo "
"; echo ""; echo ""; echo ""; echo "
 

MyPHPAdmin

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "
"; echo ""; echo ""; echo "
"; echo "















"; echo ""; echo "		"; echo "
"; //##################################################################### if ($myadmin == ""){ echo "

Welcome to MyPHPAdmin

"; echo "

PHP/MySQL administration by: Tim Geiges
"; echo "

http://wmf.dyndns.org

"; echo "
"; echo "
"; } //##################################################################### // DATABASE //###################################################################### if ($myadmin == "db") { echo "

Database Admin

"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; //##################################################################### if ($admin == "") { echo "
"; } //##################################################################### if ($admin == "view") { echo "
"; echo "
"; echo "

Choose a database to VIEW!!!

"; echo "
"; echo "
"; dbview(tableview, db); } //##################################################################### if ($admin == "tableview") { echo "
"; echo "
"; echo "

Choose a table to VIEW!!!

"; echo "
"; echo "
"; tableview(viewtablecontents, $dbuse, db); } //##################################################################### if ($admin == "viewtablecontents") { echo "
"; mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); $result = mysql_query ("SELECT * FROM $tableuse;"); echo "
"; echo ""; echo "
"; echo " "; while($value = mysql_fetch_array($result)) { print ""; for($i=0; $i< mysql_num_fields($result); $i++ ) { print ""; } print ""; } mysql_free_result($result); mysql_close(); echo "
$value[$i]
"; echo "
"; echo "
"; } //######################################################################################### if ($admin == "create") { echo "
"; echo "
"; echo "
"; echo "

Type a name for the new Database.

"; echo "
"; echo "
"; echo "
"; } //######################################################################################### if ($admin == "createdb") { echo "
"; echo "
"; mysql_connect ($dbhost, $username, $password); mysql_query ("CREATE DATABASE $dbname"); echo "
Your Databases called $dbname has been created, would you like to set up some tables?

"; echo "
"; echo "
"; echo "
"; echo "
"; echo "YES"; echo "
NO"; echo "
"; echo "
"; echo "
"; } //######################################################################################### if ($admin == "dropdb") { echo "
"; echo "
"; echo "

Choose a database to DROP!!!!!!

"; echo "
"; echo "
"; dbview(dropdbques, db); } //######################################################################################### if ($admin == "dropdbques") { echo "
"; echo "
"; echo "

Are you sure you want to delete database $dbuse

"; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "YES"; echo "
NO"; echo "
"; echo "
"; echo "
"; } //######################################################################################### if ($admin == "dropdbdoit") { echo "
"; echo "
"; echo "

The Database \"$dbuse\" has been deleted.

"; echo "
"; echo "
"; mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); mysql_query ("drop database $dbuse"); echo "
"; } //##################################################################### } //##################################################################### //############################################################ // EDIT DATABASE //############################################################ if ($myadmin == "editdb") { include ("SETUP.PHP"); } //############################################################ //###################################################################### // TABLE //###################################################################### if ($myadmin == "table") { echo "

Table Admin

"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; //######################################################################################### if ($admin == "") { echo "
"; } //######################################################################################### if ($admin == "describetable") { echo "
"; echo "
"; echo "
"; echo "
Choose a database to DESCRIBE a table from

"; echo "
"; echo "
"; echo "
"; dbview(describetablelist, table); } //######################################################################################### if ($admin == "describetablelist") { echo "
"; echo "
"; echo "
"; echo "
Choose a table to DESCRIBE

"; echo "
"; echo "
"; tableview(describetabledoit, $dbuse, table); echo "
"; } //######################################################################################### if ($admin == "describetabledoit") { echo "
"; mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); $result = mysql_query ("describe $tableuse;"); echo "
"; echo ""; echo "
"; echo " "; while($value = mysql_fetch_array($result)) { print ""; for($i=0; $i< mysql_num_fields($result); $i++ ) { print ""; } print ""; } mysql_free_result($result); mysql_close(); echo "
$value[$i]
"; echo "
"; echo "
"; } //##################################################################### if ($admin == "maketable") { echo "
"; echo "
"; echo "
"; echo "

Choose a database to MAKE a table in.

"; echo "
"; echo "
"; dbview (maketableform, table); echo "
"; } //##################################################################### if ($admin == "maketableform") { echo "
"; echo "
"; echo "
"; echo "

This is the new table form
"; echo "below are the existing tables within the database \"$dbuse\"

"; echo "
"; echo "

"; mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); $result = mysql_query ("SHOW TABLES;"); while($value = mysql_fetch_array($result)) { //This loop goes through the colums and prints //each value for($i=0; $i< mysql_num_fields($result); $i++ ) { echo "
"; echo "
"; print "$value[$i]
"; echo "
"; echo "
"; } } mysql_free_result($result); mysql_close(); echo "
"; echo "
"; echo "
"; echo "Edit this data to fit your needs.
"; echo ""; echo ""; echo "
"; echo "
"; echo "

"; } //######################################################################################### if ($admin == "maketabledoit") { echo "
"; echo "Your new table has been created"; mysql_connect ($dbhost, $username, $password); mysql_query ("CREATE DATABASE $dbname"); echo "  Would you like to create another table?"; echo "

YES"; echo "
NO"; mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); mysql_query ("$createtable"); echo "



HOME"; echo "
"; } //######################################################################################### if ($admin == "deletetable") { echo "
"; echo "
"; echo "

Choose a database to DROP a TABLE from!!!!

"; echo "
"; echo "
"; dbview(droptableview, table); } //######################################################################################### if ($admin == "droptableview") { echo "
"; echo "
"; echo "

Choose a TABLE to DROP!!!

"; echo "
"; echo "
"; tableview(droptableques, $dbuse, table); } //######################################################################################### if ($admin == "droptableques") { echo "
"; echo "
"; echo "
Are you sure you want to delete the table $tableuse from the database $dbuse

"; echo "
"; echo "
"; echo ""; echo ""; echo "
"; echo "
"; echo "YES"; echo "
NO"; echo "
"; echo "
"; echo "
"; } //######################################################################################### if ($admin == "droptabledoit") { echo "
"; echo "
"; echo "

The Table \"$tableuse\" was dropped.

"; echo "
"; echo "
"; mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); mysql_query ("drop table $tableuse"); echo "
"; } //######################################################################################### //########################## NEW COLUMN CODE ############################################ if ($admin == "newcol") { echo "
"; echo "
"; echo "
"; echo "

Choose a database to EDIT COLUMNS in.

"; echo "
"; echo "
"; dbview (newcoltab, table); echo "
"; } //###################################################################### if ($admin == "newcoltab") { echo "
"; echo "
"; echo "

Choose a table to EDIT COLUMNS in.

"; echo "
"; echo "
"; tableview(newcolques, $dbuse, table); } //##################################################################### if ($admin == "newcolques") { echo "
"; echo "
"; echo "

Before we continue you will need to backup the Database"; echo "
Are you sure you want to BACKUP the database $dbuse?

"; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "YES"; echo "
NO"; echo "
"; echo "
"; echo "
"; } //###################################################################### if ($admin == "newcoldoit") { echo "
"; echo "
"; echo "
"; echo "
Click an existing coloumn to DELETE OR
"; echo "Enter a new column name and column type in the fields provided to add a NEW column."; echo "
"; echo "

"; $dd = "/usr/bin/mysqldump -u $username --password=$password --add-drop-table $dbuse > tabledump/$dbuse"; exec ($dd, $ddR, $ddRV); mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); $result = mysql_query ("describe $tableuse;"); echo "
"; echo ""; echo "
CLICK A COLUMN TO DELETE"; echo " "; while($value = mysql_fetch_array($result)) { print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } print "
$value[0]$value[1]$value[2]$value[3]$value[4]$value[5]

"; echo ""; print ""; echo ""; echo ""; echo ""; echo ""; echo "
Fill out the form below for new columns
col name  "; echo "col type  "; print "col size
"; mysql_free_result($result); mysql_close(); echo "
"; echo "
"; echo "
"; } //##################################################################### if ($admin == "newcolnext" && $newcol != "" && $type != "") { echo "
"; echo "
"; echo "

Are you sure you would like to continue?

"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; } if ($admin == "newcolnext" && $newcol == "") { echo "
"; echo "
"; echo "
"; echo "

You need to type a name in the colname field


"; echo "
"; echo "
"; echo "
"; } if ($admin == "newcolnext" && $type == "") { echo "
"; echo "
"; echo "
"; echo "

You need to type a name in the coltype field

"; echo "
"; echo "
"; echo "
"; } //##################################################################### if ($admin == "newcolnextdoit") { mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); if ($size == "") { mysql_query ("ALTER TABLE $tableuse add $newcol $type;"); } else { mysql_query ("ALTER TABLE $tableuse add $newcol $type($size);"); } echo "
"; mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); $result = mysql_query ("describe $tableuse;"); echo "
"; $valof = $result; if ($valof != "") { echo "
"; $dd = "/bin/rm -f -r tabledump/$dbuse"; exec ($dd, $ddR, $ddRV); } if ($valof == "") { echo "
There was a problem with your new col
"; echo "Your database will now be restored..."; echo "

$newcol   $type($size)
$addl, $param"; mysql_connect ($dbhost, $username, $password); mysql_drop_db ($dbuse); mysql_create_db ($dbuse); $dd = "/usr/bin/mysql -u $username --password=$password $dbuse < tabledump/$dbuse"; exec ($dd, $ddR, $ddRV); $dd = "/bin/rm -f -r tabledump/$dbuse"; exec ($dd, $ddR, $ddRV); } echo "
"; echo "
"; echo "
"; echo "
Click an existing coloumn to DELETE OR
"; echo "Enter a new column name and column type in the fields provided to add a NEW column."; echo "
"; echo "

"; $dd = "/usr/bin/mysqldump -u $username --password=$password --add-drop-table $dbuse > tabledump/$dbuse"; exec ($dd, $ddR, $ddRV); mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); $result = mysql_query ("describe $tableuse;"); echo "
"; echo ""; echo "
CLICK A COLUMN TO DELETE"; echo " "; while($value = mysql_fetch_array($result)) { print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } print "
$value[0]$value[1]$value[2]$value[3]$value[4]$value[5]

"; echo ""; print ""; echo ""; echo ""; echo ""; echo ""; echo "
Fill out the form below for new columns
col name  "; echo "col type  "; print "col size
"; mysql_free_result($result); mysql_close(); echo "
"; echo "
"; echo "
"; } //##################################################################### if ($admin == "coldelques") { echo "
"; echo "
"; echo "

Are you sure you would like to delete column \"$col\"?

"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; } //##################################################################### if ($admin == "coldeldoit") { mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); mysql_query ("ALTER TABLE $tableuse drop $coldel;"); echo "
"; echo "
"; echo "
"; echo "
Click an existing coloumn to DELETE OR
"; echo "Enter a new column name and column type in the fields provided to add a NEW column."; echo "
"; echo "

"; $dd = "/usr/bin/mysqldump -u $username --password=$password --add-drop-table $dbuse > tabledump/$dbuse"; exec ($dd, $ddR, $ddRV); mysql_connect ($dbhost, $username, $password); mysql_select_db ($dbuse); $result = mysql_query ("describe $tableuse;"); echo "
"; echo ""; echo "
CLICK A COLUMN TO DELETE"; echo " "; while($value = mysql_fetch_array($result)) { print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } print "
$value[0]$value[1]$value[2]$value[3]$value[4]$value[5]

"; echo ""; print ""; echo ""; echo ""; echo ""; echo ""; echo "
Fill out the form below for new columns
col name  "; echo "col type  "; print "col size
"; mysql_free_result($result); mysql_close(); echo "
"; echo "
"; echo "
"; } //##################################################################### } //##################################################################### //###################################################################### // BACKUP/RESTORE //###################################################################### if ($myadmin == "backup") { echo "

Backup/Restore Admin

"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; //###################################################################### if ($admin == "") { echo "
"; } //###################################################################### if ($admin == "backup") { echo "
"; echo "
"; echo "
"; echo "

Choose a database to BACKUP!!!!

"; echo "
"; echo "
"; dbview (backupdbques, backup); echo "
"; } //###################################################################### if ($admin == "backupdbques") { echo "
"; echo "
"; echo "

Are you sure you want to BACKUP the database $dbuse?

"; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo "YES"; echo "
NO"; echo "
"; echo "
"; echo "
"; } //###################################################################### if ($admin == "backupdbdoit") { echo "
"; echo "
"; echo "
"; echo "

\"$dbuse\" has been backed up.

"; echo "
"; echo "
"; $dd = "/usr/bin/mysqldump -u $username --password=$password --add-drop-table $dbuse > dumps/$dbuse"; exec ($dd, $ddR, $ddRV); echo "
"; } //###################################################################### if ($admin == "restore") { echo "
"; echo "
"; echo "
"; echo "

Choose a database to RESTORE!!!
This will delete and restore the database

"; echo "
"; echo "

"; $dd = "/bin/ls dumps"; exec ($dd, $ddR, $ddRV); reset ($ddR); while (list($key,$val) = each($ddR)) { echo "
"; echo "
"; print "$val
"; echo "
"; echo "
"; } echo "
"; } //######################################################################################### if ($admin == "restoredbques") { echo "
"; echo "
"; echo "
"; echo "

Are you sure you want to RESTORE the database $dbuse

"; echo "
"; echo "

"; echo ""; echo "

YES"; echo "
NO"; echo "
"; } //######################################################################################### if ($admin == "restoredbdoit") { echo "
"; echo "
"; echo "
"; echo "

The database \"$restore\" has been restored.

"; echo "
"; echo "

"; mysql_connect ($dbhost, $username, $password); mysql_drop_db ($restore); mysql_create_db ($restore); $dd = "/usr/bin/mysql -u $username --password=$password $restore < dumps/$restore"; exec ($dd, $ddR, $ddRV); echo "
"; } //###################################################################### } //################################################################### echo "

















"; echo "
"; echo "
"; //##################################################################### ?>