right.php

用PHP实现的sqlite数据库管理系统 能方便到进行sqlite数据库的创建、修改、插入等管理操作

<?php
ob_start();
header('Content-Type:text/html;charset=gb2312');
$field_type = array("text", "integer", "real", "blob", "varchar", "smallint", "float", "double", "boolean", "date", "time", "timestamp", "binary");
switch($_GET[w]){
	case explore_data;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[db_ID]."'");
	$result = sqlite_fetch_all($query);
	echo "<table><tr><td><a href=index.php>服务器：本地</a> &rarr; <a href=javascript:select_db(db_ID)>数据库：".$result[0][name]."</a> &rarr; 表：".$_GET[table]."</td></tr></table>";
	echo "<table><tr><td>[<a href=javascript:select_table('".$_GET[table]."')>表结构</a>][<a href=javascript:explore_data('".$_GET[table]."')>浏览数据</a>][<a href=javascript:insert_data('".$_GET[table]."')>插入数据</a>][<a href=javascript:empty_data('".$_GET[table]."')>清空数据</a>][<a href=javascript:drop_table('".$_GET[table]."')>删除表</a>]</td></tr>";
	$query = sqlite_query(sqlite_open("./".$result[0][name]), "select * from ".$_GET[table]);
	if(sqlite_num_rows($query)){
		echo "<table>";
		echo "<tr bgcolor=#beb9df height=22 valign=middle>";
		echo "<td align=center width=180 colspan=2>操作</td>";
		for($i = 0;$i < sqlite_num_fields($query);$i ++)
		{
			echo "<td align=center width=150>".sqlite_field_name($query, $i)."</td>";
		}
		echo "</tr>";
		$result = sqlite_fetch_all($query);
		for($i = 0;$i < sizeof($result);$i ++)
		{
			echo "<tr bgcolor=".($i%2==1?'#eaeaea':'#cccccc')." onclick=\"this.style.backgroundColor='#FF9966'\" onmouseover=\"this.style.backgroundColor='#B7FF6F'\" onmouseout=\"this.style.backgroundColor='".($i%2==1?'#eaeaea':'#cccccc')."'\"><td align=center width=90>[<a href=javascript:edit_data('".$_GET[table]."','".sqlite_field_name($query, 0)."','".$result[$i][0]."')>改</a>]</td><td align=center width=90>[<a href=javascript:delete_data('".$_GET[table]."','".sqlite_field_name($query, 0)."','".$result[$i][0]."')>删</a>]</td>";
			for($j = 0;$j < sqlite_num_fields($query);$j ++)
			{
				echo "<td align=center width=150>".$result[$i][sqlite_field_name($query, $j)]."</td>";
			}
		}
		echo "</table>";
	}else{
		echo "<table class=box><tr><td>SQLite 返回的查询结果为空（即零行）。 </td></tr></table>";
	}
	break;
	case edit_data;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[db_ID]."'");
	$result = sqlite_fetch_all($query);
	echo "<form method=post action=submit.php?action=edit_data&field=".$_GET[field]."&value=".$_GET[value]."&db_ID=".$_GET[db_ID]."&table=".$_GET[table]." style='margin:0px;'><table><tr><td><a href=index.php>服务器：本地</a> &rarr; <a href=javascript:select_db(db_ID)>数据库：".$result[0][name]."</a> &rarr; 表：".$_GET[table]."</td></tr></table>";
	echo "<table><tr><td>[<a href=javascript:select_table('".$_GET[table]."')>表结构</a>][<a href=javascript:explore_data('".$_GET[table]."')>浏览数据</a>][<a href=javascript:insert_data('".$_GET[table]."')>插入数据</a>][<a href=javascript:empty_data('".$_GET[table]."')>清空数据</a>][<a href=javascript:drop_table('".$_GET[table]."')>删除表</a>]</td></tr>";
	$query = sqlite_query(sqlite_open("./".$result[0][name]), "select * from ".$_GET[table]." where ".$_GET[field]." = '".$_GET[value]."'");
	$result = sqlite_fetch_all($query);
	echo "<table>";
	echo "<tr bgcolor=#beb9df height=22 valign=middle><td width=200 align=center><b>字段</b></td><td width=200 align=center><b>值</b></td></tr>";
	for($i = 0;$i < sqlite_num_fields($query);$i ++)
	echo "<tr bgcolor=".($i%2==1?'#eaeaea':'#cccccc')." onclick=\"this.style.backgroundColor='#FF9966'\" onmouseover=\"this.style.backgroundColor='#B7FF6F'\" onmouseout=\"this.style.backgroundColor='".($i%2==1?'#eaeaea':'#cccccc')."'\"><td>&nbsp;&nbsp;".sqlite_field_name($query, $i)."</td><td align=center><input type=hidden name=field[] value=".sqlite_field_name($query, $i)."><textarea name=value[]>".$result[0][sqlite_field_name($query, $i)]."</textarea></td></tr>";
	echo "<tr><td colspan=2><table class=box width=100%><tr><td>修改".$_GET[field]."=".$_GET[value]."的数据</td><td width=50% align=right><input type=submit value=执行></td></table></td></tr>";
	echo "</table></form>";
	break;
	case insert_data;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[db_ID]."'");
	$result = sqlite_fetch_all($query);
	echo "<form method=post action=submit.php?action=insert_data&db_ID=".$_GET[db_ID]."&table=".$_GET[table]." style='margin:0px;'><table><tr><td><a href=index.php>服务器：本地</a> &rarr; <a href=javascript:select_db(db_ID)>数据库：".$result[0][name]."</a> &rarr; 表：".$_GET[table]."</td></tr></table>";
	echo "<table><tr><td>[<a href=javascript:select_table('".$_GET[table]."')>表结构</a>][<a href=javascript:explore_data('".$_GET[table]."')>浏览数据</a>][<a href=javascript:insert_data('".$_GET[table]."')>插入数据</a>][<a href=javascript:empty_data('".$_GET[table]."')>清空数据</a>][<a href=javascript:drop_table('".$_GET[table]."')>删除表</a>]</td></tr>";
	$query = sqlite_query(sqlite_open("./".$result[0][name]), "select * from ".$_GET[table]);
	echo "<table>";
	echo "<tr bgcolor=#beb9df height=22 valign=middle><td width=200 align=center><b>字段</b></td><td width=200 align=center><b>值</b></td></tr>";
	for($i = 0;$i < sqlite_num_fields($query);$i ++)
	echo "<tr bgcolor=".($i%2==1?'#eaeaea':'#cccccc')." onclick=\"this.style.backgroundColor='#FF9966'\" onmouseover=\"this.style.backgroundColor='#B7FF6F'\" onmouseout=\"this.style.backgroundColor='".($i%2==1?'#eaeaea':'#cccccc')."'\"><td>&nbsp;&nbsp;".sqlite_field_name($query, $i)."</td><td align=center><input type=hidden name=field[] value=".sqlite_field_name($query, $i)."><textarea name=value[]></textarea></td></tr>";
	echo "<tr><td colspan=2><table class=box width=100%><tr><td>在表".$_GET[table]."中插入数据</td><td width=50% align=right><input type=submit value=执行></td></table></td></tr>";
	echo "</table></form>";
	break;
	case select_table;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[db_ID]."'");
	$result = sqlite_fetch_all($query);
	echo "<table><tr><td><a href=index.php>服务器：本地</a> &rarr; <a href=javascript:select_db(db_ID)>数据库：".$result[0][name]."</a> &rarr; 表：".$_GET[table]."</td></tr></table>";
	echo "<table><tr><td>[<a href=javascript:select_table('".$_GET[table]."')>表结构</a>][<a href=javascript:explore_data('".$_GET[table]."')>浏览数据</a>][<a href=javascript:insert_data('".$_GET[table]."')>插入数据</a>][<a href=javascript:empty_data('".$_GET[table]."')>清空数据</a>][<a href=javascript:drop_table('".$_GET[table]."')>删除表</a>]</td></tr>";
	$query = sqlite_query(sqlite_open("./".$result[0][name]), "select * from ".$_GET[table]);
	echo "<table>";
	echo "<tr bgcolor=#beb9df height=22 valign=middle><td width=200 align=center><b>字段</b></td></tr>";
	for($i = 0;$i < sqlite_num_fields($query);$i ++)
	echo "<tr bgcolor=".($i%2==1?'#eaeaea':'#cccccc')." onclick=\"this.style.backgroundColor='#FF9966'\" onmouseover=\"this.style.backgroundColor='#B7FF6F'\" onmouseout=\"this.style.backgroundColor='".($i%2==1?'#eaeaea':'#cccccc')."'\"><td>&nbsp;&nbsp;".sqlite_field_name($query, $i)."</td></tr>";
	echo "</table>";
	break;
	case sql;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[db_ID]."'");
	$result = sqlite_fetch_all($query);
	echo "<table><tr><td><a href=index.php>服务器：本地</a> &rarr; <a href=javascript:select_db(db_ID)>数据库：".$result[0][name]."</a></td></tr></table>";
	echo "<form style='margin:0px;' action=submit.php?action=sql&db_ID=".$_GET[db_ID]." method=post><table><tr><td>在<a href=javascript:select_db(db_ID)>数据库：".$result[0][name]."</a>中执行SQL查询</td></tr><tr><td><textarea rows=8 cols=75 name=sql></textarea></td></tr><tr><td><table width=100% class=box><tr><td width=50%>注意：select语句无效果。</td><td align=right><input type=submit value=执行></td></tr></table></td></tr></table></form>";
	break;
	case select_db;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[ID]."'");
	$result = sqlite_fetch_all($query);
	echo "<table><tr><td><a href=index.php>服务器：本地</a> &rarr; <a href=javascript:select_db(db_ID)>数据库：".$result[0][name]."</a></td></tr></table>";
	echo "<table><tr><td>[<a href=submit.php?action=delete_db&ID=".$_GET[ID].">删除数据库</a>]</td></tr><tr><td><font color=green><b>创建新的表</b></font></td></tr><tr><td>名称：<input type=text name=table_name size=15 maxlength=15> 字段数：<input type=text name=field_num size=2 maxlength=2><input type=hidden name=db_name id=db_name value=".$result[0][name]."> <input type=button onclick=create_table() value=创建></td></tr></table>";
	break;
	case create_table;
	echo "<table><tr><td><a href=index.php>服务器：本地</a> &rarr; <a href=javascript:select_db(db_ID)>数据库：".$_GET[db_name]."</a> &rarr; 创建新的表：".$_GET[name]."</td></tr></table>";
	for($i = 0;$i < sizeof($field_type);$i ++)
	$field_types .= "<option value=".$field_type[$i].">".$field_type[$i]."</option>";
	echo "<form style='margin:0px;' method=post action=submit.php?action=create_table><input type=hidden name=db_name value=".$_GET[db_name]."><input type=hidden name=table_name value=".$_GET[name]."><input type=hidden name=db_ID value=".$_GET[db_ID].">";
	echo "<table>";
	echo "<tr bgcolor=#beb9df height=22 valign=middle><td align=center width=200><b>字段</b></td><td align=center width=100><b>类型</b></td><td align=center width=100><b>长度</b></td><td align=center width=100><b>默认值</b></td><td align=center width=150><b>额外</b></td></tr>";
	for($i = 0;$i < $num;$i ++)
	{
		echo "<tr bgcolor=".($i%2==1?'#eaeaea':'#cccccc')." onclick=\"this.style.backgroundColor='#FF9966'\" onmouseover=\"this.style.backgroundColor='#B7FF6F'\" onmouseout=\"this.style.backgroundColor='".($i%2==1?'#eaeaea':'#cccccc')."'\"><td align=center><input type=text name=field_name[]></td><td align=center><select name=field_type[]>".$field_types."</select></td><td align=center><input type=text name=field_limit[] size=10></td><td align=center><input type=text name=default_value[] size=10></td><td align=center><select name=field_add[]><option value=''>空</option><option value='primary key'>Primary Key</option><option value='index'>index</option></select></td></tr>";
	}
	echo "<tr><td align=right colspan=5><table class=box width=100%><tr><td width=50% align=left>建议：设第一个字段设置为主键。</td><td>创建新的表：".$_GET[name]."<input type=submit value=执行></td></tr></table></td></tr>";
	echo "</table>";
	echo "</form>";
	break;
	default;
	echo "<table>";
	echo "<tr><td>PHP版本：".phpversion()."</td></tr>";
	echo "<tr><td>SQLite版本：".sqlite_libversion()."</td></tr>";
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db");
	$num = sqlite_num_rows($query);
	$result = sqlite_fetch_all($query);
	echo "<tr><td>管理已有数据库：";
		echo "<select onchange=\"if(this.value >0)select_db(this.value);\"><option value=0>请选择</option>";
		for($i = 0;$i < sizeof($result);$i ++)
		{
			echo "<option value=".$result[$i][ID].">".$result[$i][name]."</option>";
		}
		echo "</select>";

	echo "</td></tr>";
	echo "<tr><td><form action=submit.php?action=create_db method=post style='margin:0px;'>打开/创建新的数据库：./<input type=text name=db_name id=db_name size=15 maxlength=15>（使用相对路径） <input type=submit value=执行></form></td></tr>";
	echo "</table>";
	break;
}
?>