| Nr. | Database name: |
|---|
';
$i=1;
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
echo '
| '.$i.' | '.$row[0].' |
';
$i++;
}
echo "";
mysql_free_result($result);
mysql_close($link);
} if ($sitemode == 2) {
$link = mysql_connect($_SESSION['hostname'],$_SESSION['username'] ,$_SESSION['password'] );
if (!$link) die('Could not connect: ' . mysql_error());
mysql_select_db($_SESSION['dbname']);
$result = mysql_query('SHOW tables');
if (!$result) die('Invalid query: ' . mysql_error());
echo '
| Nr. | Tables in '.$_SESSION['dbname'].': |
|---|
';
$i=1;
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
echo '| '.$i.' | '.$row[0].' |
';
$i++;
}
echo "
";
mysql_free_result($result);
mysql_close($link);
} if ($sitemode == 3) {
$link = mysql_connect($_SESSION['hostname'],$_SESSION['username'] ,$_SESSION['password'] );
if (!$link) die('Could not connect: ' . mysql_error());
mysql_select_db($_SESSION['dbname']);
$result = mysql_query('SELECT * FROM '.$_SESSION['table']);
if (!$result) die('Invalid query: ' . mysql_error());
echo '
';
$i=1;
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if ($i==1){
echo '';
foreach ($row as $name => $value) {
echo '| '.$name.' | ';
}
echo '
';
}
echo '';
foreach ($row as $name => $value) {
if ( $value == "" ) $value=" ";
echo '| '.$value.' | ';
}
echo '
';
$i++;
}
if ($i==1){
echo "No record was found!";
}
echo "
";
mysql_free_result($result);
mysql_close($link);
}
?>