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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
|
# phpLiteAdmin
Website: https://www.phpliteadmin.org/
Bitbucket: https://bitbucket.org/phpliteadmin/public/
## What is phpLiteAdmin?
phpLiteAdmin is a web-based SQLite database admin tool written in PHP with
support for SQLite3 and SQLite2. Following in the spirit of the flat-file system
used by SQLite, phpLiteAdmin consists of a single source file, phpliteadmin.php,
that is dropped into a directory on a server and then visited in a browser.
There is no installation required. The available operations, feature set,
interface, and user experience is comparable to that of phpMyAdmin.
## News
**05.09.2019: phpLiteAdmin 1.9.8.2 released [Download now](https://www.phpliteadmin.org/download/)**
**03.09.2019: phpLiteAdmin 1.9.8.1 released [Download now](https://www.phpliteadmin.org/download/)**
**30.08.2019: phpLiteAdmin 1.9.8 released [Download now](https://www.phpliteadmin.org/download/)**
**17.08.2017: [Security alert: phpLiteAdmin 1.9.8-dev](https://www.phpliteadmin.org/2017/08/17/security-alert-1-9-8-dev/) (stable versions not affected)**
**14.12.2016: Just released phpLiteAdmin 1.9.7.1 as 1.9.7 was built incorrectly [Download now](https://www.phpliteadmin.org/download/)**
**13.12.2016: Just released phpLiteAdmin 1.9.7! [Download now](https://www.phpliteadmin.org/download/)**
**05.07.2015: Just released phpLiteAdmin 1.9.6! [Download now](https://www.phpliteadmin.org/download/)**
## Features
- Lightweight - consists of a single 200KB source file for portability
- Supports SQLite3 and SQLite2 databases
- Translated and available in over 10 languages - and counting
- Specify and manage an unlimited number of databases
- Specify a directory and optionally its subdirectories to scan for databases
- Create and delete databases
- Add, delete, rename, empty, and drop tables
- Browse, add, edit, and delete records
- Add, delete, and edit table columns
- Manage table indexes
- Manage table triggers
- Import and export tables, structure, indexes, and data (SQL, CSV)
- View data as bar, pie, and line charts
- Graphical search tool to find records based on specified field values
- Create and run your own custom SQL queries in the free-form query editor/builder
- Easily apply core SQLite functions to column values using the GUI
- Write your own PHP functions to be available to apply to column values
- Design your own theme using CSS or install a pre-made theme from the community
- All presented in an intuitive, easy-to-use GUI that allows non-technical, SQL-illiterate users to fully manage databases
- Allows multiple installations on the same server, each with a different password
- Secure password-protected interface with login screen and cookies
## Demo
A live demo of phpLiteAdmin can be found here:
https://demo.phpliteadmin.org/
## Requirements
- a server with PHP >= 5.2.4 installed
- at least one PHP SQLite library extension installed and enabled: PDO,
SQLite3, or SQLiteDatabase
PHP version 5.3.0 and greater usually comes with the SQLite3 extension installed
and enabled by default so no custom action is necessary.
## Download
The files in the source repositories are meant for development, not for use in production.
You can find the latest downloads here:
https://www.phpliteadmin.org/download/
## Installation
See https://bitbucket.org/phpliteadmin/public/wiki/Installation
## Configuration
**NEW** as of 1.9.4: You can now configure phpLiteAdmin in an external file. If
you want to do this:
- rename `phpliteadmin.config.sample.php` into `phpliteadmin.config.php`
- do not change the settings in `phpliteadmin.php` but in
`phpliteadmin.config.php`
See https://bitbucket.org/phpliteadmin/public/wiki/Configuration for details.
1. Open `phpliteadmin.config.php` (or `phpliteadmin.php` before 1.9.4) in
a text editor.
2. If you want to have a directory scanned for your databases instead of
listing them manually, specify the directory as the value of the
`$directory` variable and skip to step 4.
3. If you want to specify your databases manually, set the value of the
`$directory` variable as false and modify the `$databases` array to
hold the databases you would like to manage.
- The path field is the file path of the database relative to where
`phpliteadmin.php` will be located on the server. For example, if
`phpliteadmin.php` is located at "databases/manager/phpliteadmin.php" and
you want to manage "databases/yourdatabase.sqlite", the path value
would be "../yourdatabase.sqlite".
- The name field is the human-friendly way of referencing the database
within the application. It can be anything you want.
4. Modify the `$password` variable to be the password used for gaining access
to the phpLiteAdmin tool.
5. If you want to have multiple installations of phpLiteAdmin on the same
server, change the `$cookie_name` variable to be unique for each installation
(optional).
6. Save and upload `phpliteadmin.php` to your web server.
7. Open a web browser and navigate to the uploaded `phpliteadmin.php` file. You
will be prompted to enter a password. Use the same password you set in step 4.
## Code Repository and pull requests
The code repository is available both on bitbucket and github:
Github: https://github.com/phpLiteAdmin/pla
Bitbucket: https://bitbucket.org/phpliteadmin/public/src
You are welcome to fork the project and send us pull requests on any of these
platforms.
## Installing a theme
1. Download the themes package from the [project Downloads page](https://www.phpliteadmin.org/download/).
2. Unzip the file and choose your desired theme.
3. Upload `phpliteadmin.css` from the theme's directory alongside
`phpliteadmin.php`.
4. Your theme will automatically override the default.
## Getting help
The project's wiki provides information on how to do certain things and is
located at https://bitbucket.org/phpliteadmin/public/wiki/Home .
In addition, the project's discussion group is located at
https://groups.google.com/group/phpliteadmin .
## Reporting errors and bugs
If you find any issues while using the tool, please report them at
https://bitbucket.org/phpliteadmin/public/issues?status=new&status=open .
## License
This program is free software: you can redistribute it and/or modify
it under the terms of the **GNU General Public License** as published by
the Free Software Foundation, either **version 3** of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see <[https://www.gnu.org/licenses/](https://www.gnu.org/licenses/)>.
|
