2017 © Pedro Peláez
 

library phpliteadmin

phpLiteAdmin is a web-based SQLite database admin tool written in PHP

image

dww510/phpliteadmin

phpLiteAdmin is a web-based SQLite database admin tool written in PHP

  • Saturday, March 12, 2016
  • by dww510
  • Repository
  • 1 Watchers
  • 0 Stars
  • 48 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 17 Forks
  • 0 Open issues
  • 1 Versions
  • 2 % Grown

The README.md

phpLiteAdmin

Website: http://www.phpliteadmin.org/, (*1)

Bitbucket: https://bitbucket.org/phpliteadmin/public/, (*2)

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., (*3)

News

05.07.2015: Just released phpLiteAdmin 1.9.6! Download now, (*4)

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: http://demo.phpliteadmin.org/, (*5)

Requirements

  • a server with PHP >= 5.2.0 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., (*6)

Download

The files in the source repositories are meant for development, not for use in production., (*7)

You can find the latest downloads here: http://www.phpliteadmin.org/download/, (*8)

Installation

See https://bitbucket.org/phpliteadmin/public/wiki/Installation, (*9)

Configuration

NEW as of 1.9.4: You can now configure phpLiteAdmin in an external file. If you want to do this:, (*10)

  • 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., (*11)

  1. Open phpliteadmin.config.php (or phpliteadmin.php before 1.9.4) in a text editor., (*12)

  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., (*13)

  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., (*14)

    • 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"., (*15)

    • The name field is the human-friendly way of referencing the database within the application. It can be anything you want., (*16)

  4. Modify the $password variable to be the password used for gaining access to the phpLiteAdmin tool., (*17)

  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)., (*18)

  6. Save and upload phpliteadmin.php to your web server., (*19)

  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., (*20)

Code Repository and pull requests

The code repository is available both on bitbucket and github:, (*21)

Github: https://github.com/phpLiteAdmin/pla, (*22)

Bitbucket: https://bitbucket.org/phpliteadmin/public/src, (*23)

You are welcome to fork the project and send us pull requests on any of these platforms., (*24)

Installing a theme

  1. Download the themes package from the project Downloads page., (*25)

  2. Unzip the file and choose your desired theme., (*26)

  3. Upload phpliteadmin.css from the theme's directory alongside phpliteadmin.php., (*27)

  4. Your theme will automatically override the default., (*28)

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 http://groups.google.com/group/phpliteadmin ., (*29)

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 ., (*30)

The Versions

12/03 2016

dev-master

9999999-dev https://github.com/dww510/phpLiteAdmin

phpLiteAdmin is a web-based SQLite database admin tool written in PHP

  Sources   Download

GPL-3.0+

The Requires

  • php >=5.5

 

by Damien Wright

sql php composer sqlite phpliteadmin