MySQL の窓 ( ソース : euc-jp, クライアント : euc-jp, DB : shift

left.php

<?
require_once( "./mwin.php" );
?>

<HTML>
<HEAD>
<TITLE>PHP 雛形</TITLE>
<LINK rel="stylesheet" type="text/css" href="style.css">
<STYLE type="text/css">
</STYLE>
<SCRIPT language="javascript" type="text/javascript">
function SetDefaultQuery( sTableName ) {

	var obj = parent.Head.document;
	obj.getElementsByName("text")[0].value = "select * from `" + sTableName + "`";

}
</SCRIPT>
</HEAD>
<BODY id="left">

<?

// 接続とDB選択
$link = mysql_connect($host, $user, $pass);
if ( !$link ) {
	print mystr( "接続エラー" );
	exit();
}
mysql_select_db( $db, $link );

// SQL の指定
$sql = "SHOW TABLES FROM $db";
$result = mysql_query($sql);
if (!$result) {
	print mystr( "SQLエラー<br>" );
	print dbstr(mysql_error());
	exit();
}

// 一覧作成
print "<TABLE border='0' cellspacing='2'>";
while ($row = mysql_fetch_row($result)) {
	print "<TR>";
	print "<TD>";
	print "<A";
	print "	href=\"body.php?type=3&table=" . urlencode( dbstr($row[0]) ) . "\"";
	print "	target=\"Body\"";
	print ">◎</A>";
	print "</TD>";
	print "<TD>";
	print "<A";
	print "	href=\"body.php?type=1&table=" . urlencode( dbstr($row[0]) ) . "\"";
	print "	target=\"Body\"";
	print "	onClick='SetDefaultQuery(\"" . dbstr($row[0]) . "\")'";
	print ">" . dbstr($row[0]) . "</A>";
	print "</TD>";
	print "</TR>\n";
}
print "</TABLE>";

mysql_free_result($result);

// 接続解除
mysql_close($link);

?>

</BODY>
</HTML>