submit.php

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

<?php
function send_request($sql, $db, $db_ID = '', $table = ''){
	if($query = @sqlite_query(sqlite_open("./".$db), $sql))
	{
		setcookie(message, $sql);
		setcookie(db_ID, $db_ID?$db_ID:null);
		setcookie(table, $table?$table:null);
		header("location:index.php");
	}else
	echo "提交失败！请检查SQL语句是否有误<br>".$sql;
}
switch($_GET[action])
{
	case sql;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[db_ID]."'");
	$result = sqlite_fetch_all($query);
	send_request($sql, $result[0][name], $_GET[db_ID]);
	break;
	case empty_data;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[db_ID]."'");
	$result = sqlite_fetch_all($query);
	$sql = "delete from ".$_GET[table].";";
	send_request($sql, $result[0][name], $_GET[db_ID], $_GET[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);
	$sql = "update ".$_GET[table]." set ";
	for($i = 0;$i < sizeof($_POST[field]);$i ++)
	$sql .= ($i == 0?'':',').$_POST[field][$i]." = '".$_POST[value][$i]."'";
	$sql .= " where ".$_GET[field]." = '".$_GET[value]."';";
	send_request($sql, $result[0][name], $_GET[db_ID], $_GET[table]);	
	break;
	case delete_data;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[db_ID]."'");
	$result = sqlite_fetch_all($query);
	$sql = "delete from ".$_GET[table]." where ".$_GET[field]." = '".$_GET[value]."';";
	send_request($sql, $result[0][name], $_GET[db_ID], $_GET[table]);
	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);
	$sql = "insert into ".$_GET[table]."(";
	for($i = 0;$i < sizeof($_POST[field]);$i ++)
	$sql .= ($i == 0?'':',').$_POST[field][$i];
	$sql .= ") values (";
	for($i = 0;$i < sizeof($_POST[value]);$i ++)
	$sql .= ($i == 0?'':',').($_POST[value][$i] == ''?'null':'\''.$_POST[value][$i].'\'');
	$sql .= ");";
	send_request($sql, $result[0][name], $_GET[db_ID], $_GET[table]);	
	break;
	case drop_table;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[db_ID]."'");
	$result = sqlite_fetch_all($query);
	$sql = "drop table ".$_GET[table].";";
	send_request($sql, $result[0][name], $_GET[db_ID]);
	break;
	case delete_db;
	$db = sqlite_open("db.inc");
	$query = sqlite_query($db, "select * from db where ID = '".$_GET[ID]."'");
	$result = sqlite_fetch_all($query);
	if($result[0][name] == "db.inc")
	die("db.inc不可删除！");
	$sql = "delete from db where ID = '".$_GET[ID]."';";
	if(sqlite_query($db, $sql))
	{
		unlink("./".$result[0][name]);
		setcookie(message, $sql);
		header("location:index.php");
	}
	break;
	case create_table;
	$db = sqlite_open("./".$_POST[db_name]);
	
	$sql = "create table ".$_POST[table_name]." (";
	for($i = 0;$i < sizeof($_POST[field_name]);$i ++)
	{
		$sql .= ($i == 0?'':',').$_POST[field_name][$i]." ".($_POST[field_type][$i]).($_POST[field_limit][$i]?'('.$_POST[field_limit][$i].')':'').($_POST[field_add][$i] == 'primary key'?' '.$_POST[field_add][$i]:'');
	}
	$sql .= ");";
	
	for($i = 0;$i < sizeof($_POST[field_name]);$i ++)
	{
		if($_POST[field_add][$i] == 'index')
		$sql .= "create index ".$_POST[field_name][$i]." on ".$_POST[table_name]."(".$_POST[field_name][$i].");";
	}
	
	if(@sqlite_query($db, $sql))
	{
		setcookie(message, $sql);
		setcookie(db_ID, $_POST[db_ID]);
		setcookie(table, $_POST[table_name]);
		header("location:index.php");
	}else
	echo "提交失败！请检查SQL语句是否有误<br>".$sql;
	break;
	case create_db;
	$db = sqlite_open("./db.inc");
	$sql = "insert into db (name,time) values ('".$_POST[db_name]."','".time()."');";
	if(@sqlite_query($db, $sql))
	{
		setcookie(message, $sql);
		setcookie(db_ID, sqlite_last_insert_rowid($db));
		header("location:index.php");
	}else
	echo "提交失败！请检查SQL语句是否有误<br>".$sql;
	break;
}
?>