Menus & Navigation
|
|
|
|
<?php //header ("Cache-Control: no-cache, must-revalidate"); ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<title>Pokusy</title>
</head>
<body>
<?php
// Zaist�m platnos� premenn�ch formul�ra
//error_reporting (E_ERROR | E_WARNING | E_PARSE);
//error_reporting (E_ERROR | E_PARSE);
error_reporting (E_ALL );
if (!isset($server))$server="localhost";
if (!isset($user)) $user="";
if (!isset($CHK)) $CHK="";
if (!isset($sql)) $sql="";
if (!isset($passwd)) $passwd="";
if (!isset($DTB) ) $DTB="mysql";
if (!isset($hlavicka) ) $hlavicka=1;
$sql=eregi_replace('\\',"", $sql);
@$spojeni = mysql_connect($server, "$user", "$passwd");
if (!$spojeni){
echo "Connection to '$server' for '$user' failed ".mysql_error();
} else {
mysql_select_db ($DTB)
or die (mysql_error()." Could not select database");
}
?>
<H1><FONT COLOR="#0000aa">View database info -
</FONT>
<FONT COLOR="#ff8800">#
<?php poc_pristupov("aaa.dat")?> -
<?php echo Date("d.M.Y H:i:s");?>
</FONT>
</H1>
<FORM NAME=F1 METHOD="GET" ACTION="<?php echo($PHP_SELF); ?>">
Host: <input type="Text" name="server" value="<?php echo $server ?>" size="12" onChange="user.focus(); user.select();">
User: <input type="Text" name="user" value="<?php echo $user ?>" size="12" onblur="passwd.focus(); passwd.select();">
Password: <input type="password" name="passwd" value="<?php echo $passwd ?>" size="12" onblur="F1.submit()">
<BR>
<?php
if (!$spojeni){ die (mysql_error()."Fix your login!!!"); }
//V�pis n�zvov datab�z
echo "<B>Databases on <FONT COLOR='#0000aa'>'$server'</FONT>: <FONT size=5 COLOR=#ff0000>";
$db_list = mysql_list_dbs();
$i = 0;
$cnt = mysql_num_rows($db_list);
while ($i < $cnt) {
echo mysql_db_name($db_list, $i) . "n";
$i++;
}
echo "</FONT></B>";
?>
<?php
echo "<BR><B>Tables in database <FONT COLOR='#0000aa'>'$DTB'</FONT> :<FONT size=5 COLOR=#007700> ";
$result = mysql_list_tables ($DTB);
$i = 0;
while ($i < mysql_num_rows ($result)) {
$tb_names[$i] = mysql_tablename ($result, $i);
echo "$tb_names[$i] ";
$i++;
}
echo "</FONT></B>";
?>
<br>
<?php
$result = mysql_list_dbs ();
$i = 0;
?>
Database :
<select name=DTB size=1 width=10 onChange="posli.click()" >
<?php
while ($i < mysql_num_rows ($result)) {
$tb_names[$i] = mysql_tablename ($result, $i);
$sel=sel($DTB, $tb_names[$i]);
echo "<option value="$tb_names[$i]" $sel >$tb_names[$i]</option>";
$i++;
}
echo "</select>";
mysql_free_result ($result);
?>
<?php
$result = mysql_list_tables ($DTB);
$i = 0;
echo ", Table : ";
?>
<select name=name size=1 title=tabu�ky onChange="posli.click()" >
<?php
echo "<option value="" $sel >Select a table</option>";
while ($i < mysql_num_rows ($result)) {
$tb_names[$i] = mysql_tablename ($result, $i);
$sel=sel($name, $tb_names[$i]);
echo "<option value="$tb_names[$i]" $sel >$tb_names[$i]</option>";
$i++;
}
echo "</select>";
?>
<select name=hlavicka size=1 onChange="posli.click()" >
<?php
$i = 1;
while ($i <= 6) {
$tb_names[$i] = mysql_tablename ($result, $i);
$sel=sel($hlavicka, $i);
echo "<option value="$i" $sel >$i</option>";
$i++;
}
echo "</select>";
?>
Use custom SQL <input type="checkbox" name="CHK" value="YES" <?php if ($CHK=="YES"){echo "checked";}?>><br>
<textarea cols="90" wrap=virtual rows="4" name="sql"><?php echo $sql ?></textarea>
<?
mysql_free_result ($result);
?>
<INPUT TYPE="submit" NAME=posli >
</FORM>
<!-- Koniec formul�ra -->
<HR>
<?php
mysql_select_db("$DTB");
if ($CHK==""){
@$result=mysql_query ("show columns from $name") or die (mysql_error()." No table to show");
echo "<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=1>";
for ($i = 0; $i < $hlavicka; $i++) {
echo "<TR BGCOLOR=bbbbbb>";
mysql_data_seek ($result, 0) ;
while ($row = mysql_fetch_array ($result)) {
print "<TH>".$row[$i]."</TH>";
}
print "</TR>";
}
$sql1="select * from $name";
$result=mysql_query ($sql1) or die (mysql_error()." kvak");
$col1="ffffff" ; $col2="bbffbb"; $bgcolor="whatever";
while ($row = mysql_fetch_assoc ($result)) {
if ( $bgcolor!=$col1){$bgcolor=$col1;} else {$bgcolor=$col2;};
print "<TR bgcolor="$bgcolor">";
foreach($row as $k => $v) {
// print "ppp$a[$k] => $v.qqqn";
print "<TD>$v </TD>";
}
}
print "</TABLE><P>";
}else {
print "<TABLE CELLPADDING=2 CELLSPACING=0 BORDER=1><TR bgcolor=ffff99>";
if (($CHK=="")){ $sql="select * from $name"; }
$result=mysql_query ($sql) or die (mysql_error()." kvak");
$row = mysql_fetch_assoc ($result);
foreach($row as $k => $v) {
print "<TH>$k</TH>";
}
print "</TR>";
mysql_data_seek ($result, 0) ;
$col1="ffffff" ; $col2="bbffbb"; $bgcolor="whatever";
while ($row = mysql_fetch_assoc ($result)) {
if ( $bgcolor!=$col1){$bgcolor=$col1;} else {$bgcolor=$col2;};
print "<TR bgcolor="$bgcolor">";
foreach($row as $k => $v) {
// print "ppp$a[$k] => $v.qqqn";
print "<TD>$v </TD>";
}
}
echo "</TABLE>";
}
mysql_free_result ($result);
echo "-o-";
// echo mysql_close ($link);
?>
<hr size="10">
<?php // show_source ("$PHP_SELF"); ?>
<HR></BODY></HTML>
|
|
|
Usage Example
|
|
|
Rate This Script
|
|
|
|
Store
Your email: