Code: Select all
<?
$host='localhost';
$kto='me';
$pass='pass';
$db_name='db';
$moja=mysql_connect($host,$kto,$pass)
or die("Nie mozna polaczyc sie z serverem");
mysql_select_db("$db_name")
or die("Nie mozna sie polaczyc z baza");
print "<FORM>";
print "<SELECT name='tb_name'>\n";
$listatab = mysql_list_tables($db_name);
while ($row = mysql_fetch_row($listatab)){
foreach ($row as $tb_list)
{
print "<OPTION value='$tb_list'>$tb_list</OPTION>\n";
}
}
print "<INPUT type='submit' value=' Wybierz '>";
print "</SELECT></FORM><BR>\n";
$sql="SELECT * FROM $tb_name";
print "<B>Zapytanie:</B> $sql <BR>\n";
$wynik=mysql_query($sql) or die("sql_error");
print "<TABLE border =1><TR bgcolor=gray>\n";
$pole = mysql_list_fields($db_name, $tb_name, $moja);
$kolumna = mysql_num_fields($pole);
for ($i = 0; $i < $kolumna; $i++)
print ("<TD>".mysql_field_name($pole, $i)."</TD>\n");
while ( $costam=mysql_fetch_row($wynik)){
print "<TR>\n";
foreach ($costam as $cosinnego)
{
print "<TD>$cosinnego</TD>\n";
}
}
mysql_close($moja);
?>