PHP文本数据库类之管理（txtDB.manager.php）

使用方法：结合txtDb.inc

初始用户和密码为:admin 123

CODE:

<?php

TxtDb Manager

version: 0.1.0

mail: psher@sina.com

This script is the manager for PHP txtDb.

#############################

Suppose Modify structrual

include('txtdb.inc');

$root="txtdb";

$s_admins=array("admin","admin2","admin3");

$s_password="123";

####################

if(isset($_GET))@extract($_GET);

if(isset($_POST))@extract($_POST);

if(isset($_SESSION))@extract($_SESSION);

if(isset($_COOKIE))@extract($_COOKIE);

#################

if(isset($u_admin))$admin=$u_admin;

if(isset($u_password))$password=md5($u_password);

$s_password=md5($s_password);

$islogin=false;

if(($password==$s_password)and in_array($admin,$s_admins)){

setcookie('admin', $admin);

setcookie('password',$password);

$islogin=true;

if(isset($u_admin) and isset($u_password))echo"<script>top.location.reload();</script>";

}

if($action=="quit"){

setcookie('admin');

setcookie('password');

$islogin=false;

echo "<script>top.nav.location.reload();</script>";

}

if(!$islogin and $action!="leftbar" and $action!="")$action="main";

#################

<html>

<head>

<title>Episome TxtDb Manager</title>

<style>

body,td,input,textarea,select{font-family: verdana; font-size:10pt;}

.btn{width:100px}

