/
index.php
73 lines (63 loc) · 1.82 KB
/
index.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<?php
/**
* [type] file
* [name] controller.php
* [package] psa
* [since] 2010.09.22
* [update] 2013.12.19 : login added
*/
include_once('autologin.php');
$cmd->setValue('base');
$submit->setValue('Go');
$html = new Page;
$html->setLanguage('en-en');
$html->build();
$head = new Head;
$head->setTitle('PSA - homepage');
$head->setCss('./css/psa.css');
$head->setJs('./js/PSA.js');
$head->build();
$body = new Body;
$body->build();
// include_once('./inc/menubar.php');
$body->line('
<h3>PHP SQLite Admin tool - PSA in short...</h3>
<p>PSA stands for PHP - SQLite - Administration. This application lets you
do the basic operations with SQLite3 databases. The current version only
supports the very basics. Check out the manual for
more information.</p>
<p>Click <a href="login.php">here</a> to log in.</p>
<p> The following issues are already implemented :</p>
<ul>
<li>select directory and extension</li>
<li>list databases based on the above</li>
<li>list tables based on selected database</li>
<li>perform random queries on the selected database</li>
<li>show table structure</li>
<li>browse table</li>
<li>update rows</li>
<li>delete rows</li>
<li>create database</li>
<li>drop database</li>
<li>vacuum database</li>
<li>create table</li>
<li>drop column</li>
<li>dump sql statements per table</li>
<li>insert rows</li>
<li>drop table</li>
<li>list indexes (part of table info)</li>
<li>drop indexes</li>
<li>create indexes</li>
<li>list views</li>
<li>drop views</li>
<li>dump table data to csv et al</li>
<li>show all performed queries and also hold result</li>
<li>dump database structure</li>
</ul>
<p>Not yet planned :</p>
<ul>
<li>stored procedures</li>
<li>triggers</li>
</ul>');
$body->line('</div>');
include_once('./inc/footer.php');