Work directory: '.$_SESSION['work_dir'].'

'; ?>

Tables:

'.substr($f,0,-4).'
'; } closedir($dh); ?>
Create new table

Table creation

Table name:

Column name	Type	Indexes
	INT	PRIMARY KEY; AUTO_INCREMENT
		INDEX UNIQUE NO INDEX

',!print_r($_POST),''; $fields = array(); $params = array( 'AUTO_INCREMENT' => '', 'INDEX' => array(), 'UNIQUE' => array() ); foreach($_POST['name'] as $idx=>$v) { if(empty($v)) { unset($_POST['name'][$idx]); continue; } $fields[$v] = $_POST['type'][$idx]; $index = $_POST['index'][$idx]; if($index == 'AUTO_INCREMENT') $params['AUTO_INCREMENT'] = $v; if($index == 'INDEX' || $index == 'UNIQUE') $params[$index][] = $v; } if($db->create($_POST['table'], $fields, $params)) echo 'Table created successfully.

open table'; else echo 'Could not create table: '.$db->get_error(); break; case 'open': $tbl = $_GET['table']; list($fields, $params, ) = unserialize(file_get_contents($wd.'/'.$tbl.'.str')); @$index = $params['INDEX']; @$unique = $params['UNIQUE']; $aname = $params['AUTO_INCREMENT']['name']; ?>

(delete)

$type) { ?>

Column name	Type	Indices
>

Auto_increment value:
Data file:	Mb
PRIMARY index file:	Kb
B-TREE index file:	Kb
List index file:	Kb

Records:

select($tbl, array('cond' => $_REQUEST['cond'], 'limit' => $_REQUEST['limit'])); echo 'Select performed for '.round(microtime(true)-$start,5).' sec

'; ?> $type){echo'';}?>'; echo ''; foreach($row as $v) { if(strlen($v) > 100) $v = substr($v,0,100).'...'; echo ''; } echo ''; } ?>

	'.htmlspecialchars($name).'
×	'.wordwrap(htmlspecialchars($v),75,'').'

Add new row:

insert($tbl, $_POST)) echo 'Record added successfully. Auto increment value: '.$db->insert_id(); else echo 'Row add error: '.$db->get_error(); echo '

Go back'; break; case 'delete-row': if($res = $db->delete($_GET['table'], array('cond' => $_GET['field'].' = '.intval($_GET[$_GET['field']])))) echo 'Record deleted.'; else echo 'Error when deleting record: '.$db->get_error(); echo '

Go back'; break; case 'delete-table': chdir($wd); $tbl = $_GET['table']; $dh = opendir('.'); while(false!==($f=readdir($dh))) { if(substr($f,0,strlen($tbl)+1) == $tbl.'.' && strlen($f) == strlen($tbl)+4) unlink($f); } closedir($dh); echo 'If you see no errors, that means that the table was deleted successfully.'; break; } ?>