hr{color:#AAAAAA;size:1}

li{list-style:square;line-height: 24px;}

h5{font-size:11pt;color:green;margin-top:0;margin-bottom:0}

h6{font-size:10pt;color:red;margin-top:0;margin-bottom:0}

td{height:24};

a{color:blue;text-decoration:none;}

a:hover{color:red;text-decoration:underline;}

form{margin-top:0;margin-bottom:0}

.tbl{color:red;}

</style>

var lastRow;

function select(curRow,curColor,lastColor){

if (lastRow!=null) lastRow.style.background=lastColor;

curRow.style.background=curColor;

lastRow = curRow;

}

</script>

##########################

if(!is_dir($root))

die('<h6>Current TxtDb root does not exists!</h6>');

$db=new txtDb($root);

$version=$db->version;

############################

switch($action){

case "leftbar":

leftbar();

break;

case "main":

main();

break;

case "selecttable":

selecttable($table);

break;

case "viewdata":

viewdata($table,$start,$num,$sortby,$order,$keyword,$fields,$selectstring,$selectcolumn);

break;

case "newtable":

newtable($table,$tblfields);

break;

case "insertrecord":

insertrecord($table,$value,$id);

break;

case "delrecord":

delrecord($table,$id,$start,$num,$order,$sortby);

break;

case "editrecord":

editrecord($table,$id,$act,$value,$start,$num,$order,$sortby);

break;

case "droptable":

droptable($table);

break;

case "cleartable":

cleartable($table);

break;

default:

index();

}

edit a row from table

function editrecord($table,$id,$act,$value,$start,$num,$order,$sortby){

global $db;

$order=($order=="asc")?"desc":"asc";

$db->open($table,$id,1);

if($act=="save" and is_array($value)){

$db->change($value,$id);

echo "<h5>The record of table <font class=tbl>[".$table."]</font> has been modifyed !</h5><hr>";

echo "<li><a href='?action=viewdata&table=".$table."&start=".$start."&num=".$num."&order=".$order."&sortby=".$sortby."'>View data</a>";

die();

}

echo"

<h5>Modify record of table <font class=tbl>[".$table."]</font> !</h5><hr>

<tr>

<form action='?action=editrecord&table=$table&start=$start&num=$num&order=$order&sortby=$sortby' method=post>";

foreach($db->fieldNames as $field){

$v=stripslashes($db->dbValues[$id][$field]);

echo "

<tr>

<td bgcolor='#B3DBF9' width='100' align=right><nobr>$field : </nobr></td>

</tr>

}

echo"

</table>

</td>

 <input type=submit value='Save >>' class=btn><br> <input type=submit value='Cancel >>' class=btn onclick='js:history.go(-1)'>

</td>

</tr></form>

</table>

}

delete a row from table

function delrecord($table,$id,$start,$num,$order,$sortby){

global $db;

$order=($order=="asc")?"desc":"asc";

$db->open($table,0,1);

$db->delete($id);

echo "<h5>The record of table <font class=tbl>[".$table."]</font> has been deleted !</h5><hr>";

echo "<li><a href='?action=viewdata&table=".$table."&start=".$start."&num=".$num."&order=".$order."&sortby=".$sortby."'>View data</a>";

die();

}

Insert a row to table

function insertrecord($table,$value,$id){

global $db;

$db->open($table,0,1);

if(is_array($value)){

$db->append($value,$id);

echo "<h5>The record has been inserted to table <font class=tbl>[".$table."]</font>!</h5><hr>";

echo "<li><a href='?action=viewdata&table=".$table."'>View data</a>";

echo "<li><a href='?action=insertrecord&table=$table'>Insert record</a>";

die();

}

echo"<h5>Insert record to <font class=tbl>[".$table."]</font></h5>";

echo "<hr>";

echo "

<tr>

foreach($db->fieldNames as $field){

echo "

<tr>

<td bgcolor='#B3DBF9' width='100' align=right><nobr>$field : </nobr></td>

</tr>

}

echo "

</table>

</td>

<td valign=bottom> ID <input size=3 name=id value='$db->lines'><br> <input type=submit onclick='return !isNaN(iform.id.value);' value='Insert >>' class=btn><br> <input type=submit value='Cancel >>' class=btn onclick='js:history.go(-1)'></td>

</tr></form>

</table>

}

view data

function viewdata($table,$start,$num,$sortby,$order,$keyword,$fields,$selectstring,$selectcolumn){

global $db;

if(trim($start)=='')$start=0;

if(trim($num)=='')$num=30;

$db->open($table,$start,$num);

if(trim($sortby)!='')

$db->sortby($sortby,$order);

$order=($order=="asc")?"desc":"asc";

$dbValues=$db->dbValues;

if(trim($keyword)!="")

$dbValues=$db->query($keyword,$fields);

if(trim($selectstring)!="")

$dbValues=$db->select($selectcolumn,$selectstring);

echo"

<h5>Data for Table <font class=tbl>[".$table."]</font></h5>

<hr>

<tr>

<td> <b>Actions</b> </td>

foreach($db->fieldNames as $value){

$select_string.="<option value=".$value.">".$value."</option>";

echo"<td> <a href='?action=viewdata&table=$table&start=".$start."&num=".$num."&sortby=".$value."&order=".$order."'>".$value."</a> </td>\n";

}

echo "</tr>";

if(is_array($dbValues))

foreach($dbValues as $id=>$Values){

echo "<tr style='background:#EEEEEE;cursor:hand' onclick=\"javascript:select(this,'#DCFAE8','#EEEEEE')\">\n";

echo "<td><nobr> <a href='?action=editrecord&id=".$id."&table=".$table."&start=".$start."&num=".$num."&order=".$order."&sortby=".$sortby."'>Edit</a> <a href='?action=delrecord&table=".$table."&id=".$id."&start=".$start."&num=".$num."&order=".$order."&sortby=".$sortby."' onclick=\"return window.confirm('Are U sure of delete the record?');\">Del</a> </nobr></td>";

echo "<td bgcolor='#B3DBF9'> $id </td>";

if(is_array($Values))

foreach($Values as $key=>$value){

echo "<td><nobr> ".htmlspecialchars($value)." </nobr></td>";

}

echo "</tr>\n";

}

echo"

</tr>

</table>

</td>

</tr>

</table>

<li>Query :<br>

<tr>

  Show <br>

  <input size=5 value='$num' name='num'> rows [<a onclick='num.value=$db->lines' style='cursor:hand'>All</a>] <br>

  Starting from <br>

  <input value='Display >>' onclick='return (!isNaN(iform.start.value) && !isNaN(iform.num.value));' type=submit>

  </form>

</td>

  For <input size=12 value='$keyword' name='keyword'> in  <br>

<select name='fields[]' id=fields size=4 multiple style='width:100%'>$select_string</select>

<input value='Display >>' type=submit> [<a onclick='for(i=0;i<fields.length;i++)fields[i].selected=true' style='cursor:hand'>All</a>]

</form>

</td>

  For <input size=12 value='$selectstring' name='selectstring'> ==  <br>

<select name='selectcolumn' size=4 style='width:100%'>$select_string</select>

<input value='Display >>' type=submit>

</form>

</td>

</tr>

</table>

</td></tr></table>

<li>Records : $db->lines

<li><a href='?action=insertrecord&table=$table'>Insert record</a>

<li><a href='?action=cleartable&table=".$table."' onclick=\"return window.confirm('Are U sure of clear the data?');\">Clear</a> or <a href='?action=droptable&table=".$table."' onclick=\"return window.confirm('Are U sure of drop the table?');\">Drop</a> this table.

<li>";

$db->times();

}

select table

function selecttable($table){

global $db;

$db->open($table,0,1);

echo "<h5>Select Table <font class=tbl>[".$table."]</font></h5><hr>";

echo "<li>Path : ".$db->tableName;

echo "<li>Size : ".number_format(filesize($db->tableName))." (bytes)";

echo "<li>Records : ".$db->lines;

echo "<li>Fields :".$db->fields."<br>";

echo "<select size=8 name=field style='width:200'>";

foreach($db->fieldNames as $value){

echo "<option value=".$value.">".$value;

}

echo "</select>";

echo "<input value='Add >>' type=submit>";

echo "<input value='Drop >>' type=submit>";

echo "<input value='Insert >>' type=submit>";

echo "<li><a href='?action=viewdata&table=".$table."'>View data</a>";

echo "<li><a href='?action=insertrecord&table=".$table."'>Insert record</a>";

echo "<li><a href='?action=cleartable&table=".$table."' onclick=\"return window.confirm('Are U sure of clear the data?');\">Clear</a> or <a href='?action=droptable&table=".$table."' onclick=\"return window.confirm('Are U sure of drop the table?');\">Drop</a> this table.";

echo "<li>Time of last modification : ".date ("F d Y H:i:s.", filemtime($db->tableName))."<br>";

clearstatcache();

$db->times();

}

clear table

function cleartable($table){

global $db;

$db->open($table,0,1);

$db->clear();

echo "<h5>The table <font class=tbl>[".$table."]</font> has been cleared !</h5><hr>";

}

drop table

function droptable($table){

global $db;

$db->open($table,0,1);

$db->drop();

echo "<h5>The table <font class=tbl>[".$table."]</font> has been droped !</h5><hr>";

echo "<script>top.nav.location.reload();</script>";

}

create table

function newtable($table,$tblfields){

global $db;

if(isset($table) and isset($tblfields)){

if(!ereg("^[-a-zA-Z0-9_\.]",$table))

die('<font color=red>Table name <font class=tbl>['.$table.']</font> not allow!</font>');

$tblfields=str_replace("\n","",$tblfields);

$fields=explode("\r",$tblfields);

foreach($fields as $key=>$value){

if(trim($value)=="")unset($fields[$key]);

}

if($db->create($table,$fields)){

echo "<br><h5>The table <font class=tbl>[".$table."]</font> has been created !</h5><br>";

echo "<script>top.nav.location.reload();</script>";

die();

}

<body>

<h5>Create New Table</h5>

<hr>

TableName:<br>

Fields: (field per line)<br>

</form>

</body>

}

show DB information

function main(){

global $version,$islogin;

$httphost=$_ENV["HTTP_HOST"];

$server=$_SERVER["SERVER_SOFTWARE"];

$php=PHP_VERSION;

$os=PHP_OS;

echo"

<nobr><h5>Welcome to TxtDb Manager </h5></nobr>

<li>TxtDb $version running on $httphost

<li>PHP $php running on $os

<li>Server_SoftWare : $server";

if(!$islogin){

echo "

</form>

}

echo "<br><hr width='60%' align=left></body>";

}

navigation bar

function leftbar(){

global $db,$islogin;

<style>

body{background:#444444;color:white;}

a{color:white;}

a:hover{color:red;}

hr{color:white;}

td{height:20}

</style>

<?echo"

showTables($db->root,$db->exten);

echo"

</table>

<b>Actions</b>

<td nowrap><font face=Wingdings>w</font> <a href='?action=newtable' target=manager>Create Table</a></td>

</tr>";

if($islogin)echo"

<td nowrap><font face=Wingdings>w</font> <a href='?action=quit' target=manager>Exit Manager</a></td>

</tr>";

echo"

</table>

</body>";

}

show All tables

function showtables($path){

global $db;

$dirhandle=opendir($path);

while($file=readdir($dirhandle)){

if ($file!="." && $file!=".."){

if (is_dir($path.'/'.$file)){

showtables($path.'/'.$file);

}else{

$path_info=pathinfo($file);

$exten=strtolower(".".$path_info["extension"]);

if($exten==strtolower($db->exten)){

if(strpos($path,'/')){

$file=str_replace($db->root.'/','',$path.'/'.$file);

$subdir=" ";

}

$file=str_replace($db->exten,'',$file);

echo "

$subdir<font face=Wingdings>w</font> <a href='?action=selecttable&table=$file' target='manager'>$file</a>

</td>

</tr>

}//

}

closedir($dirhandle);

}

index of this manager

function index(){

print'

</frameset>';

}