left.php

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

<?php
ob_start();
header('Content-Type:text/html;charset=gb2312');
?>
<table>
<tr><td align=center>phpSQLiteAdmin</td></tr>
<tr><td align=center>[<a href=javascript:run_sql()>SQL</a>]</td></tr>
</table>
<?php
if (! function_exists ('sqlite_list_tables')) {
    function sqlite_list_tables (&$dblink) {
        $tables = array ();
        
        $sql = "SELECT name FROM sqlite_master WHERE (type = 'table')";
        if ($res = sqlite_query ($dblink, $sql)) {
            while (sqlite_has_more($res)) {
                $tables[] = sqlite_fetch_single($res);
            }
        }
        
        return $tables;
    }
}
switch($_GET[w]){
	case load_db;
	echo "<table>";
	echo "<tr><td>";
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db");
	$num = sqlite_num_rows($query);
	$result = sqlite_fetch_all($query);
	echo "<select onchange=select_db(this.value)>";
	for($i = 0;$i < $num;$i ++)
	{
		echo "<option".($result[$i][ID] == $_GET[ID]?' selected':'')." value=".$result[$i][ID].">".$result[$i][name]."</option>";
		if($result[$i][ID] == $_GET[ID])
		$database = $result[$i][name];
	}
	echo "</select>";
	echo "</td></tr>";
	$tables =  sqlite_list_tables(sqlite_open("./".$database));
	if(sizeof($tables) == 0)
		echo "<tr><td>数据库里没有表</td></tr>";
	for($i = 0;$i < sizeof($tables);$i ++)
	{
		echo "<tr><td>[表]<a href=javascript:select_table('".$tables[$i]."')>".$tables[$i]."</a></td></tr>";
	}
	echo "<table>";
	break;
}
?>